# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Хост: localhost
# Время создания: Янв 25 2009 г., 19:26
# Версия сервера: 5.0.24
# Версия PHP: 5.1.6
#
# БД : `picbattles`
#
# --------------------------------------------------------
#
# Структура таблицы `picbattles_comments`
#
DROP TABLE IF EXISTS `picbattles_comments`;
CREATE TABLE `picbattles_comments` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`parent_id` bigint(20) unsigned NOT NULL default '0',
`user_id` bigint(20) unsigned NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`timing` bigint(20) unsigned NOT NULL default '0',
`target` varchar(50) default NULL,
`target_id` bigint(20) unsigned NOT NULL default '0',
`target_title` varchar(255) NOT NULL,
`target_uri` varchar(255) NOT NULL,
`validated` tinyint(4) NOT NULL default '0',
`rating` bigint(20) default '0',
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
#
# Дамп данных таблицы `picbattles_comments`
#
INSERT INTO `picbattles_comments` VALUES (1, 0, 1, '127.0.0.1', 1214277291, 'Pictures', 1, 'Star Wars Fertilizer', '/_pics/Pictures/1/Star%26%23032%3BWars%26%23032%3BFertilizer/?hold=auto', 1, 0, '', 'First comment goes here!');
# --------------------------------------------------------
#
# Структура таблицы `picbattles_context`
#
DROP TABLE IF EXISTS `picbattles_context`;
CREATE TABLE `picbattles_context` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`parent_id` bigint(20) unsigned NOT NULL default '0',
`user_id` bigint(20) unsigned NOT NULL default '0',
`added` bigint(20) unsigned NOT NULL default '0',
`type` varchar(50) NOT NULL default '',
`context` text NOT NULL,
`title` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`language` varchar(50) NOT NULL default '',
`priority` bigint(20) NOT NULL default '0',
`deleted` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=139 ;
#
# Дамп данных таблицы `picbattles_context`
#
INSERT INTO `picbattles_context` VALUES (12, 0, 1, 1167109211, 'navigation', '', 'ADMIN_NAV', 'Support||http://plusphp.com/?module=ContactUs\r\nUsers||#BASE_URI#?module=Profiles\r\nConfiguration||#BASE_URI#?module=SiteConfig\r\nLanguage||#BASE_URI#?module=Language\r\nBlocks||#BASE_URI#?module=Context\r\nRoles||#BASE_URI#?module=Roles', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (13, 0, 1, 1168586548, 'textblock', '', 'COORDS', ' © 2007-2008, plus.php Web Development:\r\nabout us,\r\nfree software & tools for webmasters,\r\ninternet marketing services,\r\ncontact us.', '', 0, 1209683075);
INSERT INTO `picbattles_context` VALUES (21, 0, 1, 1185096408, 'codeblock', '', 'SITE_META', 'Photo Rating', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (22, 0, 1, 1185096434, 'codeblock', '', 'SITE_KEYWORDS', 'photos, galleries, photo rating', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (24, 0, 1, 1185097119, 'codeblock', '', 'CONTACT_EMAIL', 'contact@email.com', '', 0, 1203953236);
INSERT INTO `picbattles_context` VALUES (33, 0, 1, 1195026085, 'codeblock', '', 'SITE_NAME', 'Photo Battles', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (35, 0, 1, 1203953283, 'codeblock', '', 'COUNTERS', '<h3>About Us</h3>\r\n<p>В«Daily PhotosВ» is a free media host service. All <a href="/Pictures/">photos</a> & texts on the site <a href="/?module=Pictures&file=Add">uploaded</a> by <a href="/People/">users</a> and owned by their copyrights holders. If you see any picture which you think has to be removed - <a href="/ContactUs/">contact us</a>.</p>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (42, 0, 0, 0, 'codeblock', '', 'BANNED_IP', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (43, 0, 1, 1208891642, 'codeblock', '', 'ADMIN_EMAIL', 'here@admin.com', '', 0, 1211162613);
INSERT INTO `picbattles_context` VALUES (45, 0, 0, 0, 'codeblock', '', 'DISALLOWED_EMAILS', 'mailinator.com\r\nmail.ru', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (46, 0, 0, 0, 'codeblock', '', 'COORDS', '<h3>Services</h3>\r\n<ul>\r\n<li><a href="/_PHOTOBattles/?module=Pictures&file=Add">Upload</a> : <a href="/_PHOTOBattles/People/Edit/">Public</a> : <a href="/_PHOTOBattles/Profiles/Edit/">Profile</a> <a href="/_PHOTOBattles/?module=Authorization&file=logout"><img src="/_PHOTOBattles/templates/photobattles/icons/login.png" border="0" title="Logout or Login" alt="Logout or Login" align="absmiddle" border="0" /></a></li>\r\n<li><a href="/_PHOTOBattles/rss/"><img src="/_PHOTOBattles/templates/photobattles/rss.png" border="0" title="RSS Feed" alt="RSS Feed" align="absmiddle" border="0" /> Subscribe : Daily Pictures</a></li>\r\n<li><a href="/_PHOTOBattles/Pages/23/Terms-of-Service/">Terms of Service</a></li>\r\n<li><a href="/_PHOTOBattles/Pages/25/Privacy-Policy/">Privacy Policy</a></li>\r\n<li><a href="/_PHOTOBattles/ContactUs/">Feedback / Contact</a></li>\r\n</ul>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (47, 0, 0, 0, 'config', '_PlusPHP_Registration', 'registrationAllowed', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (48, 0, 0, 0, 'config', '_PlusPHP_Registration', 'confirmationNeeded', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (49, 0, 0, 0, 'config', '_PlusPHP_Registration', 'confirmationForced', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (50, 0, 0, 0, 'config', '_PlusPHP_Registration', 'captchaRegistration', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (51, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'email', 'email@here.com', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (52, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'start_module', 'PhotoBattles', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (53, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'template', 'photobattles-v', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (54, 0, 0, 0, 'config', 'Profiles', 'profilesPerPage', '10', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (55, 0, 0, 0, 'config', 'ShortURL', 'linksPerPage', '10', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (56, 0, 0, 0, 'config', 'ShortURL', 'redirectType', 'instant', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (57, 0, 0, 0, 'config', 'ShortURL', 'redirectDelay', '15', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (58, 0, 0, 0, 'config', 'ShortURL', 'urlsDisallowed', 'hormail.com', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (59, 0, 0, 0, 'usergroup', '', 'Visitors', 'Comments|all|unlimit|none|none\nLists|none|none|none|none\nMessages|none|none|none|none\nPages|all|none|none|none\nPeople|all|none|none|none\nPhotoBattles|all|none|none|none\nPictures|all|unlimit|none|none\nProfiles|none|none|none|none\nRoles|none|none|none|none\n', '', 1, 0);
INSERT INTO `picbattles_context` VALUES (60, 0, 0, 0, 'usergroup', '', 'Registered Users', 'Comments|all|unlimit|own|none\nLists|none|none|none|none\nMessages|none|none|none|none\nPages|all|none|none|none\nPeople|all|none|own|none\nPhotoBattles|all|none|none|none\nPictures|all|unlimit|own|none\nProfiles|own|none|own|none\nRoles|none|none|none|none\n', '', 1, 0);
INSERT INTO `picbattles_context` VALUES (61, 0, 0, 0, 'usergroup', '', 'Paid Users', '', '', 1, 0);
INSERT INTO `picbattles_context` VALUES (62, 0, 0, 0, 'config', 'ShortURL', 'redirectMode', 'rewrite', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (63, 0, 0, 0, 'config', 'ShortURL', 'lowerFrameHeight', '0', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (64, 0, 0, 0, 'codeblock', '', 'REDIRECT_ADS_TOP', '<!-- redirect ads code - top //-->', '', 0, 1214302968);
INSERT INTO `picbattles_context` VALUES (65, 0, 0, 0, 'codeblock', '', 'REDIRECT_ADS_BOTTOM', '<!-- redirect ads code - bottom //-->', '', 0, 1214302948);
INSERT INTO `picbattles_context` VALUES (66, 0, 0, 0, 'codeblock', '', 'FRAME_ADS_TOP', '<!-- frame ads code - top //-->', '', 0, 1214302973);
INSERT INTO `picbattles_context` VALUES (67, 0, 0, 0, 'codeblock', '', 'FRAME_ADS_BOTTOM', '<!-- frame ads code - bottom //-->', '', 0, 1214302943);
INSERT INTO `picbattles_context` VALUES (69, 0, 0, 0, 'config', 'Profiles', 'oldProfilesAge', '180', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (70, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'pagination', '5', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (71, 0, 1, 1210762122, 'codeblock', 'Profiles\r\nSiteConfig', 'TIMEZONES', '-11||Samoa, Midway\r\n-10||Hawaii, French Polynesia, Cook island\r\n-9||Alaska\r\n-8||US Pacific\r\n-7||US Mountain\r\n-6||US Central\r\n-5||US Eastern\r\n-4||New Foundland, Venezuela, Chile\r\n-3||Brazil, Argentina, Greenland\r\n-2||Mid-Atlantic\r\n-1||Azores, Cape Verda Is.\r\n0||GMT - England, Ireland, Portugal\r\n+1||France, Spain, Germany, Poland, Italy\r\n+2||Turkey, Greece, Finland, Ukraine\r\n+3||Russia, Saudi Arabia, UAE\r\n+4||Oman, Georgia\r\n+5||Pakistan\r\n+5:30||India\r\n+6||India\r\n+6:30||India\r\n+7||Indonesia, Thailand, Vietnam\r\n+8||China, Phillipines, Malaysia, West Australia\r\n+9||Japan\r\n+10||East Australia\r\n+11||Solomon islands, Micronesia\r\n+12||Marshall Islands, Fiji', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (72, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'timezone', '0', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (73, 0, 0, 0, 'config', 'ShortURL', 'hitsPerPage', '10', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (74, 0, 0, 0, 'codeblock', '', 'SHORT_ADS_TOP', '<!-- stats pages ads code //-->', '', 0, 1214302963);
INSERT INTO `picbattles_context` VALUES (75, 0, 0, 0, 'codeblock', '', 'SHORT_ADS_BOTTOM', '<!-- stats pages ads code //-->', '', 0, 1214302958);
INSERT INTO `picbattles_context` VALUES (76, 0, 0, 0, 'config', 'ShortURL', 'outerIPinfo', 'http://www.ip2location.com/', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (77, 0, 0, 0, 'config', 'ShortURL', 'subHosts', 'co com net spb smk kiev org blogspot google multiply', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (78, 0, 0, 0, 'config', '_PlusPHP_SiteConfig', 'dateFormat', '%B %d, %Y', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (79, 0, 0, 0, 'config', 'Pictures', 'imageSize', '450', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (80, 0, 0, 0, 'config', 'Pictures', 'thumbSize', '160', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (81, 0, 0, 0, 'config', 'Pictures', 'watermarkText', 'Better Image Host', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (82, 0, 0, 0, 'config', 'Pictures', 'watermarkPosition', 'bottom-right', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (83, 0, 0, 0, 'config', 'Pictures', 'watermarkMode', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (84, 0, 0, 0, 'config', 'Pictures', 'imagesPerPage', '12', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (85, 0, 0, 0, 'config', 'Pictures', 'downvotedImage', '5', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (86, 0, 0, 0, 'config', 'Pictures', 'popularImage', '5', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (87, 0, 0, 0, 'config', 'Pictures', 'galleryMode', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (88, 0, 0, 0, 'config', 'Pictures', 'relatedImages', '6', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (89, 0, 0, 0, 'config', 'Pictures', 'defaultPictureTitle', 'My Photo', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (90, 0, 0, 0, 'config', 'Pictures', 'photoStartMode', 'new', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (113, 0, 1, 1213082983, 'codeblock', 'Pictures', 'ADD_PIC_RULES', '<p>1) To upload pictures you may <a href="#BASE_URI#?module=Registration">register</a> or <a href="#BASE_URI#?module=Authorization">login</a> - to edit them later.</p>\r\n<p>2) Don't forget to give a credit to photographerВ if possible (name or link to site).</p>\r\n<p>3) If you fill in "Your nick" field of the form your pictures will be available @ <a href="http://#THIS_HOST##BASE_URI#YOUR_NICKNAME/">http://#THIS_HOST##BASE_URI#YOUR_NICKNAME/</a> (your blog's address) - so carefully choose your nickname (letters, numbers and -_ symbols are allowed). If you care about your nickname on this site - <a href="#BASE_URI#?module=Registration">register</a>.</p>\r\n<p>4) If you are using nickname which is registered and protected with password (for example, Nick) - please <a href="#BASE_URI#?module=Authorization">sign in</a>: overwise system will automatically count you as a new user and assign new nickname like Nick1, Nick2, Nick3 and so on.</p>\r\n<p>5) Your nickname can be registered by someone else until youВ <a href="#BASE_URI#?module=Profiles&file=Edit">assign password</a> to it - even if you uploaded few pictures or submitted few comments.</p>\r\n<p>6) By using this site you are agree to <a href="#BASE_URI#?module=Pages&id=25">Privacy Policy</a> and <a href="#BASE_URI#?module=Pages&id=23">Terms of Service</a>.</p>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (114, 0, 1, 1213813601, 'codeblock', '', 'COMMENTS_BLOCK', '<h3><a name="submitForm"></a><a href="#BASE_URI#Comments/">Comments</a> on pictures:</h3>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (115, 0, 0, 0, 'config', 'Comments', 'commentsPerPage', '10', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (116, 0, 0, 0, 'config', 'Comments', 'commentsInModules', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (117, 0, 0, 0, 'config', 'Comments', 'disableCommentsInterface', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (118, 0, 0, 0, 'config', 'Comments', 'disableCommentsCaptcha', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (119, 0, 0, 0, 'config', 'Comments', 'disableCommentsUnregistered', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (120, 0, 0, 0, 'config', '_PlusPHP_Registration', 'logoutAll', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (121, 0, 1, 0, 'config', 'Pictures', 'watermarkImage', 'png', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (122, 0, 1, 0, 'config', 'People', 'peoplePerPage', '10', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (123, 0, 1, 0, 'config', '_PlusPHP_vote', 'downvotedItem', '3', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (124, 0, 1, 0, 'config', '_PlusPHP_vote', 'popularItem', '3', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (125, 0, 1, 0, 'config', '_PlusPHP_vote', 'karmaControl', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (126, 0, 1, 0, 'config', 'Pictures', 'imageCats', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (127, 0, 1, 1216864621, 'codeblock', 'People\r\nSiteConfig', 'PEOPLE_SOCIAL', 'Digg|http://digg.com/#profile#/|Digg_24.png\r\nMySpace|http://#profile#.myspace.com/|MySpace_24.png\r\nStumbleUpon|http://#profile#.stumbleupon.com/|Stumbleupon_24.png\r\nReddit|http://#profile#.reddit.com/|Reddit_24.png\r\nTwitter|http://twitter.com/#profile#/|Twitter_24.png\r\nYouTube|http://youtube.com/user/#profile#|Youtube_24.png\r\nFlickr|http://www.flickr.com/people/#profile#/|Flickr_24.png\r\nDelicious|http://del.icio.us/#profile#|Delicious_24.png\r\nTechnorati|http://www.technorati.com/people/technorati/#profile#|Technorati_24.png', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (128, 0, 1, 1217594481, 'navigation', '', 'TOP_NAV', '', '', 0, 1217594532);
INSERT INTO `picbattles_context` VALUES (129, 0, 1, 1226841307, 'codeblock', '', 'ADS_HEADER', '<a href="http://plusphp.com/Pages/64/Photo-Battles-Rating-Script/"><img src="#BASE_URI#templates/photobattles-v/ads-header.gif" border="0" /></a>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (130, 0, 1, 1226841461, 'codeblock', '', 'ADS_TITLE', '<a href="http://plusphp.com/Pages/64/Photo-Battles-Rating-Script/"><img src="#BASE_URI#templates/photobattles-v/ads-horizontal.gif" border="0" /></a>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (131, 0, 1, 1226841509, 'codeblock', '', 'ADS_BOTTOM', '<br /><br />\r\n<a href="http://plusphp.com/Pages/64/Photo-Battles-Rating-Script/"><img src="#BASE_URI#templates/photobattles-v/ads-title.gif" border="0" /></a>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (132, 0, 1, 1226843080, 'codeblock', '', 'ADS_CENTER', '<a href="http://plusphp.com/Pages/64/Photo-Battles-Rating-Script/"><img src="#BASE_URI#templates/photobattles-v/ads-top.gif" border="0" /></a>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (133, 0, 1, 1226846803, 'codeblock', '', 'ADS_400', '<a href="http://plusphp.com/Pages/64/Photo-Battles-Rating-Script/"><img src="#BASE_URI#templates/photobattles-v/ads-400.gif" border="0" /></a>', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (134, 0, 1, 0, 'config', 'PhotoBattles', 'minimumBattleRatio', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (135, 0, 1, 0, 'config', 'PhotoBattles', 'minimumBattles', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (136, 0, 1, 0, 'config', 'PhotoBattles', 'imageBattleTimeout', '1', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (137, 0, 1, 0, 'config', 'Comments', 'stopWords', '', '', 0, 0);
INSERT INTO `picbattles_context` VALUES (138, 0, 1, 0, 'config', '_PlusPHP_SiteConfig', 'licenseKeys', '', '', 0, 0);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_lists`
#
DROP TABLE IF EXISTS `picbattles_lists`;
CREATE TABLE `picbattles_lists` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`parent_id` bigint(20) NOT NULL default '0',
`title` text,
`description` text,
`language` varchar(20) default NULL,
`priority` bigint(20) unsigned default NULL,
`deleted` tinyint(4) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=644 ;
#
# Дамп данных таблицы `picbattles_lists`
#
INSERT INTO `picbattles_lists` VALUES (1, 1, 0, 'Countries', 'countries description', '', 1, 0);
INSERT INTO `picbattles_lists` VALUES (3, 1, 105, 'England', '', '', 61, 0);
INSERT INTO `picbattles_lists` VALUES (5, 1, 3, 'London district', '', '', 63, 0);
INSERT INTO `picbattles_lists` VALUES (14, 1, 105, 'Germany', 'суперские центры', '', 71, 0);
INSERT INTO `picbattles_lists` VALUES (15, 1, 3, 'Scotland', '', '', 66, 0);
INSERT INTO `picbattles_lists` VALUES (165, 1, 69, 'StLouis', '', '', 23, 0);
INSERT INTO `picbattles_lists` VALUES (22, 1, 3, 'Welsh', '', '', 64, 0);
INSERT INTO `picbattles_lists` VALUES (68, 1, 64, 'Columbia, District', '', '', 12, 0);
INSERT INTO `picbattles_lists` VALUES (67, 1, 64, 'California', '', '', 8, 0);
INSERT INTO `picbattles_lists` VALUES (123, 1, 105, 'Italia', '', '', 69, 0);
INSERT INTO `picbattles_lists` VALUES (66, 1, 64, 'Arkanzas', '', '', 7, 0);
INSERT INTO `picbattles_lists` VALUES (65, 1, 64, 'Arizona', '', '', 6, 0);
INSERT INTO `picbattles_lists` VALUES (63, 1, 3, 'Ireland', '', '', 65, 0);
INSERT INTO `picbattles_lists` VALUES (166, 1, 64, 'Schwartzeneggers Gym', '', '', 3, 0);
INSERT INTO `picbattles_lists` VALUES (62, 1, 3, 'London', '', '', 62, 0);
INSERT INTO `picbattles_lists` VALUES (69, 1, 64, 'Illinois', '', '', 22, 0);
INSERT INTO `picbattles_lists` VALUES (70, 1, 64, 'Florida', '', '', 25, 0);
INSERT INTO `picbattles_lists` VALUES (643, 1, 636, 'Eva in Bikini', '', '', 5, 0);
INSERT INTO `picbattles_lists` VALUES (126, 1, 105, 'Finland', '', '', 67, 0);
INSERT INTO `picbattles_lists` VALUES (64, 1, 102, 'USA', '', '', 2, 0);
INSERT INTO `picbattles_lists` VALUES (125, 1, 105, 'Norway', '', '', 70, 0);
INSERT INTO `picbattles_lists` VALUES (72, 1, 64, 'Michigan', '', '', 32, 0);
INSERT INTO `picbattles_lists` VALUES (73, 1, 64, 'Missouri', '', '', 35, 0);
INSERT INTO `picbattles_lists` VALUES (74, 1, 64, 'Nebraska', '', '', 37, 0);
INSERT INTO `picbattles_lists` VALUES (75, 1, 64, 'New York', '', '', 42, 0);
INSERT INTO `picbattles_lists` VALUES (76, 1, 64, 'Oklahoma', '', '', 46, 0);
INSERT INTO `picbattles_lists` VALUES (77, 1, 64, 'Texas', '', '', 47, 0);
INSERT INTO `picbattles_lists` VALUES (78, 1, 64, 'Washington', '', '', 48, 0);
INSERT INTO `picbattles_lists` VALUES (79, 1, 64, 'Wyoming', 'WY', '', 49, 0);
INSERT INTO `picbattles_lists` VALUES (80, 1, 68, 'Washington', '', '', 13, 0);
INSERT INTO `picbattles_lists` VALUES (81, 1, 67, 'Los Angeles', '', '', 10, 0);
INSERT INTO `picbattles_lists` VALUES (82, 1, 67, 'San Fransisco', '', '', 9, 0);
INSERT INTO `picbattles_lists` VALUES (83, 1, 81, 'Santa Monica', '', '', 11, 0);
INSERT INTO `picbattles_lists` VALUES (124, 1, 105, 'Denmark', '', '', 60, 0);
INSERT INTO `picbattles_lists` VALUES (101, 1, 105, 'Montenegro', '', '', 68, 0);
INSERT INTO `picbattles_lists` VALUES (102, 1, 1, 'America', '', '', 1, 0);
INSERT INTO `picbattles_lists` VALUES (103, 1, 1, 'Asia', '', '', 53, 0);
INSERT INTO `picbattles_lists` VALUES (104, 1, 1, 'Australia', '', '', 50, 0);
INSERT INTO `picbattles_lists` VALUES (105, 1, 1, 'Europe', '', '', 59, 0);
INSERT INTO `picbattles_lists` VALUES (106, 1, 104, 'Australia', '', '', 51, 0);
INSERT INTO `picbattles_lists` VALUES (107, 1, 104, 'New Zealand', '', '', 52, 0);
INSERT INTO `picbattles_lists` VALUES (108, 1, 103, 'China', '', '', 54, 0);
INSERT INTO `picbattles_lists` VALUES (109, 1, 103, 'India', '', '', 55, 0);
INSERT INTO `picbattles_lists` VALUES (110, 1, 103, 'Japan', '', '', 56, 0);
INSERT INTO `picbattles_lists` VALUES (111, 1, 103, 'Mongolia', '', '', 57, 0);
INSERT INTO `picbattles_lists` VALUES (112, 1, 103, 'Taiwan', '', '', 58, 0);
INSERT INTO `picbattles_lists` VALUES (594, 1, 64, 'Alabama', '', '', 4, 0);
INSERT INTO `picbattles_lists` VALUES (595, 1, 64, 'Alaska', '', '', 5, 0);
INSERT INTO `picbattles_lists` VALUES (596, 1, 64, 'Colorado', '', '', 14, 0);
INSERT INTO `picbattles_lists` VALUES (597, 1, 64, 'Connecticut', '', '', 15, 0);
INSERT INTO `picbattles_lists` VALUES (598, 1, 64, 'Delaware', '', '', 16, 0);
INSERT INTO `picbattles_lists` VALUES (599, 1, 64, 'Florida', '', '', 17, 0);
INSERT INTO `picbattles_lists` VALUES (600, 1, 64, 'Georgia', '', '', 18, 0);
INSERT INTO `picbattles_lists` VALUES (601, 1, 64, 'Hawaii', '', '', 19, 0);
INSERT INTO `picbattles_lists` VALUES (602, 1, 64, 'Idaho', '', '', 20, 0);
INSERT INTO `picbattles_lists` VALUES (603, 1, 64, 'Indiana', '', '', 21, 0);
INSERT INTO `picbattles_lists` VALUES (604, 1, 64, 'Iowa', '', '', 24, 0);
INSERT INTO `picbattles_lists` VALUES (605, 1, 64, 'Kansas', '', '', 26, 0);
INSERT INTO `picbattles_lists` VALUES (606, 1, 64, 'Kentucky', '', '', 27, 0);
INSERT INTO `picbattles_lists` VALUES (607, 1, 64, 'Louisiana ', '', '', 28, 0);
INSERT INTO `picbattles_lists` VALUES (608, 1, 64, 'Maine ', '', '', 29, 0);
INSERT INTO `picbattles_lists` VALUES (609, 1, 64, 'Maryland ', '', '', 30, 0);
INSERT INTO `picbattles_lists` VALUES (610, 1, 64, 'Massachusetts ', '', '', 31, 0);
INSERT INTO `picbattles_lists` VALUES (612, 1, 64, 'Minnesota ', '', '', 33, 0);
INSERT INTO `picbattles_lists` VALUES (613, 1, 64, 'Mississippi ', '', '', 34, 0);
INSERT INTO `picbattles_lists` VALUES (615, 1, 64, 'Montana ', '', '', 36, 0);
INSERT INTO `picbattles_lists` VALUES (617, 1, 64, 'Nevada ', '', '', 38, 0);
INSERT INTO `picbattles_lists` VALUES (618, 1, 64, 'New Hampshire ', '', '', 40, 0);
INSERT INTO `picbattles_lists` VALUES (619, 1, 64, 'New Jersey ', '', '', 39, 0);
INSERT INTO `picbattles_lists` VALUES (620, 1, 64, 'New Mexico ', '', '', 41, 0);
INSERT INTO `picbattles_lists` VALUES (621, 1, 75, 'New York ', '', '', 43, 0);
INSERT INTO `picbattles_lists` VALUES (622, 1, 64, 'North Carolina ', '', '', 45, 0);
INSERT INTO `picbattles_lists` VALUES (623, 1, 64, 'North Dakota', '', '', 44, 0);
INSERT INTO `picbattles_lists` VALUES (624, 1, 0, 'Images Categories', '', '', 0, 0);
INSERT INTO `picbattles_lists` VALUES (625, 1, 624, 'Celebrities', '', '', 7, 0);
INSERT INTO `picbattles_lists` VALUES (626, 1, 624, 'Cars', '', '', 12, 0);
INSERT INTO `picbattles_lists` VALUES (627, 1, 624, 'Animals', '', '', 13, 0);
INSERT INTO `picbattles_lists` VALUES (628, 1, 625, 'Actresses', '', '', 9, 0);
INSERT INTO `picbattles_lists` VALUES (629, 1, 625, 'Actors', '', '', 8, 0);
INSERT INTO `picbattles_lists` VALUES (630, 1, 625, 'Models', '', '', 11, 0);
INSERT INTO `picbattles_lists` VALUES (631, 1, 625, 'Singers', '', '', 10, 0);
INSERT INTO `picbattles_lists` VALUES (634, 1, 624, 'Female Actresses', '', '', 2, 0);
INSERT INTO `picbattles_lists` VALUES (635, 0, 634, 'Linda Evangelista', NULL, NULL, 6, 0);
INSERT INTO `picbattles_lists` VALUES (636, 0, 634, 'Eva Longoria', NULL, NULL, 4, 0);
INSERT INTO `picbattles_lists` VALUES (640, 1, 624, 'Funny Photos', '', '', 1, 0);
INSERT INTO `picbattles_lists` VALUES (642, 1, 634, 'Nima Wellson', '', '', 3, 0);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_messages`
#
DROP TABLE IF EXISTS `picbattles_messages`;
CREATE TABLE `picbattles_messages` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) unsigned NOT NULL,
`to_id` bigint(20) unsigned NOT NULL,
`thread_start` bigint(20) unsigned default NULL,
`from_ip` varchar(15) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`status` tinyint(4) NOT NULL,
`timing` bigint(20) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
#
# Дамп данных таблицы `picbattles_messages`
#
# --------------------------------------------------------
#
# Структура таблицы `picbattles_pages`
#
DROP TABLE IF EXISTS `picbattles_pages`;
CREATE TABLE `picbattles_pages` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) unsigned NOT NULL,
`parent_id` bigint(20) unsigned default NULL,
`type` varchar(50) default NULL,
`title` text,
`body` text,
`language` varchar(255) default NULL,
`priority` bigint(20) NOT NULL default '0',
`deleted` smallint(6) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
#
# Дамп данных таблицы `picbattles_pages`
#
INSERT INTO `picbattles_pages` VALUES (22, 0, 0, 'pages', 'About Service', 'Something-about-this-site.', NULL, 0, 0);
INSERT INTO `picbattles_pages` VALUES (23, 0, 0, 'pages', 'Terms of Service', 'This service provided as is - without any guarantees.
\r\nAdministration may delete links, terminate users\' accounts, forbid URLs to certain domains and ban visitors\' IP addresses without prior notice.
\r\nIn some cases your information and access can be restored (use "contact" form). For example, your access to the site can be restored in case if your account suspended due to inactivity.
', NULL, 0, 0);
INSERT INTO `picbattles_pages` VALUES (25, 0, 0, 'pages', 'Privacy Policy', 'Your private registration information (e-mail, IP, password) will never be transferred (sold, traded) to third party persons or companies - except official investigation cases.
\r\nProfile passwords stored in database as encrypted strings which cannot be restored into actual readable text.
\r\nAdministration of this site will never contact you with advertising purposes. Administration may send occasional e-mails with announces of new functionality or technical emergencies.
', NULL, 0, 0);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_pictures`
#
DROP TABLE IF EXISTS `picbattles_pictures`;
CREATE TABLE `picbattles_pictures` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`cat_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`ip` varchar(15) NOT NULL,
`ident` varchar(255) NOT NULL,
`title` varchar(255) default NULL,
`description` text NOT NULL,
`tags` varchar(255) NOT NULL,
`keywords` varchar(255) NOT NULL,
`added` bigint(20) unsigned NOT NULL,
`autoupdated` bigint(20) unsigned NOT NULL,
`popular` bigint(20) unsigned default '0',
`karma` bigint(20) default '0',
`credit` varchar(255) NOT NULL,
`private` tinyint(4) NOT NULL,
`hash_source` varchar(50) NOT NULL,
`hash_big` varchar(50) NOT NULL,
`views` bigint(20) unsigned NOT NULL,
`downloads` bigint(20) unsigned NOT NULL,
`battles` bigint(20) unsigned NOT NULL,
`battlesRatio` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=5 ;
#
# Дамп данных таблицы `picbattles_pictures`
#
INSERT INTO `picbattles_pictures` VALUES (1, 640, 1, '127.0.0.1', 'star-wars-fertilizer-star-wars-funny', 'Star Wars Fertilizer', '', '1,2', 'star wars, funny', 1214277091, 1228970025, 0, 3, 'http://reddit.com/', 0, '3915597370', '3915597370', 0, 0, 8, 38);
INSERT INTO `picbattles_pictures` VALUES (2, 626, 1, '127.0.0.1', '-1m-Vintage-Car-vintage-cars', '$1m Vintage Car', '', '3,4', 'vintage, cars', 1217649187, 1228970671, 0, 8, '', 0, '3083372438', '4202566781', 0, 0, 9, 89);
INSERT INTO `picbattles_pictures` VALUES (3, 640, 1, '127.0.0.1', 'Standing-on-Wall-illusion-people', 'Standing on Wall', '', '5,6', 'illusion, people', 1224077337, 1228970035, 0, 5, '', 0, '2551635491', '2551635491', 1, 0, 6, 83);
INSERT INTO `picbattles_pictures` VALUES (4, 640, 0, '127.0.0.1', 'Bianca-935aae5b62', 'Bianca', '', '', '', 1226833054, 1226928308, 0, 3, '', 0, '1070043860', '2359851088', 2, 0, 4, 75);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_public`
#
DROP TABLE IF EXISTS `picbattles_public`;
CREATE TABLE `picbattles_public` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`owner_id` bigint(20) unsigned NOT NULL default '0',
`title` varchar(50) default NULL,
`description` text NOT NULL,
`country` varchar(50) default NULL,
`province` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL default '',
`adres` varchar(255) NOT NULL default '',
`phone` varchar(255) NOT NULL default '',
`fax` varchar(255) NOT NULL default '',
`cell` varchar(255) NOT NULL default '',
`im` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL default '',
`site` varchar(255) NOT NULL default '',
`signature` varchar(255) NOT NULL,
`birthday` bigint(20) default NULL,
`gender` tinyint(4) NOT NULL,
`thumb` tinyint(4) NOT NULL,
`anonym` tinyint(4) NOT NULL,
`socialization` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
#
# Дамп данных таблицы `picbattles_public`
#
INSERT INTO `picbattles_public` VALUES (1, 1, NULL, '', NULL, '', '', '', '', '', '', '', '', '', '', NULL, 0, 0, 0, '');
# --------------------------------------------------------
#
# Структура таблицы `picbattles_sessions`
#
DROP TABLE IF EXISTS `picbattles_sessions`;
CREATE TABLE `picbattles_sessions` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) unsigned default NULL,
`ip` varchar(15) NOT NULL default '',
`session_name` varchar(50) default NULL,
`started` bigint(20) unsigned default NULL,
`updated` bigint(20) unsigned default NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
#
# Дамп данных таблицы `picbattles_sessions`
#
INSERT INTO `picbattles_sessions` VALUES (1, 1, '127.0.0.1', '8a0fb2522217945b2c01d4558b7c9c67', 1224089788, 1224089788);
INSERT INTO `picbattles_sessions` VALUES (2, 1, '127.0.0.1', 'b5c70374930b7333790cfef5c80f3bd8', 1226844972, 1226844972);
INSERT INTO `picbattles_sessions` VALUES (3, 1, '127.0.0.1', '03d015a5f7a729b37c5f35c89516c4b2', 1226846790, 1226846790);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_tags`
#
DROP TABLE IF EXISTS `picbattles_tags`;
CREATE TABLE `picbattles_tags` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`site_id` bigint(20) NOT NULL,
`title` varchar(255) NOT NULL,
`updated` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
#
# Дамп данных таблицы `picbattles_tags`
#
INSERT INTO `picbattles_tags` VALUES (1, 0, 'star wars', 1214277227);
INSERT INTO `picbattles_tags` VALUES (2, 0, 'funny', 1214277230);
INSERT INTO `picbattles_tags` VALUES (3, 0, 'vintage', 0);
INSERT INTO `picbattles_tags` VALUES (4, 0, 'cars', 0);
INSERT INTO `picbattles_tags` VALUES (5, 0, 'illusion', 0);
INSERT INTO `picbattles_tags` VALUES (6, 0, 'people', 0);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_users`
#
DROP TABLE IF EXISTS `picbattles_users`;
CREATE TABLE `picbattles_users` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`role` bigint(20) unsigned default NULL,
`till` date default NULL,
`login` varchar(50) default NULL,
`pass` varchar(50) default NULL,
`email` varchar(100) default NULL,
`new_email` varchar(255) NOT NULL,
`confirmation` varchar(255) NOT NULL,
`rank` tinyint(4) default '1',
`karma` bigint(20) NOT NULL default '1',
`power` bigint(20) NOT NULL default '1',
`timezone` varchar(6) default '0',
`deleted` tinyint(4) default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`private` tinyint(4) NOT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
#
# Дамп данных таблицы `picbattles_users`
#
INSERT INTO `picbattles_users` VALUES (1, 0, '0000-00-00', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@email.com', '', '', 3, 50, 2, '+3', 0, '2008-06-24 07:07:38', '2009-01-17 05:34:18', 0);
# --------------------------------------------------------
#
# Структура таблицы `picbattles_votes`
#
DROP TABLE IF EXISTS `picbattles_votes`;
CREATE TABLE `picbattles_votes` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) unsigned NOT NULL,
`ip` varchar(15) NOT NULL,
`target` varchar(100) default NULL,
`target_id` bigint(20) unsigned NOT NULL,
`how` tinyint(4) NOT NULL,
`timing` bigint(20) unsigned NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
#
# Дамп данных таблицы `picbattles_votes`
#