5HbxejPH

1-- MySQL Script generated by MySQL Workbench
2-- Tue Feb 18 18:35:09 2020
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`users` (
24  `idUsers` INT(11) NOT NULL AUTO_INCREMENT,
25  `uidUsers` TINYTEXT NOT NULL,
26  `emailUsers` TINYTEXT NOT NULL,
27  `pwdUsers` LONGTEXT NOT NULL,
28  `userFirstName` VARCHAR(45) NOT NULL,
29  `userLastName` VARCHAR(45) NOT NULL,
30  `userAddress` VARCHAR(100) NOT NULL,
31  `userPhone` VARCHAR(45) NOT NULL,
32  `userCountry` VARCHAR(45) NOT NULL,
33  `userZip` INT NOT NULL,
34  `userCity` VARCHAR(45) NOT NULL,
35  PRIMARY KEY (`idUsers`))
36ENGINE = MyISAM
37AUTO_INCREMENT = 6
38DEFAULT CHARACTER SET = latin1
39COLLATE = latin1_bin;
40
41
42-- -----------------------------------------------------
43-- Table `mydb`.`products`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `mydb`.`products` (
46  `idProducts` INT(12) NOT NULL,
47  `productName` VARCHAR(50) NOT NULL,
48  `productPrice` FLOAT NOT NULL,
49  `productDesc` VARCHAR(1000) NOT NULL,
50  `productShortDesc` VARCHAR(250) NOT NULL,
51  `productStock` FLOAT NULL,
52  PRIMARY KEY (`idProducts`))
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `mydb`.`orders`
58-- -----------------------------------------------------
59CREATE TABLE IF NOT EXISTS `mydb`.`orders` (
60  `idOrders` INT NOT NULL AUTO_INCREMENT,
61  `orderAmount` FLOAT NOT NULL,
62  `orderShipAddress` VARCHAR(100) NOT NULL,
63  `orderCity` VARCHAR(45) NOT NULL,
64  `orderZip` VARCHAR(45) NOT NULL,
65  `orderCountry` VARCHAR(45) NOT NULL,
66  `orderPhone` VARCHAR(45) NOT NULL,
67  `orderShipping` FLOAT NOT NULL,
68  `orderEmail` VARCHAR(45) NOT NULL,
69  `orderDate` DATE NOT NULL,
70  PRIMARY KEY (`idOrders`))
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `mydb`.`category`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `mydb`.`category` (
78  `idcategory` INT NOT NULL,
79  `name` VARCHAR(45) NOT NULL,
80  `details` VARCHAR(1000) NOT NULL,
81  PRIMARY KEY (`idcategory`))
82ENGINE = InnoDB;
83
84
85SET SQL_MODE=@OLD_SQL_MODE;
86SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
87SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;