DROP TABLE IF EXISTS pw_actions;
CREATE TABLE pw_actions (
  id smallint(6) unsigned NOT NULL auto_increment,
  images char(15) NOT NULL default '',
  `name` char(15) NOT NULL default '',
  descrip char(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_actions(images,name,descrip) VALUES ('1.gif', '{#action_1}', '{#act_1}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('2.gif', '{#action_2}', '{#act_2}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('3.gif', '{#action_3}', '{#act_3}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('4.gif', '{#action_4}', '{#act_4}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('5.gif', '{#action_5}', '{#act_5}');

DROP TABLE IF EXISTS pw_activity;
CREATE TABLE pw_activity (
  tid mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(80) NOT NULL default '',
  admin mediumint(8) NOT NULL default '0',
  starttime int(10) NOT NULL default '0',
  endtime int(10) NOT NULL default '0',
  location varchar(20) NOT NULL default '',
  num smallint(6) NOT NULL default '0',
  sexneed tinyint(1) NOT NULL default '0',
  costs int(10) NOT NULL default '0',
  deadline int(10) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY admin (admin)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_actmember;
CREATE TABLE pw_actmember (
  id mediumint(8) unsigned NOT NULL auto_increment,
  actid mediumint(8) NOT NULL default '0',
  winduid mediumint(8) NOT NULL default '0',
  state tinyint(1) NOT NULL default '0',
  applydate int(10) NOT NULL default '0',
  contact varchar(20) NOT NULL default '',
  message varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY actid (actid),
  KEY winduid (winduid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_administrators;
CREATE TABLE pw_administrators (
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  groupid tinyint(3) NOT NULL default '0',
  groups varchar(255) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_adminlog;
CREATE TABLE pw_adminlog (
  id int(11) NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '',
  username1 varchar(30) NOT NULL default '',
  username2 varchar(30) NOT NULL default '',
  field1 varchar(30) NOT NULL default '',
  field2 varchar(30) NOT NULL default '',
  field3 varchar(255) NOT NULL default '',
  descrip text NOT NULL,
  `timestamp` int(10) NOT NULL default '0',
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY `type` (`type`,`timestamp`),
  KEY username1 (username1),
  KEY username2 (username2)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_adminset;
CREATE TABLE pw_adminset (
  gid tinyint(3) unsigned NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (gid)
) TYPE=MyISAM;

INSERT INTO pw_adminset VALUES (3, 'a:53:{s:8:"settings";a:11:{s:5:"basic";i:1;s:4:"safe";i:1;s:3:"att";i:1;s:6:"credit";i:1;s:3:"reg";i:1;s:6:"member";i:1;s:6:"pcache";i:1;s:5:"index";i:1;s:6:"thread";i:1;s:4:"read";i:1;s:5:"other";i:1;}s:11:"updatecache";s:1:"1";s:9:"postcache";s:1:"1";s:6:"credit";s:1:"1";s:8:"setforum";s:1:"1";s:10:"uniteforum";s:1:"1";s:8:"creathtm";s:1:"1";s:7:"setuser";s:1:"1";s:8:"ipsearch";s:1:"1";s:9:"userstats";s:1:"1";s:7:"upgrade";s:1:"1";s:9:"editgroup";s:1:"1";s:5:"level";s:1:"1";s:7:"article";i:0;s:6:"member";i:0;s:7:"message";i:0;s:7:"banuser";s:1:"1";s:7:"viewban";s:1:"1";s:5:"ipban";s:1:"1";s:6:"setbwd";s:1:"1";s:8:"tpccheck";s:1:"1";s:9:"postcheck";s:1:"1";s:6:"report";s:1:"1";s:10:"checkemail";i:0;s:8:"checkreg";i:0;s:12:"announcement";s:1:"1";s:8:"mailuser";s:1:"1";s:8:"send_msg";s:1:"1";s:8:"giveuser";s:1:"1";s:10:"attachment";s:1:"1";s:11:"attachstats";s:1:"1";s:11:"attachrenew";s:1:"1";s:8:"adminlog";i:0;s:8:"forumlog";s:1:"1";s:9:"creditlog";s:1:"1";s:7:"userlog";s:1:"1";s:6:"setads";s:1:"1";s:8:"ipstates";s:1:"1";s:5:"share";s:1:"1";s:8:"viewtody";s:1:"1";s:5:"c_set";s:1:"1";s:7:"c_forum";s:1:"1";s:7:"c_unite";s:1:"1";s:5:"c_htm";s:1:"1";s:6:"addatc";s:1:"1";s:6:"schatc";s:1:"1";s:6:"bakout";s:1:"0";s:5:"bakin";s:1:"0";s:6:"repair";s:1:"0";s:9:"setstyles";s:1:"1";s:8:"superdel";a:3:{s:7:"article";i:1;s:6:"member";i:1;s:7:"message";i:1;}s:9:"usercheck";a:2:{s:10:"checkemail";i:1;s:8:"checkreg";i:1;}s:6:"record";a:1:{s:8:"adminlog";i:1;}}');
INSERT INTO pw_adminset VALUES (4, 'a:52:{s:8:"settings";s:1:"0";s:11:"updatecache";s:1:"0";s:9:"postcache";s:1:"1";s:6:"credit";s:1:"0";s:8:"setforum";s:1:"0";s:10:"uniteforum";s:1:"0";s:8:"creathtm";s:1:"0";s:7:"setuser";s:1:"0";s:8:"ipsearch";s:1:"1";s:9:"userstats";s:1:"1";s:7:"upgrade";s:1:"0";s:9:"editgroup";s:1:"1";s:5:"level";s:1:"0";s:7:"article";s:1:"0";s:6:"member";s:1:"0";s:7:"message";i:0;s:7:"banuser";s:1:"1";s:7:"viewban";s:1:"1";s:5:"ipban";s:1:"1";s:6:"setbwd";s:1:"1";s:8:"tpccheck";s:1:"1";s:9:"postcheck";s:1:"1";s:6:"report";s:1:"1";s:10:"checkemail";i:0;s:8:"checkreg";i:0;s:12:"announcement";s:1:"1";s:8:"mailuser";s:1:"0";s:8:"send_msg";s:1:"0";s:8:"giveuser";s:1:"1";s:10:"attachment";s:1:"1";s:11:"attachstats";s:1:"1";s:11:"attachrenew";s:1:"1";s:8:"adminlog";s:1:"0";s:8:"forumlog";s:1:"1";s:9:"creditlog";s:1:"1";s:7:"userlog";s:1:"1";s:6:"setads";s:1:"1";s:8:"ipstates";s:1:"0";s:5:"share";s:1:"1";s:8:"viewtody";s:1:"1";s:5:"c_set";s:1:"0";s:7:"c_forum";s:1:"0";s:7:"c_unite";s:1:"0";s:5:"c_htm";s:1:"0";s:6:"addatc";s:1:"0";s:6:"schatc";s:1:"0";s:6:"bakout";s:1:"0";s:5:"bakin";s:1:"0";s:6:"repair";s:1:"0";s:9:"setstyles";s:1:"0";s:8:"superdel";a:1:{s:7:"message";i:1;}s:9:"usercheck";a:2:{s:10:"checkemail";i:1;s:8:"checkreg";i:1;}}');
INSERT INTO pw_adminset VALUES (5, 'a:50:{s:8:"settings";s:1:"0";s:11:"updatecache";s:1:"0";s:9:"postcache";s:1:"0";s:6:"credit";s:1:"0";s:8:"setforum";s:1:"0";s:10:"uniteforum";s:1:"0";s:8:"creathtm";s:1:"0";s:7:"setuser";s:1:"0";s:8:"ipsearch";s:1:"0";s:9:"userstats";s:1:"0";s:7:"upgrade";s:1:"0";s:9:"editgroup";s:1:"0";s:5:"level";s:1:"0";s:7:"article";s:1:"0";s:6:"member";s:1:"0";s:7:"message";s:1:"0";s:7:"banuser";s:1:"1";s:7:"viewban";s:1:"1";s:5:"ipban";s:1:"0";s:6:"setbwd";s:1:"0";s:8:"tpccheck";s:1:"0";s:9:"postcheck";s:1:"0";s:6:"report";s:1:"1";s:10:"checkemail";s:1:"0";s:8:"checkreg";s:1:"0";s:12:"announcement";s:1:"1";s:8:"mailuser";s:1:"0";s:8:"send_msg";s:1:"0";s:8:"giveuser";s:1:"0";s:10:"attachment";s:1:"0";s:11:"attachstats";s:1:"0";s:11:"attachrenew";s:1:"0";s:8:"adminlog";s:1:"0";s:8:"forumlog";s:1:"1";s:9:"creditlog";s:1:"1";s:7:"userlog";s:1:"0";s:6:"setads";s:1:"0";s:8:"ipstates";s:1:"0";s:5:"share";s:1:"0";s:8:"viewtody";s:1:"0";s:5:"c_set";s:1:"0";s:7:"c_forum";s:1:"0";s:7:"c_unite";s:1:"0";s:5:"c_htm";s:1:"0";s:6:"addatc";s:1:"0";s:6:"schatc";s:1:"0";s:6:"bakout";s:1:"0";s:5:"bakin";s:1:"0";s:6:"repair";s:1:"0";s:9:"setstyles";s:1:"0";}');

DROP TABLE IF EXISTS pw_announce;
CREATE TABLE pw_announce (
  aid smallint(6) unsigned NOT NULL auto_increment,
  fid smallint(6) NOT NULL default '-1',
  ifopen tinyint(1) NOT NULL default '0',
  ifconvert tinyint(1) NOT NULL default '0',
  vieworder smallint(6) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  startdate varchar(15) NOT NULL default '',
  url varchar(80) NOT NULL default '',
  enddate varchar(15) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  content mediumtext NOT NULL,
  PRIMARY KEY  (aid),
  KEY vieworder (vieworder,startdate),
  KEY fid (fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_argument;
CREATE TABLE pw_argument (
  tid smallint(6) unsigned NOT NULL auto_increment,
  tpcid smallint(6) NOT NULL default '0',
  gid smallint(6) unsigned NOT NULL default '0',
  author varchar(20) NOT NULL default '',
  authorid mediumint(8) unsigned not null default '0',
  postdate int(10) unsigned NOT NULL default '0',
  lastpost int(10) NOT NULL default '0',
  topped tinyint(1) NOT NULL default '0',
  toppedtime int(10) NOT NULL default '0',
  `subject` varchar(50) NOT NULL default '',
  content text NOT NULL,
  PRIMARY KEY  (tid),
  KEY gid (gid,tpcid),
  KEY authorid (authorid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_attachbuy;
CREATE TABLE pw_attachbuy (
  `aid` mediumint(8) unsigned NOT NULL,
  `uid` mediumint(8) unsigned NOT NULL,
  `ctype` varchar(20) NOT NULL,
  `cost` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`aid`,`uid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_attachs;
CREATE TABLE pw_attachs (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  `name` char(80) NOT NULL default '',
  `type` char(30) NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  attachurl char(80) NOT NULL default '0',
  hits mediumint(8) unsigned NOT NULL default '0',
  needrvrc smallint(6) unsigned NOT NULL default '0',
  special tinyint(3) unsigned NOT NULL default '0',
  ctype varchar(20) NOT NULL default '',
  uploadtime int(10) NOT NULL default '0',
  descrip char(100) NOT NULL default '',
  ifthumb tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY fid (fid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid),
  KEY `type` (`type`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_banuser;
CREATE TABLE pw_banuser (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  fid smallint(6) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  startdate int(10) NOT NULL default '0',
  days int(4) NOT NULL default '0',
  admin char(15) NOT NULL default '',
  reason char(80) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY uid (uid,fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_bbsinfo;
CREATE TABLE pw_bbsinfo (
  id smallint(3) unsigned NOT NULL auto_increment,
  newmember varchar(15) NOT NULL default '',
  totalmember mediumint(8) unsigned NOT NULL default '0',
  higholnum smallint(6) unsigned NOT NULL default '0',
  higholtime int(10) unsigned NOT NULL default '0',
  tdtcontrol int(10) unsigned NOT NULL default '0',
  yposts mediumint(8) unsigned NOT NULL default '0',
  hposts mediumint(8) unsigned NOT NULL default '0',
  hit_tdtime int(10) unsigned NOT NULL default '0',
  hit_control tinyint(2) unsigned NOT NULL default '0',
  plantime int(10) NOT NULL default '0',
  o_post int(10) unsigned NOT NULL default '0',
  o_tpost int(10) unsigned NOT NULL default '0',
  KEY id (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_block;
CREATE TABLE pw_block (
  bid smallint(6) unsigned NOT NULL auto_increment,
  sid smallint(6) unsigned NOT NULL,
  function varchar(30) NOT NULL,
  name varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  fid varchar(30) NOT NULL,
  special varchar(30) NOT NULL,
  cachetime int(10) unsigned NOT NULL,
  ifextra tinyint(1) unsigned NOT NULL default '0',
  iflock tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (bid)
) TYPE=MyISAM;

INSERT INTO pw_block VALUES (1, 1, 'newsubject', '{#block_1}', '', '', '', 1800, 0, 1);
INSERT INTO pw_block VALUES (2, 1, 'newreply', '{#block_2}', '', '', '', 600, 0, 1);
INSERT INTO pw_block VALUES (3, 1, 'digestsubject', '{#block_3}', '', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (4, 1, 'replysort', '{#block_4}', '', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (5, 1, 'hitsort', '{#block_5}', '', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (6, 2, 'usersort', '{#block_6}', 'money', '', '1', 3000, 0, 1);
INSERT INTO pw_block VALUES (7, 2, 'usersort', '{#block_7}', 'rvrc', '', '1', 3000, 0, 1);
INSERT INTO pw_block VALUES (8, 3, 'forumsort', '{#block_8}', 'tpost', '', '', 600, 0, 1);
INSERT INTO pw_block VALUES (9, 3, 'forumsort', '{#block_9}', 'topic', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (10, 3, 'forumsort', '{#block_10}', 'article', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (11, 4, 'gettags', '{#block_11}', 'hot', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (12, 4, 'gettags', '{#block_12}', 'new', '', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (13, 5, 'newpic', '{#block_13}', '', '', '', 1700, 0, 1);
INSERT INTO pw_block VALUES (14, 5, 'newpic', '{#block_14}', '', 'cateid', '', 1900, 0, 1);
INSERT INTO pw_block VALUES (15, 6, 'replysort', '{#block_15}', '', '', '2', 86400, 0, 1);
INSERT INTO pw_block VALUES (16, 7, 'newsubject', '{#block_16}', '', '', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (17, 7, 'replysort', '{#block_17}', '', '', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (18, 2, 'usersort', '{#block_18}', 'onlinetime', '', '1', 86400, 0, 1);
INSERT INTO pw_block VALUES (19, 2, 'usersort', '{#block_19}', 'todaypost', '', '1', 1200, 0, 1);
INSERT INTO pw_block VALUES (20, 2, 'usersort', '{#block_20}', 'monthpost', '', '1', 40000, 0, 1);
INSERT INTO pw_block VALUES (21, 2, 'usersort', '{#block_21}', 'postnum', '', '1', 40000, 0, 1);
INSERT INTO pw_block VALUES (22, 2, 'usersort', '{#block_21}', 'monoltime', '', '1', 40000, 0, 1);
INSERT INTO pw_block VALUES (23, 1, 'replysort', '{#block_23}', 'replysortday', '', '', 1800, 0, 1);
INSERT INTO pw_block VALUES (24, 6, 'replysort', '{#block_24}', '', '', '2', 86400, 0, 1);
INSERT INTO pw_block VALUES (25, 2, 'usersort', '{#block_25}', 'credit', '', '', 3000, 0, 1);
INSERT INTO pw_block VALUES (26, 2, 'usersort', '{#block_26}', 'currency', '', '', 3000, 0, 1);
INSERT INTO pw_block VALUES (27, 8, 'getpushinfo', '{#block_27}', '', '', '', 90000, 0, 1);
INSERT INTO pw_block VALUES (28, 1, 'highlightsubject', '{#block_28}', '', 'cateid', '', 50000, 0, 1);
INSERT INTO pw_block VALUES (29, 1, 'highlightsubject', '{#block_29}', '', '', '', 50000, 0, 1);
INSERT INTO pw_block VALUES (30, 1, 'replysort', '{#block_30}', 'replysortday', 'cateid', '', 4000, 0, 1);
INSERT INTO pw_block VALUES (31, 1, 'digestsubject', '{#block_31}', '', 'cateid', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (32, 1, 'digestsubject', '{#block_32}', '', 'fid', '', 86400, 0, 1);
INSERT INTO pw_block VALUES (33, 1, 'highlightsubject', '{#block_33}', '', 'fid', '', 40000, 0, 1);
INSERT INTO pw_block VALUES (34, 1, 'newreply', '{#block_34}', '', 'cateid', '', 1200, 0, 1);
INSERT INTO pw_block VALUES (35, 8, 'getpushinfo', '{#block_35}', '', 'cateid', '', 90000, 0, 1);
INSERT INTO pw_block VALUES (36, 1, 'hitsort', '{#block_36}', '', 'cateid', '', 40000, 0, 1);
INSERT INTO pw_block VALUES (37, 1, 'newsubject', '{#block_37}', '', 'cateid', '', 1000, 0, 1);
INSERT INTO pw_block VALUES (38, 6, 'replysort', '{#block_38}', 'replysortday', '', '2', 3600, 0, 1);
INSERT INTO pw_block VALUES (39, 6, 'replysort', '{#block_39}', 'replysortday', 'cateid', '2', 1800, 0, 1);
INSERT INTO pw_block VALUES (40, 5, 'newpic', '{#block_40}', '', 'cateid', '', 2000, 0, 1);
INSERT INTO pw_block VALUES (41, 6, 'newsubject', '{#block_41}', '', '', '2', 1800, 0, 1);
INSERT INTO pw_block VALUES (42, 6, 'newsubject', '{#block_42}', '', 'cateid', '2', 1800, 0, 1);
INSERT INTO pw_block VALUES (43, 7, 'newsubject', '{#block_43}', '', '', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (44, 7, 'replysort', '{#block_44}', '', 'cateid', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (45, 7, 'replysort', '{#block_45}', 'replysortday', '', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (46, 7, 'replysort', '{#block_46}', 'replysortday', 'cateid', '4', 1800, 0, 1);
INSERT INTO pw_block VALUES (47, 1, 'hitsort', '{#block_47}', 'hitsortday', '', '', 1800, 0, 1);
INSERT INTO pw_block VALUES (48, 1, 'hitsort', '{#block_48}', 'hitsortday', 'cateid', '', 1800, 0, 1);

DROP TABLE IF EXISTS pw_buyadvert;
CREATE TABLE pw_buyadvert (
  id int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  config text NOT NULL,
  PRIMARY KEY  (id,uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_cache;
CREATE TABLE pw_cache (
  `name` varchar(20) NOT NULL default '',
  `cache` mediumtext NOT NULL,
  `time` int(10) NOT NULL default '0',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_clientorder;
CREATE TABLE pw_clientorder (
  id int(11) NOT NULL auto_increment,
  order_no varchar(30) NOT NULL default '',
  `type` tinyint(3) UNSIGNED NOT NULL,
  uid mediumint(8) NOT NULL default '0',
  paycredit varchar(15) NOT NULL default '',
  `price` DECIMAL(8,2) NOT NULL DEFAULT '0',
  payemail varchar(60) NOT NULL default '',
  number smallint(6) NOT NULL default '0',
  `date` int(10) NOT NULL default '0',
  state tinyint(1) NOT NULL default '0',
  `extra_1` mediumint(8) NOT NULL, 
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY order_no (order_no)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_cmembers;
CREATE TABLE pw_cmembers (
  id mediumint(9) NOT NULL auto_increment,
  uid mediumint(9) unsigned NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  realname varchar(20) NOT NULL default '',
  ifadmin tinyint(1) NOT NULL default '0',
  gender tinyint(1) NOT NULL default '0',
  tel varchar(15) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  colonyid smallint(6) NOT NULL default '0',
  address varchar(255) NOT NULL default '',
  introduce varchar(255) NOT NULL default '',
  `addtime` int(10) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY colonyid (colonyid,uid),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_cnalbum;
CREATE TABLE pw_cnalbum (
  aid mediumint(8) NOT NULL auto_increment,
  aname varchar(50) NOT NULL default '',
  aintro varchar(200) NOT NULL default '',
  atype smallint(4) NOT NULL default '0',
  `private` tinyint(1) UNSIGNED NOT NULL,
  ownerid mediumint(8) UNSIGNED NOT NULL,
  uid mediumint(8) NOT NULL default '0',
  owner varchar(50) NOT NULL default '',
  photonum smallint(6) NOT NULL default '0',
  lastphoto varchar(100) NOT NULL default '',
  lasttime int(10) UNSIGNED NOT NULL,
  lastpid varchar(100) NOT NULL,
  crtime int(10) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY atype (atype,ownerid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_cnclass;
CREATE TABLE pw_cnclass (
  cid smallint(6) unsigned NOT NULL auto_increment,
  cname char(20) NOT NULL default '',
  cnsum int(10) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY cname (cname)
) TYPE=MyISAM;

INSERT INTO pw_cnclass VALUES (1, '{#default_atc}','0');

DROP TABLE IF EXISTS pw_cnphoto;
CREATE TABLE pw_cnphoto (
  pid smallint(8) NOT NULL auto_increment,
  aid smallint(8) NOT NULL default '0',
  pintro varchar(200) NOT NULL default '',
  path varchar(200) NOT NULL default '',
  uploader varchar(50) NOT NULL default '',
  uptime int(10) NOT NULL default '0',
  hits smallint(6) NOT NULL default '0',
  ifthumb tinyint(1) UNSIGNED NOT NULL default '0',
  c_num MEDIUMINT(8) UNSIGNED NOT NULL,
  PRIMARY KEY  (pid),
  KEY aid (aid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_colonys;
CREATE TABLE pw_colonys (
  id smallint(6) unsigned NOT NULL auto_increment,
  classid smallint(6) NOT NULL default '0',
  cname varchar(20) NOT NULL default '',
  admin varchar(20) NOT NULL default '',
  members int(10) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  ifopen tinyint(1) NOT NULL default '0',
  albumopen tinyint(1) NOT NULL default '0',
  cnimg varchar(100) NOT NULL default '',
  createtime int(10) NOT NULL default '0',
  annouce varchar(255) NOT NULL default '',
  albumnum smallint(6) NOT NULL default '0',
  annoucesee smallint(6) NOT NULL default '0',
  descrip varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY cname (cname),
  KEY admin (admin),
  KEY classid (classid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_comment;
CREATE TABLE pw_comment (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL,
  `username` varchar(15) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(10) NOT NULL,
  `typeid` mediumint(8) NOT NULL,
  `upid` mediumint(8) NOT NULL,
  `postdate` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`typeid`),
  KEY `upid` (`upid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_config;
CREATE TABLE pw_config (
  db_name varchar(30) NOT NULL default '',
  db_value text NOT NULL,
  decrip text NOT NULL,
  PRIMARY KEY  (db_name)
) TYPE=MyISAM;

INSERT INTO pw_config (db_name, db_value) VALUES ('rg_regdetail', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_emailcheck', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_allowsameip', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_regsendemail', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_whyregclose', '{#rg_whyregclose}');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_welcomemsg', '{#rg_welcomemsg}');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_rgpermit', '{#rg_rgpermit}');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_banname', '{#rg_banname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_mailifopen', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bbsifopen', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_whybbsclose', '{#db_whybbsclose}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_openpost', '0		');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_onlinelmt', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_regpopup', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_debug', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_forumdir', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bbstitle', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_metakeyword', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_metadescrip', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bbsname', 'PHPwind Board');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bfn', 'index.php');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bbsurl', '{#db_bbsurl}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ceoconnect', '{#db_bbsurl}/sendemail.php?username={#db_manager}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ceoemail', 'webmaster@phpwind.com');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_recycle', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_icp', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_autochange', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_hour', '20');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_http', 'N');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attachurl', 'N');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_lp', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_obstart', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_charset', '{#db_charset}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_forcecharset', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_defaultstyle', 'wind');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_cvtime', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_timedf', '8');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_datefm', 'Y-m-d H:i');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pingtime', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_columns', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_msgsound', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_shield', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_tcheck', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_adminset', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifonlinetime', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifjump', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_refreshtime', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_onlinetime', '3600');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_maxresult', '500');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_footertime', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ckpath', '/');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ckdomain', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_postallowtime', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_cvtimes', '30');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_windpost', 'a:8:{s:3:"pic";s:1:"1";s:8:"picwidth";s:3:"700";s:9:"picheight";s:3:"700";s:4:"size";s:1:"6";s:5:"flash";s:1:"0";s:4:"mpeg";s:1:"1";s:6:"iframe";s:1:"0";s:8:"checkurl";s:1:"1";}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_signheight', '60');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_signwindcode', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_windpic', 'a:5:{s:3:"pic";s:1:"1";s:8:"picwidth";s:3:"700";s:9:"picheight";s:3:"700";s:4:"size";s:1:"5";s:5:"flash";s:1:"0";}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_allowupload', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attachdir', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attachhide', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attachnum', '4');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showreplynum', '5');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_selcount', '15');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_replysendmail', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_replysitemail', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pwcode', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_setform', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_titlemax', '100');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_postmax', '50000');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_postmin', '3');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_autoimg', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ntnum', '2');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifselfshare', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_indexlink', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_indexmqshare', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_indexshowbirth', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_indexonline', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_adminshow', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showguest', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_today', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_indexfmlogo', '2');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_todaypost', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_newtime', '3600');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_perpage', '20');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_readperpage', '10');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_maxpage', '1000');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_maxmember', '1000');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_anonymousname', '{#anonymousname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_hithour', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_topped', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_threadonline', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showonline', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_threadshowpost', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showcolony', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_threademotion', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ipfrom', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_watermark', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifgif', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterwidth', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterheight', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterpos', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterimg', 'mark.gif');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_watertext', 'http://www.phpwind.net');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterfont', '5');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_watercolor', '#0000FF');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waterpct', '85');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_jpgquality', '75');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_iffthumb', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifathumb', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_signmoney', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_wapifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_wapcharset', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_waplimit', '2000');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_jsifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_jsper', '600');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bindurl', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_loadavg', '3');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_cc', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ipcheck', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifsafecv', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_iplimit', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifftp', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ftpweb', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_enterreason', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_adminreason', '{#db_adminreason}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_opensch', '0		');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_gdcheck', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_postgd', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_gdstyle', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_gdtype', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_gdsize', '150	60	4');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_upload', '1	160	160	20480');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_uploadfiletype', 'a:6:{s:3:"gif";i:200;s:3:"png";i:200;s:3:"zip";i:1000;s:3:"rar";i:1000;s:3:"jpg";i:200;s:3:"txt";i:5;}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_creditset', 'a:3:{s:4:"rvrc";a:6:{s:6:"Digest";i:20;s:4:"Post";i:10;s:5:"Reply";i:10;s:8:"Undigest";i:20;s:6:"Delete";i:10;s:8:"Deleterp";i:10;}s:5:"money";a:6:{s:6:"Digest";i:20;s:4:"Post";i:10;s:5:"Reply";i:10;s:8:"Undigest";i:20;s:6:"Delete";i:10;s:8:"Deleterp";i:10;}i:1;a:6:{s:6:"Digest";i:0;s:4:"Post";i:0;s:5:"Reply";i:0;s:8:"Undigest";i:0;s:6:"Delete";i:0;s:8:"Deleterp";i:0;}}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showgroup', ',3,4,5,16,');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_showcustom', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_menu', '7');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_fthumbsize', '100	100');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_athumbsize', '575	0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_signgroup', ',5,6,7,16,8,9,10,11,12,13,14,15,');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_autoban', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_wapfids', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_safegroup', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attfg', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_allowregister', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_reg', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_regsendmsg', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_ifcheck', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_rglower', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_namelen', '3	12');
INSERT INTO pw_config (db_name, db_value) VALUES ('rg_pwdlen', '6	16');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtpauth', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_banby', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_bantype', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_banlimit', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_banmax', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_rmbrate', '10');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_rmblest', '5');
INSERT INTO pw_config (db_name, db_value) VALUES ('cy_virement', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('cy_virerate', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('cy_virelimit', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_diy', 'setforum,setuser,level,postcache,customfield,article');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ipban', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ipstates', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_union', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('fc_shownum', '7');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_tlist', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ptable', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_plist', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ads', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_wordsfb', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_htmifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_dir', '.php?');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ext', '.html');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_upgrade', 'a:7:{s:7:"postnum";s:3:"1.2";s:7:"digests";s:1:"0";s:4:"rvrc";s:1:"0";s:5:"money";s:3:"0.1";s:6:"credit";s:1:"0";s:10:"onlinetime";s:1:"0";i:1;s:3:"0.5";}');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_onlinepay', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_whycolse', '{#ol_whycolse}');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_payto', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_md5code', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_paypal', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_paypalcode', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_99bill', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ol_99billcode', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_head', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_foot', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptkey', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ppttype', 'client');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ppturls', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptserverurl', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptloginurl', 'login.php');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptloginouturl', 'login.php?action=quit');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptregurl', 'register.php');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_pptcredit', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_toolifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_allowtrade', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_attachname', 'attachment');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_picpath', 'images');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_htmdir', 'htm_data');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_guestdir', 'data/guestcache');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_mailmethod', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtphost', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtpport', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtpfrom', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtpuser', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtphelo', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_smtpmxmailname', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_mxdns', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ml_mxdnsbak', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ftp_pass', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ftp_server', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ftp_port', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ftp_dir', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('ftp_user', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_schwait', '2');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_registerfile', 'register.php');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_adminfile', 'admin.php');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_newinfoifopen', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_sortnum', '20');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_styledb', 'a:1:{s:4:"wind";a:2:{i:0;s:4:"wind";i:1;i:1;}}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_moneyname', '{#db_moneyname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_moneyunit', '{#db_moneyunit}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_rvrcname', '{#db_rvrcname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_rvrcunit', '{#db_rvrcunit}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_creditname', '{#db_creditname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_creditunit', '{#db_creditunit}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_currencyname', '{#db_currencyname}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_currencyunit', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_maxtypenum', '5');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_selectgroup', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_ifpwcache', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_urlcheck', '');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_xforwardip', '1');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_adminrecord', '0');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_floorunit', '{#db_floorunit}');
INSERT INTO pw_config (db_name, db_value) VALUES ('db_floorname', '{#db_floorname}');

DROP TABLE IF EXISTS pw_credits;
CREATE TABLE pw_credits (
  cid tinyint(3) unsigned NOT NULL auto_increment,
  `name` char(30) NOT NULL default '',
  unit char(30) NOT NULL default '',
  description char(255) NOT NULL default '',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;

INSERT INTO pw_credits VALUES ('1', '{#credit_name}','{#credit_unit}', '{#credit_descrip}');

DROP TABLE IF EXISTS pw_creditlog;
CREATE TABLE pw_creditlog (
  id int(10) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL,
  username varchar(15) NOT NULL,
  ctype varchar(8) NOT NULL,
  affect int(10) NOT NULL,
  adddate int(10) NOT NULL,
  logtype varchar(20) NOT NULL,
  ip varchar(15) NOT NULL,
  descrip varchar(255) NOT NULL,
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY adddate (adddate)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_customfield;
CREATE TABLE pw_customfield (
  id smallint(6) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  maxlen smallint(6) NOT NULL default '0',
  vieworder smallint(6) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  state tinyint(1) NOT NULL default '0',
  required tinyint(1) NOT NULL default '0',
  viewinread tinyint(1) NOT NULL default '0',
  editable tinyint(1) NOT NULL default '0',
  descrip varchar(255) NOT NULL default '',
  viewright varchar(255) NOT NULL default '',
  options text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_datastate;
CREATE TABLE pw_datastate (
  year smallint(4) NOT NULL default '0',
  month tinyint(2) NOT NULL default '0',
  day tinyint(2) NOT NULL default '0',
  topic mediumint(8) NOT NULL default '0',
  reply mediumint(8) NOT NULL default '0',
  regmen mediumint(8) NOT NULL default '0',
  postmen mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (year,month,day)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_debatedata;
CREATE TABLE pw_debatedata (
  `pid` int(10) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `authorid` int(10) unsigned NOT NULL,
  `standpoint` tinyint(1) unsigned NOT NULL default '0',
  `postdate` int(10) unsigned NOT NULL,
  `vote` int(10) unsigned NOT NULL,
  `voteids` text NOT NULL,
  PRIMARY KEY  (`pid`,`tid`,`authorid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_debates;
CREATE TABLE pw_debates (
  `tid` int(10) unsigned NOT NULL,
  `authorid` int(10) unsigned NOT NULL,
  `postdate` int(10) unsigned NOT NULL,
  `obtitle` varchar(255) NOT NULL,
  `retitle` varchar(255) NOT NULL,
  `endtime` int(10) unsigned NOT NULL,
  `obvote` int(10) unsigned NOT NULL default '0',
  `revote` int(10) unsigned NOT NULL default '0',
  `obposts` int(10) unsigned NOT NULL default '0',
  `reposts` int(10) unsigned NOT NULL default '0',
  `umpire` varchar(16) NOT NULL,
  `umpirepoint` varchar(255) NOT NULL,
  `debater` varchar(16) NOT NULL,
  `judge` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_draft;
CREATE TABLE pw_draft (
  did mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) NOT NULL default '0',
  content text NOT NULL,
  PRIMARY KEY  (did),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_elements;
CREATE TABLE pw_elements (
  eid mediumint(8) unsigned NOT NULL auto_increment,
  `type` varchar(30) NOT NULL,
  mark varchar(30) NOT NULL,
  `id` mediumint(8) unsigned NOT NULL,
  `value` int(10) NOT NULL,
  addition char(255) NOT NULL,
  `special` tinyint(1) NOT NULL default '0',
  `time` INT( 10 ) UNSIGNED NOT NULL,
  PRIMARY KEY  (eid),
  UNIQUE KEY `type` (`type`,`mark`,`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_extragroups;
CREATE TABLE pw_extragroups (
  uid mediumint(9) NOT NULL default '0',
  gid smallint(6) NOT NULL default '0',
  togid smallint(6) NOT NULL default '0',
  startdate int(10) NOT NULL default '0',
  days smallint(6) NOT NULL default '0',
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_favors;
CREATE TABLE pw_favors (
  uid mediumint(8) unsigned NOT NULL default '1',
  tids text NOT NULL,
  `type` varchar(255) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_feed;
CREATE TABLE pw_feed (
  id int(10) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL,
  type varchar(10) NOT NULL,
  descrip TEXT,
  timestamp int(10) unsigned NOT NULL,
  `typeid` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (id),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_focus;
CREATE TABLE pw_focus (
  id int(10) unsigned NOT NULL auto_increment,
  pushto VARCHAR(30) NOT NULL,
  pushtime int(10) NOT NULL,
  fid smallint(6) NOT NULL,
  tid mediumint(8) NOT NULL,
  subject varchar(100) NOT NULL,
  content text NOT NULL,
  postdate int(10) NOT NULL,
  url varchar(100) NOT NULL,
  imgurl varchar(100) NOT NULL,
  PRIMARY KEY  (id),
  KEY pushto (pushto)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forumdata;
CREATE TABLE pw_forumdata (
  fid smallint(6) unsigned NOT NULL default '0',
  tpost mediumint(8) unsigned NOT NULL default '0',
  topic mediumint(8) unsigned NOT NULL default '0',
  article mediumint(8) unsigned NOT NULL default '0',
  subtopic mediumint(8) unsigned NOT NULL default '0',
  top1 smallint(6) unsigned NOT NULL default '0',
  top2 smallint(6) unsigned NOT NULL default '0',
  aid smallint(6) unsigned NOT NULL default '0',
  aidcache int(10) unsigned NOT NULL default '0',
  aids char(135) NOT NULL default '',
  lastpost char(135) NOT NULL default '',
  PRIMARY KEY  (fid),
  KEY aid (aid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forumlog;
CREATE TABLE pw_forumlog (
  id int(11) NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '',
  username1 varchar(30) NOT NULL default '',
  username2 varchar(30) NOT NULL default '',
  field1 varchar(30) NOT NULL default '',
  field2 varchar(30) NOT NULL default '',
  field3 varchar(255) NOT NULL default '',
  descrip text NOT NULL,
  `timestamp` int(10) NOT NULL default '0',
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY `type` (`type`),
  KEY username1 (username1),
  KEY username2 (username2)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forummsg;
CREATE TABLE IF NOT EXISTS pw_forummsg (
  id smallint(6) NOT NULL auto_increment,
  fid smallint(6) NOT NULL default '0',
  uid mediumint(8) NOT NULL default '0',
  username varchar(15) NOT NULL,
  toname varchar(200) NOT NULL,
  msgtype tinyint(1) NOT NULL default '0',
  posttime int(10) NOT NULL default '0',
  savetime int(10) NOT NULL default '0',
  message mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY fid (fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forums;
CREATE TABLE pw_forums (
  fid smallint(6) unsigned NOT NULL auto_increment,
  fup smallint(6) unsigned NOT NULL default '0',
  ifsub tinyint(1) NOT NULL default '0',
  childid tinyint(1) NOT NULL default '0',
  `type` enum('category','forum','sub','sub2') NOT NULL default 'forum',
  logo char(100) NOT NULL default '',
  `name` char(100) NOT NULL default '',
  descrip char(255) NOT NULL default '',
  dirname char(15) NOT NULL default '',
  keywords varchar(50) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  forumadmin char(255) NOT NULL default '',
  fupadmin char(255) NOT NULL default '',
  style char(12) NOT NULL default '',
  across tinyint(4) NOT NULL default '0',
  allowhtm tinyint(1) NOT NULL default '0',
  allowhide tinyint(1) NOT NULL default '1',
  allowsell tinyint(1) NOT NULL default '1',
  allowtype tinyint(3) NOT NULL default '1',
  copyctrl tinyint(1) NOT NULL default '0',
  allowencode tinyint(1) NOT NULL default '1',
  `password` char(32) NOT NULL default '',
  viewsub tinyint(1) NOT NULL default '0',
  allowvisit char(120) NOT NULL default '',
  allowread char(120) NOT NULL default '',
  allowpost char(120) NOT NULL default '',
  allowrp char(120) NOT NULL default '',
  allowdownload char(120) NOT NULL default '',
  allowupload char(120) NOT NULL default '',
  f_type enum('forum','former','hidden','vote') NOT NULL default 'forum',
  f_check tinyint(1) unsigned NOT NULL default '0',
  t_type char(255) NOT NULL default '',
  forumsell varchar(15) NOT NULL default '',
  cms tinyint(1) NOT NULL default '0',
  ifhide tinyint(1) NOT NULL default '1',
  showsub tinyint(1) NOT NULL default '0',
  forumtype varchar(30) NOT NULL default '',
  PRIMARY KEY  (fid),
  KEY fup (fup),
  KEY `type` (ifsub,vieworder,fup)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forumsell;
CREATE TABLE pw_forumsell (
  id mediumint(8) NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '1',
  buydate int(10) unsigned NOT NULL default '0',
  overdate int(10) unsigned NOT NULL default '0',
  credit varchar(8) NOT NULL default '',
  cost DECIMAL(8,2) NOT NULL,
  PRIMARY KEY  (id),
  KEY fid (fid),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forumsextra;
CREATE TABLE pw_forumsextra (
  fid smallint(6) NOT NULL default '0',
  creditset text NOT NULL,
  forumset text NOT NULL,
  commend text NOT NULL,
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_forumtype;
CREATE TABLE pw_forumtype (
  ftid smallint(6) unsigned NOT NULL auto_increment,
  typename varchar(30) NOT NULL,
  mark varchar(30) NOT NULL,
  allowtype tinyint(3) NOT NULL,
  PRIMARY KEY  (ftid)
) TYPE=MyISAM ;

DROP TABLE IF EXISTS pw_friends;
CREATE TABLE pw_friends (
  uid mediumint(8) NOT NULL default '0',
  friendid mediumint(8) NOT NULL default '0',
  status tinyint(1) not null default '0',
  joindate int(10) NOT NULL default '0',
  descrip varchar(255) NOT NULL default '',
  `ftid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (uid,friendid),
  KEY joindate (joindate),
  KEY ftid (ftid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_friendtype;
CREATE TABLE pw_friendtype (
  `ftid` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY  (`ftid`),
  KEY `uid` (`uid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_hack;
CREATE TABLE pw_hack(
  hk_name varchar(30) NOT NULL default '',
  vtype ENUM('string','array') NOT NULL,
  hk_value text NOT NULL,
  decrip text NOT NULL,
  PRIMARY KEY  (hk_name)
) TYPE=MyISAM;

INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_A','a:1:{s:10:"rvrc_money";a:6:{i:0;s:4:"{#rvrc}";i:1;s:4:"{#money}";i:2;s:1:"2";i:3;s:1:"3";i:4;s:1:"1";i:5;i:1;}}');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_ddate','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_drate','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_num','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_open','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_per','5');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_rate','5');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_timelimit','2');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_virelimit','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_virement','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('bk_virerate','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('currrate1', 'a:4:{s:4:"rvrc";i:100;s:5:"money";i:100;s:6:"credit";i:1;i:1;i:5;}');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('currrate2', '');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_open','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_remove','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_newcolony','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_createmoney','100');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_joinmoney','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_allowcreate','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_allowjoin','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_memberfull','50');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_imgsize','1048576');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_name','{#colony}');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_groups',',3,4,5,8,9,10,11,12,13,14,15,16,');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_imgwidth','200');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_imgheight','100');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_visittime','60');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('cn_transfer','10');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_open','0');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_days','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_limitdays','0');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_costs','50');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_credit','currency');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('inv_groups',',3,4,5,');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('md_groups',',3,');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('md_ifmsg','1');
INSERT INTO pw_hack(hk_name,hk_value) VALUES ('md_ifopen','0');

DROP TABLE IF EXISTS pw_help;
CREATE TABLE pw_help (
  hid smallint(6) unsigned NOT NULL auto_increment,
  hup smallint(6) unsigned NOT NULL default '0',
  lv tinyint(2) NOT NULL default '0',
  fathers varchar(100) NOT NULL default '',
  ifchild tinyint(1) NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  url varchar(80) NOT NULL default '',
  content mediumtext NOT NULL,
  vieworder tinyint(3) NOT NULL default '0',
  ispw tinyint(1) default '0',
  PRIMARY KEY  (hid),
  KEY hup (hup)
) TYPE=MyISAM;

INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('1','0','0','','1','{#help_1}','','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('2','1','1','1','0','{#help_2}','{#helpd_2}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('3','1','1','1','0','{#help_3}','{#helpd_3}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('4','1','1','1','0','{#help_4}','{#helpd_4}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('5','1','1','1','0','{#help_5}','{#helpd_5}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('6','1','1','1','0','{#help_6}','{#helpd_6}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('7','1','1','1','0','{#help_7}','{#helpd_7}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('8','0','0','','1','{#help_8}','','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('9','8','1','8','0','{#help_9}','{#helpd_9}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('10','8','1','8','0','{#help_10}','{#helpd_10}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('11','8','1','8','0','{#help_11}','{#helpd_11}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('12','8','1','8','0','{#help_12}','{#helpd_12}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('13','8','1','8','0','{#help_13}','{#helpd_13}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('14','8','1','8','0','{#help_14}','{#helpd_14}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('15','8','1','8','0','{#help_15}','{#helpd_15}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('16','8','1','8','0','{#help_16}','{#helpd_16}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('17','8','1','8','0','{#help_17}','{#helpd_17}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('18','0','0','','1','{#help_18}','','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('19','18','1','18','0','{#help_19}','{#helpd_19}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('20','18','1','18','0','{#help_20}','{#helpd_20}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('21','18','1','18','0','{#help_21}','{#helpd_21}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('22','18','1','18','0','{#help_22}','{#helpd_22}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('23','18','1','18','0','{#help_23}','{#helpd_23}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('24','18','1','18','0','{#help_24}','{#helpd_24}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('25','18','1','18','0','{#help_25}','{#helpd_25}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('26','18','1','18','0','{#help_26}','{#helpd_26}','1');
INSERT INTO pw_help(hid,hup,lv,fathers,ifchild,title,content,ispw) VALUES('27','18','1','18','0','{#help_27}','{#helpd_27}','1');

DROP TABLE IF EXISTS pw_home;
CREATE TABLE pw_home (
  id smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  title varchar(20) NOT NULL default '',
  position tinyint(3) NOT NULL default '0',
  vieworder tinyint(3) NOT NULL default '0',
  upstep smallint(6) NOT NULL default '0',
  lastupdate int(10) NOT NULL default '0',
  ifopen tinyint(1) NOT NULL default '0',
  config text NOT NULL,
  `cache` text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_home VALUES('1','eye','{#home_1}','2','0','3600','','1','a:4:{s:4:"tids";s:0:"";s:4:"nums";s:1:"5";s:5:"order";s:4:"hits";s:4:"time";s:1:"7";}','');
INSERT INTO pw_home VALUES('2','tags','{#home_2}','2','1','45000','','1','a:2:{s:4:"tags";s:0:"";s:4:"nums";s:2:"25";}','');
INSERT INTO pw_home VALUES('3','recommend','{#home_3}','3','0','32767','','1','a:5:{s:4:"tids";s:0:"";s:3:"pic";s:0:"";s:4:"nums";s:2:"13";s:5:"order";s:3:"dig";s:4:"time";s:1:"3";}','');
INSERT INTO pw_home VALUES('4','hottopic','{#home_4}','3','1','32767','','1','a:3:{s:4:"nums";s:2:"10";s:5:"order";s:7:"replies";s:4:"time";s:1:"3";}','');
INSERT INTO pw_home VALUES('5','bbsinfo','{#home_5}','4','1','180','','1','','');
INSERT INTO pw_home VALUES('6','forumsort','{#home_6}','4','0','32767','','1','a:1:{s:4:"nums";s:2:"10";}','');
INSERT INTO pw_home VALUES('7','newreply','{#home_7}','6','0','3600','','1','a:2:{s:4:"nums";s:2:"14";s:4:"time";s:1:"3";}','');
INSERT INTO pw_home VALUES('8','newtopic','{#home_8}','7','0','3600','','1','a:2:{s:4:"nums";s:2:"14";s:4:"time";s:1:"3";}','');
INSERT INTO pw_home VALUES('9','usersort','{#home_9}','8','0','32767','','1','a:2:{s:4:"nums";s:2:"10";s:5:"order";s:7:"postnum";}','');

DROP TABLE IF EXISTS pw_invitecode;
CREATE TABLE pw_invitecode (
  id mediumint(8) unsigned NOT NULL auto_increment,
  invcode varchar(40) NOT NULL default '',
  uid mediumint(8) NOT NULL default '0',
  receiver varchar(20) NOT NULL default '',
  createtime int(10) NOT NULL default '0',
  usetime int(10) NOT NULL default '0',
  ifused tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY invcode (invcode)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_ipstates;
CREATE TABLE pw_ipstates (
  `day` char(10) NOT NULL default '',
  `month` char(7) NOT NULL default '',
  nums int(10) NOT NULL default '0',
  PRIMARY KEY  (`day`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_medalinfo;
CREATE TABLE pw_medalinfo (
  id tinyint(4) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  intro varchar(255) NOT NULL default '',
  picurl varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (1, '{#medalname_1}', '{#medaldesc_1}!','1.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (2, '{#medalname_2}', '{#medaldesc_2}', '2.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (3, '{#medalname_3}', '{#medaldesc_3}', '3.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (4, '{#medalname_4}', '{#medaldesc_4}', '4.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (5, '{#medalname_5}', '{#medaldesc_5}', '5.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (6, '{#medalname_6}', '{#medaldesc_6}', '6.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (7, '{#medalname_7}', '{#medaldesc_7}', '7.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (8, '{#medalname_8}', '{#medaldesc_8}', '8.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (9, '{#medalname_9}', '{#medaldesc_9}', '9.gif');
INSERT INTO pw_medalinfo(id,name,intro,picurl) VALUES (10,'{#medalname_10}','{#medaldesc_10}','10.gif');

DROP TABLE IF EXISTS pw_medalslogs;
CREATE TABLE pw_medalslogs (
  id int(10) NOT NULL auto_increment,
  awardee varchar(40) NOT NULL default '',
  awarder varchar(40) NOT NULL default '',
  awardtime int(10) NOT NULL default '0',
  timelimit tinyint(2) NOT NULL default '0',
  state tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  `action` tinyint(1) NOT NULL default '0',
  why varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY awardee (awardee)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_medaluser;
CREATE TABLE pw_medaluser (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL,
  `mid` tinyint(4) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_membercredit;
CREATE TABLE pw_membercredit (
  uid mediumint(8) unsigned NOT NULL default '0',
  cid tinyint(3) NOT NULL default '0',
  `value` mediumint(8) NOT NULL default '0',
  KEY uid (uid),
  KEY cid (cid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_memberdata;
CREATE TABLE pw_memberdata (
  uid mediumint(8) unsigned NOT NULL default '1',
  postnum int(10) unsigned NOT NULL default '0',
  digests smallint(6) NOT NULL default '0',
  rvrc int(10) NOT NULL default '0',
  money int(10) NOT NULL default '0',
  credit int(10) NOT NULL default '0',
  currency int(10) NOT NULL default '0',
  lastvisit int(10) unsigned NOT NULL default '0',
  thisvisit int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  onlinetime int(10) unsigned NOT NULL default '0',
  monoltime int(10) unsigned NOT NULL default '0',
  todaypost smallint(6) unsigned NOT NULL default '0',
  monthpost smallint(6) unsigned NOT NULL default '0',
  uploadtime int(10) unsigned NOT NULL default '0',
  uploadnum smallint(6) unsigned NOT NULL default '0',
  onlineip char(30) NOT NULL default '',
  starttime int(10) unsigned NOT NULL default '0',
  postcheck char(16) NOT NULL default '',
  pwdctime int(10) unsigned NOT NULL default '0',
  f_num int(10) unsigned NOT NULL default '0',
  creditpop varchar(150) NOT NULL,
  PRIMARY KEY uid (uid),
  KEY postnum (postnum)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_memberinfo;
CREATE TABLE pw_memberinfo (
  uid mediumint(8) unsigned NOT NULL default '1',
  adsips mediumtext NOT NULL,
  credit varchar(50) NOT NULL default '',
  deposit int(10) NOT NULL default '0',
  startdate int(10) NOT NULL default '0',
  ddeposit int(10) NOT NULL default '0',
  dstartdate int(10) NOT NULL default '0',
  regreason varchar(255) NOT NULL default '',
  readmsg mediumtext NOT NULL,
  delmsg mediumtext NOT NULL,
  tooltime varchar(42) NOT NULL default '',
  replyinfo varchar(81) NOT NULL default '',
  lasttime int(10) NOT NULL default '0',
  digtid text NOT NULL,
  customdata text NOT NULL,
  tradeinfo text NOT NULL,
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_members;
CREATE TABLE pw_members (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username varchar(15) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  safecv varchar(10) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  groupid tinyint(3) NOT NULL default '-1',
  memberid tinyint(3) NOT NULL default '0',
  groups varchar(255) NOT NULL default '',
  icon varchar(100) NOT NULL default '',
  gender tinyint(1) NOT NULL default '0',
  regdate int(10) unsigned NOT NULL default '0',
  signature text NOT NULL,
  introduce text NOT NULL,
  oicq varchar(12) NOT NULL default '',
  aliww VARCHAR( 30 ) NOT NULL,
  icq varchar(12) NOT NULL default '',
  msn varchar(35) NOT NULL default '',
  yahoo varchar(35) NOT NULL default '',
  site varchar(75) NOT NULL default '',
  location varchar(36) NOT NULL default '',
  honor varchar(100) NOT NULL default '',
  bday date NOT NULL default '0000-00-00',
  lastaddrst varchar(255) NOT NULL default '',
  yz int(10) NOT NULL default '1',
  timedf varchar(5) NOT NULL default '',
  style varchar(12) NOT NULL default '',
  datefm varchar(15) NOT NULL default '',
  t_num tinyint(3) unsigned NOT NULL default '0',
  p_num tinyint(3) unsigned NOT NULL default '0',
  attach varchar(50) NOT NULL default '',
  hack varchar(255) NOT NULL default '0',
  newpm tinyint(1) NOT NULL default '0',
  banpm text NOT NULL,
  msggroups varchar(255) NOT NULL default '',
  medals varchar(255) NOT NULL default '',
  userstatus int(10) unsigned NOT NULL default '0',
  shortcut varchar(255) NOT NULL default '',
  PRIMARY KEY  (uid),
  UNIQUE KEY username (username),
  KEY groupid (groupid),
  KEY email (email)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_memo;
CREATE TABLE pw_memo (
  mid int(10) unsigned NOT NULL auto_increment,
  username varchar(15) NOT NULL,
  postdate int(10) NOT NULL default '0',
  content text NOT NULL,
  isuser tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mid),
  KEY isuser (isuser,username)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_modules;
CREATE TABLE pw_modules (
  id int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(4) NOT NULL default '0',
  targets varchar(50) NOT NULL default '',
  varname varchar(20) NOT NULL default '',
  state tinyint(1) NOT NULL default '0',
  vieworder tinyint(4) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  ifhire tinyint(1) NOT NULL default '0',
  config text NOT NULL,
  PRIMARY KEY  (id),
  KEY `type` (`type`),
  KEY vieworder (vieworder),
  KEY state (state)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_mpageconfig;
CREATE TABLE pw_mpageconfig (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `mode` varchar(20) NOT NULL,
  `scr` varchar(20) NOT NULL,
  `config` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mode` (`mode`,`scr`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_msg;
CREATE TABLE pw_msg (
  mid int(10) unsigned NOT NULL auto_increment,
  touid mediumint(8) unsigned NOT NULL default '0',
  togroups varchar(80) NOT NULL default '',
  fromuid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  `type` enum('rebox','sebox','public') NOT NULL default 'rebox',
  ifnew tinyint(1) NOT NULL default '0',
  mdate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (mid),
  KEY touid (touid),
  KEY fromuid (fromuid,mdate),
  KEY `type` (`type`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_msgc;
CREATE TABLE pw_msgc (
  mid int(10) unsigned NOT NULL,
  title varchar(130) NOT NULL,
  content text NOT NULL,
  PRIMARY KEY  (mid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_msglog;
CREATE TABLE pw_msglog (
  mid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  withuid mediumint(8) unsigned NOT NULL default '0',
  mdate int(10) unsigned NOT NULL default '0',
  mtype enum('send','receive') NOT NULL default 'send',
  PRIMARY KEY  (mid,uid),
  KEY uid (uid,withuid,mdate)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_nav;
CREATE TABLE pw_nav (
  nid smallint(4) NOT NULL auto_increment,
  title char(50) NOT NULL default '',
  style char(50) NOT NULL default '',
  link char(100) NOT NULL default '',
  alt char(50) NOT NULL default '',
  pos char(10) NOT NULL default '',
  target tinyint(1) NOT NULL default '0',
  `view` smallint(4) NOT NULL default '0',
  `icon` VARCHAR( 255 ) NOT NULL,
  PRIMARY KEY  (nid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_oboard;
CREATE TABLE pw_oboard (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL,
  `username` varchar(15) NOT NULL,
  `touid` mediumint(8) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `postdate` int(10) NOT NULL,
  `c_num` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `touid` (`touid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_online;
CREATE TABLE pw_online (
  olid int(10) NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  lastvisit int(10) NOT NULL default '0',
  ip char(30) NOT NULL default '',
  fid smallint(6) NOT NULL default '0',
  tid mediumint(8) NOT NULL default '0',
  groupid tinyint(3) NOT NULL default '0',
  `action` char(2) NOT NULL default '',
  ifhide tinyint(1) NOT NULL default '0',
  uid mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (olid),
  KEY uid (uid),
  KEY ip (ip)
) TYPE=HEAP;

DROP TABLE IF EXISTS pw_ouserdata;
CREATE TABLE pw_ouserdata (
  `uid` int(10) unsigned NOT NULL,
  `index_privacy` tinyint(1) unsigned NOT NULL default '0',
  `profile_privacy` tinyint(1) unsigned NOT NULL default '0',
  `info_privacy` tinyint(1) unsigned NOT NULL default '0',
  `credit_privacy` tinyint(1) unsigned NOT NULL default '0',
  `owrite_privacy` tinyint(1) unsigned NOT NULL default '0',
  `msgboard_privacy` tinyint(1) unsigned NOT NULL default '0',
  `visits` int(10) unsigned NOT NULL default '0',
  `tovisit` varchar(255) NOT NULL,
  `whovisit` varchar(255) NOT NULL,
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_owritedata;
CREATE TABLE pw_owritedata (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL,
  `touid` int(10) unsigned NOT NULL,
  `postdate` int(10) unsigned NOT NULL,
  `isshare` tinyint(1) unsigned NOT NULL default '0',
  `source` varchar(10) NOT NULL,
  `content` varchar(255) NOT NULL,
  `c_num` mediumint(8) UNSIGNED NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_permission;
CREATE TABLE pw_permission (
  `uid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `gid` smallint(6) unsigned NOT NULL,
  `rkey` varchar(20) NOT NULL,
  `type` enum('basic','special','system','systemforum') NOT NULL,
  `rvalue` varchar(255) NOT NULL,
  PRIMARY KEY  (`uid`,`fid`,`gid`,`rkey`),
  KEY `rkey` (`rkey`)
) TYPE=MyISAM;

INSERT INTO pw_permission VALUES(0, 0, 1, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowsort', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 1, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 1, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 1, 'signnum', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 1, 'show', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 1, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 1, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 1, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 1, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 1, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'maxmsg', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowportait', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowrp', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowdelatc', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowpost', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allownewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowhidden', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowencode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowsell', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowsearch', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowmember', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowreport', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowmessege', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowsort', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'alloworder', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowupload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allowdownload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'allownum', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'edittime', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 2, 'postpertime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 2, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 2, 'signnum', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'show', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 2, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 2, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 2, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 2, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'maxmsg', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowhide', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowhonor', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowactive', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'htmlcode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 3, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 3, 'postpertime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 3, 'searchtime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 3, 'signnum', 'basic', '1000');
INSERT INTO pw_permission VALUES(0, 0, 3, 'show', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewipfrom', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'msggroup', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 3, 'markable', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'maxcredit', 'basic', '300');
INSERT INTO pw_permission VALUES(0, 0, 3, 'marklimit', 'basic', '-20,20');
INSERT INTO pw_permission VALUES(0, 0, 3, 'markctype', 'basic', ',rvrc,money,credit,1,');
INSERT INTO pw_permission VALUES(0, 0, 3, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowadmincp', 'system', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'delatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'moveatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'copyatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'typeadmin', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewcheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewclose', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'delattach', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewip', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'banuser', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'bantype', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'banmax', 'systemforum', '30');
INSERT INTO pw_permission VALUES(0, 0, 3, 'viewhide', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'postpers', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'replylock', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'modother', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'deltpcs', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'topped', 'systemforum', '3');
INSERT INTO pw_permission VALUES(0, 0, 3, 'tpctype', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'tpccheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'allowtime', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 3, 'superright', 'system', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'maxmsg', 'basic', '30');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowhonor', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowactive', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'htmlcode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 4, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 4, 'postpertime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 4, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 4, 'signnum', 'basic', '1000');
INSERT INTO pw_permission VALUES(0, 0, 4, 'show', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewipfrom', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'msggroup', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 4, 'markable', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'maxcredit', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 4, 'marklimit', 'basic', '-10,10');
INSERT INTO pw_permission VALUES(0, 0, 4, 'markctype', 'basic', ',rvrc,money,');
INSERT INTO pw_permission VALUES(0, 0, 4, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowadmincp', 'system', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'delatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'moveatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'copyatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'typeadmin', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewcheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewclose', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'delattach', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewip', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'banuser', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'bantype', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'banmax', 'systemforum', '20');
INSERT INTO pw_permission VALUES(0, 0, 4, 'viewhide', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'postpers', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'replylock', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'modother', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'deltpcs', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'topped', 'systemforum', '3');
INSERT INTO pw_permission VALUES(0, 0, 4, 'tpctype', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'tpccheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 4, 'allowtime', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 4, 'superright', 'system', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'maxmsg', 'basic', '40');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowhonor', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowactive', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 5, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'postpertime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 5, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 5, 'signnum', 'basic', '500');
INSERT INTO pw_permission VALUES(0, 0, 5, 'show', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'maxcredit', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 5, 'marklimit', 'basic', '-5,5');
INSERT INTO pw_permission VALUES(0, 0, 5, 'markctype', 'basic', ',money,');
INSERT INTO pw_permission VALUES(0, 0, 5, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowadmincp', 'system', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'delatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'moveatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'copyatc', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'typeadmin', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewcheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewclose', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'delattach', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewip', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'banuser', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'bantype', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'banmax', 'systemforum', '10');
INSERT INTO pw_permission VALUES(0, 0, 5, 'viewhide', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'postpers', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'replylock', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'modother', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'remind', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'shield', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'topped', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'tpccheck', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'tpctype', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'unite', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'deltpcs', 'systemforum', '1');
INSERT INTO pw_permission VALUES(0, 0, 5, 'allowtime', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 5, 'superright', 'system', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowportait', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowrp', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowdelatc', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowpost', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allownewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowhidden', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowencode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowsell', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowsearch', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowmember', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowreport', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowmessege', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowsort', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowupload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allowdownload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 6, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 6, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 6, 'signnum', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 6, 'show', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 6, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 6, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 6, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 6, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowreport', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowmessege', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowsort', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 7, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 7, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 7, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 7, 'signnum', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 7, 'show', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 7, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 7, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 7, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 7, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowportait', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allownewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowencode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowsell', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowmember', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowsort', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 8, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 8, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'postpertime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 8, 'signnum', 'basic', '30');
INSERT INTO pw_permission VALUES(0, 0, 8, 'show', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'viewipfrom', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'fontsize', 'basic', '3');
INSERT INTO pw_permission VALUES(0, 0, 8, 'msggroup', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'maxfavor', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 8, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 8, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 8, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 8, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 9, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowportait', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowencode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowsell', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'alloworder', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 9, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 9, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'postpertime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 9, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 9, 'signnum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 9, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 9, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 9, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 9, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 9, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 9, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 9, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowportait', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'upload', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 10, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 10, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 10, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 10, 'signnum', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 10, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 10, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 10, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 10, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 10, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 10, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 10, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowprofile', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 11, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 11, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 11, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 11, 'signnum', 'basic', '150');
INSERT INTO pw_permission VALUES(0, 0, 11, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 11, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 11, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 11, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 11, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 11, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 11, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 12, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 12, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 12, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 12, 'signnum', 'basic', '200');
INSERT INTO pw_permission VALUES(0, 0, 12, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 12, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 12, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 12, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 12, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 12, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 12, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 13, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 13, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 13, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 13, 'signnum', 'basic', '200');
INSERT INTO pw_permission VALUES(0, 0, 13, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 13, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 13, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 13, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 13, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 13, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 13, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowhidden', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowencode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowsell', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 14, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 14, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 14, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 14, 'signnum', 'basic', '200');
INSERT INTO pw_permission VALUES(0, 0, 14, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 14, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 14, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 14, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 14, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 14, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 14, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'maxmsg', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowhonor', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowsearch', 'basic', '2');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 15, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 15, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 15, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 15, 'signnum', 'basic', '200');
INSERT INTO pw_permission VALUES(0, 0, 15, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 15, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 15, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 15, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 15, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 15, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 15, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'maxmsg', 'basic', '20');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowhide', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowread', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowportait', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'upload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowrp', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowhonor', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowdelatc', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowpost', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allownewvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowvote', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowactive', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'htmlcode', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowhidden', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowencode', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowsell', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowsearch', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowmember', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowprofile', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowreport', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowmessege', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowsort', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'alloworder', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowupload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowdownload', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allownum', 'basic', '50');
INSERT INTO pw_permission VALUES(0, 0, 16, 'edittime', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'postpertime', 'basic', '15');
INSERT INTO pw_permission VALUES(0, 0, 16, 'searchtime', 'basic', '10');
INSERT INTO pw_permission VALUES(0, 0, 16, 'signnum', 'basic', '200');
INSERT INTO pw_permission VALUES(0, 0, 16, 'show', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewipfrom', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'imgwidth', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'imgheight', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'fontsize', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'msggroup', 'basic', '1');
INSERT INTO pw_permission VALUES(0, 0, 16, 'maxfavor', 'basic', '100');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewvote', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'atccheck', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'markable', 'basic', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'postlimit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'uploadtype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'maxcredit', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'marklimit', 'basic', ',');
INSERT INTO pw_permission VALUES(0, 0, 16, 'markctype', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'markdt', 'basic', '');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowadmincp', 'system', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'delatc', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'moveatc', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'copyatc', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'typeadmin', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewcheck', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewclose', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'delattach', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewip', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'banuser', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'bantype', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'banmax', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'viewhide', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'postpers', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'replylock', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'modother', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'deltpcs', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'topped', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'tpctype', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'tpccheck', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'allowtime', 'systemforum', '0');
INSERT INTO pw_permission VALUES(0, 0, 16, 'superright', 'system', '1');

DROP TABLE IF EXISTS pw_pidtmp;
CREATE TABLE pw_pidtmp (
  pid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (pid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_pinglog;
CREATE TABLE IF NOT EXISTS pw_pinglog (
  id mediumint(8) NOT NULL auto_increment,
  fid smallint(6) NOT NULL default '0',
  tid mediumint(8) NOT NULL default '0',
  pid int(10) NOT NULL default '0',
  name varchar(15) NOT NULL,
  point varchar(10) NOT NULL,
  pinger varchar(15) NOT NULL,
  record mediumtext NOT NULL,
  pingdate int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY tid (tid),
  KEY pid (pid),
  KEY fid (fid,tid,pid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_plan;
CREATE TABLE pw_plan (
  id smallint(6) unsigned NOT NULL auto_increment,
  `subject` varchar(80) NOT NULL default '',
  `month` varchar(2) NOT NULL default '',
  `week` varchar(1) NOT NULL default '',
  `day` varchar(2) NOT NULL default '',
  `hour` varchar(80) NOT NULL default '',
  usetime int(10) NOT NULL default '0',
  nexttime int(10) NOT NULL default '0',
  ifsave tinyint(1) NOT NULL default '0',
  ifopen tinyint(1) NOT NULL default '0',
  filename varchar(80) NOT NULL default '',
  config text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_plan VALUES (1, '{#plan_1}', '*', '6', '1', '*', 0, 0, 1, 0, 'cleardata', '');
INSERT INTO pw_plan VALUES (2, '{#plan_2}', '*', '*', '20', '30', 0, 0, 0, 0, 'freeban', '');
INSERT INTO pw_plan VALUES (3, '{#plan_3}', '*', '*', '0', '*', 0, 0, 1, 0, 'birthday', '');
INSERT INTO pw_plan VALUES (4, '{#plan_4}', '*', '1', '12', '30', 0, 0, 1, 0, 'rewardmsg', '');
INSERT INTO pw_plan VALUES (5, '{#plan_5}', '15', '*', '2', '*', 0, 0, 0, 0, 'team', 'a:3:{s:10:\"credittype\";s:6:\"credit\";s:6:\"credit\";a:3:{i:3;s:3:\"100\";i:4;s:2:\"60\";i:5;s:2:\"50\";}s:6:\"groups\";s:5:\"3,4,5\";}');
INSERT INTO pw_plan VALUES (6, '{#plan_6}', '16', '*', '18', '30', 0, 0, 0, 0, 'medal', '');
INSERT INTO pw_plan VALUES (7, '{#plan_7}', '*', '*', '22', '*', 0, 0, 0, 0, 'extragroup', '');

DROP TABLE IF EXISTS pw_polls;
CREATE TABLE pw_polls (
  pollid int(10) unsigned NOT NULL auto_increment,
  tid mediumint(8) unsigned NOT NULL default '0',
  voteopts mediumtext NOT NULL,
  modifiable tinyint(1) NOT NULL default '0',
  previewable tinyint(1) NOT NULL default '0',
  multiple tinyint(1) unsigned NOT NULL,
  mostvotes smallint(6) unsigned NOT NULL,
  voters mediumint(8) unsigned NOT NULL,
  timelimit int(3) NOT NULL default '0',
  PRIMARY KEY  (pollid),
  KEY tid (tid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_posts;
CREATE TABLE pw_posts (
  pid int(10) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  aid text NOT NULL,
  author varchar(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  icon tinyint(2) NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  `subject` varchar(100) NOT NULL default '',
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL,
  alterinfo varchar(50) NOT NULL default '',
  remindinfo varchar(150) NOT NULL default '',
  leaveword varchar(255) NOT NULL default '',
  ipfrom varchar(255) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '1',
  ifwordsfb tinyint(1) NOT NULL default '1',
  ifcheck tinyint(1) NOT NULL default '0',
  content mediumtext NOT NULL,
  ifmark varchar(255) NOT NULL default '',
  ifreward tinyint(1) NOT NULL default '0',
  ifshield tinyint(1) unsigned NOT NULL default '0',
  anonymous tinyint(1) NOT NULL default '0',
  ifhide tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY fid (fid),
  KEY postdate (postdate),
  KEY tid (tid,postdate),
  KEY authorid (authorid),
  KEY ifcheck (ifcheck)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_proclock;
CREATE TABLE pw_proclock (
  uid mediumint(8) unsigned NOT NULL,
  action varchar(20) NOT NULL,
  time int(10) NOT NULL,
  PRIMARY KEY  (uid,action)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_recycle;
CREATE TABLE pw_recycle (
  pid int(10) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  fid smallint(6) unsigned NOT NULL default '0',
  deltime int(10) unsigned NOT NULL default '0',
  admin varchar(15) NOT NULL default '',
  PRIMARY KEY  (pid,tid),
  KEY tid (tid),
  KEY fid (fid,pid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_report;
CREATE TABLE pw_report (
  id int(10) unsigned NOT NULL auto_increment,
  tid mediumint(8) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  uid mediumint(9) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  reason char(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY `type` (`type`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_reward;
CREATE TABLE pw_reward (
  tid mediumint(8) NOT NULL,
  cbtype varchar(20) NOT NULL,
  catype varchar(20) NOT NULL,
  cbval int(10) NOT NULL,
  caval int(10) NOT NULL,
  timelimit int(10) NOT NULL,
  author varchar(30) NOT NULL,
  pid mediumint(8) NOT NULL,
  PRIMARY KEY  (tid),
  KEY timelimit (timelimit)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_schcache;
CREATE TABLE pw_schcache (
  sid mediumint(8) unsigned NOT NULL auto_increment,
  sorderby varchar(13) NOT NULL default '',
  schline varchar(32) NOT NULL default '',
  schtime int(10) unsigned NOT NULL default '0',
  total mediumint(8) unsigned NOT NULL default '0',
  schedid text NOT NULL,
  PRIMARY KEY  (sid),
  KEY schline (schline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_setform;
CREATE TABLE pw_setform (
  id int(10) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  ifopen tinyint(1) NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_setform VALUES('1','{#setform_1}','1','{#setfrom_1_inro}');

DROP TABLE IF EXISTS pw_share;
CREATE TABLE pw_share (
  id mediumint(8) NOT NULL auto_increment,
  `type` varchar(20) NOT NULL,
  uid mediumint(8) NOT NULL,
  username varchar(15) NOT NULL,
  postdate int(10) NOT NULL,
  content text NOT NULL,
  ifhidden tinyint(1) unsigned NOT NULL default '0',
  c_num mediumint( 8 ) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid,postdate)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_sharelinks;
CREATE TABLE pw_sharelinks (
  sid smallint(6) unsigned NOT NULL auto_increment,
  threadorder tinyint(3) NOT NULL default '0',
  `name` char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  descrip char(200) NOT NULL default '0',
  logo char(100) NOT NULL default '',
  ifcheck tinyint(1) NOT NULL default '0',
  username char(20) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

INSERT INTO pw_sharelinks (threadorder ,name ,url ,descrip ,logo ,ifcheck) VALUES ('0', 'PHPwind Board', 'http://www.phpwind.net', '{#sharelinks}', 'logo.gif', '1');

DROP TABLE IF EXISTS pw_singleright;
CREATE TABLE pw_singleright (
  uid mediumint(8) unsigned NOT NULL default '0',
  visit varchar(80) NOT NULL default '',
  post varchar(80) NOT NULL default '',
  reply varchar(80) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_smiles;
CREATE TABLE pw_smiles (
  id smallint(6) unsigned NOT NULL auto_increment,
  path varchar(20) NOT NULL default '',
  `name` varchar(20) NOT NULL default '',
  descipt varchar(100) NOT NULL default '',
  vieworder tinyint(2) NOT NULL default '0',
  `type` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_smiles (path,name,vieworder,type) VALUES ('default','{#smile}','1','0');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('1.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('2.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('3.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('4.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('5.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('6.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('7.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('8.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('9.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('10.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('11.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('12.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('13.gif','0','1');
INSERT INTO pw_smiles (path,vieworder,type) VALUES ('14.gif','0','1');

DROP TABLE IF EXISTS pw_sqlcv;
CREATE TABLE pw_sqlcv (
  id int(10) NOT NULL auto_increment,
  var varchar(20) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_stamp;
CREATE TABLE pw_stamp (
  sid smallint(6) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  stamp varchar(30) NOT NULL,
  init smallint(6) NOT NULL,
  iflock tinyint( 1 ) unsigned NOT NULL default '0',
  PRIMARY KEY  (sid),
  UNIQUE KEY stamp (stamp)
) TYPE=MyISAM;

INSERT INTO `pw_stamp` VALUES (1, '{#stamp_1}', 'subject', 1, 1);
INSERT INTO `pw_stamp` VALUES (2, '{#stamp_2}', 'user', 6, 1);
INSERT INTO `pw_stamp` VALUES (3, '{#stamp_3}', 'forum', 9, 1);
INSERT INTO `pw_stamp` VALUES (4, '{#stamp_4}', 'tag', 11, 1);
INSERT INTO `pw_stamp` VALUES (5, '{#stamp_5}', 'image', 14, 1);
INSERT INTO `pw_stamp` VALUES (6, '{#stamp_6}', 'active', 16, 1);
INSERT INTO `pw_stamp` VALUES (7, '{#stamp_7}', 'trade', 17, 1);
INSERT INTO `pw_stamp` VALUES (8, '{#stamp_8}', 'push', 27, 1);

DROP TABLE IF EXISTS pw_styles;
CREATE TABLE pw_styles (
  sid smallint(6) unsigned NOT NULL auto_increment,
  `uid` MEDIUMINT( 8 ) NOT NULL,
  `name` char(50) NOT NULL default '',
  customname char(50) NOT NULL default '',
  createtime INT(10) NOT NULL,
  lastmodify INT(10) NOT NULL,
  ifopen tinyint(1) NOT NULL default '0',
  stylepath char(50) NOT NULL default '',
  tplpath char(50) NOT NULL default '',
  yeyestyle char(3) NOT NULL default '',
  bgcolor char(100) NOT NULL,
  linkcolor char(7) NOT NULL,
  tablecolor char(7) NOT NULL default '',
  tdcolor char(7) NOT NULL,
  tablewidth char(6) NOT NULL,
  mtablewidth char(6) NOT NULL,
  headcolor char(100) NOT NULL,
  headborder char(7) NOT NULL,
  headfontone char(7) NOT NULL,
  headfonttwo char(7) NOT NULL,
  cbgcolor char(100) NOT NULL,
  cbgborder char(7) NOT NULL,
  cbgfont char(7) NOT NULL,
  forumcolorone char(7) NOT NULL default '',
  forumcolortwo char(7) NOT NULL default '',
  extcss TEXT NOT NULL,
  PRIMARY KEY  (sid),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_tagdata;
CREATE TABLE pw_tagdata (
  tagid mediumint(8) NOT NULL default '0',
  tid mediumint(8) NOT NULL default '0',
  KEY tagid (tagid),
  KEY tid (tid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_tags;
CREATE TABLE pw_tags (
  tagid mediumint(8) unsigned NOT NULL auto_increment,
  tagname varchar(15) NOT NULL default '',
  num mediumint(8) NOT NULL default '0',
  ifhot tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (tagid),
  KEY num (ifhot,num),
  KEY tagname (tagname)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_threads;
CREATE TABLE pw_threads (
  tid mediumint(8) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  icon tinyint(2) NOT NULL default '0',
  titlefont char(15) NOT NULL default '',
  author char(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  subject char(100) NOT NULL default '',
  toolinfo char(16) NOT NULL default '',
  toolfield varchar(21) NOT NULL default '',
  ifcheck tinyint(1) NOT NULL default '0',
  type tinyint(2) NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  lastposter char(15) NOT NULL default '',
  hits int(10) unsigned NOT NULL default '0',
  replies int(10) unsigned NOT NULL default '0',
  topped smallint(6) NOT NULL default '0',
  locked tinyint(1) NOT NULL default '0',
  digest tinyint(1) NOT NULL default '0',
  special tinyint(1) NOT NULL default '0',
  state tinyint(1) NOT NULL default '0',
  ifupload tinyint(1) NOT NULL default '0',
  ifmail tinyint(1) NOT NULL default '0',
  ifmark smallint(6) NOT NULL default '0',
  ifshield tinyint(1) NOT NULL default '0',
  anonymous tinyint(1) NOT NULL default '0',
  dig int(10) NOT NULL default '0',
  fight int(10) NOT NULL default '0',
  ptable tinyint(3) NOT NULL default '0',
  ifmagic tinyint(1) NOT NULL default '0',
  ifhide tinyint(1) NOT NULL default '0',
  inspect varchar(30) NOT NULL default '',
  PRIMARY KEY  (tid),
  KEY authorid (authorid),
  KEY postdate (postdate),
  KEY digest (digest),
  KEY type (fid,type,ifcheck),
  KEY special (special),
  KEY lastpost (fid,ifcheck,topped,lastpost)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_tmsgs;
CREATE TABLE pw_tmsgs (
  tid mediumint(8) unsigned NOT NULL default '0',
  aid text NOT NULL,
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL,
  ipfrom varchar(255) NOT NULL default '',
  alterinfo varchar(50) NOT NULL default '',
  remindinfo varchar(150) NOT NULL default '',
  tags varchar(100) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '1',
  ifwordsfb tinyint(1) NOT NULL default '1',
  content mediumtext NOT NULL,
  form varchar(30) NOT NULL default '',
  ifmark varchar(255) NOT NULL default '',
  c_from varchar(30) NOT NULL default '',
  magic varchar(50) NOT NULL,
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_toollog;
CREATE TABLE pw_toollog (
  id int(10) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '',
  nums smallint(6) NOT NULL default '0',
  money smallint(6) NOT NULL default '0',
  descrip varchar(255) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  ip varchar(15) NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  filename varchar(20) NOT NULL default '',
  touid mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY touid (touid),
  KEY type (type)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_tools;
CREATE TABLE pw_tools (
  id smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  filename varchar(20) NOT NULL default '',
  descrip varchar(255) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  logo varchar(100) NOT NULL default '',
  state tinyint(1) NOT NULL default '0',
  price varchar(255) NOT NULL default '',
  creditype varchar(10) NOT NULL default '',
  `rmb` DECIMAL(8,2) NOT NULL,
  `type` tinyint(1) NOT NULL default '0',
  stock smallint(6) NOT NULL default '0',
  conditions text NOT NULL ,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_tools VALUES('1','{#tool_1}','reputation','{#tool_1_inro}','1','1.gif','1','100','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('2','{#tool_2}','credit','{#tool_2_inro}','2','2.gif','1','100','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('3','{#tool_3}','colortitle','{#tool_3_inro}','3','3.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('4','{#tool_4}','top','{#tool_4_inro}','4','4.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('5','{#tool_5}','top2','{#tool_5_inro}','5','5.gif','1','200','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('6','{#tool_6}','top3','{#tool_6_inro}','6','6.gif','1','500','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('7','{#tool_7}','upread','{#tool_7_inro}','7','7.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('8','{#tool_8}','changename','{#tool_8_inro}','8','8.gif','1','100','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('9','{#tool_9}','digest','{#tool_9_inro}','9','9.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('10','{#tool_10}','digest2','{#tool_10_inro}','10','10.gif','1','200','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('11','{#tool_11}','lock','{#tool_11_inro}','11','11.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('12','{#tool_12}','unlock','{#tool_12_inro}','12','12.gif','1','100','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('13','{#tool_13}','flower','{#tool_13_inro}','13','13.gif','0','1','money','','1','1000','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('14','{#tool_14}','egg','{#tool_14_inro}','14','14.gif','0','1','money','','1','1000','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('15','{#tool_15}','luck','{#tool_15_inro}','15','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('16','{#tool_16}','birth','{#tool_16_inro}','16','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('17','{#tool_17}','backdown','{#tool_17_inro}','17','','0','10','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('18','{#tool_18}','pig','{#tool_18_inro}','18','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('19','{#tool_19}','clear','{#tool_19_inro}','19','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('20','{#tool_20}','mirror','{#tool_20_inro}','20','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('21','{#tool_21}','defend','{#tool_21_inro}','21','','0','10','currency','','2','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('22','{#tool_22}','backup','{#tool_22_inro}','22','','0','10','currency','','1','100','a:1:{s:6:"credit";a:7:{s:7:"postnum";i:0;s:7:"digests";i:0;s:4:"rvrc";i:0;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:0;i:2;i:0;}}');

DROP TABLE IF EXISTS pw_trade;
CREATE TABLE pw_trade (
  tid mediumint(8) unsigned NOT NULL,
  uid mediumint(8) unsigned NOT NULL,
  name varchar(80) NOT NULL,
  icon varchar(80) NOT NULL,
  degree tinyint(1) unsigned NOT NULL,
  type smallint(6) unsigned NOT NULL,
  num smallint(6) unsigned NOT NULL,
  salenum smallint(6) unsigned NOT NULL,
  price decimal(8,2) NOT NULL,
  costprice decimal(8,2) NOT NULL,
  locus varchar(30) NOT NULL,
  paymethod tinyint(3) unsigned NOT NULL,
  transport tinyint(1) unsigned NOT NULL,
  mailfee decimal(4,2) NOT NULL,
  expressfee decimal(4,2) NOT NULL,
  emsfee decimal(4,2) NOT NULL,
  deadline int(10) unsigned NOT NULL,
  PRIMARY KEY  (tid),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_tradeorder;
CREATE TABLE pw_tradeorder (
  oid mediumint(8) unsigned NOT NULL auto_increment,
  order_no varchar(30) NOT NULL,
  tid mediumint(8) unsigned NOT NULL,
  subject varchar(80) NOT NULL,
  buyer mediumint(8) unsigned NOT NULL,
  seller mediumint(8) unsigned NOT NULL,
  price decimal(6,2) NOT NULL,
  quantity smallint(6) unsigned NOT NULL,
  transportfee decimal(4,2) NOT NULL,
  transport tinyint(1) unsigned NOT NULL,
  buydate int(10) unsigned NOT NULL,
  tradedate int(10) unsigned NOT NULL,
  ifpay tinyint(1) NOT NULL,
  address varchar(80) NOT NULL,
  consignee varchar(15) NOT NULL,
  tel varchar(15) NOT NULL,
  zip varchar(15) NOT NULL,
  descrip varchar(255) NOT NULL,
  payment tinyint(1) unsigned NOT NULL,
  tradeinfo varchar(255) NOT NULL,
  PRIMARY KEY  (oid),
  UNIQUE KEY order_no (order_no),
  KEY tid (tid),
  KEY buyer (buyer),
  KEY seller (seller)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_voter;
CREATE TABLE pw_voter (
  tid mediumint(8) unsigned NOT NULL,
  uid mediumint(8) unsigned NOT NULL,
  username varchar(15) NOT NULL,
  vote tinyint(3) unsigned NOT NULL,
  `time` int(10) unsigned NOT NULL,
  KEY tid (tid),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_usergroups;
CREATE TABLE pw_usergroups (
  gid smallint(5) unsigned NOT NULL auto_increment,
  gptype enum('default','member','system','special') NOT NULL default 'member',
  grouptitle varchar(60) NOT NULL default '',
  groupimg varchar(15) NOT NULL default '',
  grouppost int(10) NOT NULL default '0',
  ifdefault tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (gid),
  KEY gptype (gptype),
  KEY grouppost (grouppost)
) TYPE=MyISAM;

INSERT INTO pw_usergroups SET gid = 1,  gptype = 'default',grouptitle = 'default',    groupimg = '8', grouppost = 0, ifdefault=1;
INSERT INTO pw_usergroups SET gid = 2,  gptype = 'default',grouptitle = '{#level_1}', groupimg = '8', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 3,  gptype = 'system', grouptitle = '{#level_3}', groupimg = '3', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 4,  gptype = 'system', grouptitle = '{#level_4}', groupimg = '4', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 5,  gptype = 'system', grouptitle = '{#level_5}', groupimg = '5', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 6,  gptype = 'default', grouptitle = '{#level_6}', groupimg = '8', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 7,  gptype = 'default', grouptitle = '{#level_7}', groupimg = '8', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 8,  gptype = 'member', grouptitle = '{#level_8}', groupimg = '8', grouppost = 0, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 9,  gptype = 'member', grouptitle = '{#level_9}', groupimg = '9', grouppost = 100, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 10, gptype = 'member', grouptitle = '{#level_10}',groupimg = '10',grouppost = 300, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 11, gptype = 'member', grouptitle = '{#level_11}',groupimg = '11',grouppost = 600, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 12, gptype = 'member', grouptitle = '{#level_12}',groupimg = '12',grouppost = 1000, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 13, gptype = 'member', grouptitle = '{#level_13}',groupimg = '13',grouppost = 5000, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 14, gptype = 'member', grouptitle = '{#level_14}',groupimg = '14',grouppost = 10000, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 15, gptype = 'member', grouptitle = '{#level_15}',groupimg = '14',grouppost = 50000, ifdefault=0;
INSERT INTO pw_usergroups SET gid = 16, gptype = 'special',grouptitle = '{#level_16}',groupimg = '5', grouppost = 0, ifdefault=0;

DROP TABLE IF EXISTS pw_usertool;
CREATE TABLE pw_usertool (
  uid mediumint(8) unsigned NOT NULL default '0',
  toolid smallint(6) NOT NULL default '0',
  nums smallint(6) NOT NULL default '0',
  sellnums smallint(6) NOT NULL default '0',
  sellprice varchar(255) NOT NULL default '',
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_windcode;
CREATE TABLE pw_windcode (
  id smallint(6) unsigned NOT NULL auto_increment,
  `name` varchar(15) NOT NULL default '',
  icon varchar(30) NOT NULL default '',
  pattern varchar(30) NOT NULL default '',
  replacement text NOT NULL ,
  param tinyint(1) NOT NULL default '0',
  ifopen tinyint(1) NOT NULL default '0',
  title varchar(30) NOT NULL default '',
  descrip varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_wordfb;
CREATE TABLE pw_wordfb (
  id smallint(6) unsigned NOT NULL auto_increment,
  word varchar(100) NOT NULL default '',
  wordreplace varchar(100) NOT NULL default '',
  `type` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;