script.sql

全面管理订单流程(包含下单,核单,发货,跟单,记账等等),物流,客户关系和销售 媒体分析,货品销售分析,话务业绩分析.

CREATE TABLE `address` (
  `address_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `name` varchar(50) default NULL,
  `address` varchar(200) default NULL,
  `post` varchar(10) default NULL,
  `tel` varchar(20) default NULL,
  `mobile` varchar(20) default NULL,
  PRIMARY KEY  (`address_id`),
  UNIQUE KEY `address_id` (`address_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `logo1` varchar(100) default NULL,
  `logo2` varchar(100) default NULL,
  `description` text,
  `status` int(11) default '1',
  PRIMARY KEY  (`brand_id`),
  UNIQUE KEY `brand_id` (`brand_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `favorite` (
  `favorite_id` int(11) NOT NULL auto_increment,
  `goods_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY  (`favorite_id`),
  UNIQUE KEY `favorite_id` (`favorite_id`),
  KEY `goods_id` (`goods_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `good` (
  `good_id` int(11) NOT NULL auto_increment,
  `goods_id` int(11) NOT NULL,
  `item` varchar(20) default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`good_id`),
  UNIQUE KEY `good_id` (`good_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL auto_increment,
  `brand_id` int(11) default NULL,
  `goodstype_id` int(11) NOT NULL,
  `goodstype_id2` int(11) default NULL,
  `name` varchar(50) default NULL,
  `photo` varchar(100) default NULL,
  `sphoto` varchar(100) default NULL,
  `price1` varchar(10) default NULL,
  `price2` varchar(10) default NULL,
  `price3` varchar(10) default NULL,
  `dot` int(11) default '0',
  `pv` int(11) default '0',
  `weight` int(11) default NULL,
  `kucun` int(11) default '0',
  `description` text,
  `createtime` datetime default NULL,
  `status` int(11) default '1',
  PRIMARY KEY  (`goods_id`),
  UNIQUE KEY `goods_id` (`goods_id`),
  KEY `goodstype_id` (`goodstype_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `goodstype` (
  `goodstype_id` int(11) NOT NULL auto_increment,
  `typename` varchar(20) default NULL,
  `parentId` int(11) default NULL,
  PRIMARY KEY  (`goodstype_id`),
  UNIQUE KEY `goodstype_id` (`goodstype_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `ordergoods` (
  `orderno` varchar(50) default NULL,
  `goods_id` int(11) NOT NULL,
  `price` varchar(20) default NULL,
  `count` int(11) default '1',
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL,
  `no` varchar(50) default NULL,
  `status` int(11) default '0',
  `createtime` datetime default NULL,
  `totalprice` varchar(20) default NULL,
  `paymethod_id` int(11) default NULL,
  `postmethod_id` int(11) default NULL,
  `usedot` int(11) default '0',
  `description` text,
  PRIMARY KEY  (`order_id`),
  UNIQUE KEY `order_id` (`order_id`),
  UNIQUE KEY `no` (`no`),
  KEY `user_id` (`user_id`),
  KEY `address_id` (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `orderstatus` (
  `orderstatus_id` int(11) NOT NULL auto_increment,
  `orderno` varchar(50) default NULL,
  `status` int(11) default NULL,
  `statusname` varchar(20) default NULL,
  `description` text,
  `createtime` timestamp NULL default NULL,
  PRIMARY KEY  (`orderstatus_id`),
  UNIQUE KEY `orderstatus_id` (`orderstatus_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `paymethod` (
  `paymethod_id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `description` text,
  PRIMARY KEY  (`paymethod_id`),
  UNIQUE KEY `paymethod_id` (`paymethod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `postmethod` (
  `postmethod_id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `first` varchar(30) default NULL,
  `firstfee` varchar(30) default NULL,
  `next` varchar(30) default NULL,
  `nextfee` varchar(30) default NULL,
  `other` varchar(30) default NULL,
  `otherfee` varchar(30) default NULL,
  `time` varchar(50) default NULL,
  PRIMARY KEY  (`postmethod_id`),
  UNIQUE KEY `postmethod_id` (`postmethod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `relategoods` (
  `id` int(11) NOT NULL auto_increment,
  `goods_id` int(11) default NULL,
  `relategoods_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `remit` (
  `remit_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `paymethod_id` int(11) default NULL,
  `remittime` varchar(20) default NULL,
  `remitmoney` varchar(20) default NULL,
  `description` char(20) default NULL,
  `createtime` datetime default NULL,
  PRIMARY KEY  (`remit_id`),
  UNIQUE KEY `remit_id` (`remit_id`),
  KEY `user_id` (`user_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `top` (
  `top_id` int(11) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `type` int(11) default '0',
  `status` int(11) default '1',
  PRIMARY KEY  (`top_id`),
  UNIQUE KEY `top_id` (`top_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `user` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `realname` varchar(20) default NULL,
  `password` varchar(20) default NULL,
  `tel` varchar(20) default NULL,
  `qq` varchar(20) default NULL,
  `email` varchar(50) default NULL,
  `city` varchar(30) default NULL,
  `ictype` varchar(20) default NULL,
  `ic` varchar(50) default NULL,
  `dot` int(11) default NULL,
  `sex` varchar(10) default NULL,
  `age` varchar(10) default NULL,
  `marry` varchar(8) default NULL,
  `mobile` varchar(20) default NULL,
  `post` varchar(10) default NULL,
  `address` varchar(100) default NULL,
  `status` int(11) default '1',
  `createtime` datetime default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `user` VALUES (1,'admin','','888888','','','[e-mail]','',NULL,'',NULL,'','','','','','',1,'2007-08-06 10:58:31');