Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `banners` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `img` text NOT NULL,
- `url` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
- CREATE TABLE IF NOT EXISTS `files` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` longtext CHARACTER SET utf8 NOT NULL,
- `url` longtext CHARACTER SET utf8 NOT NULL,
- `size` longtext CHARACTER SET utf8 NOT NULL,
- `date` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
- CREATE TABLE IF NOT EXISTS `ips` (
- `id_vapros` int(12) NOT NULL,
- `ip` varchar(30) NOT NULL,
- `timestamp` int(15) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE IF NOT EXISTS `lgsl` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `c_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
- `q_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
- `s_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
- `zone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `disabled` tinyint(1) NOT NULL DEFAULT '0',
- `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `status` tinyint(1) NOT NULL DEFAULT '0',
- `cache` text COLLATE utf8_unicode_ci NOT NULL,
- `cache_time` text COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
- CREATE TABLE IF NOT EXISTS `news` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` longtext CHARACTER SET utf8 NOT NULL,
- `new` longtext CHARACTER SET utf8 NOT NULL,
- `author` longtext CHARACTER SET utf8 NOT NULL,
- `date` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
- CREATE TABLE IF NOT EXISTS `otgovori` (
- `id` int(12) NOT NULL AUTO_INCREMENT,
- `id_vapros` int(12) NOT NULL,
- `otgovor` varchar(255) CHARACTER SET utf8 NOT NULL,
- `broi` int(5) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
- --
- -- Схема на данните от таблица `otgovori`
- --
- INSERT INTO `otgovori` (`id`, `id_vapros`, `otgovor`, `broi`) VALUES
- (5, 3, 'Да', 3),
- (6, 3, 'Не', 1);
- CREATE TABLE IF NOT EXISTS `sitebanners` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `img` longtext CHARACTER SET utf8 NOT NULL,
- `url` longtext CHARACTER SET utf8 NOT NULL,
- `size` longtext CHARACTER SET utf8 NOT NULL,
- `author` longtext CHARACTER SET utf8 NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
- CREATE TABLE IF NOT EXISTS `team` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` longtext CHARACTER SET utf8 NOT NULL,
- `post` longtext CHARACTER SET utf8 NOT NULL,
- `skype` longtext CHARACTER SET utf8 NOT NULL,
- `nick` longtext CHARACTER SET utf8 NOT NULL,
- `date` longtext CHARACTER SET utf8 NOT NULL,
- `img` longtext CHARACTER SET utf8 NOT NULL,
- `city` longtext CHARACTER SET utf8 NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
- CREATE TABLE IF NOT EXISTS `vaprosi` (
- `id` int(12) NOT NULL AUTO_INCREMENT,
- `vapros` varchar(255) CHARACTER SET utf8 NOT NULL,
- `br_otgovori` int(5) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement