CREATE TABLE {pre}_wars (
wars_id {serial},
games_id int(8) NOT NULL default '0',
categories_id int(8) NOT NULL default '0',
clans_id int(8) NOT NULL default '0',
squads_id int(8) NOT NULL default '0',
wars_date varchar(14) NOT NULL default '',
wars_status varchar(20) NOT NULL default '',
wars_score1 int(6) NOT NULL default '0',
wars_score2 int(6) NOT NULL default '0',
wars_serverip varchar(80) NOT NULL default '',
wars_serverpw varchar(80) NOT NULL default '',
wars_url varchar(80) NOT NULL default '',
wars_opponents varchar(200) NOT NULL default '',
wars_players1 int(4) NOT NULL default '0',
wars_players2 int(4) NOT NULL default '0',
wars_report text,
wars_close int(2) NOT NULL default '0',
wars_pictures text,
PRIMARY KEY (wars_id)
){engine};

|