数据库设计

1,新建数据库onecms

CREATE DATABASE onecms;

2,新建goods表:

CREATE TABLE goods(

id int(11) not null primary key auto_increment,

goodstypeid int(11) NOT NULL,

goodstypefid int(11) NOT NULL,

goodstypefstr varchar(33) NOT NULL,

title varchar(255) NOT NULL,

flag varchar(33) NOT NULL,

marketprice int(11) NOT NULL,

salesprice int(11) NOT NULL,

housenum int(11) NOT NULL,

content VARCHAR(255) NOT NULL,

picurl varchar(255) NOT NULL,

hits int(11),

orderid int(11),

checkinfo smallint(1),

delstate smallint(1))ENGINE=InnoDB DEFAULT CHARSET=utf8;

3,新建goodstype表

CREATE TABLE goodstype(

id int(11) not null primary key auto_increment,

fid int(11) NOT NULL,

classname varchar(255) NOT NULL,

orderid int(11) NOT NULL,

checkinfo int(11) NOT NULL,

fstr VARCHAR(33) NOT NULL)

ENGINE=InnoDB DEFAULT CHARSET=utf8;

4,插入测试数据

goods表插入数据:

INSERT INTO `goods` VALUES ('1', '2', '0', '0,2,', '华为手机', '', '1000', '800', '1', '华为P10Plus', './uploads/c2922d7d93043572a95bd8b5289a41b.png', '18', '1', '1', '0');

INSERT INTO `goods` VALUES ('2', '4', '3', '0,3,4,', '羽绒服', '', '1000', '888', '0', '纯鸭绒羽绒服', './uploads/1397f1630770e4cc2d407c1911c2ecc.png', '3', '2', '1', '0');

INSERT INTO `goods` VALUES ('3', '1', '0', '0,1,', '笔记本', '', '3800', '3666', '0', '联想thinkpad笔记本', './uploads/fd9ecdaf3ee9a9035f51da6471e3f90.png', '2', '3', '1', '0');

goodstype表插入数据:

INSERT INTO `goodstype` VALUES ('1', '0', '电脑', '1', '1', '0,');

INSERT INTO `goodstype` VALUES ('2', '0', '手机', '2', '1', '0,');

INSERT INTO `goodstype` VALUES ('3', '0', '衣服', '3', '0', '0,');

INSERT INTO `goodstype` VALUES ('4', '3', '羽绒服', '4', '1', '0,3,');