-- MySQL dump 10.13  Distrib 5.1.48, for Win32 (ia32)
--
-- Host: localhost    Database: sitebuilder5
-- ------------------------------------------------------
-- Server version	5.1.48-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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 `action`
--

DROP TABLE IF EXISTS `action`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `action`
--

LOCK TABLES `action` WRITE;
/*!40000 ALTER TABLE `action` DISABLE KEYS */;
/*!40000 ALTER TABLE `action` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_param`
--

DROP TABLE IF EXISTS `config_param`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_param` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `config_section_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  `in_backup` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_param`
--

LOCK TABLES `config_param` WRITE;
/*!40000 ALTER TABLE `config_param` DISABLE KEYS */;
INSERT INTO `config_param` VALUES (1,1,'version','5.1.0',0),(2,1,'build','',0);
/*!40000 ALTER TABLE `config_param` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_section`
--

DROP TABLE IF EXISTS `config_section`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_section`
--

LOCK TABLES `config_section` WRITE;
/*!40000 ALTER TABLE `config_section` DISABLE KEYS */;
INSERT INTO `config_section` VALUES (1,'general');
/*!40000 ALTER TABLE `config_section` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `header`
--

DROP TABLE IF EXISTS `header`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `header` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `logo_is_black` int(11) NOT NULL DEFAULT '1',
  `title_color` varchar(7) NOT NULL DEFAULT '#000000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=147 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `header`
--

LOCK TABLES `header` WRITE;
/*!40000 ALTER TABLE `header` DISABLE KEYS */;
INSERT INTO `header` VALUES (1,'accounting-and-financial_01',1,'#000000'),(2,'accounting-and-financial_02',1,'#000000'),(3,'artist-designer_01',1,'#000000'),(4,'artist-designer_02',0,'#FFFFFF'),(5,'artist-website-exhibit_01',0,'#FFFFFF'),(6,'artist-website-exhibit_02',0,'#FFFFFF'),(7,'association-foundation-league_01',1,'#000000'),(8,'association-foundation-league_02',0,'#FFFFFF'),(9,'author-writer-website_01',0,'#FFFFFF'),(10,'author-writer-website_02',0,'#FFFFFF'),(11,'band-website_01',0,'#FFFFFF'),(12,'band-website_02',0,'#FFFFFF'),(13,'birth-engagement-wedding-announcement_01',1,'#000000'),(14,'bricklayer-and-tiler_01',0,'#FFFFFF'),(15,'bricklayer-and-tiler_02',0,'#FFFFFF'),(16,'business-company-website_01',1,'#000000'),(17,'business-company-website_02',1,'#000000'),(18,'car-rental_01',0,'#FFFFFF'),(19,'car-rental_02',1,'#000000'),(20,'car-repair-service_01',1,'#000000'),(21,'car-repair-service_02',1,'#000000'),(22,'cargo-delivery-services_01',1,'#000000'),(23,'cargo-delivery-services_02',1,'#000000'),(24,'carpenter_01',0,'#FFFFFF'),(25,'carpenter_02',1,'#000000'),(26,'charity-philanthropic-organization_01',0,'#FFFFFF'),(27,'charity-philanthropic-organization_02',0,'#FFFFFF'),(28,'church-religious-organization_01',1,'#000000'),(29,'church-religious-organization_02',0,'#FFFFFF'),(30,'coffee-shop_01',0,'#FFFFFF'),(31,'coffee-shop_02',0,'#FFFFFF'),(32,'community-college-internet-radio_01',0,'#FFFFFF'),(33,'community-college-internet-radio_02',1,'#000000'),(34,'construction-company_01',1,'#000000'),(35,'construction-company_02',1,'#000000'),(36,'consulting-services_01',1,'#000000'),(37,'consulting-services_02',1,'#000000'),(38,'dance-studio_01',0,'#FFFFFF'),(39,'dance-studio_02',1,'#000000'),(40,'dance-studio_03',0,'#FFFFFF'),(41,'decorator_01',0,'#FFFFFF'),(42,'decorator_02',1,'#000000'),(43,'design-studio_01',1,'#000000'),(44,'design-studio_02',1,'#000000'),(45,'design-studio_03',1,'#000000'),(46,'driving-school_01',1,'#000000'),(47,'driving-school_02',1,'#000000'),(48,'electrician_01',1,'#000000'),(49,'electrician_02',1,'#000000'),(50,'engagement-wedding_01',0,'#FFFFFF'),(51,'engagement-wedding_02',1,'#000000'),(52,'engagement-wedding_03',1,'#000000'),(53,'environmental-organization_01',0,'#FFFFFF'),(54,'environmental-organization_02',1,'#000000'),(55,'fallback',1,'#000000'),(56,'fashion-clothing-store_01',0,'#FFFFFF'),(57,'fashion-clothing-store_02',1,'#000000'),(58,'fitness-studio_01',0,'#FFFFFF'),(59,'fitness-studio_02',0,'#FFFFFF'),(60,'general-residential-contractors_01',1,'#000000'),(61,'general-residential-contractors_02',1,'#000000'),(62,'generic-shop_01',1,'#000000'),(63,'generic-shop_02',1,'#000000'),(64,'glass_01',1,'#000000'),(65,'glass_02',1,'#000000'),(66,'health-care-provider_01',1,'#000000'),(67,'health-care-provider_02',1,'#000000'),(68,'hotel_01',1,'#000000'),(69,'hotel_02',1,'#000000'),(70,'house-painter_01',1,'#000000'),(71,'house-painter_02',1,'#000000'),(72,'hvac-services_01',0,'#FFFFFF'),(73,'hvac-services_02',1,'#000000'),(74,'insurance-agency_01',1,'#000000'),(75,'insurance-agency_02',1,'#000000'),(76,'language-school_01',1,'#000000'),(77,'language-school_02',1,'#000000'),(78,'language-trip_01',1,'#000000'),(79,'language-trip_02',1,'#000000'),(80,'lawyer-service_01',0,'#FFFFFF'),(81,'lawyer-service_02',1,'#000000'),(82,'library_01',1,'#000000'),(83,'library_02',0,'#FFFFFF'),(84,'movie-blog_01',0,'#FFFFFF'),(85,'movie-blog_02',0,'#FFFFFF'),(86,'movie-blog_03',0,'#FFFFFF'),(87,'movie-fan-website_01',0,'#FFFFFF'),(88,'movie-fan-website_02',0,'#FFFFFF'),(89,'museum-gallery-exhibition_01',1,'#000000'),(90,'museum-gallery-exhibition_02',1,'#000000'),(91,'music-blog_01',1,'#000000'),(92,'music-blog_02',1,'#000000'),(93,'musician-fan-website_01',1,'#000000'),(94,'musician-fan-website_02',0,'#FFFFFF'),(95,'musician-performer-website_01',0,'#FFFFFF'),(96,'musician-performer-website_02',1,'#000000'),(97,'night-club_01',0,'#FFFFFF'),(98,'night-club_02',0,'#FFFFFF'),(99,'night-club_03',0,'#FFFFFF'),(100,'non-profit-organization_01',0,'#FFFFFF'),(101,'non-profit-organization_02',1,'#000000'),(102,'personal-collection_01',1,'#000000'),(103,'personal-collection_02',1,'#000000'),(104,'personal-family-website_01',0,'#FFFFFF'),(105,'personal-family-website_02',0,'#FFFFFF'),(106,'pet-shop_01',1,'#000000'),(107,'pet-shop_02',1,'#000000'),(108,'pharmacy_01',1,'#000000'),(109,'pharmacy_02',0,'#FFFFFF'),(110,'photographer-website-exhibit_01',1,'#000000'),(111,'photographer-website-exhibit_02',0,'#FFFFFF'),(112,'photography-portrait-studio_01',1,'#000000'),(113,'photography-portrait-studio_02',0,'#FFFFFF'),(114,'plumber_01',1,'#000000'),(115,'plumber_02',1,'#000000'),(116,'political-party-organization_01',0,'#FFFFFF'),(117,'political-party-organization_02',0,'#FFFFFF'),(118,'political-party-organization_03',0,'#FFFFFF'),(119,'pub-bar-cafe_01',1,'#000000'),(120,'pub-bar-cafe_02',0,'#FFFFFF'),(121,'pub-bar-cafe_03',1,'#000000'),(122,'pub-bar-cafe_04',0,'#FFFFFF'),(123,'pub-bar-cafe_05',0,'#FFFFFF'),(124,'restaurant_01',0,'#FFFFFF'),(125,'restaurant_02',0,'#FFFFFF'),(126,'restaurant_03',0,'#FFFFFF'),(127,'resume-work-profile-cv_01',1,'#000000'),(128,'resume-work-profile-cv_02',1,'#000000'),(129,'roofer_01',1,'#000000'),(130,'roofer_02',1,'#000000'),(131,'school-website_01',0,'#FFFFFF'),(132,'school-website_02',1,'#000000'),(133,'school-website_03',0,'#FFFFFF'),(134,'seminar-convention-trade-show_01',1,'#000000'),(135,'seminar-convention-trade-show_02',0,'#FFFFFF'),(136,'sports-team-fan-website_01',0,'#FFFFFF'),(137,'sports-team-fan-website_02',0,'#FFFFFF'),(138,'theater-blog_01',0,'#FFFFFF'),(139,'theater-blog_02',0,'#FFFFFF'),(140,'theater-blog_03',0,'#FFFFFF'),(141,'theater-cinema-performance_01',0,'#FFFFFF'),(142,'theater-cinema-performance_02',1,'#000000'),(143,'travel-agency_01',0,'#FFFFFF'),(144,'travel-agency_02',1,'#000000'),(145,'travel-blog_01',0,'#FFFFFF'),(146,'travel-blog_02',1,'#000000');
/*!40000 ALTER TABLE `header` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `host`
--

DROP TABLE IF EXISTS `host`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `host` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `is_active` int(11) NOT NULL DEFAULT '1',
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `host`
--

LOCK TABLES `host` WRITE;
/*!40000 ALTER TABLE `host` DISABLE KEYS */;
/*!40000 ALTER TABLE `host` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locale`
--

DROP TABLE IF EXISTS `locale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `locale` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `english_name` varchar(255) NOT NULL DEFAULT '',
  `decimal_point` varchar(3) NOT NULL DEFAULT '.',
  `monetary_unit_code` varchar(3) NOT NULL DEFAULT 'USD',
  `currency_symbol_left` varchar(20) NOT NULL DEFAULT '$',
  `currency_symbol_right` varchar(20) NOT NULL DEFAULT '',
  `date_format` varchar(10) NOT NULL DEFAULT 'Y/m/d',
  `time_format` varchar(10) NOT NULL DEFAULT 'H:i:s',
  `week_begin` int(11) NOT NULL DEFAULT '1',
  `is_active` int(11) NOT NULL DEFAULT '1',
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locale`
--

LOCK TABLES `locale` WRITE;
/*!40000 ALTER TABLE `locale` DISABLE KEYS */;
INSERT INTO `locale` VALUES (1,'en_US','English, United States','English, United States','.','USD','$','','n/j/Y','g:i:s A',1,1,'98c3b0f3-46f9-658b-14f5-e48ac00b9a31'),(2,'de_DE','Deutsch, Deutschland','German, Germany',',','EUR','','€','d.m.Y','H:i:s',1,1,'e6ba9170-4c7c-8498-bc94-cccba5045ea3'),(3,'en_GB','English, Great Britain','English, Great Britain','.','GBP','£','','n/j/Y','g:i:s A',1,1,'ccfd82dd-1225-f5ab-5b75-0e21c7c1e9e3'),(4,'es_ES','Español, España','Spanish, Spain',',','EUR','','€','d/m/Y','G:i:s',1,1,'339df815-d7ce-6529-f683-203f88c795cd'),(5,'fr_FR','Français, France','French, France',',','EUR','','€','d/m/Y','H:i:s',1,1,'30f72019-3faa-7b4f-8dbf-e256088c11db'),(6,'it_IT','Italiano, Italia','Italian, Italy','.','EUR','','€','Y/m/d','H:i:s',1,1,'f7839cd5-2ce5-d65b-60b6-4dcc2fda6ebb'),(7,'ja_JP','日本語, 日本','Japanese, Japan','.','JPY','¥','','Y/m/d','H:i:s',1,1,'d2a7315a-27c4-aca7-b6cc-ca21855b037a'),(8,'nl_NL','Dutch, Netherlands','Dutch, Netherlands','.','EUR','','€','Y/m/d','H:i:s',1,1,'5cdf5935-faea-8782-d772-90b84b6870e4'),(9,'ru_RU','Русский, Россия','Russian, Russia',',','RUB','','р.','d.m.Y','H:i:s',1,1,'e206a1c5-7416-09a1-6cc8-273025c497d6'),(10,'zh_CN','简体中文，中国','Simplified Chinese, China','.','CNY','元','','Y/m/d','H:i:s',1,1,'4bf152c6-2ccf-c809-8d7f-ec631ca380bd'),(11,'zh_TW','繁體中文，臺灣','Traditional Chinese, Taiwan','.','TWD','元','','Y/m/d','H:i:s',1,1,'1d23b5bd-26a7-60c2-bb8f-811cd4fe6252');
/*!40000 ALTER TABLE `locale` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `placeholder_value`
--

DROP TABLE IF EXISTS `placeholder_value`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `placeholder_value` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_site_id_name` (`site_id`,`name`),
  KEY `key_site_id` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `placeholder_value`
--

LOCK TABLES `placeholder_value` WRITE;
/*!40000 ALTER TABLE `placeholder_value` DISABLE KEYS */;
/*!40000 ALTER TABLE `placeholder_value` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plan`
--

DROP TABLE IF EXISTS `plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `creation_date` varchar(25) NOT NULL DEFAULT '',
  `update_date` varchar(25) NOT NULL DEFAULT '',
  `max_pages` int(11) NOT NULL DEFAULT '0',
  `is_active` int(11) NOT NULL DEFAULT '1',
  `is_default` int(11) NOT NULL DEFAULT '0',
  `is_publication_settings_management_allowed` int(11) NOT NULL DEFAULT '0',
  `trial_life_time` int(11) NOT NULL DEFAULT '0',
  `trial_life_type_id` int(11) NOT NULL DEFAULT '0',
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  `is_additional_site_content_allowed` int(11) NOT NULL DEFAULT '0',
  `additional_site_content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plan`
--

LOCK TABLES `plan` WRITE;
/*!40000 ALTER TABLE `plan` DISABLE KEYS */;
INSERT INTO `plan` VALUES (1,'Root','','2011-03-15T18:08:02+01:00','2011-03-15T18:08:02+01:00',-1,0,0,1,30,1,'0874861b-0cfe-fa29-da3f-4ac8d07226b5',1,''),(2,'Default plan','','2011-03-15T18:08:02+01:00','2011-03-15T18:08:02+01:00',-1,1,1,1,30,1,'7913fbed-04d2-0b14-2fcb-c8387581be52',1,'');
/*!40000 ALTER TABLE `plan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plan_host`
--

DROP TABLE IF EXISTS `plan_host`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan_host` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plan_id` int(11) NOT NULL DEFAULT '0',
  `host_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `host_id_plan_id` (`host_id`,`plan_id`),
  KEY `plan_id` (`plan_id`),
  KEY `host_id` (`host_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plan_host`
--

LOCK TABLES `plan_host` WRITE;
/*!40000 ALTER TABLE `plan_host` DISABLE KEYS */;
/*!40000 ALTER TABLE `plan_host` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plan_publish_mode`
--

DROP TABLE IF EXISTS `plan_publish_mode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan_publish_mode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plan_id` int(11) NOT NULL DEFAULT '0',
  `publish_mode_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mode_id_plan_id` (`publish_mode_id`,`plan_id`),
  KEY `plan_id` (`plan_id`),
  KEY `mode_id` (`publish_mode_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plan_publish_mode`
--

LOCK TABLES `plan_publish_mode` WRITE;
/*!40000 ALTER TABLE `plan_publish_mode` DISABLE KEYS */;
INSERT INTO `plan_publish_mode` VALUES (1,1,1),(2,1,3),(3,2,1),(4,2,3);
/*!40000 ALTER TABLE `plan_publish_mode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plan_template`
--

DROP TABLE IF EXISTS `plan_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plan_id` int(11) NOT NULL DEFAULT '0',
  `template_id` int(11) NOT NULL DEFAULT '0',
  `is_trial` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_id_plan_id` (`template_id`,`plan_id`),
  KEY `plan_id` (`plan_id`),
  KEY `template_id` (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plan_template`
--

LOCK TABLES `plan_template` WRITE;
/*!40000 ALTER TABLE `plan_template` DISABLE KEYS */;
INSERT INTO `plan_template` VALUES (1,1,1,0);
/*!40000 ALTER TABLE `plan_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `publish_mode`
--

DROP TABLE IF EXISTS `publish_mode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `publish_mode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `publish_mode`
--

LOCK TABLES `publish_mode` WRITE;
/*!40000 ALTER TABLE `publish_mode` DISABLE KEYS */;
INSERT INTO `publish_mode` VALUES (1,'FTP'),(3,'XCopy');
/*!40000 ALTER TABLE `publish_mode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `session`
--

DROP TABLE IF EXISTS `session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session` (
  `id` varchar(32) NOT NULL DEFAULT '',
  `modified` int(11) NOT NULL DEFAULT '0',
  `lifetime` int(11) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `session`
--

LOCK TABLES `session` WRITE;
/*!40000 ALTER TABLE `session` DISABLE KEYS */;
/*!40000 ALTER TABLE `session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site`
--

DROP TABLE IF EXISTS `site`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dir_name` varchar(32) NOT NULL DEFAULT '',
  `site_id` varchar(32) NOT NULL DEFAULT '',
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `creation_date` varchar(25) NOT NULL DEFAULT '',
  `template_id` int(11) DEFAULT NULL,
  `site_publish_settings_id` int(11) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `logo` varchar(255) DEFAULT NULL,
  `color_scheme` varchar(255) DEFAULT NULL,
  `header` varchar(255) DEFAULT NULL,
  `button` varchar(255) DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_slogan` varchar(255) DEFAULT NULL,
  `pages_use_name` int(11) NOT NULL DEFAULT '1',
  `description` text,
  `keywords` text,
  `custom_head` text,
  `google_analytics_code` text,
  `locale_id` int(11) NOT NULL DEFAULT '0',
  `is_changed_since_last_publication` int(11) DEFAULT NULL,
  `site_page_id` int(11) DEFAULT NULL,
  `is_trial` int(11) NOT NULL DEFAULT '0',
  `plan_id` int(11) NOT NULL DEFAULT '0',
  `initial_site_template_id` int(11) DEFAULT '0',
  `site_owner_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `site_id` (`site_id`),
  UNIQUE KEY `uuid` (`uuid`),
  UNIQUE KEY `site_publish_setting_id` (`site_publish_settings_id`),
  KEY `template_id` (`template_id`),
  KEY `site_page_id` (`site_page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site`
--

LOCK TABLES `site` WRITE;
/*!40000 ALTER TABLE `site` DISABLE KEYS */;
/*!40000 ALTER TABLE `site` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_design`
--

DROP TABLE IF EXISTS `site_design`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_design` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL DEFAULT '0',
  `property_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `site_id_property` (`site_id`,`property_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_design`
--

LOCK TABLES `site_design` WRITE;
/*!40000 ALTER TABLE `site_design` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_design` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_owner`
--

DROP TABLE IF EXISTS `site_owner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_owner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personal_name` varchar(255) NOT NULL DEFAULT '',
  `company_name` varchar(255) NOT NULL DEFAULT '',
  `phone` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `city` varchar(255) NOT NULL DEFAULT '',
  `country` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_owner`
--

LOCK TABLES `site_owner` WRITE;
/*!40000 ALTER TABLE `site_owner` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_owner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_page`
--

DROP TABLE IF EXISTS `site_page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `site_page_type_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `browser_title` varchar(255) NOT NULL DEFAULT '',
  `is_visible` int(11) NOT NULL DEFAULT '1',
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `file_name` varchar(255) DEFAULT '',
  `identity` varchar(255) DEFAULT '',
  `widget_id` int(11) DEFAULT '0',
  `login` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_page`
--

LOCK TABLES `site_page` WRITE;
/*!40000 ALTER TABLE `site_page` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_page` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_publication`
--

DROP TABLE IF EXISTS `site_publication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_publication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_publish_settings_id` int(11) DEFAULT NULL,
  `site_id` int(11) NOT NULL DEFAULT '0',
  `version` varchar(15) NOT NULL DEFAULT '',
  `publication_time` int(11) NOT NULL DEFAULT '0',
  `uuid` varchar(100) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `site_id` (`site_id`),
  KEY `publication_time` (`publication_time`),
  KEY `site_publish_settings_id` (`site_publish_settings_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_publication`
--

LOCK TABLES `site_publication` WRITE;
/*!40000 ALTER TABLE `site_publication` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_publication` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_publish_settings`
--

DROP TABLE IF EXISTS `site_publish_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_publish_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `host_id` int(11) DEFAULT '0',
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  `target_url` text,
  `fallback_ip` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT '',
  `is_mysql_used` int(11) NOT NULL DEFAULT '0',
  `mysql_host` varchar(255) DEFAULT '',
  `mysql_port` varchar(6) DEFAULT '',
  `mysql_user` varchar(255) DEFAULT '',
  `mysql_password` varchar(255) DEFAULT '',
  `mysql_database` varchar(255) DEFAULT '',
  `http_user` varchar(255) DEFAULT '',
  `http_password` varchar(255) DEFAULT '',
  `ftp_mode` varchar(7) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_publish_settings`
--

LOCK TABLES `site_publish_settings` WRITE;
/*!40000 ALTER TABLE `site_publish_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_publish_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_template`
--

DROP TABLE IF EXISTS `site_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL DEFAULT '',
  `site_template_category_id` int(11) NOT NULL DEFAULT '0',
  `version` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_template`
--

LOCK TABLES `site_template` WRITE;
/*!40000 ALTER TABLE `site_template` DISABLE KEYS */;
INSERT INTO `site_template` VALUES (1,'accounting_service',1,'1.0.0'),(2,'announcement',10,'1.0.0'),(3,'artist',6,'1.0.0'),(4,'association',4,'1.0.0'),(5,'band',6,'1.0.0'),(6,'band_fan',9,'1.0.0'),(7,'bricklayer',2,'1.0.0'),(8,'business_master',1,'1.0.0'),(9,'cafe',5,'1.0.0'),(10,'car_rental',1,'1.0.0'),(11,'car_repair',1,'1.0.0'),(12,'cargo_delivery',1,'1.0.0'),(13,'carpenter',2,'1.0.0'),(14,'charity_organization',4,'1.0.0'),(15,'clothes_store',3,'1.0.0'),(16,'coffee_shop',3,'1.0.0'),(17,'collection',9,'1.0.0'),(18,'construction_company',2,'1.0.0'),(19,'consulting_services',1,'1.0.0'),(20,'dance_studio',6,'1.0.0'),(21,'decorator',2,'1.0.0'),(22,'design_studio',6,'1.0.0'),(23,'designer',6,'1.0.0'),(24,'driving_school',8,'1.0.0'),(25,'electrician',2,'1.0.0'),(26,'environmental_organization',4,'1.0.0'),(27,'family',10,'1.0.0'),(28,'fitness_studio',7,'1.0.0'),(29,'generic',11,'1.0.0'),(30,'generic_shop',3,'1.0.0'),(31,'glazier',2,'1.0.0'),(32,'healthcare_center',7,'1.0.0'),(33,'hotel',5,'1.0.0'),(34,'house_painter',2,'1.0.0'),(35,'hvac',2,'1.0.0'),(36,'insurance_agency',1,'1.0.0'),(37,'language_school',8,'1.0.0'),(38,'language_travel',8,'1.0.0'),(39,'lawyer',1,'1.0.0'),(40,'library',4,'1.0.0'),(41,'movie_blog',9,'1.0.0'),(42,'movie_fan',9,'1.0.0'),(43,'museum',6,'1.0.0'),(44,'music_blog',9,'1.0.0'),(45,'musician',6,'1.0.0'),(46,'non_profit_organization',4,'1.0.0'),(47,'pet_shop',3,'1.0.0'),(48,'pharmacy',7,'1.0.0'),(49,'photographer',6,'1.0.0'),(50,'plumber',2,'1.0.0'),(51,'political_blog',9,'1.0.0'),(52,'political_party',4,'1.0.0'),(53,'portrait_studio',6,'1.0.0'),(54,'radio',4,'1.0.0'),(55,'religious_organization',4,'1.0.0'),(56,'residential_contractor',2,'1.0.0'),(57,'resume',10,'1.0.0'),(58,'roofer',2,'1.0.0'),(59,'seminar',4,'1.0.0'),(60,'sports_fan',9,'1.0.0'),(61,'theater',6,'1.0.0'),(62,'travel_agency',5,'1.0.0'),(63,'travel_blog',10,'1.0.0'),(64,'wedding',10,'1.0.0'),(65,'writer',6,'1.0.0');
/*!40000 ALTER TABLE `site_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_template_category`
--

DROP TABLE IF EXISTS `site_template_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_template_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_template_category`
--

LOCK TABLES `site_template_category` WRITE;
/*!40000 ALTER TABLE `site_template_category` DISABLE KEYS */;
INSERT INTO `site_template_category` VALUES (1,'Services'),(2,'ConstructionHousing'),(3,'Retail'),(4,'Organization'),(5,'Entertainmentleisure'),(6,'ArtsDesign'),(7,'HealthSport'),(8,'Education'),(9,'FanHobby'),(10,'Personal'),(11,'Other');
/*!40000 ALTER TABLE `site_template_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_version`
--

DROP TABLE IF EXISTS `site_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL DEFAULT '0',
  `version` int(11) NOT NULL DEFAULT '0',
  `chunk_version` varchar(8) DEFAULT NULL,
  `chunk` int(11) DEFAULT NULL,
  `finish_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_site_id` (`site_id`),
  KEY `key_site_id_version` (`site_id`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_version`
--

LOCK TABLES `site_version` WRITE;
/*!40000 ALTER TABLE `site_version` DISABLE KEYS */;
/*!40000 ALTER TABLE `site_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `template`
--

DROP TABLE IF EXISTS `template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(32) NOT NULL DEFAULT '',
  `is_active` int(11) NOT NULL DEFAULT '1',
  `template_category_id` int(11) NOT NULL DEFAULT '0',
  `version` varchar(16) NOT NULL DEFAULT '',
  `defaults` varchar(128) NOT NULL DEFAULT '',
  `header_upload_support` int(11) DEFAULT NULL,
  `keywords` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `template`
--

LOCK TABLES `template` WRITE;
/*!40000 ALTER TABLE `template` DISABLE KEYS */;
INSERT INTO `template` VALUES (1,'generic','Generic',1,1,'5.0.0','logo.gif|headers1|buttons1',NULL,NULL);
/*!40000 ALTER TABLE `template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `template_category`
--

DROP TABLE IF EXISTS `template_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `template_category`
--

LOCK TABLES `template_category` WRITE;
/*!40000 ALTER TABLE `template_category` DISABLE KEYS */;
INSERT INTO `template_category` VALUES (1,'Generic','Generic');
/*!40000 ALTER TABLE `template_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `template_property`
--

DROP TABLE IF EXISTS `template_property`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template_property` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_id` int(11) NOT NULL DEFAULT '0',
  `property` varchar(255) NOT NULL DEFAULT '',
  `default_value` varchar(255) NOT NULL DEFAULT '',
  `category` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_id_property` (`template_id`,`property`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `template_property`
--

LOCK TABLES `template_property` WRITE;
/*!40000 ALTER TABLE `template_property` DISABLE KEYS */;
INSERT INTO `template_property` VALUES (1,1,'color1','#aee3e0',1),(2,1,'color2','#edeed8',1),(3,1,'color3','#f38228',1),(4,1,'color4','#65cee3',1),(5,1,'type','fixed',2),(6,1,'width','780',2),(7,1,'sidebarFirst','0',2),(8,1,'sidebarFirstWidth','200',2),(9,1,'sidebarFirstPosition','left',2),(10,1,'sidebarSecond','0',2),(11,1,'sidebarSecondWidth','200',2),(12,1,'sidebarSecondPosition','right',2),(13,1,'verticalMargin','0',2),(14,1,'horizontalMargin','0',2),(15,1,'sidebarFirstMinHeight','200',2),(16,1,'sidebarSecondMinHeight','200',2),(17,1,'contentMinHeight','200',2),(18,1,'siteBackground','background-none',3),(19,1,'watermarkBackground','background-none',3),(20,1,'headerBackground','background-none',3),(21,1,'column1Background','background-none',3),(22,1,'column2Background','background-none',3),(23,1,'contentBackground','background-none',3),(24,1,'footerBackground','background-none',3),(25,1,'siteColor','',4),(26,1,'watermarkColor','',4),(27,1,'headerColor','',4),(28,1,'footerColor','',4),(29,1,'column1Color','',4),(30,1,'column2Color','',4),(31,1,'contentColor','',4),(32,1,'watermarkBorder','border1-black',5),(33,1,'headerBorder','border1-black',5),(34,1,'column1Border','border1-black',5),(35,1,'column2Border','border1-black',5),(36,1,'contentBorder','border1-black',5),(37,1,'footerBorder','border1-black',5),(38,1,'watermarkExternalBorder','external-border-none',6),(39,1,'textFont','Tahoma',7),(40,1,'textFontSize','13',7),(41,1,'textFontBold','0',7),(42,1,'textFontItalic','0',7),(43,1,'textFontUnderline','0',7),(44,1,'linkFontBold','0',7),(45,1,'linkFontItalic','0',7),(46,1,'linkFontUnderline','1',7),(47,1,'h1Font','Arial',7),(48,1,'h1FontSize','32',7),(49,1,'h1FontBold','1',7),(50,1,'h1FontItalic','0',7),(51,1,'h1FontUnderline','0',7),(52,1,'h2Font','Arial',7),(53,1,'h2FontSize','16',7),(54,1,'h2FontBold','1',7),(55,1,'h2FontItalic','0',7),(56,1,'h2FontUnderline','0',7),(57,1,'contentTextColor','',8),(58,1,'contentLinkColor','',8),(59,1,'contentH1Color','',8),(60,1,'contentH2Color','',8),(61,1,'headerTextColor','',8),(62,1,'headerLinkColor','',8),(63,1,'headerH1Color','',8),(64,1,'headerH2Color','',8),(65,1,'footerTextColor','',8),(66,1,'footerLinkColor','',8),(67,1,'footerH1Color','',8),(68,1,'footerH2Color','',8),(69,1,'column1TextColor','',8),(70,1,'column1LinkColor','',8),(71,1,'column1H1Color','',8),(72,1,'column1H2Color','',8),(73,1,'column2TextColor','',8),(74,1,'column2LinkColor','',8),(75,1,'column2H1Color','',8),(76,1,'column2H2Color','',8),(77,1,'logo','logo.gif',9),(78,1,'banner','headers1',9),(79,1,'customBanner','',9),(80,1,'button','buttons1',9);
/*!40000 ALTER TABLE `template_property` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `template_property_category`
--

DROP TABLE IF EXISTS `template_property_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template_property_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `template_property_category`
--

LOCK TABLES `template_property_category` WRITE;
/*!40000 ALTER TABLE `template_property_category` DISABLE KEYS */;
INSERT INTO `template_property_category` VALUES (1,'colorScheme'),(2,'layout'),(3,'background'),(4,'backgroundColor'),(5,'border'),(6,'external-border'),(7,'font'),(8,'fontColor'),(9,'custom');
/*!40000 ALTER TABLE `template_property_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `token_access`
--

DROP TABLE IF EXISTS `token_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token_id` varchar(32) DEFAULT '',
  `site_id` int(11) NOT NULL DEFAULT '0',
  `is_authorized` int(11) NOT NULL DEFAULT '0',
  `creation_date` varchar(25) DEFAULT '',
  `locale_id` int(11) NOT NULL DEFAULT '0',
  `skin_code` varchar(255) DEFAULT '',
  `session_id` varchar(32) DEFAULT '',
  `session_life_time` int(11) NOT NULL DEFAULT '0',
  `is_permanent` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `token_access`
--

LOCK TABLES `token_access` WRITE;
/*!40000 ALTER TABLE `token_access` DISABLE KEYS */;
/*!40000 ALTER TABLE `token_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trial_life_type`
--

DROP TABLE IF EXISTS `trial_life_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trial_life_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trial_life_type`
--

LOCK TABLES `trial_life_type` WRITE;
/*!40000 ALTER TABLE `trial_life_type` DISABLE KEYS */;
INSERT INTO `trial_life_type` VALUES (1,'Day'),(2,'Hour');
/*!40000 ALTER TABLE `trial_life_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upgrade`
--

DROP TABLE IF EXISTS `upgrade`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upgrade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(8) NOT NULL DEFAULT '',
  `chunk` int(11) NOT NULL,
  `status` varchar(4) DEFAULT NULL,
  `finish_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_upgrade_version_chunk` (`version`,`chunk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upgrade`
--

LOCK TABLES `upgrade` WRITE;
/*!40000 ALTER TABLE `upgrade` DISABLE KEYS */;
/*!40000 ALTER TABLE `upgrade` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `view`
--

DROP TABLE IF EXISTS `view`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `view` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `view`
--

LOCK TABLES `view` WRITE;
/*!40000 ALTER TABLE `view` DISABLE KEYS */;
/*!40000 ALTER TABLE `view` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `widget`
--

DROP TABLE IF EXISTS `widget`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(100) NOT NULL DEFAULT '0',
  `type_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `widget`
--

LOCK TABLES `widget` WRITE;
/*!40000 ALTER TABLE `widget` DISABLE KEYS */;
/*!40000 ALTER TABLE `widget` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `widget_contact_fields`
--

DROP TABLE IF EXISTS `widget_contact_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_contact_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `widget_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `type` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `required` int(11) NOT NULL DEFAULT '1',
  `weight` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_widget_id_name` (`widget_id`,`name`),
  KEY `key_widget_id` (`widget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `widget_contact_fields`
--

LOCK TABLES `widget_contact_fields` WRITE;
/*!40000 ALTER TABLE `widget_contact_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `widget_contact_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `widget_container`
--

DROP TABLE IF EXISTS `widget_container`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_container` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `container_id` int(11) NOT NULL DEFAULT '0',
  `widget_id` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_container_id_widget_id_position` (`container_id`,`widget_id`,`position`),
  KEY `key_container_id_position` (`container_id`,`position`),
  KEY `key_widget_id` (`widget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `widget_container`
--

LOCK TABLES `widget_container` WRITE;
/*!40000 ALTER TABLE `widget_container` DISABLE KEYS */;
/*!40000 ALTER TABLE `widget_container` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `widget_property`
--

DROP TABLE IF EXISTS `widget_property`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_property` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `widget_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_widget_id_name` (`widget_id`,`name`),
  KEY `key_widget_id` (`widget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `widget_property`
--

LOCK TABLES `widget_property` WRITE;
/*!40000 ALTER TABLE `widget_property` DISABLE KEYS */;
/*!40000 ALTER TABLE `widget_property` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `widget_type`
--

DROP TABLE IF EXISTS `widget_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `widget_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) DEFAULT '',
  `uuid` varchar(36) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `widget_type`
--

LOCK TABLES `widget_type` WRITE;
/*!40000 ALTER TABLE `widget_type` DISABLE KEYS */;
INSERT INTO `widget_type` VALUES (1,'container_fixed',''),(2,'container_vertical',''),(3,'text',''),(4,'header',''),(5,'navigation',''),(6,'contact',''),(7,'blog',''),(8,'shared_text',''),(9,'script',''),(10,'advertisement',''),(11,'search',''),(13,'breadcrumbs','');
/*!40000 ALTER TABLE `widget_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;

-- Dump completed on 2017-01-26  8:04:05