Ето и SQL-a
Код за потвърждение: Избери целия код
//////////////////////////MAIN///////////////////////////////
CREATE TABLE IF NOT EXISTS `server_ad` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`players` varchar(2) NOT NULL,
`maxplayers` varchar(2) NOT NULL,
`tip` text NOT NULL,
`karta` text NOT NULL,
`ip` varchar(255) NOT NULL,
`port` varchar(8) NOT NULL,
`status` text NOT NULL,
`addedfor` varchar(11) NOT NULL,
`expiredin` varchar(11) NOT NULL,
`zakachen` varchar(1) NOT NULL,
`country` text NOT NULL,
`dobavenot` text NOT NULL,
`os` varchar(1) DEFAULT NULL,
`vac` varchar(255) DEFAULT NULL,
`game` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
////////////////////CATEGORY/////////////////////////
CREATE TABLE IF NOT EXISTS `server_ad_cat` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`categoryname` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45;
INSERT INTO `server_ad_cat` (`id`, `categoryname`) VALUES
(1, '5on5'),
(2, 'AWP Only'),
(3, 'Aim'),
(4, 'Bhop'),
(5, 'Catch'),
(6, 'Classic'),
(7, 'Crysis'),
(8, 'Cups'),
(9, 'DeathRace'),
(10, 'Deathmatch'),
(11, 'Deathrun'),
(12, 'Diablo'),
(13, 'Dust2 Only'),
(14, 'Dust2 and Inferno Only'),
(15, 'Free4All'),
(16, 'Ghost'),
(17, 'GunGame'),
(18, 'Hide N Seek'),
(19, 'HnS Training'),
(20, 'Inferno Only'),
(21, 'Italy2 Only'),
(22, 'Jailbreak'),
(23, 'Just Capture the Flag'),
(24, 'Knife'),
(25, 'Kreedz'),
(26, 'Longjump'),
(27, 'Massive'),
(28, 'Monster Mod'),
(29, 'PaintBall'),
(30, 'Predator'),
(31, 'Rally'),
(32, 'Respawn'),
(33, 'Silent Hill'),
(34, 'Snowball War'),
(35, 'Soccerjam'),
(36, 'SuperHero'),
(37, 'Surf'),
(38, 'VolleyBall'),
(39, 'WC3 SaveXP'),
(40, 'Warcraft 3'),
(41, 'Zombie'),
(42, 'Zombie Base Builder'),
(43, 'Zombie Escape'),
(44, 'other');
////////////////////////RATING////////////////////////////
CREATE TABLE IF NOT EXISTS `server_ad_wcd_yt_rate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_item` int(11) NOT NULL,
`ip` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`rate` int(1) NOT NULL,
`dt_rated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;