Revision: 67783
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 30, 2014 02:11 by jacktan
Initial Code
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';
Initial URL
Initial Description
Confirm the sql script file is encoded with `UTF-8`
Initial Title
Table creating sql for a typical shopping cart
Initial Tags
table
Initial Language
SQL