

CREATE TABLE pw_warning (
  id tinyint(20) NOT NULL auto_increment,
  uid mediumint(20) unsigned NOT NULL default '0',
  fid int(20) unsigned NOT NULL default '0',
  tid int(20) unsigned NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  oldgid TINYINT(10) unsigned NOT NULL DEFAULT '0',
  starttime int(10) unsigned NOT NULL default '0',
  master varchar(20) NOT NULL default '',
  warningno tinyint(1) NOT NULL default '0',
  wreson varchar(255) NOT NULL default '',
  wtimes mediumint(20) NOT NULL default '0',
  PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE pw_warningf (
  id tinyint(8) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(30) NOT NULL default '',
  fid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default '0',
  fidlock int(2) NOT NULL default '0',
  name varchar(100) NOT NULL default '',
  dayy INT(10) unsigned NOT NULL default '0',
  msg TEXT NOT NULL default '',
  time INT NOT NULL default '0',
  PRIMARY KEY (id)
) TYPE=MyISAM;
