/ Published in: SQL
Confirm the sql script file is encoded with `UTF-8`
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
CREATE TABLE IF NOT EXISTS `goods_order` ( `order_id` INT UNSIGNED NOT NULL COMMENT '订å•å•å·', `goods_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT '商å“款å·', `order_type` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '订å•ç±»åž‹', `order_status` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '订å•çŠ¶æ€', `color_id` SMALLINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '颜色id', `size_id` SMALLINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '尺寸id', `goods_number` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'æ•°é‡', `depot_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT '仓库id', `packet_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT '储ä½code', `gmt_create` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'æ·»åŠ æ—¶é—´', `gmt_modify` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间', PRIMARY KEY(`order_id`,`goods_id`) )ENGINE=InnoDB AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';