Gecko [ new.puissanc-elec.fr ]

Name	Size	Permission
config	[ DIR ]	drwx---r-x
controllers	[ DIR ]	drwx---r-x
models	[ DIR ]	drwx---r-x
runtime	[ DIR ]	drwx---r-x
views	[ DIR ]	drwx---r-x
data.sql	151.8 KB	-rw----r--
sql.sql	43.11 KB	-rw----r--

Code Editor : sql.sql

-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 18, 2016 at 11:44 AM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

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

--
-- Database: `stsbuilder_nocommerce`
--

-- --------------------------------------------------------

--
-- Table structure for table `authassignment`
--

CREATE TABLE IF NOT EXISTS `authassignment` (
  `itemname` varchar(64) NOT NULL,
  `userid` varchar(64) NOT NULL,
  `bizrule` text,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `authitem`
--

CREATE TABLE IF NOT EXISTS `authitem` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text,
  `bizrule` text,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `authitemchild`
--

CREATE TABLE IF NOT EXISTS `authitemchild` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_authassignment`
--

CREATE TABLE IF NOT EXISTS `tbla_authassignment` (
  `itemname` varchar(64) NOT NULL,
  `userid` varchar(64) NOT NULL,
  `bizrule` text,
  `data` text,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_colors`
--

CREATE TABLE IF NOT EXISTS `tbla_colors` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `color1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color2` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color3` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color4` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color5` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_modified` datetime NOT NULL,
  `date_added` datetime NOT NULL,
  `author_id` int(11) NOT NULL,
  `last_modified_by` int(11) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_configurations`
--

CREATE TABLE IF NOT EXISTS `tbla_configurations` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `data_type` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_contributors`
--

CREATE TABLE IF NOT EXISTS `tbla_contributors` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `site_id` int(11) NOT NULL,
  `role` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_contributor_invites`
--

CREATE TABLE IF NOT EXISTS `tbla_contributor_invites` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permission` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `site_id` int(11) NOT NULL,
  `creator_id` int(11) NOT NULL,
  `last_modified_by` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_form_data`
--

CREATE TABLE IF NOT EXISTS `tbla_form_data` (
  `form_id` int(11) NOT NULL,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_news`
--

CREATE TABLE IF NOT EXISTS `tbla_news` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `unique_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `summary` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `viewed` int(11) DEFAULT '0',
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `last_modify_id` int(11) NOT NULL,
  `date_available` datetime DEFAULT NULL,
  `status` int(11) NOT NULL,
  `main_category_id` int(11) DEFAULT NULL,
  `tags` text COLLATE utf8_unicode_ci,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow_comment` int(11) DEFAULT '1',
  `author_id` int(11) NOT NULL,
  `og_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `og_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_news_categories`
--

CREATE TABLE IF NOT EXISTS `tbla_news_categories` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` int(255) NOT NULL,
  `seo_title` int(11) NOT NULL,
  `og_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `og_title` int(255) NOT NULL,
  `sort_order` int(11) DEFAULT '1',
  `date_added` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_news_comments`
--

CREATE TABLE IF NOT EXISTS `tbla_news_comments` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `parent_id` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '1',
  `viewed` int(11) DEFAULT '0',
  `date_added` datetime DEFAULT NULL,
  `approved` int(11) DEFAULT '0',
  `date_approved` datetime DEFAULT NULL,
  `is_spam` int(11) DEFAULT '0',
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_news_news_categories`
--

CREATE TABLE IF NOT EXISTS `tbla_news_news_categories` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_news_tags`
--

CREATE TABLE IF NOT EXISTS `tbla_news_tags` (
  `news_id` int(11) NOT NULL,
  `tags_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_pages`
--

CREATE TABLE IF NOT EXISTS `tbla_pages` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_homepage` int(11) DEFAULT '0',
  `system_page` int(11) DEFAULT '0',
  `is_movable` tinyint(1) NOT NULL DEFAULT '1',
  `can_haschild` tinyint(1) NOT NULL DEFAULT '1',
  `is_protected` tinyint(1) NOT NULL DEFAULT '0',
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) DEFAULT '1',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `favicon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sample_page` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login_required` int(11) NOT NULL DEFAULT '0',
  `no_display` int(11) NOT NULL DEFAULT '0',
  `date_added` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `author_id` int(11) DEFAULT '0',
  `last_modify_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_skins`
--

CREATE TABLE IF NOT EXISTS `tbla_skins` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `css` text COLLATE utf8_unicode_ci,
  `html` text COLLATE utf8_unicode_ci,
  `format` int(11) DEFAULT '0',
  `date_added` datetime DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `last_modified_by` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_tags`
--

CREATE TABLE IF NOT EXISTS `tbla_tags` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbla_users`
--

CREATE TABLE IF NOT EXISTS `tbla_users` (
  `id` int(11) NOT NULL,
  `inline_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `username` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `last_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `last_host` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `login_attempts` int(11) NOT NULL,
  `total_logins` int(11) NOT NULL,
  `date_blocked` datetime NOT NULL,
  `date_expires` datetime NOT NULL,
  `date_active` datetime NOT NULL,
  `date_login` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_authitem`
--

CREATE TABLE IF NOT EXISTS `tbl_authitem` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `display` int(11) NOT NULL,
  `description` text,
  `bizrule` text,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_authitemchild`
--

CREATE TABLE IF NOT EXISTS `tbl_authitemchild` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_category`
--

CREATE TABLE IF NOT EXISTS `tbl_category` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(512) DEFAULT NULL,
  `order` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Galleries';

-- --------------------------------------------------------

--
-- Table structure for table `tbl_colorscheme`
--

CREATE TABLE IF NOT EXISTS `tbl_colorscheme` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `color1` varchar(10) NOT NULL,
  `color2` varchar(10) NOT NULL,
  `color3` varchar(10) NOT NULL,
  `color4` varchar(10) NOT NULL,
  `color5` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_configuration`
--

CREATE TABLE IF NOT EXISTS `tbl_configuration` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_content`
--

CREATE TABLE IF NOT EXISTS `tbl_content` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_help_categories`
--

CREATE TABLE IF NOT EXISTS `tbl_help_categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ipn_message_log`
--

CREATE TABLE IF NOT EXISTS `tbl_ipn_message_log` (
  `id` int(11) NOT NULL,
  `subscription_id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_language`
--

CREATE TABLE IF NOT EXISTS `tbl_language` (
  `id` int(11) NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_languages`
--

CREATE TABLE IF NOT EXISTS `tbl_languages` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `code` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `code2` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `locale` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `charset` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `raw_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `raw_time` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `raw_datetime` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `format_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `format_time` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `format_datetime` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `decimal_point` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `thousands_sep` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `currency_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `priority` tinyint(2) NOT NULL,
  `date_modified` datetime NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_library_script`
--

CREATE TABLE IF NOT EXISTS `tbl_library_script` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `inline` tinyint(1) NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '0',
  `in_library` tinyint(1) NOT NULL DEFAULT '1',
  `type` int(10) NOT NULL DEFAULT '1',
  `priority` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mail_templates`
--

CREATE TABLE IF NOT EXISTS `tbl_mail_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `deletable` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_modulecategory`
--

CREATE TABLE IF NOT EXISTS `tbl_modulecategory` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `blog` int(11) NOT NULL,
  `ecommerce` int(11) NOT NULL,
  `priority` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_modulelist`
--

CREATE TABLE IF NOT EXISTS `tbl_modulelist` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `category` int(11) NOT NULL,
  `blog` int(11) NOT NULL,
  `ecommerce` int(11) NOT NULL,
  `authorization` tinyint(1) NOT NULL DEFAULT '1',
  `priority` int(11) NOT NULL,
  `display` tinyint(1) NOT NULL,
  `editable` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_module_data`
--

CREATE TABLE IF NOT EXISTS `tbl_module_data` (
  `id` int(11) NOT NULL,
  `module_name` varchar(255) NOT NULL,
  `view` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `backend` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `scripts` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `styles` text NOT NULL,
  `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_page`
--

CREATE TABLE IF NOT EXISTS `tbl_page` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `template` int(11) NOT NULL,
  `is_template` int(11) NOT NULL DEFAULT '0',
  `expired_date` datetime NOT NULL,
  `can_expire` tinyint(1) NOT NULL DEFAULT '0',
  `category` int(20) NOT NULL,
  `is_template_active` int(11) NOT NULL DEFAULT '1',
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `asset_size` int(11) NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '0',
  `owner_id` int(11) NOT NULL,
  `create_step` int(11) NOT NULL DEFAULT '1',
  `is_created_complete` tinyint(1) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL,
  `plan_id` int(20) NOT NULL,
  `db_id` int(11) NOT NULL,
  `db_table_prefix` varchar(10) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `last_modified_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_page_domain`
--

CREATE TABLE IF NOT EXISTS `tbl_page_domain` (
  `site_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `creator_id` int(11) NOT NULL,
  `last_modified_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_page_installation`
--

CREATE TABLE IF NOT EXISTS `tbl_page_installation` (
  `id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_complete` int(11) NOT NULL DEFAULT '0',
  `step` int(11) NOT NULL DEFAULT '0',
  `is_active` int(11) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_page_type`
--

CREATE TABLE IF NOT EXISTS `tbl_page_type` (
  `name` varchar(255) NOT NULL,
  `display_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plan`
--

CREATE TABLE IF NOT EXISTS `tbl_plan` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `monthly_stripe_id` varchar(30) NOT NULL,
  `yearly_stripe_id` varchar(30) NOT NULL,
  `monthly_amount` double NOT NULL,
  `yearly_amount` double NOT NULL,
  `display` tinyint(1) NOT NULL DEFAULT '1',
  `deleable` int(11) NOT NULL DEFAULT '1',
  `priority` int(1) NOT NULL DEFAULT '1',
  `currency` varchar(3) NOT NULL,
  `unit_prefix` varchar(3) NOT NULL,
  `unit_postfix` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plan_addition`
--

CREATE TABLE IF NOT EXISTS `tbl_plan_addition` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plan_condition`
--

CREATE TABLE IF NOT EXISTS `tbl_plan_condition` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plan_description`
--

CREATE TABLE IF NOT EXISTS `tbl_plan_description` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plan_module`
--

CREATE TABLE IF NOT EXISTS `tbl_plan_module` (
  `plan_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_popup_script`
--

CREATE TABLE IF NOT EXISTS `tbl_popup_script` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase`
--

CREATE TABLE IF NOT EXISTS `tbl_purchase` (
  `id` bigint(20) NOT NULL,
  `subscription_id` int(20) NOT NULL,
  `cycle` varchar(10) NOT NULL,
  `site_id` int(11) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `currency_code` varchar(3) NOT NULL,
  `token` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `creator_id` bigint(20) NOT NULL,
  `last_modified_by` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sample_page`
--

CREATE TABLE IF NOT EXISTS `tbl_sample_page` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `thumbnail` varchar(50) NOT NULL,
  `priority` int(11) DEFAULT '1',
  `is_active` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sample_page_categories`
--

CREATE TABLE IF NOT EXISTS `tbl_sample_page_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_social_share_buttons`
--

CREATE TABLE IF NOT EXISTS `tbl_social_share_buttons` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_subscription`
--

CREATE TABLE IF NOT EXISTS `tbl_subscription` (
  `id` bigint(20) NOT NULL,
  `site_id` int(11) NOT NULL,
  `profile_id` varchar(30) NOT NULL,
  `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `plan_id` varchar(30) NOT NULL,
  `payment_type` varchar(20) NOT NULL,
  `cycle` varchar(10) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `status` varchar(10) NOT NULL,
  `last_payment_date` datetime NOT NULL,
  `last_payment_amount` float NOT NULL,
  `last_transaction_id` varchar(20) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `creator_id` bigint(20) NOT NULL,
  `last_modified_by` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_term`
--

CREATE TABLE IF NOT EXISTS `tbl_term` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value_en` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `javascript` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ticket`
--

CREATE TABLE IF NOT EXISTS `tbl_ticket` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `title` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '1',
  `view` int(11) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `last_modified_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ticket_answer`
--

CREATE TABLE IF NOT EXISTS `tbl_ticket_answer` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `date_modified` datetime NOT NULL,
  `last_modified_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_update`
--

CREATE TABLE IF NOT EXISTS `tbl_update` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `sql` text NOT NULL,
  `delete_files` varchar(900) NOT NULL,
  `release_date` datetime NOT NULL,
  `description` text NOT NULL,
  `important` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `id` bigint(20) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(100) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `activation_key` varchar(100) NOT NULL,
  `is_admin` tinyint(1) DEFAULT '0',
  `is_active` tinyint(1) NOT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  `private_key` varchar(50) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_data`
--

CREATE TABLE IF NOT EXISTS `tbl_user_data` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `data` text NOT NULL,
  `name` varchar(100) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_recover_password`
--

CREATE TABLE IF NOT EXISTS `tbl_user_recover_password` (
  `user_id` int(11) NOT NULL,
  `code` varchar(100) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `is_used` int(11) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_session`
--

CREATE TABLE IF NOT EXISTS `tbl_user_session` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_websitecategory`
--

CREATE TABLE IF NOT EXISTS `tbl_websitecategory` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_zone_templates`
--

CREATE TABLE IF NOT EXISTS `tbl_zone_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `yiilog`
--

CREATE TABLE IF NOT EXISTS `yiilog` (
  `id` int(11) NOT NULL,
  `level` varchar(128) DEFAULT NULL,
  `category` varchar(128) DEFAULT NULL,
  `logtime` int(11) DEFAULT NULL,
  `message` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `yiisession`
--

CREATE TABLE IF NOT EXISTS `yiisession` (
  `id` char(32) NOT NULL,
  `expire` int(11) DEFAULT NULL,
  `data` longblob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `authassignment`
--
ALTER TABLE `authassignment`
  ADD PRIMARY KEY (`itemname`,`userid`);

--
-- Indexes for table `authitem`
--
ALTER TABLE `authitem`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `authitemchild`
--
ALTER TABLE `authitemchild`
  ADD PRIMARY KEY (`parent`,`child`),
  ADD KEY `child` (`child`);

--
-- Indexes for table `tbla_authassignment`
--
ALTER TABLE `tbla_authassignment`
  ADD PRIMARY KEY (`itemname`,`userid`,`site_id`);

--
-- Indexes for table `tbla_colors`
--
ALTER TABLE `tbla_colors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_configurations`
--
ALTER TABLE `tbla_configurations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbla_contributors`
--
ALTER TABLE `tbla_contributors`
  ADD PRIMARY KEY (`user_id`,`site_id`,`role`);

--
-- Indexes for table `tbla_contributor_invites`
--
ALTER TABLE `tbla_contributor_invites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_news`
--
ALTER TABLE `tbla_news`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_name_2` (`unique_name`,`site_id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_news_categories`
--
ALTER TABLE `tbla_news_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_news_comments`
--
ALTER TABLE `tbla_news_comments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_news_news_categories`
--
ALTER TABLE `tbla_news_news_categories`
  ADD PRIMARY KEY (`news_id`,`category_id`,`site_id`);

--
-- Indexes for table `tbla_news_tags`
--
ALTER TABLE `tbla_news_tags`
  ADD PRIMARY KEY (`news_id`,`tags_id`,`site_id`);

--
-- Indexes for table `tbla_pages`
--
ALTER TABLE `tbla_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_skins`
--
ALTER TABLE `tbla_skins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_tags`
--
ALTER TABLE `tbla_tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbla_users`
--
ALTER TABLE `tbla_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inline_id` (`inline_id`,`site_id`);

--
-- Indexes for table `tbl_authitem`
--
ALTER TABLE `tbl_authitem`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `tbl_authitemchild`
--
ALTER TABLE `tbl_authitemchild`
  ADD PRIMARY KEY (`parent`,`child`),
  ADD KEY `child` (`child`);

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_colorscheme`
--
ALTER TABLE `tbl_colorscheme`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_configuration`
--
ALTER TABLE `tbl_configuration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_content`
--
ALTER TABLE `tbl_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `tbl_help_categories`
--
ALTER TABLE `tbl_help_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_ipn_message_log`
--
ALTER TABLE `tbl_ipn_message_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_language`
--
ALTER TABLE `tbl_language`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `key` (`name`);

--
-- Indexes for table `tbl_library_script`
--
ALTER TABLE `tbl_library_script`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_mail_templates`
--
ALTER TABLE `tbl_mail_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `tbl_modulecategory`
--
ALTER TABLE `tbl_modulecategory`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_modulelist`
--
ALTER TABLE `tbl_modulelist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_module_data`
--
ALTER TABLE `tbl_module_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_page`
--
ALTER TABLE `tbl_page`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `tbl_page_domain`
--
ALTER TABLE `tbl_page_domain`
  ADD UNIQUE KEY `page_id` (`site_id`,`name`);

--
-- Indexes for table `tbl_page_installation`
--
ALTER TABLE `tbl_page_installation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_page_type`
--
ALTER TABLE `tbl_page_type`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `tbl_plan`
--
ALTER TABLE `tbl_plan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_plan_addition`
--
ALTER TABLE `tbl_plan_addition`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_plan_condition`
--
ALTER TABLE `tbl_plan_condition`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_plan_description`
--
ALTER TABLE `tbl_plan_description`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_plan_module`
--
ALTER TABLE `tbl_plan_module`
  ADD PRIMARY KEY (`plan_id`,`module_id`);

--
-- Indexes for table `tbl_popup_script`
--
ALTER TABLE `tbl_popup_script`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase`
--
ALTER TABLE `tbl_purchase`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sample_page`
--
ALTER TABLE `tbl_sample_page`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `tbl_sample_page_categories`
--
ALTER TABLE `tbl_sample_page_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_social_share_buttons`
--
ALTER TABLE `tbl_social_share_buttons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_subscription`
--
ALTER TABLE `tbl_subscription`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_term`
--
ALTER TABLE `tbl_term`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_ticket`
--
ALTER TABLE `tbl_ticket`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_ticket_answer`
--
ALTER TABLE `tbl_ticket_answer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_update`
--
ALTER TABLE `tbl_update`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user_data`
--
ALTER TABLE `tbl_user_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user_session`
--
ALTER TABLE `tbl_user_session`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_websitecategory`
--
ALTER TABLE `tbl_websitecategory`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_zone_templates`
--
ALTER TABLE `tbl_zone_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `yiilog`
--
ALTER TABLE `yiilog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `yiisession`
--
ALTER TABLE `yiisession`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbla_colors`
--
ALTER TABLE `tbla_colors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_configurations`
--
ALTER TABLE `tbla_configurations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_contributor_invites`
--
ALTER TABLE `tbla_contributor_invites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_news`
--
ALTER TABLE `tbla_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_news_categories`
--
ALTER TABLE `tbla_news_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_news_comments`
--
ALTER TABLE `tbla_news_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_pages`
--
ALTER TABLE `tbla_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_skins`
--
ALTER TABLE `tbla_skins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_tags`
--
ALTER TABLE `tbla_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbla_users`
--
ALTER TABLE `tbla_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_colorscheme`
--
ALTER TABLE `tbl_colorscheme`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_configuration`
--
ALTER TABLE `tbl_configuration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_content`
--
ALTER TABLE `tbl_content`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_help_categories`
--
ALTER TABLE `tbl_help_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_ipn_message_log`
--
ALTER TABLE `tbl_ipn_message_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_language`
--
ALTER TABLE `tbl_language`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_library_script`
--
ALTER TABLE `tbl_library_script`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_mail_templates`
--
ALTER TABLE `tbl_mail_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_modulecategory`
--
ALTER TABLE `tbl_modulecategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_modulelist`
--
ALTER TABLE `tbl_modulelist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_module_data`
--
ALTER TABLE `tbl_module_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_page`
--
ALTER TABLE `tbl_page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_page_installation`
--
ALTER TABLE `tbl_page_installation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_plan`
--
ALTER TABLE `tbl_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_plan_addition`
--
ALTER TABLE `tbl_plan_addition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_plan_condition`
--
ALTER TABLE `tbl_plan_condition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_plan_description`
--
ALTER TABLE `tbl_plan_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_popup_script`
--
ALTER TABLE `tbl_popup_script`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_purchase`
--
ALTER TABLE `tbl_purchase`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_sample_page`
--
ALTER TABLE `tbl_sample_page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_sample_page_categories`
--
ALTER TABLE `tbl_sample_page_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_social_share_buttons`
--
ALTER TABLE `tbl_social_share_buttons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_subscription`
--
ALTER TABLE `tbl_subscription`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_term`
--
ALTER TABLE `tbl_term`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_ticket`
--
ALTER TABLE `tbl_ticket`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_ticket_answer`
--
ALTER TABLE `tbl_ticket_answer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_update`
--
ALTER TABLE `tbl_update`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_user_data`
--
ALTER TABLE `tbl_user_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_user_session`
--
ALTER TABLE `tbl_user_session`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_websitecategory`
--
ALTER TABLE `tbl_websitecategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_zone_templates`
--
ALTER TABLE `tbl_zone_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `yiilog`
--
ALTER TABLE `yiilog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
/*!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 */;

${this.title}

Code Editor : sql.sql