PHP实例开发源码-PHP米表程序.zip

<?php die();?>DROP TABLE IF EXISTS `jw_account` CREATE TABLE `jw_account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `orderid` char(30) NOT NULL DEFAULT '0', `money` decimal(10,2) NOT NULL DEFAULT '0.00', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `custom` varchar(200) NOT NULL, `payment` char(50) NOT NULL, `paymenttype` tinyint(1) unsigned NOT NULL DEFAULT '1', `paymentno` char(100) NOT NULL, `molds` char(30) NOT NULL, `aid` mediumint(8) unsigned NOT NULL DEFAULT '0', `addtime` int(10) unsigned NOT NULL DEFAULT '0', `auser` char(30) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_admin_group` CREATE TABLE `jw_admin_group` ( `gid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` char(20) NOT NULL, `audit` tinyint(1) unsigned NOT NULL DEFAULT '0', `oneself` tinyint(1) unsigned NOT NULL DEFAULT '0', `paction` text NOT NULL, PRIMARY KEY (`gid`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_admin_per` CREATE TABLE `jw_admin_per` ( `pid` tinyint(5) unsigned NOT NULL AUTO_INCREMENT, `action` char(50) NOT NULL, `name` char(20) NOT NULL, `up` tinyint(5) NOT NULL DEFAULT '0', `no` tinyint(1) unsigned NOT NULL DEFAULT '0', `orders` int(10) unsigned NOT NULL DEFAULT '0', `molds` char(30) NOT NULL, PRIMARY KEY (`pid`)) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_admin_user` CREATE TABLE `jw_admin_user` ( `auid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `auser` char(20) NOT NULL, `apass` char(32) NOT NULL, `aname` char(30) NOT NULL, `amail` char(100) NOT NULL, `atel` char(100) NOT NULL, `level` tinyint(1) unsigned NOT NULL DEFAULT '0', `gid` smallint(5) unsigned NOT NULL DEFAULT '0', `pclasstype` text NOT NULL, PRIMARY KEY (`auid`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_ads` CREATE TABLE `jw_ads` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `taid` smallint(5) unsigned NOT NULL DEFAULT '0', `orders` int(10) NOT NULL DEFAULT '0', `name` char(100) NOT NULL, `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `adsw` smallint(5) unsigned NOT NULL DEFAULT '0', `adsh` smallint(5) unsigned NOT NULL DEFAULT '0', `adfile` char(200) NOT NULL, `body` text NOT NULL, `gourl` char(200) NOT NULL, `target` char(8) NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_adstype` CREATE TABLE `jw_adstype` ( `taid` smallint(5) NOT NULL AUTO_INCREMENT, `name` char(100) NOT NULL, `adsw` smallint(5) unsigned NOT NULL DEFAULT '0', `adsh` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`taid`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_article` CREATE TABLE `jw_article` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `tid` smallint(5) unsigned NOT NULL DEFAULT '0', `sid` smallint(5) unsigned NOT NULL DEFAULT '0', `isshow` tinyint(1) unsigned NOT NULL DEFAULT '0', `title` char(100) NOT NULL, `style` char(60) NOT NULL, `trait` char(50) NOT NULL, `gourl` char(255) NOT NULL, `htmlfile` char(100) NOT NULL, `htmlurl` char(255) NOT NULL, `addtime` int(10) unsigned NOT NULL DEFAULT '0', `hits` int(10) unsigned NOT NULL DEFAULT '0', `litpic` char(255) NOT NULL, `orders` int(10) NOT NULL DEFAULT '0', `mrank` smallint(5) NOT NULL DEFAULT '0', `mgold` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `keywords` char(200) NOT NULL, `description` char(255) NOT NULL, `user` char(30) NOT NULL, `usertype` tinyint(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `orbye` (`orders`,`addtime`) USING BTREE, KEY `article` (`isshow`,`tid`,`trait`,`sid`) USING BTREE) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_article_field` CREATE TABLE `jw_article_field` ( `aid` mediumint(8) unsigned NOT NULL DEFAULT '0', `body` mediumtext NOT NULL, `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', PRIMARY KEY (`aid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_attribute` CREATE TABLE `jw_attribute` ( `sid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `tid` mediumint(8) unsigned NOT NULL, `name` char(100) NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1', `orders` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`sid`), KEY `attribute` (`tid`,`isshow`) USING BTREE, KEY `attribute_orbye` (`orders`) USING BTREE) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_attribute_type` CREATE TABLE `jw_attribute_type` ( `tid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` char(100) NOT NULL, `classtype` text NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1', `orders` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`tid`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_classtype` CREATE TABLE `jw_classtype` ( `tid` mediumint(8) NOT NULL AUTO_INCREMENT, `molds` char(20) NOT NULL, `pid` smallint(5) unsigned NOT NULL DEFAULT '0', `classname` char(50) NOT NULL, `classnamesub` char(80) NOT NULL, `gourl` char(255) NOT NULL, `litpic` char(200) NOT NULL, `title` char(100) NOT NULL, `keywords` char(255) NOT NULL, `description` varchar(300) NOT NULL, `isindex` tinyint(1) unsigned NOT NULL DEFAULT '1', `t_index` char(50) NOT NULL, `t_list` char(50) NOT NULL, `t_listimg` char(50) NOT NULL, `t_listb` char(50) NOT NULL, `t_content` char(50) NOT NULL, `listnum` mediumint(8) unsigned NOT NULL DEFAULT '0', `htmldir` char(100) NOT NULL, `htmlfile` char(100) NOT NULL, `mrank` smallint(5) NOT NULL DEFAULT '0', `msubmit` smallint(5) NOT NULL DEFAULT '0', `orders` int(10) NOT NULL DEFAULT '0', `body` mediumtext NOT NULL, `mshow` tinyint(1) unsigned NOT NULL DEFAULT '1', `imgw` smallint(5) unsigned NOT NULL DEFAULT '0', `imgh` smallint(5) unsigned NOT NULL DEFAULT '0', `unit` char(20) NOT NULL, PRIMARY KEY (`tid`)) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_comment` CREATE TABLE `jw_comment` ( `cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `aid` mediumint(8) unsigned NOT NULL, `molds` char(20) NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '0', `body` text NOT NULL, `reply` text NOT NULL, `addtime` int(10) unsigned NOT NULL DEFAULT '0', `retime` int(10) unsigned NOT NULL DEFAULT '0', `user` char(30) NOT NULL, `ruser` char(30) NOT NULL, PRIMARY KEY (`cid`)) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_custom` CREATE TABLE `jw_custom` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `name` char(200) NOT NULL, `dir` char(100) NOT NULL, `template` char(100) NOT NULL, `file` char(200) NOT NULL, `html` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_fields` CREATE TABLE `jw_fields` ( `fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `molds` char(20) NOT NULL, `fieldsname` char(20) NOT NULL, `fields` char(20) NOT NULL, `fieldstype` char(20) NOT NULL, `fieldslong` smallint(5) unsigned NOT NULL DEFAULT '0', `selects` text NOT NULL, `fieldorder` int(10) NOT NULL DEFAULT '0', `issubmit` tinyint(1) unsigned NOT NULL DEFAULT '1', `lists` tinyint(1) unsigned NOT NULL DEFAULT '0', `fieldshow` tinyint(1) unsigned NOT NULL DEFAULT '1', `types` text NOT NULL, `contingency` char(20) NOT NULL, `imgw` smallint(6) NOT NULL DEFAULT '0', `imgh` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`fid`)) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 DROP TABLE IF EXISTS `jw_funs` CREATE TABLE `jw_funs` ( `fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `funs` char(20) NOT NULL, `fundb` char(255) NOT NULL, `name` char(20) NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1', `afiles` text NOT NULL, `version` char(20)