· 5 years ago · Mar 07, 2020, 03:18 PM
1CREATE TABLE IF NOT EXISTS zip (zip INT(10) PRIMARY KEY, city VARCHAR(30), state VARCHAR(20))
2database pwn_user_data
3 CREATE TABLE `pwn_user_data` (
4 userid varchar(75) NOT NULL,
5 password varchar(75),
6 passwordhash varchar(75),
7 firstname varchar(25),
8 lastname varchar(25),
9 street varchar(125),
10 city varchar(45),
11 state char(25),
12 country char(25),
13 phone varchar(30),
14 pwn_site varchar(45) NOT NULL,
15 email varchar(75),
16 id INT(8) UNSIGNED AUTO_INCREMENT PRIMARY KEY
17 );