WebRoot/maker.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE TABLE `quanxian` (
`qxid` int(11) NOT NULL auto_increment,
`qx` VARCHAR(40) default NULL,  PRIMARY KEY  (`qxid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `yonghu` (
`yhid` int(11) NOT NULL auto_increment,
`yhm` VARCHAR(40) default NULL,
`mm` VARCHAR(40) default NULL,
`zsxm` VARCHAR(40) default NULL,
`yj` VARCHAR(40) default NULL,
`dz` VARCHAR(40) default NULL,
`dh` VARCHAR(40) default NULL,
`zcsj` VARCHAR(40) default NULL,
`qx` VARCHAR(40) default NULL,  PRIMARY KEY  (`yhid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `leibie` (
`lbid` int(11) NOT NULL auto_increment,
`lbmc` VARCHAR(40) default NULL,
`jg` VARCHAR(40) default NULL,  PRIMARY KEY  (`lbid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `kefang` (
`kfid` int(11) NOT NULL auto_increment,
`kfmc` VARCHAR(40) default NULL,
`wz` VARCHAR(40) default NULL,
`fjh` VARCHAR(40) default NULL,
`ms` VARCHAR(40) default NULL,
`fjdh` VARCHAR(40) default NULL,
`lbid` INTEGER(11) default NULL,  PRIMARY KEY  (`kfid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `zhusu` (
`zsid` int(11) NOT NULL auto_increment,
`kfid` INTEGER(11) default NULL,
`yhid` INTEGER(11) default NULL,
`sjjg` VARCHAR(40) default NULL,
`zt` VARCHAR(40) default NULL,
`jszt` VARCHAR(40) default NULL,
`zsts` VARCHAR(40) default NULL,
`rzsj` VARCHAR(40) default NULL,
`jzsj` VARCHAR(40) default NULL,  PRIMARY KEY  (`zsid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `gonggao` (
`ggid` int(11) NOT NULL auto_increment,
`ggnr` VARCHAR(40) default NULL,
`sj` VARCHAR(40) default NULL,  PRIMARY KEY  (`ggid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
CREATE TABLE `caiwu` (
`cwid` int(11) NOT NULL auto_increment,
`jg` VARCHAR(40) default NULL,
`sm` VARCHAR(40) default NULL,
`zt` VARCHAR(40) default NULL,  PRIMARY KEY  (`cwid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;