59 行
1.9 KiB
Plaintext
59 行
1.9 KiB
Plaintext
DROP DATABASE IF EXISTS `honya_db`;
|
|
CREATE DATABASE `honya_db` CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;
|
|
|
|
DROP TABLE IF EXISTS `item`;
|
|
CREATE TABLE `item` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL,
|
|
`slug` varchar(100) NOT NULL,
|
|
`author` varchar(100),
|
|
`language` varchar(2) NOT NULL,
|
|
`description` text,
|
|
`price` float(10, 8) NOT NULL,
|
|
`quantity` int(10) NOT NULL,
|
|
`filename` varchar(100) NOT NULL,
|
|
`pagecount` int(10) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
DROP TABLE IF EXISTS `item_img`;
|
|
CREATE TABLE `item_img` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`item_id` int(10) NOT NULL,
|
|
`filename` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
DROP TABLE IF EXISTS `author`;
|
|
CREATE TABLE `author` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL,
|
|
`slug` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
DROP TABLE IF EXISTS `shipping`;
|
|
CREATE TABLE `shipping` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL,
|
|
`slug` varchar(100) NOT NULL,
|
|
`zip` varchar(100) NOT NULL,
|
|
`housenr` varchar(100) NOT NULL,
|
|
`address1` varchar(100) NOT NULL,
|
|
`address2` varchar(100),
|
|
`country` varchar(100) NOT NULL,
|
|
`email` varchar(100) NOT NULL,
|
|
`shipped` int(1),
|
|
`shippedtime` int(10),
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
DROP TABLE IF EXISTS `orders`;
|
|
CREATE TABLE `orders` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`item_id` int(10) NOT NULL,
|
|
`shipping_id` int(10) NOT NULL,
|
|
`payment_id` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|