# sSpace V2.0.x
# Time:2005-08-11 12:40
# Tablepre: wane_
# Powered by wan-e.net
# Website: http://www.wan-e.net
DROP TABLE IF EXISTS `wane_ad`;
CREATE TABLE `wane_ad` (
`aid` smallint(6) unsigned NOT NULL auto_increment,
`context` text NOT NULL,
PRIMARY KEY (`aid`)
);
DROP TABLE IF EXISTS `wane_class`;
CREATE TABLE `wane_class` (
`cid` smallint(6) unsigned NOT NULL auto_increment,
`upid` smallint(6) unsigned NOT NULL default '0',
`upids` varchar(255) NOT NULL default '',
`upstage` int(20) unsigned NOT NULL default '1',
`title` varchar(50) NOT NULL default '',
`cateshow` tinyint(1) unsigned NOT NULL default '1',
`orderid` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `upid` (`upid`)
);
DROP TABLE IF EXISTS `wane_faq`;
CREATE TABLE `wane_faq` (
`fid` smallint(4) unsigned NOT NULL auto_increment,
`upfid` smallint(4) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`context` text NOT NULL,
`orderid` smallint(4) NOT NULL default '0',
PRIMARY KEY (`fid`),
KEY `upfid` (`upfid`)
);
DROP TABLE IF EXISTS `wane_favourite`;
CREATE TABLE `wane_favourite` (
`fid` mediumint(8) unsigned NOT NULL auto_increment,
`sid` mediumint(8) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`addtime` int(10) NOT NULL default '0',
PRIMARY KEY (`fid`),
KEY `sid` (`sid`),
KEY `uid` (`uid`)
);
DROP TABLE IF EXISTS `wane_links`;
CREATE TABLE `wane_links` (
`id` smallint(4) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`img` varchar(80) NOT NULL default '',
`url` varchar(80) NOT NULL default '',
`context` varchar(50) NOT NULL default '',
`orderid` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
);
DROP TABLE IF EXISTS `wane_log_admin`;
CREATE TABLE `wane_log_admin` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`take` varchar(255) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
);
DROP TABLE IF EXISTS `wane_log_credits`;
CREATE TABLE `wane_log_credits` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`uidt` mediumint(8) NOT NULL default '0',
`usernamet` varchar(30) NOT NULL default '',
`sid` mediumint(8) unsigned NOT NULL default '0',
`spname` varchar(80) NOT NULL default '',
`htmlroot` varchar(10) NOT NULL default '',
`operate` varchar(30) NOT NULL default '',
`credits` mediumint(8) NOT NULL default '0',
`addtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `uidt` (`uidt`),
KEY `sid` (`sid`)
);
DROP TABLE IF EXISTS `wane_log_merchant`;
CREATE TABLE `wane_log_merchant` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`orderid` varchar(32) NOT NULL default '',
`sid` mediumint(8) unsigned NOT NULL default '0',
`spname` varchar(80) NOT NULL default '',
`htmlroot` varchar(10) NOT NULL default '',
`uids` mediumint(8) unsigned NOT NULL default '0',
`users` varchar(30) NOT NULL default '',
`uidb` mediumint(8) unsigned NOT NULL default '0',
`userb` varchar(30) NOT NULL default '',
`take` varchar(255) NOT NULL default '',
`spend` float unsigned NOT NULL default '0',
`addtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sid` (`sid`),
KEY `uids` (`uids`),
KEY `uidb` (`uidb`)
);
DROP TABLE IF EXISTS `wane_made`;
CREATE TABLE `wane_made` (
`mid` smallint(6) unsigned NOT NULL auto_increment,
`upmid` smallint(6) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`orderid` smallint(6) unsigned NOT NULL default '0',
`sps` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`mid`),
KEY `upmid` (`upmid`)
);
DROP TABLE IF EXISTS `wane_member`;
CREATE TABLE `wane_member` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`kind` smallint(3) NOT NULL default '0',
`pms` smallint(4) unsigned NOT NULL default '0',
`regtime` int(10) unsigned NOT NULL default '0',
`regip` varchar(15) NOT NULL default '',
`logins` smallint(4) unsigned NOT NULL default '1',
`lastlogin` int(10) unsigned NOT NULL default '0',
`vip` tinyint(1) NOT NULL default '0',
`losetime` int(10) unsigned NOT NULL default '0',
`info_sign` tinyint(1) unsigned NOT NULL default '0',
`credits` mediumint(6) unsigned NOT NULL default '0',
`money_left` float unsigned NOT NULL default '0',
`money_take` float unsigned NOT NULL default '0',
`buy` smallint(4) unsigned NOT NULL default '0',
`buys` smallint(4) unsigned NOT NULL default '0',
`sale` smallint(4) unsigned NOT NULL default '0',
`sales` smallint(4) unsigned NOT NULL default '0',
`question` varchar(80) NOT NULL default '',
`answer` varchar(80) NOT NULL default '',
`truename` varchar(30) NOT NULL default '',
`phone` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`zipcode` int(6) unsigned zerofill NOT NULL default '000000',
`qq` varchar(14) NOT NULL default '',
`icq` varchar(14) NOT NULL default '',
`msn` varchar(50) NOT NULL default '',
`yahoo` varchar(50) NOT NULL default '',
PRIMARY KEY (`uid`)
);
DROP TABLE IF EXISTS `wane_news`;
CREATE TABLE `wane_news` (
`nid` mediumint(8) unsigned NOT NULL auto_increment,
`announce` tinyint(1) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`context` text NOT NULL,
`author` varchar(30) NOT NULL default '',
`itfrom` varchar(50) NOT NULL default '',
`addtime` int(10) NOT NULL default '0',
`click` smallint(6) unsigned NOT NULL default '0',
`htmlroot` varchar(10) NOT NULL default '',
PRIMARY KEY (`nid`)
);
DROP TABLE IF EXISTS `wane_orders`;
CREATE TABLE `wane_orders` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`orderid` varchar(32) NOT NULL default '',
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`uids` int(12) NOT NULL default '0',
`usernames` varchar(30) NOT NULL default '',
`sid` int(12) unsigned NOT NULL default '0',
`spname` varchar(50) NOT NULL default '',
`htmlroot` varchar(10) NOT NULL default '',
`payway` set('other','home','bank','online') NOT NULL default 'other',
`spcount` smallint(6) NOT NULL default '0',
`sendoutway` mediumint(8) unsigned NOT NULL default '0',
`sendoutspend` float unsigned NOT NULL default '0',
`price` double NOT NULL default '0',
`spend` double NOT NULL default '0',
`take` tinyint(1) NOT NULL default '0',
`sign` tinyint(1) NOT NULL default '1',
`truename` varchar(30) NOT NULL default '',
`phone` varchar(30) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`zipcode` mediumint(6) NOT NULL default '0',
`email` varchar(80) NOT NULL default '',
`qq` varchar(14) NOT NULL default '',
`icq` varchar(14) NOT NULL default '',
`msn` varchar(80) NOT NULL default '',
`yahoo` varchar(80) NOT NULL default '',
`context` text NOT NULL,
`addtime` int(10) unsigned NOT NULL default '0',
`operate` set('none','taked','merchant') NOT NULL default 'none',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `uids` (`uids`),
KEY `sid` (`sid`),
KEY `sendoutway` (`sendoutway`)
);
DROP TABLE IF EXISTS `wane_pms`;
CREATE TABLE `wane_pms` (
`pmid` mediumint(8) unsigned NOT NULL auto_increment,
`recid` mediumint(8) unsigned NOT NULL default '0',
`recer` varchar(30) NOT NULL de