Posted By

jacktan on 10/30/14

Tagged

table

Versions (?)

Last Edited at 10/30/14 02:11am

Statistics

Viewed 808 times

Favorited by 0 user(s)

Related snippets

Table creating sql for a typical shopping cart

/ Published in: SQL

Confirm the sql script file is encoded with `UTF-8`

Highlighted TextExpand

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';

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.