mysql 京东

浏览数：26 / 时间：2015年06月12日

DROP TABLE IF EXISTS `jd_admin`;
CREATE TABLE `jd_admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL COMMENT ‘用户名‘,
`password` varchar(64) NOT NULL COMMENT ‘密码‘,
`salt` char(6) NOT NULL COMMENT ‘加密KEY‘,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT ‘管理员表‘;
INSERT INTO `jd_admin` VALUES (1,‘admin‘,‘86f3059b228c8acf99e69734b6bb32cc‘,‘admin‘),(3,‘333‘,‘2222‘,‘‘),(4,‘555‘,‘0595fd2f9bae57aa90ff1112b459ecd4‘,‘4c2134‘);



CREATE table  jd_type(
   
   id  int  unsigned  not null  AUTO_INCREMENT  COMMENT ‘主键ID‘,
   type_name varchar(30)  not  null  COMMENT ‘类型名称‘,
   primary key(id)
)ENGINE=InnoDB  default charset=utf8  COMMENT ‘商品类型表‘;

insert  into jd_type  values(null,‘电脑‘);


DROP  TABLE  IF  EXISTS  jd_attribute;

CREATE table  jd_attribute(

    id  int  unsigned not null  AUTO_INCREMENT COMMENT ‘主键ID‘,
    attr_name varchar(30)  not null  COMMENT‘属性名称‘,
    attr_type int not  null  COMMENT  ‘属性类型‘,
    attr_value  varchar(300) not null DEFAULT ‘‘  COMMENT ‘属性可选值‘,
    type_id int  unsigned  not  null  COMMENT ‘类型ID‘,
    PRIMARY KEY(id),
    FOREIGN KEY (type_id) REFERENCES  jd_type(id)  on  DELETE CASCADE,
    KEY  type_id(type_id),
    KEY  attr_type(attr_type)
)ENGINE=InnoDB  DEFAULT  charset=utf8  COMMENT ‘商品属性表‘;