File: //kunden/kunden/homepages/oneclick/gallery/3.0.9/2/scripts/schema.sql
-- MySQL dump 10.9
--
-- Host: 195.214.235.52 Database: gallery3
-- ------------------------------------------------------
-- Server version 5.0.51a-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@access_caches`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@access_caches`;
CREATE TABLE `@@DB_MAIN_PREFIX@@access_caches` (
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) default NULL,
`view_full_1` binary(1) NOT NULL default '0',
`edit_1` binary(1) NOT NULL default '0',
`add_1` binary(1) NOT NULL default '0',
`view_full_2` binary(1) NOT NULL default '0',
`edit_2` binary(1) NOT NULL default '0',
`add_2` binary(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@access_caches`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@access_caches` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@access_caches` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@access_caches` VALUES (1,1,'1','0','0','1','0','0');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@access_caches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@access_intents`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@access_intents`;
CREATE TABLE `@@DB_MAIN_PREFIX@@access_intents` (
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) default NULL,
`view_1` binary(1) default NULL,
`view_full_1` binary(1) default NULL,
`edit_1` binary(1) default NULL,
`add_1` binary(1) default NULL,
`view_2` binary(1) default NULL,
`view_full_2` binary(1) default NULL,
`edit_2` binary(1) default NULL,
`add_2` binary(1) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@access_intents`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@access_intents` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@access_intents` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@access_intents` VALUES (1,1,'1','1','0','0','1','1','0','0');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@access_intents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@caches`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@caches`;
CREATE TABLE `@@DB_MAIN_PREFIX@@caches` (
`id` int(9) NOT NULL auto_increment,
`key` varchar(255) NOT NULL,
`tags` varchar(255) default NULL,
`expiration` int(9) NOT NULL,
`cache` longblob,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`),
KEY `tags` (`tags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@caches`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@caches` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@caches` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@caches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@comments`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@comments`;
CREATE TABLE `@@DB_MAIN_PREFIX@@comments` (
`author_id` int(9) default NULL,
`created` int(9) NOT NULL,
`guest_email` varchar(128) default NULL,
`guest_name` varchar(128) default NULL,
`guest_url` varchar(255) default NULL,
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) NOT NULL,
`server_http_accept_charset` varchar(64) default NULL,
`server_http_accept_encoding` varchar(64) default NULL,
`server_http_accept_language` varchar(64) default NULL,
`server_http_accept` varchar(128) default NULL,
`server_http_connection` varchar(64) default NULL,
`server_http_host` varchar(64) default NULL,
`server_http_referer` varchar(255) default NULL,
`server_http_user_agent` varchar(128) default NULL,
`server_query_string` varchar(64) default NULL,
`server_remote_addr` varchar(40) default NULL,
`server_remote_host` varchar(255) default NULL,
`server_remote_port` varchar(16) default NULL,
`state` varchar(15) default 'unpublished',
`text` text,
`updated` int(9) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@comments`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@comments` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@failed_auths`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@failed_auths`;
CREATE TABLE `@@DB_MAIN_PREFIX@@failed_auths` (
`id` int(9) NOT NULL auto_increment,
`count` int(9) NOT NULL,
`name` varchar(255) NOT NULL,
`time` int(9) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@failed_auths`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@failed_auths` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@failed_auths` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@failed_auths` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@graphics_rules`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@graphics_rules`;
CREATE TABLE `@@DB_MAIN_PREFIX@@graphics_rules` (
`id` int(9) NOT NULL auto_increment,
`active` tinyint(1) default '0',
`args` varchar(255) default NULL,
`module_name` varchar(64) NOT NULL,
`operation` varchar(64) NOT NULL,
`priority` int(9) NOT NULL,
`target` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@graphics_rules`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@graphics_rules` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@graphics_rules` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@graphics_rules` VALUES (1,1,'a:3:{s:5:\"width\";i:200;s:6:\"height\";i:200;s:6:\"master\";i:2;}','gallery','gallery_graphics::resize',100,'thumb'),
(2,1,'a:3:{s:5:\"width\";i:640;s:6:\"height\";i:640;s:6:\"master\";i:2;}','gallery','gallery_graphics::resize',100,'resize');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@graphics_rules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@groups`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@groups`;
CREATE TABLE `@@DB_MAIN_PREFIX@@groups` (
`id` int(9) NOT NULL auto_increment,
`name` char(64) default NULL,
`special` tinyint(1) default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@groups`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@groups` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@groups` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@groups` VALUES (1,'Everybody',1),
(2,'Registered Users',1);
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@groups_users`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@groups_users`;
CREATE TABLE `@@DB_MAIN_PREFIX@@groups_users` (
`group_id` int(9) NOT NULL,
`user_id` int(9) NOT NULL,
PRIMARY KEY (`group_id`,`user_id`),
UNIQUE KEY `user_id` (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@groups_users`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@groups_users` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@groups_users` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@groups_users` VALUES (1,1),
(1,2),
(2,2);
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@groups_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@incoming_translations`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@incoming_translations`;
CREATE TABLE `@@DB_MAIN_PREFIX@@incoming_translations` (
`id` int(9) NOT NULL auto_increment,
`key` char(32) NOT NULL,
`locale` char(10) NOT NULL,
`message` text NOT NULL,
`revision` int(9) default NULL,
`translation` text,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`,`locale`),
KEY `locale_key` (`locale`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@incoming_translations`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@incoming_translations` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@incoming_translations` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@incoming_translations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@items`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@items`;
CREATE TABLE `@@DB_MAIN_PREFIX@@items` (
`id` int(9) NOT NULL auto_increment,
`album_cover_item_id` int(9) default NULL,
`captured` int(9) default NULL,
`created` int(9) default NULL,
`description` text,
`height` int(9) default NULL,
`left_ptr` int(9) NOT NULL,
`level` int(9) NOT NULL,
`mime_type` varchar(64) default NULL,
`name` varchar(255) default NULL,
`owner_id` int(9) default NULL,
`parent_id` int(9) NOT NULL,
`rand_key` decimal(11,10) default NULL,
`relative_path_cache` varchar(255) default NULL,
`relative_url_cache` varchar(255) default NULL,
`resize_dirty` tinyint(1) default '1',
`resize_height` int(9) default NULL,
`resize_width` int(9) default NULL,
`right_ptr` int(9) NOT NULL,
`slug` varchar(255) default NULL,
`sort_column` varchar(64) default NULL,
`sort_order` char(4) default 'ASC',
`thumb_dirty` tinyint(1) default '1',
`thumb_height` int(9) default NULL,
`thumb_width` int(9) default NULL,
`title` varchar(255) default NULL,
`type` varchar(32) NOT NULL,
`updated` int(9) default NULL,
`view_count` int(9) default '0',
`weight` int(9) NOT NULL default '0',
`width` int(9) default NULL,
`view_1` binary(1) default '0',
`view_2` binary(1) default '0',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `type` (`type`),
KEY `random` (`rand_key`),
KEY `weight` (`weight`),
KEY `left_ptr` (`left_ptr`),
KEY `relative_path_cache` (`relative_path_cache`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@items`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@items` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@items` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@items` VALUES (1,NULL,NULL,1309327982,'',NULL,1,1,NULL,NULL,2,0,NULL,'','',1,NULL,NULL,2,NULL,'weight','ASC',1,NULL,NULL,'@@TITLE@@','album',1309327982,0,1,NULL,'1','1');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@items_tags`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@items_tags`;
CREATE TABLE `@@DB_MAIN_PREFIX@@items_tags` (
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) NOT NULL,
`tag_id` int(9) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`,`id`),
KEY `item_id` (`item_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@items_tags`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@items_tags` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@items_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@items_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@logs`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@logs`;
CREATE TABLE `@@DB_MAIN_PREFIX@@logs` (
`id` int(9) NOT NULL auto_increment,
`category` varchar(64) default NULL,
`html` varchar(255) default NULL,
`message` text,
`referer` varchar(255) default NULL,
`severity` int(9) default '0',
`timestamp` int(9) default '0',
`url` varchar(255) default NULL,
`user_id` int(9) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@logs`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@logs` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@messages`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@messages`;
CREATE TABLE `@@DB_MAIN_PREFIX@@messages` (
`id` int(9) NOT NULL auto_increment,
`key` varchar(255) default NULL,
`severity` varchar(32) default NULL,
`value` text,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@messages`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@messages` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@modules`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@modules`;
CREATE TABLE `@@DB_MAIN_PREFIX@@modules` (
`id` int(9) NOT NULL auto_increment,
`active` tinyint(1) default '0',
`name` varchar(64) default NULL,
`version` int(9) default NULL,
`weight` int(9) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `weight` (`weight`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@modules`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@modules` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@modules` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@modules` VALUES (1,1,'gallery',57,1),
(2,1,'user',4,2),
(3,1,'comment',7,3),
(4,1,'organize',4,4),
(5,1,'info',2,5),
(6,1,'rss',1,6),
(7,1,'search',1,7),
(8,1,'slideshow',2,8),
(9,1,'tag',3,9),
(10,1,'g2_import',2,11);
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@outgoing_translations`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@outgoing_translations`;
CREATE TABLE `@@DB_MAIN_PREFIX@@outgoing_translations` (
`id` int(9) NOT NULL auto_increment,
`base_revision` int(9) default NULL,
`key` char(32) NOT NULL,
`locale` char(10) NOT NULL,
`message` text NOT NULL,
`translation` text,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`,`locale`),
KEY `locale_key` (`locale`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@outgoing_translations`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@outgoing_translations` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@outgoing_translations` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@outgoing_translations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@permissions`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@permissions`;
CREATE TABLE `@@DB_MAIN_PREFIX@@permissions` (
`id` int(9) NOT NULL auto_increment,
`display_name` varchar(64) default NULL,
`name` varchar(64) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@permissions`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@permissions` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@permissions` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@permissions` VALUES (1,'View','view'),
(2,'View full size','view_full'),
(3,'Edit','edit'),
(4,'Add','add');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@search_records`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@search_records`;
CREATE TABLE `@@DB_MAIN_PREFIX@@search_records` (
`id` int(9) NOT NULL auto_increment,
`item_id` int(9) default NULL,
`dirty` tinyint(1) default '1',
`data` longtext,
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
FULLTEXT KEY `data` (`data`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@search_records`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@search_records` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@search_records` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@search_records` VALUES (1,1,0,' Gallery');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@search_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@sessions`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@sessions`;
CREATE TABLE `@@DB_MAIN_PREFIX@@sessions` (
`session_id` varchar(127) NOT NULL,
`data` text NOT NULL,
`last_activity` int(10) unsigned NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@sessions`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@sessions` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@tags`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@tags`;
CREATE TABLE `@@DB_MAIN_PREFIX@@tags` (
`id` int(9) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
`count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@tags`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@tags` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@tasks`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@tasks`;
CREATE TABLE `@@DB_MAIN_PREFIX@@tasks` (
`id` int(9) NOT NULL auto_increment,
`callback` varchar(128) default NULL,
`context` text NOT NULL,
`done` tinyint(1) default '0',
`name` varchar(128) default NULL,
`owner_id` int(9) default NULL,
`percent_complete` int(9) default '0',
`state` varchar(32) default NULL,
`status` varchar(255) default NULL,
`updated` int(9) default NULL,
PRIMARY KEY (`id`),
KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@tasks`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@tasks` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@tasks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@themes`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@themes`;
CREATE TABLE `@@DB_MAIN_PREFIX@@themes` (
`id` int(9) NOT NULL auto_increment,
`name` varchar(64) default NULL,
`version` int(9) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@themes`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@themes` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@themes` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@themes` VALUES (1,'wind',1),
(2,'admin_wind',1);
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@themes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@users`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@users`;
CREATE TABLE `@@DB_MAIN_PREFIX@@users` (
`id` int(9) NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
`full_name` varchar(255) NOT NULL,
`password` varchar(64) NOT NULL,
`login_count` int(10) unsigned NOT NULL default '0',
`last_login` int(10) unsigned NOT NULL default '0',
`email` varchar(64) default NULL,
`admin` tinyint(1) default '0',
`guest` tinyint(1) default '0',
`hash` char(32) default NULL,
`url` varchar(255) default NULL,
`locale` char(10) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `hash` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@users`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@users` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@users` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@users` VALUES (1,'guest','Guest User','',0,0,NULL,0,1,NULL,NULL,NULL),
(2,'@@ADMIN_NAME@@','Gallery Administrator','@@ADMIN_PASSWORD@@',0,0,'@@ADMIN_EMAIL@@',1,0,NULL,NULL,'@@LOCALE@@');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `@@DB_MAIN_PREFIX@@vars`
--
DROP TABLE IF EXISTS `@@DB_MAIN_PREFIX@@vars`;
CREATE TABLE `@@DB_MAIN_PREFIX@@vars` (
`id` int(9) NOT NULL auto_increment,
`module_name` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
`value` text,
PRIMARY KEY (`id`),
UNIQUE KEY `module_name` (`module_name`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `@@DB_MAIN_PREFIX@@vars`
--
LOCK TABLES `@@DB_MAIN_PREFIX@@vars` WRITE;
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@vars` DISABLE KEYS */;
INSERT INTO `@@DB_MAIN_PREFIX@@vars` VALUES
(47, 'gallery', 'active_site_theme', 'wind'),
(48, 'gallery', 'active_admin_theme', 'admin_wind'),
(49, 'gallery', 'page_size', '9'),
(50, 'gallery', 'thumb_size', '200'),
(51, 'gallery', 'resize_size', '640'),
(52, 'gallery', 'default_locale', 'en_US'),
(53, 'gallery', 'image_quality', '75'),
(54, 'gallery', 'image_sharpen', '15'),
(55, 'gallery', 'upgrade_checker_auto_enabled', '1'),
(56, 'gallery', 'blocks_dashboard_sidebar', 'a:4:{i:2;a:2:{i:0;s:7:"gallery";i:1;s:11:"block_adder";}i:3;a:2:{i:0;s:7:"gallery";i:1;s:5:"stats";}i:4;a:2:{i:0;s:7:"gallery";i:1;s:13:"platform_info";}i:5;a:2:{i:0;s:7:"gallery";i:1;s:12:"project_news";}}'),
(57, 'gallery', 'blocks_dashboard_center', 'a:4:{i:6;a:2:{i:0;s:7:"gallery";i:1;s:7:"welcome";}i:7;a:2:{i:0;s:7:"gallery";i:1;s:15:"upgrade_checker";}i:8;a:2:{i:0;s:7:"gallery";i:1;s:12:"photo_stream";}i:9;a:2:{i:0;s:7:"gallery";i:1;s:11:"log_entries";}}'),
(59, 'gallery', 'date_format', 'Y-M-d'),
(60, 'gallery', 'date_time_format', 'Y-M-d H:i:s'),
(61, 'gallery', 'time_format', 'H:i:s'),
(62, 'gallery', 'show_credits', '1'),
(63, 'gallery', 'credits', 'Powered by <a href="%url">%gallery_version</a>'),
(64, 'gallery', 'simultaneous_upload_limit', '5'),
(65, 'gallery', 'admin_area_timeout', '5400'),
(66, 'gallery', 'maintenance_mode', '0'),
(67, 'gallery', 'visible_title_length', '15'),
(68, 'gallery', 'favicon_url', 'lib/images/favicon.ico'),
(69, 'gallery', 'apple_touch_icon_url', 'lib/images/apple-touch-icon.png'),
(70, 'gallery', 'email_from', 'unknown@unknown.com'),
(71, 'gallery', 'email_reply_to', 'unknown@unknown.com'),
(72, 'gallery', 'email_line_length', '70'),
(73, 'gallery', 'email_header_separator', 's:1:"\n";'),
(74, 'gallery', 'show_user_profiles_to', 'registered_users'),
(75, 'gallery', 'extra_binary_paths', '/usr/local/bin:/opt/local/bin:/opt/bin'),
(76, 'gallery', 'timezone', NULL),
(77, 'gallery', 'lock_timeout', '1'),
(78, 'gallery', 'movie_extract_frame_time', '3'),
(79, 'gallery', 'movie_allow_uploads', 'autodetect'),
(80, 'gallery', 'blocks_site_sidebar', 'a:4:{i:10;a:2:{i:0;s:7:"gallery";i:1;s:8:"language";}i:11;a:2:{i:0;s:4:"info";i:1;s:8:"metadata";}i:12;a:2:{i:0;s:3:"rss";i:1;s:9:"rss_feeds";}i:13;a:2:{i:0;s:3:"tag";i:1;s:3:"tag";}}'),
(81, 'gallery', 'identity_provider', 'user'),
(82, 'user', 'minimum_password_length', '5'),
(83, 'comment', 'spam_caught', '0'),
(84, 'comment', 'access_permissions', 'everybody'),
(85, 'comment', 'rss_visible', 'all'),
(86, 'info', 'show_title', '1'),
(87, 'info', 'show_description', '1'),
(88, 'info', 'show_owner', '1'),
(89, 'info', 'show_name', '1'),
(90, 'info', 'show_captured', '1'),
(91, 'slideshow', 'max_scale', '0'),
(92, 'tag', 'tag_cloud_size', '30'),
(93, 'gallery', 'private_key', '@@PRIVATE_KEY@@'),
(94, 'gallery', 'graphics_toolkit', 'gd'),
(95, 'gallery', 'graphics_toolkit_path', '');
/*!40000 ALTER TABLE `@@DB_MAIN_PREFIX@@vars` ENABLE KEYS */;
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;