tPQSmXf7

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
56CREATE TABLE IF NOT EXISTS `sitebanners` (
57  `id` int(11) NOT NULL AUTO_INCREMENT,
58  `img` longtext CHARACTER SET utf8 NOT NULL,
59  `url` longtext CHARACTER SET utf8 NOT NULL,
60  `size` longtext CHARACTER SET utf8 NOT NULL,
61  `author` longtext CHARACTER SET utf8 NOT NULL,
62  PRIMARY KEY (`id`)
63) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
64
65CREATE TABLE IF NOT EXISTS `team` (
66  `id` int(11) NOT NULL AUTO_INCREMENT,
67  `name` longtext CHARACTER SET utf8 NOT NULL,
68  `post` longtext CHARACTER SET utf8 NOT NULL,
69  `skype` longtext CHARACTER SET utf8 NOT NULL,
70  `nick` longtext CHARACTER SET utf8 NOT NULL,
71  `date` longtext CHARACTER SET utf8 NOT NULL,
72  `img` longtext CHARACTER SET utf8 NOT NULL,
73  `city` longtext CHARACTER SET utf8 NOT NULL,
74  PRIMARY KEY (`id`)
75) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
76
77CREATE TABLE IF NOT EXISTS `vaprosi` (
78  `id` int(12) NOT NULL AUTO_INCREMENT,
79  `vapros` varchar(255) CHARACTER SET utf8 NOT NULL,
80  `br_otgovori` int(5) NOT NULL DEFAULT '0',
81  PRIMARY KEY (`id`)
82) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;