Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- Tue Feb 18 18:35:09 2020
- -- Model: New Model Version: 1.0
- -- MySQL Workbench Forward Engineering
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @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';
- -- -----------------------------------------------------
- -- Schema mydb
- -- -----------------------------------------------------
- -- -----------------------------------------------------
- -- Schema mydb
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
- USE `mydb` ;
- -- -----------------------------------------------------
- -- Table `mydb`.`users`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`users` (
- `idUsers` INT(11) NOT NULL AUTO_INCREMENT,
- `uidUsers` TINYTEXT NOT NULL,
- `emailUsers` TINYTEXT NOT NULL,
- `pwdUsers` LONGTEXT NOT NULL,
- `userFirstName` VARCHAR(45) NOT NULL,
- `userLastName` VARCHAR(45) NOT NULL,
- `userAddress` VARCHAR(100) NOT NULL,
- `userPhone` VARCHAR(45) NOT NULL,
- `userCountry` VARCHAR(45) NOT NULL,
- `userZip` INT NOT NULL,
- `userCity` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`idUsers`))
- ENGINE = MyISAM
- AUTO_INCREMENT = 6
- DEFAULT CHARACTER SET = latin1
- COLLATE = latin1_bin;
- -- -----------------------------------------------------
- -- Table `mydb`.`products`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`products` (
- `idProducts` INT(12) NOT NULL,
- `productName` VARCHAR(50) NOT NULL,
- `productPrice` FLOAT NOT NULL,
- `productDesc` VARCHAR(1000) NOT NULL,
- `productShortDesc` VARCHAR(250) NOT NULL,
- `productStock` FLOAT NULL,
- PRIMARY KEY (`idProducts`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`orders`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`orders` (
- `idOrders` INT NOT NULL AUTO_INCREMENT,
- `orderAmount` FLOAT NOT NULL,
- `orderShipAddress` VARCHAR(100) NOT NULL,
- `orderCity` VARCHAR(45) NOT NULL,
- `orderZip` VARCHAR(45) NOT NULL,
- `orderCountry` VARCHAR(45) NOT NULL,
- `orderPhone` VARCHAR(45) NOT NULL,
- `orderShipping` FLOAT NOT NULL,
- `orderEmail` VARCHAR(45) NOT NULL,
- `orderDate` DATE NOT NULL,
- PRIMARY KEY (`idOrders`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`category`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`category` (
- `idcategory` INT NOT NULL,
- `name` VARCHAR(45) NOT NULL,
- `details` VARCHAR(1000) NOT NULL,
- PRIMARY KEY (`idcategory`))
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement