Файл: Dvig/base.txt
Строк: 271
CREATE TABLE IF NOT EXISTS `chat_posts` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`text` text NOT NULL,
`author` int(11) NOT NULL,
`room` int(11) NOT NULL,
`time` int(15) NOT NULL,
`pole` text NOT
NULL,
`polea` text NOT NULL,
`poleb` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `chat_room` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` text NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF
NOT EXISTS `core_black_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(10) NOT NULL,
`kogo` int(10) NOT NULL,
`time` int(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `core_deistvie` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`komu` int(10) NOT NULL,
`ktoo`
int(10) NOT NULL,
`deistvie` text NOT NULL,
`time` int(50) NOT
NULL,
`status` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS
`core_mail_dialog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto_one`
int(10) NOT NULL,
`kto_two` int(10) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF
NOT EXISTS `core_photos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(10) NOT NULL,
`opis` varchar(150) NOT NULL,
`time` int(50)
NOT NULL,
`file` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF
NOT EXISTS `core_wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author` int(11) NOT NULL,
`komu` int(11) NOT NULL,
`time` int(15)
NOT NULL,
`text` text NOT NULL,
`polea` text NOT NULL,
`poleb`
text NOT NULL,
`polec` text NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF
NOT EXISTS `design` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`number` int(2) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
INSERT INTO
`design` (`id`, `name`, `number`) VALUES
(1,
'Оранжевый(стандарт)', 1),
(2, 'Джинсовый',
2),
(3, 'Красный', 3),
(4, 'Темно-коричневый',
4),
(5, 'Серо-синий', 5),
(6, 'Светлый', 6),
(7,
'Синий', 7),
(8, 'Оранжевый', 8);
CREATE TABLE IF NOT
EXISTS `dnevnik_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`author` int(11) NOT NULL,
`time` int(15) NOT NULL,
`opis` text NOT NULL,
`pole` text NOT NULL,
`polea` text NOT NULL,
`poleb` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS
`dnevnik_zapis` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dnevnik`
text NOT NULL,
`author` int(11) NOT NULL,
`time` int(15) NOT NULL,
`text` text NOT NULL,
`pole` text NOT NULL,
`polea` text NOT NULL,
`poleb` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS
`forum_podrazdel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text
NOT NULL,
`razdel` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS
`forum_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`razdel` int(5)
NOT NULL,
`podrazdel` int(5) NOT NULL,
`theme` int(5) NOT NULL,
`text` text NOT NULL,
`time` int(15) NOT NULL,
`author` int(5) NOT
NULL,
`translit` int(2) NOT NULL,
`quote` int(7) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `forum_razdel` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` text NOT NULL,
`opis` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `forum_themes` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`razdel` int(5) NOT NULL,
`podrazdel` int(5) NOT
NULL,
`name` text NOT NULL,
`time` int(15) NOT NULL,
`author_id`
int(5) NOT NULL,
`last_id` int(5) NOT NULL,
`status` int(3) NOT
NULL,
`vip` int(2) NOT NULL,
`time_last` int(20) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `friend` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`kto` text NOT NULL,
`kogo` text NOT NULL,
`status` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `golosa` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`stat` varchar(10) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `gorod_avto` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`cost` int(10) NOT NULL,
`avto` varchar(80) NOT
NULL,
`clas` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=85 ;
INSERT INTO `gorod_avto`
(`id`, `cost`, `avto`, `clas`) VALUES
(1, 5000, 'Ваз 2101', 0),
(2,
7000, 'Ваз 2106', 0),
(3, 9000, 'Ваз 2107', 0),
(4, 12000, 'Ваз
2109', 0),
(5, 15000, 'Ваз 2110', 0),
(6, 17000, 'Ваз 2112',
0),
(7, 20000, 'Ваз 2114', 0),
(8, 22000, 'LADA Priora', 0),
(9,
23000, 'Volkswagen golf 2001', 0),
(10, 25000, 'Volkswagen golf 2006',
0),
(11, 27000, 'Renault megane', 0),
(12, 29000, 'Renault clio',
0),
(13, 30000, 'Renault Symbol', 0),
(14, 35000, 'Renault Logan',
0),
(15, 37000, 'Renault Duster', 0),
(16, 38000, 'Peugeot 106',
0),
(17, 40000, 'Peugeot 206', 0),
(18, 42000, 'Peugeot 307', 0),
(19,
45000, 'Mitsubishi Evolution X', 0),
(20, 47000, 'Mitsubishi Pajero',
0),
(21, 48000, 'Mercedes s600', 0),
(22, 50000, 'Audi 80', 0),
(23,
52000, 'Audi 100', 0),
(24, 54000, 'Audi a4', 0),
(25, 56000, 'Audi a6',
0),
(26, 58000, 'Audi a8', 0),
(27, 60000, 'Audi rs4', 0),
(28, 62000,
'Audi rs6', 0),
(29, 64000, 'Audi r8', 0),
(30, 65000, 'Audi q3',
0),
(31, 68000, 'Audi q5', 0),
(32, 70000, 'Audi q7', 0),
(33, 72000,
'BMW 320i', 0),
(34, 74000, 'BMW z4', 0),
(35, 76000, 'BMW 525i',
0),
(36, 78000, 'BMW 528xi', 0),
(37, 79000, 'BMW m6', 0),
(38, 80000,
'BMW 725i', 0),
(39, 82000, 'BMW 730d', 0),
(40, 84000, 'BMW x1',
0),
(41, 86000, 'BMW x3', 0),
(42, 87000, 'BMW x5m', 0),
(43, 88000,
'BMW x6', 0),
(44, 90000, 'BMW x6m', 0),
(45, 92000, 'FORD Focus ',
0),
(46, 94000, 'FORD explorer', 0),
(47, 96000, 'FORD Mondeo', 0),
(48,
98000, 'FORD Fusion', 0),
(49, 100000, 'FORD GT', 0),
(50, 110000, 'FORD
Mustang', 0),
(51, 120000, 'FORD Fiesta', 0),
(52, 140000, 'Nissan
Qashqai', 0),
(53, 160000, 'Nissan Almera', 0),
(54, 180000, 'Nissan
Teana', 0),
(55, 200000, 'Nissan Juke', 0),
(56, 240000, 'Nissan 350z',
0),
(57, 280000, 'Nissan 370z', 0),
(58, 320000, 'Nissan Murano',
0),
(59, 360000, 'Nissan Patrol', 0),
(60, 400000, 'Nissan GT-R',
0),
(61, 450000, 'Nissan Skyline', 0),
(62, 470000, 'Subaru WRX',
0),
(63, 470000, 'Subaru Impreza XV', 0),
(64, 470000, 'Subaru Advanced
Tourer', 0),
(65, 480000, 'Subaru Forester', 0),
(66, 650000,
'Rolls-Royce Phantom', 0),
(67, 700000, 'Rolls-Royce Silver Seraph',
0),
(68, 750000, 'Rolls-Royce Phantom Coupe', 0),
(69, 800000,
'Rolls-Royce Phantom Drophead Coupe', 0),
(70, 850000, 'Rolls-Royce
Ghost', 0),
(71, 900000, 'Porsche Panamera', 0),
(72, 950000, 'Porsche
911', 0),
(73, 1000000, 'Porsche Cayenne', 0),
(74, 1100000, 'Porsche
Cayman', 0),
(75, 1700000, 'Porsche Carrera GT', 0),
(76, 1750000,
'Ferrari 599', 0),
(77, 1800000, 'Ferrari 360 Spider', 0),
(78, 1890000,
'Ferrari F430 Spider', 0),
(79, 1950000, 'Ferrari California', 0),
(80,
2300000, 'Ferrari Enzo', 0),
(81, 2310000, 'Ferrari FF', 0),
(82,
2310000, 'Lamborghini Gallardo', 0),
(83, 2350000, 'Lamborghini
Murcielago', 0),
(84, 3500000, 'Bugatti veyron', 0);
CREATE TABLE IF
NOT EXISTS `gorod_home` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cost` int(9) NOT NULL,
`home` varchar(70) NOT NULL,
`oplata` int(4)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=10 ;
INSERT INTO `gorod_home` (`id`, `cost`, `home`,
`oplata`) VALUES
(1, 450000, 'Коммунальная квартира',
300),
(2, 700000, 'Однокомнатная квартира',
700),
(3, 900000, 'Двухкомнатная квартира',
900),
(4, 1300000, 'Трехкомнатная квартира',
1000),
(5, 2300000, 'Четырехкомнатная квартира',
1200),
(6, 2700000, 'Пятикомнатная квартира',
1300),
(7, 4000000, 'Коттедж', 1500),
(8, 5000000,
'Особняк', 1700),
(9, 7000000, 'Дворец', 1800);
CREATE
TABLE IF NOT EXISTS `gorod_zoo` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`cost` int(9) NOT NULL,
`zoo` varchar(70) NOT NULL,
`oplata` int(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=13 ;
INSERT INTO `gorod_zoo` (`id`, `cost`,
`zoo`, `oplata`) VALUES
(1, 100, 'Хомяк', 300),
(2, 200,
'Морская свинка', 700),
(3, 300, 'Рыбки', 900),
(4,
400, 'Черепаха', 1000),
(5, 500, 'Кот', 1200),
(6, 1000,
'Собака', 1300),
(7, 1500, 'Кролик', 1500),
(8, 2000,
'Шиншилла', 1700),
(9, 2300, 'Хорек', 1800),
(10, 2400,
'Улитка', 300),
(11, 2600, 'Коза', 700),
(12, 3000,
'Попугай', 900);
CREATE TABLE IF NOT EXISTS `logs` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`who` int(11) NOT NULL,
`time`
int(15) NOT NULL,
`deis` text NOT NULL,
`user_ip` text NOT NULL,
`user_agent` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `mail` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`kto` int(5) NOT NULL,
`komu`
int(5) NOT NULL,
`text` text NOT NULL,
`time` int(15) NOT NULL,
`status` int(5) NOT NULL,
`pole_a` int(5) DEFAULT NULL,
`pole_b`
int(5) DEFAULT NULL,
`pole_c` int(5) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`time` int(11) NOT
NULL,
`text` text NOT NULL,
`whoid` varchar(100) NOT NULL,
`whona`
varchar(100) NOT NULL,
`poleb` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE
TABLE IF NOT EXISTS `news_comm` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`text` text NOT NULL,
`author` int(11) NOT NULL,
`news` int(11) NOT NULL,
`time` int(15) NOT NULL,
`pole` text NOT
NULL,
`polea` text NOT NULL,
`poleb` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE
TABLE IF NOT EXISTS `obmen_cat` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`name` varchar(400) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
CREATE TABLE IF
NOT EXISTS `obmen_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`file` text NOT NULL,
`size` text NOT NULL,
`author` int(10) NOT NULL,
`cat_obmen` varchar(80) NOT NULL,
`time`
int(13) NOT NULL,
`down` int(11) NOT NULL,
`view` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `online` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`ses` varchar(50) NOT NULL,
`time` int(11)
NOT NULL,
`who` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=306 ;
CREATE TABLE
IF NOT EXISTS `podar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cost`
int(11) NOT NULL,
`img` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=309 ;
INSERT INTO
`podar` (`id`, `cost`, `img`) VALUES
(1, 12, 0),
(2, 13, 1),
(3, 7,
10),
(4, 7, 100),
(5, 8, 101),
(6, 12, 102),
(7, 17, 103),
(8, 9,
104),
(9, 9, 105),
(10, 10, 106),
(11, 20, 107),
(12, 5, 108),
(13,
19, 109),
(14, 5, 11),
(15, 15, 110),
(16, 6, 112),
(17, 19,
113),
(18, 18, 114),
(19, 9, 115),
(20, 13, 116),
(21, 10, 117),
(22,
15, 118),
(23, 19, 119),
(24, 20, 12),
(25, 5, 120),
(26, 18,
121),
(27, 19, 122),
(28, 12, 123),
(29, 8, 124),
(30, 7, 125),
(31,
8, 126),
(32, 14, 127),
(33, 13, 128),
(34, 5, 129),
(35, 12,
13),
(36, 12, 130),
(37, 8, 131),
(38, 9, 132),
(39, 12, 133),
(40,
16, 134),
(41, 5, 135),
(42, 7, 136),
(43, 17, 137),
(44, 11,
138),
(45, 7, 139),
(46, 15, 14),
(47, 9, 140),
(48, 7, 141),
(49, 10,
142),
(50, 5, 143),
(51, 13, 144),
(52, 5, 145),
(53, 17, 146),
(54,
7, 147),
(55, 13, 148),
(56, 14, 149),
(57, 8, 15),
(58, 11,
150),
(59, 14, 151),
(60, 5, 152),
(61, 19, 153),
(62, 13, 154),
(63,
18, 155),
(64, 18, 156),
(65, 11, 157),
(66, 19, 158),
(67, 15,
159),
(68, 7, 16),
(69, 6, 160),
(70, 11, 161),
(71, 5, 162),
(72, 14,
163),
(73, 15, 164),
(74, 11, 165),
(75, 11, 166),
(76, 8, 167),
(77,
9, 168),
(78, 16, 169),
(79, 18, 17),
(80, 14, 170),
(81, 16,
171),
(82, 14, 172),
(83, 16, 173),
(84, 19, 174),
(85, 7, 175),
(86,
5, 176),
(87, 20, 177),
(88, 15, 178),
(89, 10, 179),
(90, 9,
18),
(91, 8, 180),
(92, 20, 181),
(93, 12, 182),
(94, 8, 183),
(95, 9,
184),
(96, 12, 185),
(97, 8, 186),
(98, 7, 187),
(99, 16, 188),
(100,
8, 189),
(101, 19, 19),
(102, 20, 190),
(103, 12, 191),
(104, 18,
192),
(105, 8, 193),
(106, 5, 194),
(107, 20, 195),
(108, 10,
196),
(109, 9, 197),
(110, 6, 198),
(111, 8, 199),
(112, 12, 2),
(113,
20, 20),
(114, 13, 200),
(115, 16, 201),
(116, 7, 202),
(117, 10,
203),
(118, 9, 204),
(119, 10, 205),
(120, 6, 206),
(121, 9,
207),
(122, 14, 208),
(123, 15, 209),
(124, 10, 21),
(125, 19,
210),
(126, 9, 211),
(127, 14, 212),
(128, 12, 213),
(129, 19,
214),
(130, 17, 215),
(131, 15, 216),
(132, 15, 217),
(133, 13,
218),
(134, 19, 219),
(135, 16, 22),
(136, 11, 220),
(137, 14,
221),
(138, 20, 222),
(139, 10, 223),
(140, 19, 224),
(141, 7,
225),
(142, 18, 226),
(143, 12, 227),
(144, 15, 228),
(145, 5,
229),
(146, 18, 23),
(147, 14, 230),
(148, 17, 231),
(149, 12,
232),
(150, 19, 233),
(151, 14, 234),
(152, 18, 235),
(153, 6,
236),
(154, 8, 237),
(155, 5, 238),
(156, 5, 239),
(157, 7, 24),
(158,
17, 240),
(159, 18, 241),
(160, 19, 242),
(161, 12, 243),
(162, 17,
244),
(163, 12, 245),
(164, 12, 246),
(165, 6, 247),
(166, 8,
248),
(167, 19, 249),
(168, 11, 25),
(169, 18, 250),
(170, 10,
251),
(171, 15, 252),
(172, 17, 253),
(173, 19, 254),
(174, 20,
255),
(175, 15, 256),
(176, 8, 257),
(177, 5, 258),
(178, 13,
259),
(179, 10, 26),
(180, 17, 260),
(181, 11, 261),
(182, 18,
262),
(183, 16, 263),
(184, 5, 264),
(185, 17, 265),
(186, 9,
266),
(187, 9, 267),
(188, 7, 268),
(189, 10, 269),
(190, 14,
27),
(191, 19, 270),
(192, 15, 271),
(193, 18, 272),
(194, 7,
273),
(195, 7, 274),
(196, 15, 275),
(197, 12, 276),
(198, 19,
277),
(199, 20, 278),
(200, 17, 279),
(201, 20, 28),
(202, 5,
280),
(203, 18, 281),
(204, 6, 282),
(205, 13, 283),
(206, 13,
284),
(207, 15, 285),
(208, 7, 286),
(209, 19, 287),
(210, 15,
288),
(211, 20, 289),
(212, 7, 29),
(213, 9, 290),
(214, 8,
291),
(215, 16, 292),
(216, 14, 293),
(217, 11, 294),
(218, 15,
295),
(219, 10, 296),
(220, 14, 297),
(221, 11, 298),
(222, 17,
299),
(223, 19, 3),
(224, 17, 30),
(225, 7, 300),
(226, 19,
301),
(227, 16, 302),
(228, 8, 303),
(229, 17, 304),
(230, 19,
305),
(231, 19, 306),
(232, 12, 307),
(233, 20, 308),
(234, 7,
309),
(235, 18, 31),
(236, 16, 310),
(237, 5, 311),
(238, 11,
312),
(239, 13, 313),
(240, 12, 32),
(241, 15, 33),
(242, 6,
34),
(243, 12, 35),
(244, 19, 36),
(245, 20, 37),
(246, 20, 38),
(247,
14, 39),
(248, 12, 4),
(249, 18, 43),
(250, 12, 46),
(251, 10,
47),
(252, 11, 48),
(253, 10, 49),
(254, 10, 5),
(255, 16, 50),
(256,
9, 51),
(257, 10, 52),
(258, 5, 53),
(259, 7, 54),
(260, 7, 55),
(261,
19, 56),
(262, 10, 57),
(263, 16, 58),
(264, 14, 59),
(265, 19,
6),
(266, 14, 60),
(267, 17, 61),
(268, 16, 62),
(269, 11, 63),
(270,
15, 64),
(271, 10, 65),
(272, 7, 66),
(273, 8, 67),
(274, 19,
68),
(275, 18, 69),
(276, 20, 7),
(277, 14, 70),
(278, 6, 71),
(279,
10, 72),
(280, 17, 73),
(281, 7, 74),
(282, 14, 75),
(283, 7,
76),
(284, 15, 77),
(285, 7, 78),
(286, 10, 79),
(287, 11, 8),
(288,
7, 80),
(289, 11, 81),
(290, 13, 82),
(291, 13, 83),
(292, 12,
84),
(293, 20, 85),
(294, 7, 86),
(295, 11, 87),
(296, 6, 88),
(297,
15, 89),
(298, 12, 9),
(299, 13, 90),
(300, 7, 91),
(301, 15,
92),
(302, 10, 93),
(303, 20, 94),
(304, 9, 95),
(305, 16, 96),
(306,
6, 97),
(307, 6, 98),
(308, 12, 99);
CREATE TABLE IF NOT EXISTS
`podarok` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(11) NOT
NULL,
`komu` int(11) NOT NULL,
`podarok` int(11) NOT NULL,
`podp`
varchar(100) NOT NULL,
`cost` varchar(50) NOT NULL,
`time`
varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `settings`
(
`keywords` varchar(500) NOT NULL,
`description` varchar(800) NOT
NULL,
`copy` varchar(220) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO `settings` (`keywords`, `description`, `copy`)
VALUES
('XCMS - Движок для вашего сайта', 'Если
вам нужен движок для сайта, то XCMS отлично
подойдет именно для вас!', 'Powered by
xcms-pro');
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`login` varchar(15) NOT NULL,
`solt` int(11) NOT
NULL,
`password` varchar(100) NOT NULL,
`lat_name` varchar(50) NOT
NULL,
`name` varchar(20) NOT NULL,
`pol` varchar(1) NOT NULL DEFAULT
'm',
`status` varchar(15) NOT NULL DEFAULT 'Новенький',
`time` int(11) NOT NULL,
`reg_time` int(11) NOT NULL,
`avatar`
int(11) NOT NULL,
`level` int(2) NOT NULL DEFAULT '0',
`balans`
int(11) NOT NULL DEFAULT '0',
`email` text NOT NULL,
`country` int(3)
NOT NULL DEFAULT '0',
`city` int(3) NOT NULL DEFAULT '0',
`number`
int(4) NOT NULL DEFAULT '0',
`region` varchar(30) NOT NULL,
`posts`
varchar(30) NOT NULL,
`ban` int(2) NOT NULL,
`statuse` varchar(50)
NOT NULL,
`rank` varchar(30) NOT NULL,
`navig` varchar(30) NOT
NULL,
`design` int(3) NOT NULL,
`postlast` int(15) NOT NULL,
`polec` varchar(30) NOT NULL,
`gorod_money` int(40) NOT NULL,
`zarplata` int(30) NOT NULL,
`zarplata_bila` int(30) NOT NULL,
`zarplata_next` int(30) NOT NULL,
`avto` int(2) NOT NULL,
`home`
int(2) NOT NULL,
`works` int(2) NOT NULL,
`zoo` int(2) NOT NULL,
`panel` int(1) NOT NULL,
`sdvig` varchar(10) NOT NULL,
`pokaz_pod`
int(2) NOT NULL,
`pokaz_pho` int(2) NOT NULL,
`pokaz_wal` int(2) NOT
NULL,
`pokaz_dei` int(2) NOT NULL,
`visit` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61
;
INSERT INTO `users` (`id`, `login`, `solt`, `password`, `lat_name`,
`name`, `pol`, `status`, `time`, `reg_time`, `avatar`, `level`, `balans`,
`email`, `country`, `city`, `number`, `region`, `posts`, `ban`, `statuse`,
`rank`, `navig`, `design`, `postlast`, `polec`, `gorod_money`, `zarplata`,
`zarplata_bila`, `zarplata_next`, `avto`, `home`, `works`, `zoo`, `panel`,
`sdvig`, `pokaz_pod`, `pokaz_pho`, `pokaz_wal`, `pokaz_dei`, `visit`)
VALUES
(1, 'admin', 65684807, '677e2558bb7f666e135db65f4c6b96ea', 'admin',
'Денис', 'm', 'Новенький', 1376913741, 1371208034, 1, 5,
3057, 'stiwe@yandex.ru', 1, 2, 9353, '66', '70', 0, 'Статус', '17',
'1', 8, 1376808590, '95.29.195.75', 72997400, 0, 0, 0, 84, 9, 0, 11, 1,
'0', 0, 0, 0, 1, 1),
(3, 'test', 39793977,
'098f6bcd4621d373cade4e832627b4f6', 'test', 'test', 'm',
'Новенький', 1376916260, 1371288160, 1, 0, 1222, '', 1, 1, 0, '9',
'19', 0, '0', '2', '1', 8, 1376487454, '80.239.243.174', 0, 0, 0, 0, 0, 0,
0, 0, 0, '0', 1, 0, 1, 0, 1),
(4, 'nunchaku', 17321756,
'cd0b016edf6ef1028eee68365386113c', 'nunchaku', 'nunchaku', 'm',
'Новенький', 1371325867, 1371325827, 1, 0, 0, '', 0, 0, 0, '', '',
0, '0', '0', '1', 1, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0,
0),
(2, 'Система', 95027557, '315eb115d98fcbad39ffc5edebd669c9',
'sistema', 'Система', 'd', 'Система', 1373636219, 2147483647,
1, 0, 0, 'system@pro-xcms.ru', 1, 2, 0, '66', '', 1, '0', '0', '1', 1, 0,
'0', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(16, 'redoor',
46731812, '0123cc21e27154996ea44d25d45519d6', 'redoor', 'nasir', 'm',
'Новенький', 1372461609, 1372460183, 1, 0, 100,
'djamaatn@mail.ru', 0, 1, 4143, '', '', 0, '', '1', '1', 1, 0, '', 0, 0, 0,
0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(17, 'Fantom', 78655139,
'b23d278ad3dbd4cb138a197e6b8bd8bf', 'fantom', 'fantom', 'm',
'Новенький', 1373125473, 1373125368, 1, 0, 100,
'dcms_soc@mail.ru', 0, 1, 5555, '', '', 0, '', '', '', 0, 0, '', 0, 0, 0,
0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(18, 'Мирор', 91851137,
'aab9ba42b5591219a5b20e34e0c83b78', 'miror', 'Biola4', 'm',
'Новенький', 1373130268, 1373130128, 1, 0, 226,
'Vexter13@ukr.net', 0, 2, 1111, '', '', 0, '', '', '1', 4, 0, '', 0, 0, 0,
0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(19, 'filegruz', 79900944,
'e10adc3949ba59abbe56e057f20f883e', 'filegruz', 'ibragim', 'm',
'Новенький', 1373132342, 1373130165, 1, 0, 100,
'shovhalov.tuz@yandex.ru', 1, 2, 6070, '73', '', 0, '', '', '1', 5, 0, '',
0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(20, 'jhjfgyu', 69326442,
'd17ef44610f0b11d0f09987c27a3e440', 'jhjfgyu', 'димка', 'm',
'Новенький', 1373140938, 1373140854, 1, 0, 100,
'yttttthftr@yandex.ru', 0, 2, 4532, '', '', 0, '', '', '1', 1, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(21, 'папа', 79257331,
'e10adc3949ba59abbe56e057f20f883e', 'papa', 'Андрей', 'm',
'Новенький', 1373147102, 1373146764, 1, 0, 101,
'dark_86@spaces.ru', 0, 1, 373, '', '1', 0, '', '0', '1', 5, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(22, 'Lopik', 43235115,
'6c90e5171bfdc3c62ce8925898e0db2d', 'lopik', 'Lopik', 'm',
'Новенький', 1373156730, 1373156378, 1, 0, 231,
'sevrikkk@yandex.ru', 0, 2, 9013, '', '', 0, '', '', '1', 8, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(23, 'бар-сук', 92248178,
'36bada010e55ad637201fd7a91d5ed7f', 'bar-suk', 'Олег', 'm',
'Новенький', 1373158989, 1373157346, 1, 0, 100,
'shuli555@spaces.ru', 0, 2, 6916, '', '', 0, '', '', '1', 7, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(24, 'zerg', 33681107,
'96e79218965eb72c92a549dd5a330112', 'zerg', 'zerg', 'm',
'Новенький', 1373181225, 1373181027, 1, 0, 86,
'botva58@gmail.com', 0, 2, 3383, '', '1', 0, '', '', '1', 1, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(25, 'PYRITANEC', 83139149,
'a913df5191b203afa9e9d5c05bbda75a', 'pyritanec', 'евген', 'm',
'Новенький', 1373195591, 1373193292, 1, 0, 100, 'a@mail.ru', 0, 1,
0, '', '', 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0,
0, 0, 0),
(26, 'Test', 1838318, 'a66d92cacbcb69c63a629611a1558195',
'test', 'Test', 'm', 'Новенький', 1373642380, 1373195037, 1, 0,
100, 'optimyc@bigmir.net', 0, 2, 4587, '', '', 0, '', '1', '1', 8, 0,
'176.98.73.61', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(27,
'vvvvv', 71129916, '4693fbb215b8ca15a6900f0cfa164cdc', 'vvvvv', 'vvvvvv',
'm', 'Новенький', 1373643016, 1373463808, 1, 0, 100,
'manyak@mail.ru', 0, 2, 8888, '', '', 0, '', '', '1', 2, 0,
'213.87.121.77', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(28,
'Sndm', 56234675, 'e10adc3949ba59abbe56e057f20f883e', 'sndm',
'Сэндман', 'm', 'Новенький', 1373464273, 1373464161, 1, 0,
100, 'Admin@spaces.ru', 0, 1, 3313, '', '', 0, '', '', '1', 2, 0, '', 0, 0,
0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(29, 'Favorit', 8812857,
'48d082c318579c12b24b27b3ae0f3986', 'favorit', 'Favorit', 'm',
'Новенький', 1373652202, 1373464307, 0, 0, 100, 'Favorit@bk.ru',
0, 0, 0, '', '', 0, '', '', '', 0, 0, '94.248.38.4', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(30, 'CoolBoy', 36336499,
'291a9dcb5039ea6544972906e8aeadbd', 'coolboy', 'danua01010', 'm',
'Новенький', 1373479585, 1373479569, 0, 0, 100,
'danuas@yandex.ru', 0, 0, 741, '', '', 0, '', '', '', 0, 0, '', 0, 0, 0, 0,
0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(31, 'islamsoft', 49506429,
'25c6c9dd80f1ad1c93adb24d7dee53d9', 'islamsoft', 'adgjmpt', 'm',
'Новенький', 1373651072, 1373493411, 0, 0, 100, 'mgmgm@ma.ru', 0,
0, 0, '', '', 0, '', '', '', 0, 0, '80.239.242.157', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(32, 'Cany', 42304952,
'e10adc3949ba59abbe56e057f20f883e', 'cany', 'Alex', 'm',
'Новенький', 1373638319, 1373638212, 1, 0, 100,
'cany-2011@mail.ru', 0, 2, 4055, '', '', 0, '', '', '', 0, 0, '', 0, 0, 0,
0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(33, 'говорит', 72644031,
'e10adc3949ba59abbe56e057f20f883e', 'govorit', 'гая', 'm',
'Новенький', 1373638911, 1373638873, 0, 0, 100, '', 0, 0, 222, '',
'', 0, '', '', '', 0, 0, '217.212.231.137', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0',
0, 0, 0, 0, 0),
(35, 'xaxaxa', 38383342,
'23153109a65ffefa280874c9428cef03', 'xaxaxa', 'xaxaxax', 'm',
'Новенький', 1373641977, 1373641860, 1, 0, 100, 'sss@sss.ru', 0,
2, 9548, '', '', 0, '', '', '', 0, 0, '95.153.180.3', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(34, 'pers', 50273155,
'93279e3308bdbbeed946fc965017f67a', 'pers', '11111111', 'm',
'Новенький', 1373641521, 1373641261, 1, 0, 100, 'brin83@mail.ru',
0, 0, 5555, '', '', 0, '', '', '', 0, 0, '94.20.214.133', 0, 0, 0, 0, 0, 0,
0, 0, 0, '0', 0, 0, 0, 0, 0),
(43, 'HasBeen', 55629619,
'93279e3308bdbbeed946fc965017f67a', 'hasbeen', ')', 'm',
'Новенький', 1373648449, 1373647815, 1, 0, 100, 'tratata@bk.ua',
0, 2, 800, '', '', 0, '', '', '1', 7, 0, '46.247.132.70', 0, 0, 0, 0, 0, 0,
0, 0, 0, '0', 0, 0, 0, 0, 0),
(36, 'NTL', 20106264,
'e10adc3949ba59abbe56e057f20f883e', 'ntl', 'Александр', 'm',
'Новенький', 1373643594, 1373642455, 1, 0, 100, 'ntl2000@list.ru',
0, 2, 8345, '', '', 0, '', '', '1', 3, 0, '83.149.48.24', 0, 0, 0, 0, 0, 0,
0, 0, 0, '0', 0, 0, 0, 0, 0),
(37, 'vidj', 90941721,
'b4b74726c9acad1cb9184882d1b16353', 'vidj', 'Игорь', 'm',
'Новенький', 1376819651, 1373642459, 1, 0, 100, 'tjukm@mail.ru',
0, 1, 5555, '', '', 0, '', '', '', 0, 0, '80.239.243.55', 0, 0, 0, 0, 0, 0,
0, 0, 0, '0', 0, 0, 0, 0, 1),
(38, 'romka', 8756988,
'e10adc3949ba59abbe56e057f20f883e', 'romka', 'roma', 'm',
'Новенький', 1373886396, 1373642540, 1, 0, 100, '', 0, 1, 4526,
'', '', 0, '', '', '1', 7, 0, '82.145.209.178', 0, 0, 0, 0, 0, 0, 0, 0, 0,
'0', 0, 0, 0, 0, 0),
(39, 'Tatata', 5819041,
'eef199057c8e093c6b23605a82264882', 'tatata', 'Tatata', 'm',
'Новенький', 1373650892, 1373642922, 1, 0, 100, 'ata@bk.ru', 0, 1,
4355, '', '', 0, '', '', '', 0, 0, '82.145.208.133', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(40, 'Masteram', 44905564,
'b25ddc07d23346741ef9ccbb7e2cf5e2', 'masteram', 'Masteram', 'm',
'Новенький', 1373650988, 1373643141, 1, 0, 102, 'Masteram@re.us',
0, 2, 0, '', '2', 0, '', '', '', 0, 1373643293, '46.201.80.104', 0, 0, 0,
0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(41, 'VIPuser', 86832462,
'96e79218965eb72c92a549dd5a330112', 'vipuser', 'VIPuser', 'm',
'Новенький', 1373643904, 1373643874, 0, 0, 100, 'xaxaxa@zz.mu', 0,
0, 2901, '', '', 0, '', '', '', 0, 0, '83.149.8.183', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(42, 'tegoz', 13174011,
'a19450c0f3139ced1c4a4172a152839e', 'tegoz', 'серёга', 'm',
'Новенький', 1373646321, 1373645393, 1, 0, 100,
'serjga2@spaces.ru', 0, 2, 9195, '', '', 0, '', '', '', 0, 0,
'85.115.243.107', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(47,
'abac', 42053996, 'e10adc3949ba59abbe56e057f20f883e', 'abac', 'хахах',
'm', 'Новенький', 1373654224, 1373653024, 1, 0, 213,
'Abac250@spaces.ru', 0, 2, 5766, '', '', 0, '', '', '', 1, 0,
'213.87.131.4', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(46,
'blablabla', 71318332, '8ce87b8ec346ff4c80635f667d1592ae', 'blablabla',
'))))', 'm', 'Новенький', 1373649577, 1373648572, 1, 0, 100,
'fsdfsdf@fdgd.dfgd', 0, 2, 4534, '', '', 0, '', '', '1', 7, 0,
'46.247.132.70', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(48,
'Bow', 25889598, '0f6a3e5669c93193e3d0af2479f888a2', 'bow', 'ktif', 'm',
'Новенький', 1373847500, 1373654044, 1, 0, 100,
'henkok_93@ukr.net', 0, 2, 5168, '', '', 0, '', '', '', 1, 0,
'46.202.136.179', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(49,
'PYRITANEC', 82974761, 'a913df5191b203afa9e9d5c05bbda75a', 'pyritanec',
'alti', 'm', 'Новенький', 1373928483, 1373928378, 1, 0, 100,
'a@li.ru', 0, 1, 0, '', '', 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0,
0, 0, '0', 0, 0, 0, 0, 0),
(57, 'Cool_Nick', 0,
'81ccae67b6f6bdb51ccbce11f555779e', '', '', 'm', 'Новенький',
1376452454, 1376450856, 1, 0, 35, 'talamu05', 0, 2, 0, '', '', 0, '', '',
'', 1, 0, '', 20000, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0),
(58,
'Raptor', 0, '6c90e5171bfdc3c62ce8925898e0db2d', '', '', 'm',
'Новенький', 1376783108, 1376783046, 1, 0, 50,
'sevrikkk@yandex.ru', 0, 2, 0, '', '', 0, '', '', '', 1, 0, '', 20000, 0,
0, 0, 0, 0, 0, 0, 0, '', 1, 1, 1, 0, 0),
(59, 'qwerty', 0,
'e10adc3949ba59abbe56e057f20f883e', '', '', 'm', 'Новенький',
1376826678, 1376826408, 1, 0, 52, 'qwerty@fgfg.rdfg', 0, 2, 0, '', '2', 0,
'', '', '', 1, 0, '', 20000, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 1,
1),
(60, 'pov', 0, 'cbce9b6c4b77a9ddf603cfd07a8cb7b6', '', '', 'm',
'Новенький', 1376904996, 1376892783, 1, 0, 50,
'serpov12011992@yandex.ru', 0, 1, 0, '', '', 0, '', '', '', 1, 0, '',
20000, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 1, 1, 1);