- 论坛徽章:
- 1
|
CREATE TABLE `order_form` (
`orde_id` int(11) NOT NULL auto_increment,
`orde_number` char(12) NOT NULL,
`user_id` int( NOT NULL,
`user_merc_id` int( NOT NULL,
`mepm_id` tinyint(1) NOT NULL,
`mese_id` tinyint(1) NOT NULL,
`orde_carriage` float(7,2) NOT NULL,
`orde_consignee` char(20) NOT NULL,
`orde_address` varchar(80) NOT NULL,
`orde_postalcode` char(6) NOT NULL,
`orde_tel` char(22) default NULL,
`orde_mobil` char(12) default NULL,
`orde_consignee_des` char(20) NOT NULL,
`orde_address_des` varchar(80) NOT NULL,
`orde_postalcode_des` char(6) NOT NULL,
`orde_tel_des` char(22) default NULL,
`orde_mobil_des` char(12) default NULL,
`orst_id` tinyint(1) NOT NULL,
`orde_agio_code` varbinary(20) default NULL,
`orde_time` datetime NOT NULL,
`orst_time` datetime default NULL,
`orde_remark` varchar(20) default NULL,
PRIMARY KEY (`orde_id`),
KEY `orde_number` (`orde_number`),
KEY `user_id` (`user_id`,`orst_id`),
KEY `user_merc_id` (`user_merc_id`,`orst_id`),
KEY `orde_time` (`orde_time`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
这是ding9B.sql里面一个order_form表的结构,这个表是有auto_increment ,而ding9.sql 同样的order_form表就没有auto_increment 。 |
|