qYbWHV1T

1
2CREATE TABLE IF NOT EXISTS `Client` ( 
3  `ClientID` int unsigned not null auto_increment,
4  `Full Name` varchar null,
5  `Phone1` varchar not null,
6  `Phone2` varchar null,
7  `Sex` varchar null,
8  `Address` varchar null,
9  PRIMARY KEY (`ClientID`)
10);
11
12ALTER TABLE `Client` ADD CONSTRAINT `Client_ClientID_foreign` FOREIGN KEY (`ClientID`) REFERENCES `SMS` (`ClientID`);
13ALTER TABLE `Client` ADD CONSTRAINT `Client_ClientID_foreign` FOREIGN KEY (`ClientID`) REFERENCES `Calls` (`ClientID`);
14ALTER TABLE `Client` ADD CONSTRAINT `Client_ClientID_foreign` FOREIGN KEY (`ClientID`) REFERENCES `GeoData` (`ClientID`);
15ALTER TABLE `Client` ADD CONSTRAINT `Client_ClientID_foreign` FOREIGN KEY (`ClientID`) REFERENCES `DocLinks` (`ClientID`);
16
17CREATE TABLE IF NOT EXISTS `SMS` ( 
18  `id` int unsigned not null auto_increment,
19  `Date` date null,
20  `Text` varchar not null,
21  `Condition` varchar not null,
22  `ClientID` int not null,
23  PRIMARY KEY (`id`)
24);
25
26CREATE TABLE IF NOT EXISTS `GeoData` ( 
27  `id` int unsigned not null auto_increment,
28  `Location` varchar not null,
29  `ClientID` int not null,
30  PRIMARY KEY (`id`)
31);
32
33CREATE TABLE IF NOT EXISTS `DocLinks` ( 
34  `DocID` int not null,
35  `ClientID` int null,
36  `DocFile` varchar not null,
37  PRIMARY KEY (`DocID`)
38);
39
40ALTER TABLE `DocLinks` ADD CONSTRAINT `DocLinks_DocID_foreign` FOREIGN KEY (`DocID`) REFERENCES `Documents` (`id`);
41
42CREATE TABLE IF NOT EXISTS `Calls` ( 
43  `id` int unsigned not null auto_increment,
44  `WavFile` varchar not null,
45  `Lenght` smallint not null,
46  `Date` date not null,
47  `ClientID` int not null,
48  PRIMARY KEY (`id`)
49);
50
51CREATE TABLE IF NOT EXISTS `Documents` ( 
52  `id` int unsigned not null auto_increment,
53  `Text` varchar not null,
54  PRIMARY KEY (`id`)
55);
56
57CREATE TABLE IF NOT EXISTS `MoneyThings` ( 
58  `id` int unsigned not null auto_increment,
59  `column_2` varchar not null,
60  PRIMARY KEY (`id`)
61);
62
63CREATE TABLE IF NOT EXISTS `TODO Logs` ( 
64  `id` int unsigned not null auto_increment,
65  `UserID` varchar null,
66  `Date` date null,
67  `Action` varchar null,
68  PRIMARY KEY (`id`)
69);
70
71CREATE TABLE IF NOT EXISTS `Users` ( 
72  `id` int unsigned not null auto_increment,
73  `User` varchar not null,
74  `Role` varchar not null,
75  PRIMARY KEY (`id`)
76);
77
78CREATE TABLE IF NOT EXISTS `Roles` ( 
79  `id` int unsigned not null auto_increment,
80  PRIMARY KEY (`id`)
81);