  * Use this file to build out the schema.
  */
 
-/**
- * I know I used snake_case for the attribute names
- * in the example, but let's switch to camelCase
- * throughout the project to be consistent.
- * Don't worry about it here, though.
- */
-
 DROP TABLE IF EXISTS users;
 CREATE TABLE users (
-	-- 	id does not have attribute constraints.
-	-- See roles(id)
-	id             INT(10) NOT NULL ,
+
+	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
 	first_name     VARCHAR(50) ,
 	last_name      VARCHAR(50) ,
-	address        VARCHAR(100) ,
-	-- May need city, state, zip
+	user_address        VARCHAR(100) ,
+	user_city            VARCHAR (50),
+	user_state        VARCHAR (50),
+	user_zipcode      INT(5),
 	role_id        INT ,
 	created_at     TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
 	updated_at     TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,


DROP TABLE IF EXISTS state;
CREATE TABLE state (
	-- 	id does not have attribute constraints.
	-- See roles(id)
	id         INT(10) ,
	state      VARCHAR(2) ,
	count      INT ,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP


DROP TABLE IF EXISTS transactions;
CREATE TABLE transactions (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	user_id        INT(10) ,
	post_office_id INT(10) ,
	cost           DOUBLE ,
	employee_id    INT(10) ,
	package_id     INT(10) ,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
	updated_at TIMESTAMP DEFAULT current_timestamp
);

DROP TABLE IF EXISTS packageType;
CREATE TABLE packageType (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	id    INT(10) ,
	type  VARCHAR(50) ,
	count INT

);

DROP TABLE IF EXISTS packagStatus;
CREATE TABLE packageStatus (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	type  VARCHAR(50) ,
	count INT,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
	updated_at TIMESTAMP DEFAULT current_timestamp
);
