j03uxY08

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema verminvpn
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema verminvpn
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `verminvpn` DEFAULT CHARACTER SET utf8 ;
15USE `verminvpn` ;
16
17-- -----------------------------------------------------
18-- Table `verminvpn`.`purchase`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `verminvpn`.`purchase` (
21  `OrderID` CHAR(12) NOT NULL,
22  `BuyerIP` VARCHAR(18) NULL,
23  `PaymentMethod` CHAR(1) NOT NULL,
24  `Amount` DECIMAL(6,2) NOT NULL,
25  `ItemQuantity` INT NOT NULL,
26  `Date` DATETIME NOT NULL,
27  `TxnID` VARCHAR(45) NULL,
28  PRIMARY KEY (`OrderID`))
29ENGINE = InnoDB;
30
31
32SET SQL_MODE=@OLD_SQL_MODE;
33SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
34SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;