﻿
DROP TABLE IF EXISTS pw_applyask;
CREATE TABLE pw_applyask (
  cid int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  content varchar(100) NOT NULL,
  `time` int(10) unsigned NOT NULL,
  adminmsg mediumtext NOT NULL,
  PRIMARY KEY  (cid)
) ENGINE=MyISAM ;


DROP TABLE IF EXISTS pw_applydata;
CREATE TABLE pw_applydata (
  id int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  username varchar(255) NOT NULL,
  forumid tinyint(10) unsigned NOT NULL default '0',
  city varchar(100) NOT NULL,
  joy varchar(100) NOT NULL,
  lx varchar(100) NOT NULL,
  howtime varchar(100) NOT NULL,
  howday varchar(100) NOT NULL,
  gdtime varchar(100) NOT NULL,
  form varchar(100) NOT NULL,
  interest varchar(255) NOT NULL,
  nowsee varchar(255) NOT NULL,
  howdo varchar(255) NOT NULL,
  fail varchar(255) NOT NULL,
  onlineip varchar(20) NOT NULL,
  ipfrom varchar(100) NOT NULL,
  `time` int(10) NOT NULL,
  votyes int(10) unsigned NOT NULL,
  votno int(10) unsigned NOT NULL,
  votname mediumtext NOT NULL,
  adminmsg mediumtext NOT NULL,
  checks int(2) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM ;


DROP TABLE IF EXISTS pw_applyreg;
CREATE TABLE pw_applyreg (
  uid int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL
) ENGINE=MyISAM;



DROP TABLE IF EXISTS pw_applyreply;
CREATE TABLE pw_applyreply (
  pid int(10) unsigned NOT NULL auto_increment,
  tid int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  username varchar(100) NOT NULL,
  content mediumtext NOT NULL,
  postdate int(10) NOT NULL,
  onlineip varchar(20) NOT NULL,
  ipfrom mediumtext NOT NULL,
  PRIMARY KEY  (pid)
) ENGINE=MyISAM;

