CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- CREATE TABLE `db`.`customers` (
- `id` INT NOT NULL AUTO_INCREMENT ,
- `name` VARCHAR(45) NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
- CREATE TABLE `db`.`orders` (
- `id` INT NOT NULL AUTO_INCREMENT ,
- `customer_id` INT NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
- CREATE TABLE `db`.`products` (
- `id` INT NOT NULL AUTO_INCREMENT ,
- `title` VARCHAR(255) NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
- CREATE TABLE `db`.`order_product_rel` (
- `id` INT NOT NULL AUTO_INCREMENT ,
- `order_id` INT NULL ,
- `amount` INT NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;