setup41.sql

关于进售存的 好东西

DROP TABLE IF EXISTS `#@__boss`;
CREATE TABLE `#@__boss` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`boss` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 32 ) NOT NULL ,
`logindate` DATETIME NOT NULL ,
`loginip` VARCHAR( 15 ) NOT NULL ,
`errnumber` INT( 11 ) NOT NULL ,
`rank` SMALLINT( 6 ) NOT NULL
) TYPE=MyISAM DEFAULT CHARSET=#~lang~#;

DROP TABLE IF EXISTS `#@__config`;
CREATE TABLE `#@__config` (
`id` INT( 11 ) NOT NULL ,
`config_name` VARCHAR( 30 ) NOT NULL ,
`config_mem` VARCHAR( 50 ) NOT NULL ,
`config_value` VARCHAR( 30 ) NOT NULL ,
`config_type` VARCHAR( 20 ) NOT NULL ,
`config_len` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) TYPE=MyISAM DEFAULT CHARSET=#~lang~#;

DROP TABLE IF EXISTS `#@__flink`;
CREATE TABLE `#@__flink` (
  `ID` int(11) NOT NULL auto_increment,
  `sortrank` int(11) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  `webname` varchar(30) NOT NULL default '',
  `msg` varchar(250) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `logo` varchar(100) NOT NULL default '',
  `dtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `typeid` int(11) NOT NULL default '0',
  `ischeck` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;


DROP TABLE IF EXISTS `#@__area`;
CREATE TABLE `#@__area` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `reid` int(10) unsigned NOT NULL default '0',
  `disorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

DROP TABLE IF EXISTS `#@__recordline`;
CREATE TABLE `#@__recordline` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`message` TEXT NOT NULL ,
`date` DATETIME NOT NULL ,
`ip` VARCHAR( 15 ) NOT NULL ,
`userid` VARCHAR( 20 ) NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__usertype`;
CREATE TABLE `#@__usertype` (
`rank` SMALLINT( 6 ) NOT NULL ,
`typename` VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`system` SMALLINT( 6 ) NOT NULL ,
`content` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__menu`;
CREATE TABLE `#@__menu` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 100 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`url` VARCHAR( 100 ) NOT NULL ,
`reid` INT( 10 ) NOT NULL ,
`rank` TEXT NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__categories`;
CREATE TABLE `#@__categories` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`categories` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`reid` SMALLINT( 6 ) NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__dw`;
CREATE TABLE `#@__dw` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`dwname` VARCHAR( 20 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`reid` SMALLINT( 6 ) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__gys`;
CREATE TABLE `#@__gys` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`g_name` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`g_address` VARCHAR( 120 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`g_people` VARCHAR( 10 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`g_phone` VARCHAR( 12 ) NOT NULL ,
`g_qq` VARCHAR( 20 ) NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__staff`;
CREATE TABLE `#@__staff` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`s_name` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`s_address` VARCHAR( 120 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`s_phone` VARCHAR( 15 ) NOT NULL ,
`s_part` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`s_way` SMALLINT( 6 ) NOT NULL DEFAULT '0',
`s_money` FLOAT( 20 ) NOT NULL ,
`s_utype` SMALLINT( 6 ) NOT NULL ,
`s_duty` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__guest`;
CREATE TABLE `#@__guest` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`g_name` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`g_sex` VARCHAR( 5 ) NOT NULL ,
`g_address` VARCHAR( 120 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`g_phone` VARCHAR( 15 ) NOT NULL ,
`g_qq` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`g_birthday` DATE NOT NULL DEFAULT '0000-00-00',
`g_card` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`g_group` SMALLINT( 6 ) NOT NULL ,
`g_people` VARCHAR( 20 ) NOT NULL ,
`g_dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__group`;
CREATE TABLE `#@__group` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`groupname` VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`sub` FLOAT NOT NULL DEFAULT '10'
) ENGINE = MYISAM DEFAULT CHARSET=#~lang~#;

DROP TABLE IF EXISTS `#@__lab`;
CREATE TABLE `#@__lab` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`l_name` VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`l_city` VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`l_mang` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`l_default` SMALLINT( 6 ) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__basic`;
CREATE TABLE `#@__basic` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`cp_number` VARCHAR( 15 ) NOT NULL ,
`cp_tm` VARCHAR( 15 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`cp_name` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`cp_gg` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`cp_categories` SMALLINT( 6 ) NOT NULL ,
`cp_categories_down` SMALLINT( 6 ) NOT NULL ,
`cp_dwname` SMALLINT( 6 ) NOT NULL ,
`cp_jj` FLOAT( 20 ) NOT NULL ,
`cp_sale` FLOAT( 20 ) NOT NULL ,
`cp_saleall` FLOAT( 20 ) NOT NULL ,
`cp_sdate` DATE NOT NULL DEFAULT '0000-00-00',
`cp_edate` DATE NOT NULL DEFAULT '0000-00-00',
`cp_gys` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`cp_helpword` VARCHAR( 50 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`cp_bz` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__reportrk`;
CREATE TABLE `#@__reportrk` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`r_dh` VARCHAR( 20 ) NOT NULL ,
`r_people` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`r_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`r_status` SMALLINT( 6 ) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__reportbackgys`;
CREATE TABLE `#@__reportbackgys` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`r_dh` VARCHAR( 20 ) NOT NULL ,
`r_people` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`r_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`r_status` SMALLINT( 6 ) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__reportsale`;
CREATE TABLE `#@__reportsale` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`r_dh` VARCHAR( 20 ) NOT NULL ,
`r_people` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`r_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`r_status` SMALLINT( 6 ) NOT NULL DEFAULT '0' ,
`r_adid` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__reportsback`;
CREATE TABLE `#@__reportsback` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`r_dh` VARCHAR( 20 ) NOT NULL ,
`r_people` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`r_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`r_status` SMALLINT( 6 ) NOT NULL DEFAULT '0' 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__kc`;
CREATE TABLE `#@__kc` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`productid` VARCHAR( 15 ) NOT NULL  ,
`number` INT( 11 ) NOT NULL ,
`labid` SMALLINT( 6 ) NOT NULL ,
`rdh` VARCHAR( 20 ) NOT NULL ,
`dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__kcbackgys`;
CREATE TABLE `#@__kcbackgys` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`productid` VARCHAR( 15 ) NOT NULL ,
`number` INT( 11 ) NOT NULL ,
`labid` SMALLINT( 6 ) NOT NULL ,
`rdh` VARCHAR( 20 ) NOT NULL ,
`dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__sale`;
CREATE TABLE `#@__sale` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`productid` VARCHAR( 15 ) NOT NULL ,
`number` INT( 11 ) NOT NULL ,
`rdh` VARCHAR( 20 ) NOT NULL ,
`dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__saleback`;
CREATE TABLE `#@__saleback` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`productid` VARCHAR( 15 ) NOT NULL ,
`number` INT( 11 ) NOT NULL ,
`rdh` VARCHAR( 20 ) NOT NULL ,
`dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`r_text` TEXT NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__mainkc`;
CREATE TABLE `#@__mainkc` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`p_id` VARCHAR( 15 ) NOT NULL  ,
`l_id` SMALLINT( 6 ) NOT NULL ,
`d_id` VARCHAR( 20 ) NOT NULL ,
`number` INT( 11 ) NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__accounts`;
CREATE TABLE `#@__accounts` (
`id` SMALLINT( 8 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`atype` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`amoney` FLOAT( 50 ) NOT NULL ,
`abank` SMALLINT( 6 ) NOT NULL ,
`dtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`apeople` VARCHAR( 10 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`atext` TEXT CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; 

DROP TABLE IF EXISTS `#@__bank`;
CREATE TABLE `#@__bank` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`bank_name` VARCHAR( 30 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL ,
`bank_money` FLOAT NOT NULL ,
`bank_account` VARCHAR( 30 ) NOT NULL ,
`bank_default` SMALLINT( 6 ) NOT NULL ,
`bank_text` TEXT NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;