Lk0bsG9Y

1CREATE TABLE IF NOT EXISTS `banners` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `img` text NOT NULL,
4  `url` text NOT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
7
8CREATE TABLE IF NOT EXISTS `files` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `title` longtext CHARACTER SET utf8 NOT NULL,
11  `url` longtext CHARACTER SET utf8 NOT NULL,
12  `size` longtext CHARACTER SET utf8 NOT NULL,
13  `date` varchar(255) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
16
17CREATE TABLE IF NOT EXISTS `ips` (
18  `id_vapros` int(12) NOT NULL,
19  `ip` varchar(30) NOT NULL,
20  `timestamp` int(15) NOT NULL
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23CREATE TABLE IF NOT EXISTS `lgsl` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
26  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
27  `c_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
28  `q_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
29  `s_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
30  `zone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
31  `disabled` tinyint(1) NOT NULL DEFAULT '0',
32  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
33  `status` tinyint(1) NOT NULL DEFAULT '0',
34  `cache` text COLLATE utf8_unicode_ci NOT NULL,
35  `cache_time` text COLLATE utf8_unicode_ci NOT NULL,
36  PRIMARY KEY (`id`)
37) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
38
39CREATE TABLE IF NOT EXISTS `news` (
40  `id` int(11) NOT NULL AUTO_INCREMENT,
41  `title` longtext CHARACTER SET utf8 NOT NULL,
42  `new` longtext CHARACTER SET utf8 NOT NULL,
43  `author` longtext CHARACTER SET utf8 NOT NULL,
44  `date` varchar(255) NOT NULL,
45  PRIMARY KEY (`id`)
46) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
47
48CREATE TABLE IF NOT EXISTS `otgovori` (
49  `id` int(12) NOT NULL AUTO_INCREMENT,
50  `id_vapros` int(12) NOT NULL,
51  `otgovor` varchar(255) CHARACTER SET utf8 NOT NULL,
52  `broi` int(5) NOT NULL DEFAULT '0',
53  PRIMARY KEY (`id`)
54) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
55
56--
57-- Схема на данните от таблица `otgovori`
58--
59
60INSERT INTO `otgovori` (`id`, `id_vapros`, `otgovor`, `broi`) VALUES
61(5, 3, 'Да', 3),
62(6, 3, 'Не', 1);
63
64CREATE TABLE IF NOT EXISTS `sitebanners` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `img` longtext CHARACTER SET utf8 NOT NULL,
67  `url` longtext CHARACTER SET utf8 NOT NULL,
68  `size` longtext CHARACTER SET utf8 NOT NULL,
69  `author` longtext CHARACTER SET utf8 NOT NULL,
70  PRIMARY KEY (`id`)
71) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
72
73CREATE TABLE IF NOT EXISTS `team` (
74  `id` int(11) NOT NULL AUTO_INCREMENT,
75  `name` longtext CHARACTER SET utf8 NOT NULL,
76  `post` longtext CHARACTER SET utf8 NOT NULL,
77  `skype` longtext CHARACTER SET utf8 NOT NULL,
78  `nick` longtext CHARACTER SET utf8 NOT NULL,
79  `date` longtext CHARACTER SET utf8 NOT NULL,
80  `img` longtext CHARACTER SET utf8 NOT NULL,
81  `city` longtext CHARACTER SET utf8 NOT NULL,
82  PRIMARY KEY (`id`)
83) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
84
85CREATE TABLE IF NOT EXISTS `vaprosi` (
86  `id` int(12) NOT NULL AUTO_INCREMENT,
87  `vapros` varchar(255) CHARACTER SET utf8 NOT NULL,
88  `br_otgovori` int(5) NOT NULL DEFAULT '0',
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;