-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathCreateTablesScript.txt
48 lines (43 loc) · 3.03 KB
/
CreateTablesScript.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
# Create Users Table
CREATE TABLE `leinecke_COP4331`.`Users` ( `ID` INT NOT NULL AUTO_INCREMENT , `DateCreated` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `DateLastLoggedIn` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `FirstName` VARCHAR(50) NOT NULL DEFAULT '' , `LastName` VARCHAR(50) NOT NULL DEFAULT '' , `Login` VARCHAR(50) NOT NULL DEFAULT '' , `Password` VARCHAR(50) NOT NULL DEFAULT '' , PRIMARY KEY (`ID`)) ENGINE = InnoDB;
CREATE TABLE `leinecke_COP4331`.`Contacts` ( `ID` INT NOT NULL AUTO_INCREMENT , `Name` VARCHAR(50) NOT NULL DEFAULT '' , `UserID` INT NOT NULL DEFAULT '0' , PRIMARY KEY (`ID`)) ENGINE = InnoDB;
insert into Users (FirstName,LastName,Login,Password) VALUES ('Tyler','Claitt','tim','1234');
insert into Users (FirstName,LastName,Login,Password) VALUES ('Sam','Hill','SamH','Test');
insert into Users (FirstName,LastName,Login,Password) VALUES ('Rick','Leinecker','RickL','5832a71366768098cceb7095efb774f2');
insert into Users (FirstName,LastName,Login,Password) VALUES ('Sam','Hill','SamH','0cbc6611f5540bd0809a388dc95a615b');
insert into Contacts (Name,UserID) VALUES ('Blue',1);
insert into Contacts (Name,UserID) VALUES ('White',1);
insert into Contacts (Name,UserID) VALUES ('Black',1);
insert into Contacts (Name,UserID) VALUES ('gray',1);
insert into Contacts (Name,UserID) VALUES ('Magenta',1);
insert into Contacts (Name,UserID) VALUES ('Yellow',1);
insert into Contacts (Name,UserID) VALUES ('Cyan',1);
insert into Contacts (Name,UserID) VALUES ('Salmon',1);
insert into Contacts (Name,UserID) VALUES ('Chartreuse',1);
insert into Contacts (Name,UserID) VALUES ('Lime',1);
insert into Contacts (Name,UserID) VALUES ('Light Blue',1);
insert into Contacts (Name,UserID) VALUES ('Light Gray',1);
insert into Contacts (Name,UserID) VALUES ('Light Red',1);
insert into Contacts (Name,UserID) VALUES ('Light Green',1);
insert into Contacts (Name,UserID) VALUES ('Chiffon',1);
insert into Contacts (Name,UserID) VALUES ('Fuscia',1);
insert into Contacts (Name,UserID) VALUES ('Brown',1);
insert into Contacts (Name,UserID) VALUES ('Beige',1);
insert into Contacts (Name,UserID) VALUES ('Blue',3);
insert into Contacts (Name,UserID) VALUES ('White',3);
insert into Contacts (Name,UserID) VALUES ('Black',3);
insert into Contacts (Name,UserID) VALUES ('gray',3);
insert into Contacts (Name,UserID) VALUES ('Magenta',3);
insert into Contacts (Name,UserID) VALUES ('Yellow',3);
insert into Contacts (Name,UserID) VALUES ('Cyan',3);
insert into Contacts (Name,UserID) VALUES ('Salmon',3);
insert into Contacts (Name,UserID) VALUES ('Chartreuse',3);
insert into Contacts (Name,UserID) VALUES ('Lime',3);
insert into Contacts (Name,UserID) VALUES ('Light Blue',3);
insert into Contacts (Name,UserID) VALUES ('Light Gray',3);
insert into Contacts (Name,UserID) VALUES ('Light Red',3);
insert into Contacts (Name,UserID) VALUES ('Light Green',3);
insert into Contacts (Name,UserID) VALUES ('Chiffon',3);
insert into Contacts (Name,UserID) VALUES ('Fuscia',3);
insert into Contacts (Name,UserID) VALUES ('Brown',3);
insert into Contacts (Name,UserID) VALUES ('Beige',3);