CLXKy5Jw

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4 
5-- -----------------------------------------------------
6-- Schema sampleshop_db
7-- -----------------------------------------------------
8CREATE SCHEMA IF NOT EXISTS `sampleshop_db` DEFAULT CHARACTER SET utf8 ;
9USE `sampleshop_db` ;
10 
11-- -----------------------------------------------------
12-- Table `USERS`
13-- -----------------------------------------------------
14CREATE TABLE IF NOT EXISTS `users` (
15  `username` INT(11) NOT NULL,
16  `first_name` INT(11) NOT NULL,
17  `last_name` INT(11) NOT NULL,
18  `password` INT(11) NOT NULL)
19ENGINE = InnoDB
20DEFAULT CHARACTER SET = utf8;
21 
22 
23-- -----------------------------------------------------
24-- Table `ORDERS`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `past_orders` (
27  `order_id` INT(11) NOT NULL,
28  `order_items` INT(11) NOT NULL,
29  `username` INT(11) NOT NULL,
30  PRIMARY KEY (`order_id`))
31ENGINE = InnoDB
32DEFAULT CHARACTER SET = utf8;
33 
34 
35SET SQL_MODE=@OLD_SQL_MODE;
36SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
37SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;