
CREATE TABLE pw_base (
  id mediumint(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL,
  username varchar(50) NOT NULL,
  sofname varchar(100) NOT NULL,
  bsimage varchar(255) NOT NULL,
  catidname int(10) NOT NULL,
  addstar int(10) NOT NULL,
  addsizest int(10) NOT NULL,
  addlang int(2) NOT NULL,
  inpower int(2) NOT NULL,
  addhold varchar(30) NOT NULL,
  addurl varchar(30) NOT NULL,
  content mediumtext NOT NULL,
  postlist int(2) NOT NULL,
  dowguest int(2) NOT NULL,
  time int(10) NOT NULL,
  hit int(10) unsigned NOT NULL,
  top int(1) NOT NULL,
  dight int(2) NOT NULL,
  dighttime int(10) NOT NULL,
  vote int(10) unsigned NOT NULL,
  votename varchar(255) NOT NULL,
  checks int(1) NOT NULL,
  erro int(1) NOT NULL,
  adminmsg mediumtext NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;


CREATE TABLE pw_basec (
  cid int(10) unsigned NOT NULL auto_increment,
  tid int(10) unsigned NOT NULL,
  uid int(10) unsigned NOT NULL,
  username varchar(50) NOT NULL,
  sum int(10) unsigned NOT NULL,
  title varchar(50) NOT NULL,
  content mediumtext NOT NULL,
  time int(10) NOT NULL,
  PRIMARY KEY  (cid)
) ENGINE=MyISAM;


CREATE TABLE pw_basecate (
  cid tinyint(5) NOT NULL auto_increment,
  name char(50) NOT NULL default '',
  PRIMARY KEY  (cid)
) ENGINE=MyISAM;


INSERT INTO pw_basecate (cid, name) VALUES 
(1, ''),
(2, 'ͬ'),
(3, 'E'),
(4, 'ͬ'),
(5, 'ն'),
(6, 'z'),
(7, 'Ȥ'),
(8, 'ZL'),
(9, ''),
(10, ''),
(11, 'v'),
(12, 'L'),
(13, 't');


CREATE TABLE pw_baseinfo (
  uid int(10) NOT NULL,
  author varchar(20) NOT NULL,
  posts int(6) NOT NULL,
  replys int(6) NOT NULL
) ENGINE=MyISAM;


CREATE TABLE pw_basreply (
  aid int(11) unsigned NOT NULL auto_increment,
  tid int(10) unsigned NOT NULL,
  uid int(10) unsigned NOT NULL,
  username char(20) NOT NULL default '',
  content mediumtext NOT NULL,
  ipfrom char(100) NOT NULL default '',
  time int(11) NOT NULL,
  KEY aid (aid)
) ENGINE=MyISAM;
