mysql 创建订单表语句_MySQL创建表语句

/*表： t_admin_tabs*/---------------------

/*列信息*/-----------

Field Type Collation Null Key Default Extra Privileges Comment

---------- ---------------- --------------- ------ ------ ------- ------ ------------------------------- --------------

admin_id int(11) unsigned (NULL) NO PRI (NULL) select,insert,update,references 编号

name varchar(50) utf8_general_ci NO (NULL) select,insert,update,references 用户名

password varchar(50) utf8_general_ci NO (NULL) select,insert,update,references 密码

login_time datetime (NULL) NO (NULL) select,insert,update,references 登录时间

/*索引信息*/--------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment

------------ ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ---------

t_admin_tabs 0 PRIMARY 1 admin_id A 0 (NULL) (NULL) BTREE

/*DDL 信息*/------------

CREATE TABLE `t_admin_tabs` (

`admin_id` int(11) unsigned NOT NULL COMMENT '编号',

`name` varchar(50) NOT NULL COMMENT '用户名',

`password` varchar(50) NOT NULL COMMENT '密码',

`login_time` datetime NOT NULL COMMENT '登录时间',

PRIMARY KEY (`admin_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8