CREATE TABLE `alawar_games` (
`ID` INT( 7 ) NOT NULL ,
`GENRE_ID` INT( 3 ) NOT NULL ,
`Date` VARCHAR( 10 ) NOT NULL ,
`Game_Hit_Property` VARCHAR( 3 ) NOT NULL ,
`Game_New_Property` VARCHAR( 3 ) NOT NULL ,
`Game_Genre_Best_Property` VARCHAR( 3 ) NOT NULL ,
`Game_Global_Hit_Sort` INT( 5 ) NOT NULL ,
`Game_TopList_Rating` INT( 5 ) NOT NULL ,
`Game_LastUpdatedList_Rating` INT( 5 ) NOT NULL ,
`Game_Sort` INT( 5 ) NOT NULL ,
`Game_File_Size` VARCHAR( 50 ) NOT NULL ,
`Game_Genre` VARCHAR( 50 ) NOT NULL ,
`Game_Name` VARCHAR( 100 ) NOT NULL ,
`Game_Logo_44_44_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Icon_32_32_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Icon_380_380_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Icon_50_50_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Logo_190_140_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Image_100x100_White_URL` VARCHAR( 250 ) NOT NULL ,
`Char_Desc_80` VARCHAR( 80 ) NOT NULL ,
`Char_Desc_250` VARCHAR( 250 ) NOT NULL ,
`Char_Desc_450` TEXT NOT NULL ,
`Char_Desc_1000` TEXT NOT NULL ,
`Html_Desc` TEXT NOT NULL, 
`Char_Desc_45` VARCHAR( 45 ) NOT NULL ,
`Screenshot_URL` INT( 30 ) NOT NULL ,
`Game_Download_URL` VARCHAR( 250 ) NOT NULL ,
`Game_Icon_90_50_URL` VARCHAR( 250 ) NOT NULL ,
PRIMARY KEY ( `ID` ),
FULLTEXT KEY `Game_Name` (`Game_Name`),
FULLTEXT KEY `Html_Desc` (`Html_Desc`)
);


-- 
--   `alawar_ganr`
-- 

CREATE TABLE `alawar_ganr` (
  `GENRE_ID` int(4) NOT NULL,
  `Genre_Name_Ru` varchar(200) NOT NULL,
  PRIMARY KEY  (`GENRE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
--    `alawar_ganr`
-- 

INSERT INTO `alawar_ganr` VALUES (25, '');
INSERT INTO `alawar_ganr` VALUES (27, '');
INSERT INTO `alawar_ganr` VALUES (24, '');
INSERT INTO `alawar_ganr` VALUES (26, '');
INSERT INTO `alawar_ganr` VALUES (30, '');
INSERT INTO `alawar_ganr` VALUES (28, '');






CREATE TABLE `alawar_strip` (
`igra` INT( 5 ) NOT NULL ,
`sid` INT( 1 ) NOT NULL ,
`tupe` VARCHAR( 5 ) NOT NULL ,
`link` VARCHAR( 250 ) NOT NULL ,
PRIMARY KEY ( `link` )
);


CREATE TABLE `alawar_online` (
  `ID` int(6) NOT NULL,
  `GAME_ID` int(6) NOT NULL,
  `LINK` varchar(250) NOT NULL,
  `WIDTH` int(4) NOT NULL,
  `HEIGHT` int(4) NOT NULL,
  PRIMARY KEY  (`ID`)
);