ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / letaweb / update

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;

DROP TABLE IF EXISTS `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;
DROP TABLE IF EXISTS `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 AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_zone_templates`
--
DROP TABLE IF EXISTS `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 AUTO_INCREMENT=134 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_modulelist`
--

INSERT INTO `tbl_modulelist` (`id`, `name`, `display_name`, `category`, `blog`, `ecommerce`, `authorization`, `priority`, `display`, `editable`) VALUES
(1, 'text', 'Text', 1, 0, 0, 1, 0, 1, 1),
(2, 'image', 'Image', 1, 0, 0, 1, 0, 1, 1),
(3, 'html', 'HTML', 1, 0, 0, 1, 0, 1, 1),
(4, 'iframe', 'Iframe', 1, 0, 0, 1, 0, 1, 1),
(9, 'slideshow', 'Slideshow', 2, 0, 0, 1, 0, 1, 1),
(13, 'gallery', 'Gallery', 2, 0, 0, 1, 0, 1, 1),
(16, 'youtube', 'Youtube', 3, 0, 0, 1, 0, 1, 1),
(19, 'facebooklike', 'Facebook Like', 4, 0, 0, 1, 0, 1, 1),
(20, 'facebookcomment', 'Facebook Comment', 4, 0, 0, 1, 0, 1, 1),
(22, 'tweet', 'Tweet this', 4, 0, 0, 1, 0, 0, 0),
(23, 'rssfeed', 'RSS Feed', 5, 0, 0, 1, 0, 0, 1),
(27, 'contactform', 'Contact Form', 6, 0, 0, 1, 0, 1, 1),
(30, 'googlemap', 'Google map', 7, 0, 0, 1, 0, 1, 1),
(41, 'button', 'Button', 11, 0, 0, 1, 0, 1, 1),
(42, 'menu', 'Menu', 11, 0, 0, 1, 0, 1, 1),
(43, 'tab', 'Tab', 12, 0, 0, 1, 0, 1, 1),
(49, 'accordion', 'Accordion', 12, 0, 0, 1, 2, 1, 1),
(50, 'social_buttons', 'Social buttons', 4, 0, 0, 1, 1, 1, 1),
(51, 'spacer', 'Spacer', 1, 0, 0, 1, 4, 1, 1),
(52, 'box', 'Box', 1, 0, 0, 1, 4, 1, 1),
(53, 'newsdetail', 'News Detail', 5, 0, 0, 1, 0, 1, 1),
(54, 'newslist', 'News List', 5, 0, 0, 1, 2, 1, 1),
(59, 'newscomment', 'News Comment Box', 5, 0, 0, 1, 0, 1, 1),
(60, 'audio_player', 'Audio', 3, 0, 0, 1, 0, 1, 1),
(68, 'newscategory', 'News Category', 5, 0, 0, 1, 0, 1, 1),
(70, 'line', 'Line', 1, 0, 0, 1, 0, 1, 1),
(71, 'zone', 'Zone', 1, 0, 0, 1, 0, 0, 1),
(73, 'recentnews', 'Recent news', 5, 1, 0, 1, 0, 0, 0),
(75, 'title', 'Title', 1, 0, 0, 1, 0, 1, 1),
(77, 'share_buttons', 'Share buttons', 4, 0, 0, 1, 0, 1, 1),
(79, 'pagination', 'Pagination', 1, 0, 0, 1, 0, 0, 1),
(86, 'row', 'Row', 1, 0, 0, 1, 0, 0, 1),
(89, 'embed', 'Embed', 1, 0, 0, 0, 9, 1, 1),
(91, 'video', 'Video', 3, 0, 0, 1, 0, 1, 1),
(92, 'slick', 'Slick Carousel', 2, 0, 0, 1, 0, 1, 1),
(102, 'progress_bar', 'Progress bar', 15, 0, 0, 1, 0, 1, 1),
(106, 'alert', 'Alert', 15, 0, 0, 1, 0, 1, 1),
(108, 'icon', 'Icon', 1, 0, 0, 1, 0, 1, 1),
(113, 'infobox', 'Info Box', 1, 0, 0, 1, 1, 1, 1),
(114, 'infotable', 'Info Table', 1, 0, 0, 1, 1, 1, 1),
(115, 'infobanner', 'Info Baner', 1, 0, 0, 1, 1, 1, 1),
(116, 'fancytext', 'Fancy Text', 1, 0, 0, 1, 1, 1, 1),
(118, 'typedtext', 'Typed Text', 1, 0, 0, 1, 1, 1, 1),
(119, 'mailchimp', 'MailChimp', 1, 0, 0, 1, 1, 1, 1),
(120, 'statcounter', 'Stat Counter', 1, 0, 0, 1, 1, 1, 1),
(121, 'countdown', 'Count down', 1, 0, 0, 1, 1, 1, 1),
(122, 'ihover', 'iHover', 1, 0, 0, 1, 0, 1, 1),
(128, 'facebookpage', 'Facebook Page', 4, 0, 0, 1, 1, 1, 1),
(129, 'facebookpost', 'Facebook Post', 4, 0, 0, 1, 1, 1, 1),
(130, 'facebooksend', 'Facebook Send', 4, 0, 0, 1, 1, 1, 1),
(131, 'facebookvideo', 'Facebook Video', 4, 0, 0, 1, 1, 1, 1),
(132, 'navbar', 'Navbar', 11, 0, 0, 1, 1, 1, 1),
(133, 'pricetable', 'Price table', 1, 0, 0, 1, 1, 1, 1);

DROP TABLE IF EXISTS `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 AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_library_script`
--

INSERT INTO `tbl_library_script` (`id`, `name`, `inline`, `admin`, `edit`, `in_library`, `type`, `priority`) VALUES
(1, 'jquery', 0, 0, 0, 1, 1, 1),
(2, 'jquery.metadata', 0, 1, 0, 1, 1, 1),
(3, 'jquery-ui/jquery-ui.min', 0, 1, 0, 1, 1, 1),
(4, 'jquery.dataTables.min', 0, 1, 0, 1, 1, 1),
(15, 'codemirror', 0, 1, 0, 1, 1, 1),
(17, 'css', 0, 1, 0, 1, 1, 1),
(18, 'javascript', 0, 1, 0, 1, 1, 1),
(19, 'xml', 0, 1, 0, 1, 1, 1),
(20, 'htmlmixed', 0, 1, 0, 1, 1, 1),
(25, 'plupload/plupload.full', 0, 1, 0, 1, 1, 1),
(26, 'base', 0, 1, 0, 1, 1, 1),
(28, 'jquery.json-2.4.min', 0, 1, 0, 1, 1, 1),
(29, 'pace.min', 0, 1, 0, 1, 1, 1),
(30, 'jQuery-Tags-Input/jquery.tagsinput.min', 0, 1, 0, 1, 1, 1),
(31, 'jquery-migrate', 0, 1, 1, 1, 1, 1),
(32, 'bootstrap.min', 1, 1, 1, 1, 1, 7),
(33, 'angular/angular.min', 0, 1, 0, 1, 1, 1),
(34, 'angular/angular-ui-router', 0, 1, 0, 1, 1, 1),
(35, 'angular/ct-ui-router-extras.min', 0, 1, 0, 1, 1, 1),
(36, 'angular/sortable', 0, 1, 0, 1, 1, 1),
(37, 'angular/ui-bootstrap-tpls-1.2.4.min', 0, 1, 0, 1, 1, 1),
(39, 'angular/angular-datatables.min', 0, 1, 0, 1, 1, 1),
(40, 'angular/datetimepicker', 0, 1, 0, 1, 1, 1),
(41, 'angular/angular-ng-context-menu', 0, 1, 0, 1, 1, 1),
(42, 'angular/ngStorage.min', 0, 1, 0, 1, 1, 1),
(43, 'ckeditor_full/ckeditor', 0, 1, 0, 1, 1, 1),
(44, 'require', 0, 1, 0, 1, 1, 1),
(45, 'jquery.dataTables.min', 0, 1, 0, 0, 2, 1),
(46, 'datetimepicker', 0, 1, 0, 0, 2, 1),
(47, 'dialog', 0, 1, 0, 0, 1, 1),
(48, 'editor/pagemanager', 0, 1, 0, 0, 1, 1),
(49, 'editor/pagemanager.modules', 0, 1, 0, 0, 1, 1),
(50, 'editor/pagemanager.iframe', 0, 1, 0, 0, 1, 1),
(51, 'language', 0, 1, 0, 0, 1, 1),
(52, 'editor/base', 0, 1, 0, 0, 1, 2),
(53, 'stgrid', 0, 1, 0, 0, 1, 1),
(54, 'im', 0, 1, 0, 0, 1, 1),
(55, 'ssultils', 0, 1, 0, 0, 1, 1),
(58, 'colorutils', 0, 1, 0, 0, 1, 1),
(59, 'palette', 0, 1, 0, 0, 1, 1),
(61, 'colorpicker', 0, 1, 0, 0, 1, 1),
(63, 'skinutils', 0, 1, 0, 0, 1, 1),
(64, 'ui.tab-editing', 0, 1, 0, 0, 1, 1),
(65, 'ui.tab-content', 0, 1, 0, 0, 1, 1),
(66, 'ui.category-editing', 0, 1, 0, 0, 1, 1),
(67, 'ui.dbfilter-editing', 0, 1, 0, 0, 1, 1),
(72, 'stEditor', 0, 1, 0, 0, 1, 1),
(74, 'popup', 0, 1, 0, 0, 1, 1),
(75, 'font-awesome', 1, 1, 1, 0, 2, 0),
(76, 'bootstrap.min', 1, 1, 1, 0, 2, 0),
(77, 'admin', 0, 1, 0, 0, 2, 0),
(78, 'codemirror', 0, 1, 0, 0, 2, 0),
(79, 'colorpicker', 0, 1, 0, 0, 2, 0),
(80, 'editor', 0, 1, 0, 0, 2, 0),
(81, 'widget', 0, 1, 0, 0, 2, 0),
(82, 'pace.default', 1, 1, 1, 0, 2, 0),
(83, 'ng-table.min', 0, 1, 0, 0, 2, 0),
(84, 'common', 1, 0, 1, 0, 2, 0),
(85, 'jquery.easing', 1, 1, 1, 1, 1, 0),
(86, 'edit_page', 0, 0, 1, 0, 2, 0),
(87, 'jquery.hover', 0, 0, 1, 1, 1, 0),
(88, 'jquery.ui.core', 0, 0, 1, 1, 1, 0),
(89, 'jquery.ui.widget', 0, 0, 1, 1, 1, 0),
(91, 'jquery.ui.mouse', 0, 0, 1, 1, 1, 0),
(92, 'jquery.ui.draggable', 0, 0, 1, 1, 1, 0),
(93, 'jquery.ui.resizable', 0, 0, 1, 1, 1, 0),
(95, 'common-ui', 1, 1, 1, 0, 2, 0),
(96, 'slick/slick', 1, 0, 1, 1, 1, 0),
(97, 'slick/slick-theme', 1, 0, 1, 0, 2, 0),
(98, 'slick/slick', 1, 0, 1, 0, 2, 0),
(99, 'tabs', 1, 0, 1, 1, 1, 0),
(100, 'ckeditor_standard/ckeditor', 0, 0, 1, 1, 1, 1),
(104, 'animate.min', 1, 0, 1, 0, 2, 1),
(105, 'dataTables.columnFilter', 0, 1, 0, 1, 1, 1),
(106, 'angular/angular-datatables.columnfilter', 0, 1, 0, 1, 1, 1),
(107, 'ui-iconpicker/ui-iconpicker', 0, 1, 0, 1, 1, 1),
(108, 'ui-iconpicker/ui-iconpicker', 0, 1, 0, 1, 2, 1),
(109, 'linecons/flaticon', 1, 1, 1, 1, 2, 1),
(110, 'open-iconic/font/css/open-iconic', 1, 1, 1, 1, 2, 1),
(111, 'typicons.font/font/typicons.min', 1, 1, 1, 1, 2, 1),
(112, 'wow.min', 1, 0, 1, 1, 1, 1),
(113, 'jquery.rd-parallax', 1, 0, 1, 1, 1, 1),
(114, 'twig.min', 0, 1, 0, 1, 1, 1),
(115, 'jqvmap/jqvmap', 0, 1, 0, 0, 2, 1),
(116, 'jqvmap/jquery.vmap.min', 0, 1, 0, 1, 1, 1),
(117, 'jqvmap/maps/jquery.vmap.world', 0, 1, 0, 1, 1, 1),
(118, 'flot/jquery.flot', 0, 1, 0, 1, 1, 1),
(119, 'flot/jquery.flot.resize.min', 0, 1, 0, 1, 1, 1),
(120, 'jquery-migrate', 1, 1, 0, 1, 1, 1);

--
-- Indexes for dumped tables
--

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