wQJ88UDs

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3CREATE DATABASE IF NOT EXISTS `dlpclientdatabase` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4USE `dlpclientdatabase`;
5
6DROP TABLE IF EXISTS `dlpclientadmin`;
7CREATE TABLE `dlpclientadmin` (
8  `id` bigint(20) NOT NULL,
9  `username` char(255) NOT NULL,
10  `secret` text NOT NULL,
11  `date_created` datetime NOT NULL,
12  `last_login` datetime NOT NULL
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14
15DROP TABLE IF EXISTS `dlpclientapilog`;
16CREATE TABLE `dlpclientapilog` (
17  `id` bigint(20) NOT NULL,
18  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
19  `log_details` text NOT NULL
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;
21
22DROP TABLE IF EXISTS `dlpclientserverdetails`;
23CREATE TABLE `dlpclientserverdetails` (
24  `server_type` char(255) NOT NULL DEFAULT 'TRADE',
25  `domain` char(255) NOT NULL,
26  `server_ip` char(255) NOT NULL,
27  `server_port` char(255) NOT NULL,
28  `dns_name` char(255) NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31DROP TABLE IF EXISTS `dlpclienttable`;
32CREATE TABLE `dlpclienttable` (
33  `email` char(255) NOT NULL,
34  `phone_number` char(255) NOT NULL,
35  `password` char(255) NOT NULL,
36  `first_name` char(255) NOT NULL,
37  `last_name` char(255) NOT NULL,
38  `middle_name` char(255) DEFAULT NULL,
39  `address1` char(255) DEFAULT NULL,
40  `address2` char(255) DEFAULT NULL,
41  `address3` char(255) DEFAULT NULL,
42  `address4` char(255) DEFAULT NULL,
43  `city` char(255) DEFAULT NULL,
44  `state` char(255) DEFAULT NULL,
45  `zip_code` char(255) DEFAULT NULL,
46  `occupation` char(255) DEFAULT NULL,
47  `source_of_funds` char(255) DEFAULT NULL,
48  `usage_of_funds` char(255) DEFAULT NULL,
49  `employer` char(255) DEFAULT NULL,
50  `ss_id_number` char(255) DEFAULT NULL,
51  `key1` char(255) DEFAULT NULL,
52  `key2` char(255) DEFAULT NULL,
53  `account_number` bigint(255) NOT NULL,
54  `domain` char(255) NOT NULL,
55  `backoffice` tinyint(1) DEFAULT '0',
56  `record_sent` tinyint(1) DEFAULT '0'
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59DROP TABLE IF EXISTS `dlptoken`;
60CREATE TABLE `dlptoken` (
61  `id` bigint(20) NOT NULL,
62  `username` char(255) NOT NULL,
63  `time_stamp` datetime DEFAULT NULL,
64  `unique_id` char(16) NOT NULL
65) ENGINE=MEMORY DEFAULT CHARSET=latin1;
66
67DROP TABLE IF EXISTS `ecnsymbols`;
68CREATE TABLE `ecnsymbols` (
69  `symbol` char(255) NOT NULL,
70  `exchange` char(255) NOT NULL,
71  `formatprice` char(255) NOT NULL,
72  `formatsize` char(255) NOT NULL,
73  `bidvol` char(255) NOT NULL,
74  `askvol` char(255) NOT NULL
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;
76
77
78ALTER TABLE `dlpclientadmin`
79  ADD PRIMARY KEY (`id`),
80  ADD UNIQUE KEY `username` (`username`);
81
82ALTER TABLE `dlpclientapilog`
83  ADD PRIMARY KEY (`id`);
84
85ALTER TABLE `dlpclientserverdetails`
86  ADD PRIMARY KEY (`server_type`,`domain`);
87
88ALTER TABLE `dlpclienttable`
89  ADD PRIMARY KEY (`email`);
90
91ALTER TABLE `dlptoken`
92  ADD PRIMARY KEY (`id`),
93  ADD UNIQUE KEY `unique_id` (`unique_id`);
94
95ALTER TABLE `ecnsymbols`
96  ADD PRIMARY KEY (`symbol`);
97
98
99ALTER TABLE `dlpclientadmin`
100  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
101ALTER TABLE `dlpclientapilog`
102  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
103ALTER TABLE `dlptoken`
104  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;