AccountManagement/SQL Creation Statements.txt at master · StrayCargo/AccountManagement · GitHub

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
CREATE TABLE `accounts` (
  `firstname` varchar(45) NOT NULL,
  `lastname` varchar(45) NOT NULL,
  `email` varchar(65) DEFAULT NULL,
  `idnumber` varchar(45) NOT NULL,
  `idtype` varchar(45) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `street` varchar(45) NOT NULL,
  `city` varchar(45) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zipcode` varchar(10) NOT NULL,
  `creationdate` int(255) DEFAULT NULL,
  `expireddate` int(255) DEFAULT NULL,
  `createdby` varchar(45) NOT NULL,
  `comments` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SELECT * FROM management.users;

CREATE TABLE `users` (
  `firstname` varchar(45) NOT NULL,
  `lastname` varchar(45) NOT NULL,
  `email` varchar(65) DEFAULT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(255) NOT NULL,
  `lastupdate` int(255) DEFAULT NULL,
  `admin` bit(1) DEFAULT NULL,
  `creator` varchar(45) NOT NULL DEFAULT 'DEFAULT  ''0''',
  PRIMARY KEY (`username`),
  UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;