<?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` cha
r(30) NOT NULL DEFAULT '0', `money` decimal(10,2) NOT NULL DEFAULT '0.00', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `custom` varcha
r(200) NOT NULL, `payment` cha
r(50) NOT NULL, `paymenttype` tinyint(1) unsigned NOT NULL DEFAULT '1', `paymentno` cha
r(100) NOT NULL, `molds` cha
r(30) NOT NULL, `aid` mediumint(8) unsigned NOT NULL DEFAULT '0', `addtime` int(10) unsigned NOT NULL DEFAULT '0', `auser` cha
r(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` cha
r(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` cha
r(50) NOT NULL, `name` cha
r(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` cha
r(30) NOT NULL, PRIMARY KEY (`pid`)) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=utf8
DROP TABLE IF EXISTS `jw_admin_user`
CREATE TABLE `jw_admin_user` ( `auid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `auser` cha
r(20) NOT NULL, `apass` cha
r(32) NOT NULL, `aname` cha
r(30) NOT NULL, `amail` cha
r(100) NOT NULL, `atel` cha
r(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) unsigned NOT NULL AUTO_INCREMENT, `taid` smallint(5) unsigned NOT NULL DEFAULT '0', `orders` int(10) NOT NULL DEFAULT '0', `name` cha
r(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` cha
r(200) NOT NULL, `body` text NOT NULL, `gourl` cha
r(200) NOT NULL, `target` cha
r(8) NOT NULL, `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
DROP TABLE IF EXISTS `jw_adstype`
CREATE TABLE `jw_adstype` ( `taid` smallint(5) NOT NULL AUTO_INCREMENT, `name` cha
r(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) unsigned 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` cha
r(100) NOT NULL, `style` cha
r(60) NOT NULL, `trait` cha
r(50) NOT NULL, `gourl` cha
r(255) NOT NULL, `htmlfile` cha
r(100) NOT NULL, `htmlurl` cha
r(255) NOT NULL, `addtime` int(10) unsigned NOT NULL DEFAULT '0', `hits` int(10) unsigned NOT NULL DEFAULT '0', `litpic` cha
r(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` cha
r(200) NOT NULL, `des
cription` cha
r(255) NOT NULL, `user` cha
r(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=54 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, 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` cha
r(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` cha
r(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` cha
r(20) NOT NULL, `pid` smallint(5) unsigned NOT NULL DEFAULT '0', `classname` cha
r(50) NOT NULL, `gourl` cha
r(255) NOT NULL, `litpic` cha
r(200) NOT NULL, `title` cha
r(100) NOT NULL, `keywords` cha
r(255) NOT NULL, `des
cription` varcha
r(300) NOT NULL, `isindex` tinyint(1) unsigned NOT NULL DEFAULT '1', `t_index` cha
r(50) NOT NULL, `t_list` cha
r(50) NOT NULL, `t_listimg` cha
r(50) NOT NULL, `t_listb` cha
r(50) NOT NULL, `t_content` cha
r(50) NOT NULL, `listnum` mediumint(8) unsigned NOT NULL DEFAULT '0', `htmldir` cha
r(100) NOT NULL, `htmlfile` cha
r(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` cha
r(20) NOT NULL, PRIMARY KEY (`tid`)) ENGINE=MyISAM AUTO_INCREMENT=101 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` cha
r(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` cha
r(30) NOT NULL, `ruser` cha
r(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` smallint(8) unsigned NOT NULL AUTO_INCREMENT, `name` cha
r(200) NOT NULL, `dir` cha
r(100) NOT NULL, `template` cha
r(100) NOT NULL, `file` cha
r(200) NOT NULL, `html` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
DROP TABLE IF EXISTS `jw_fields`
CREATE TABLE `jw_fields` ( `fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `molds` cha
r(20) NOT NULL, `fieldsname` cha
r(20) NOT NULL, `fields` cha
r(20) NOT NULL, `fieldstype` cha
r(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` cha
r(20) NOT NULL, `imgw` smallint(6) NOT NULL DEFAULT '0', `imgh` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`fid`)) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8
DROP TABLE IF EXISTS `jw_funs`