CREATE TABLE `web_profile` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`accountid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 16 ) NOT NULL ,
`mainchar` INT( 10 ) NOT NULL ,
`realname` VARCHAR( 32 ) NOT NULL ,
`age` INT( 2 ) NOT NULL ,
`country` VARCHAR( 100 ) NOT NULL ,
`motto` VARCHAR( 255 ) NOT NULL ,
`favjob` VARCHAR( 50 ) NOT NULL ,
`text` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_pcomments` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`accountid` INT( 10 ) NOT NULL ,
`commenter` VARCHAR( 16 ) NOT NULL ,
`feedback` INT( 1 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`comment` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_ncomments` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`nid` INT ( 10 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`feedback` INT( 1 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`comment` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_ecomments` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`eid` INT ( 10 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`feedback` INT( 1 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`comment` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_bcomments` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`bid` INT ( 10 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`feedback` INT( 1 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`comment` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_news` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 50 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`type` VARCHAR( 50 ) NOT NULL ,
`content` TEXT NOT NULL ,
`views` INT ( 10 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_events` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 50 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`type` VARCHAR( 100 ) NOT NULL ,
`status` VARCHAR( 32 ) NOT NULL ,
`content` TEXT NOT NULL ,
`views` INT ( 10 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `web_gmblog` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 50 ) NOT NULL ,
`author` VARCHAR( 16 ) NOT NULL ,
`date` VARCHAR( 32 ) NOT NULL ,
`content` TEXT NOT NULL ,
`views` INT( 10 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
ALTER TABLE `accounts` ADD `gm` INT( 1 ) DEFAULT '0';
ALTER TABLE `accounts` ADD `webadmin` INT( 1 ) DEFAULT '0';
ALTER TABLE `accounts` ADD `nick` VARCHAR( 16 ) NOT NULL ;
ALTER TABLE `accounts` ADD `mute` INT( 1 ) DEFAULT '0';
ALTER TABLE `accounts` ADD `sitelogged` VARCHAR( 255 ) NOT NULL ;