PHP Classes

File: Install/Sql/core_1.03.01032017.sql

Recommend this page to a friend!
  Classes of Duong Huynh Nghia   Lego PHP   Install/Sql/core_1.03.01032017.sql   Download  
File: Install/Sql/core_1.03.01032017.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Lego PHP
Blog and shopping cart system
Author: By
Last change:
Date: 7 years ago
Size: 35,452 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS `#_#####_#category` ( `category_id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL, `parent_id` int(11) NOT NULL DEFAULT '0', `is_active` int(1) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', `category_type` varchar(20) NOT NULL DEFAULT 'system', `params` text, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#country` ( `country_id` int(11) NOT NULL AUTO_INCREMENT, `country_code` varchar(2) NOT NULL, `country_name` varchar(255) NOT NULL, `country_phone` varchar(5) DEFAULT NULL, PRIMARY KEY (`country_id`) ) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#country` VALUES("1","AF","Afghanistan","+93"), ("2","AL","Albania","+355"), ("3","DZ","Algeria","+213"), ("4","AS","American Samoa","+1"), ("5","AD","Andorra","+376"), ("6","AO","Angola","+244"), ("7","AI","Anguilla","+1"), ("8","AG","Antigua","+1"), ("9","AR","Argentina","+54"), ("10","AM","Armenia","+374"), ("11","AW","Aruba","+297"), ("12","AU","Australia","+61"), ("13","AT","Austria","+43"), ("14","AZ","Azerbaijan","+994"), ("15","BH","Bahrain","+973"), ("16","BD","Bangladesh","+880"), ("17","BB","Barbados","+1"), ("18","BY","Belarus","+375"), ("19","BE","Belgium","+32"), ("20","BZ","Belize","+501"), ("21","BJ","Benin","+229"), ("22","BM","Bermuda","+1"), ("23","BT","Bhutan","+975"), ("24","BO","Bolivia","+591"), ("25","BA","Bosnia and Herzegovina","+387"), ("26","BW","Botswana","+267"), ("27","BR","Brazil","+55"), ("28","IO","British Indian Ocean Territory","+246"), ("29","VG","British Virgin Islands","+1"), ("30","BN","Brunei","+673"), ("31","BG","Bulgaria","+359"), ("32","BF","Burkina Faso","+226"), ("33","MM","Burma Myanmar","+95"), ("34","BI","Burundi","+257"), ("35","KH","Cambodia","+855"), ("36","CM","Cameroon","+237"), ("37","CA","Canada","+1"), ("38","CV","Cape Verde","+238"), ("39","KY","Cayman Islands","+1"), ("40","CF","Central African Republic","+236"), ("41","TD","Chad","+235"), ("42","CL","Chile","+56"), ("43","CN","China","+86"), ("44","CO","Colombia","+57"), ("45","KM","Comoros","+269"), ("46","CK","Cook Islands","+682"), ("47","CR","Costa Rica","+506"), ("48","CI","Côte d\'Ivoire","+225"), ("49","HR","Croatia","+385"), ("50","CU","Cuba","+53"), ("51","CY","Cyprus","+357"), ("52","CZ","Czech Republic","+420"), ("53","CD","Democratic Republic of Congo","+243"), ("54","DK","Denmark","+45"), ("55","DJ","Djibouti","+253"), ("56","DM","Dominica","+1"), ("57","DO","Dominican Republic","+1"), ("58","EC","Ecuador","+593"), ("59","EG","Egypt","+20"), ("60","SV","El Salvador","+503"), ("61","GQ","Equatorial Guinea","+240"), ("62","ER","Eritrea","+291"), ("63","EE","Estonia","+372"), ("64","ET","Ethiopia","+251"), ("65","FK","Falkland Islands","+500"), ("66","FO","Faroe Islands","+298"), ("67","FM","Federated States of Micronesia","+691"), ("68","FJ","Fiji","+679"), ("69","FI","Finland","+358"), ("70","FR","France","+33"), ("71","GF","French Guiana","+594"), ("72","PF","French Polynesia","+689"), ("73","GA","Gabon","+241"), ("74","GE","Georgia","+995"), ("75","DE","Germany","+49"), ("76","GH","Ghana","+233"), ("77","GI","Gibraltar","+350"), ("78","GR","Greece","+30"), ("79","GL","Greenland","+299"), ("80","GD","Grenada","+1"), ("81","GP","Guadeloupe","+590"), ("82","GU","Guam","+1"), ("83","GT","Guatemala","+502"), ("84","GN","Guinea","+224"), ("85","GW","Guinea-Bissau","+245"), ("86","GY","Guyana","+592"), ("87","HT","Haiti","+509"), ("88","HN","Honduras","+504"), ("89","HK","Hong Kong","+852"), ("90","HU","Hungary","+36"), ("91","IS","Iceland","+354"), ("92","IN","India","+91"), ("93","ID","Indonesia","+62"), ("94","IR","Iran","+98"), ("95","IQ","Iraq","+964"), ("96","IE","Ireland","+353"), ("97","IL","Israel","+972"), ("98","IT","Italy","+39"), ("99","JM","Jamaica","+1"), ("100","JP","Japan","+81"); --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#country` VALUES("101","JO","Jordan","+962"), ("102","KZ","Kazakhstan","+7"), ("103","KE","Kenya","+254"), ("104","KI","Kiribati","+686"), ("105","XK","Kosovo","+381"), ("106","KW","Kuwait","+965"), ("107","KG","Kyrgyzstan","+996"), ("108","LA","Laos","+856"), ("109","LV","Latvia","+371"), ("110","LB","Lebanon","+961"), ("111","LS","Lesotho","+266"), ("112","LR","Liberia","+231"), ("113","LY","Libya","+218"), ("114","LI","Liechtenstein","+423"), ("115","LT","Lithuania","+370"), ("116","LU","Luxembourg","+352"), ("117","MO","Macau","+853"), ("118","MK","Macedonia","+389"), ("119","MG","Madagascar","+261"), ("120","MW","Malawi","+265"), ("121","MY","Malaysia","+60"), ("122","MV","Maldives","+960"), ("123","ML","Mali","+223"), ("124","MT","Malta","+356"), ("125","MH","Marshall Islands","+692"), ("126","MQ","Martinique","+596"), ("127","MR","Mauritania","+222"), ("128","MU","Mauritius","+230"), ("129","YT","Mayotte","+262"), ("130","MX","Mexico","+52"), ("131","MD","Moldova","+373"), ("132","MC","Monaco","+377"), ("133","MN","Mongolia","+976"), ("134","ME","Montenegro","+382"), ("135","MS","Montserrat","+1"), ("136","MA","Morocco","+212"), ("137","MZ","Mozambique","+258"), ("138","NA","Namibia","+264"), ("139","NR","Nauru","+674"), ("140","NP","Nepal","+977"), ("141","NL","Netherlands","+31"), ("142","AN","Netherlands Antilles","+599"), ("143","NC","New Caledonia","+687"), ("144","NZ","New Zealand","+64"), ("145","NI","Nicaragua","+505"), ("146","NE","Niger","+227"), ("147","NG","Nigeria","+234"), ("148","NU","Niue","+683"), ("149","NF","Norfolk Island","+672"), ("150","KP","North Korea","+850"), ("151","MP","Northern Mariana Islands","+1"), ("152","NO","Norway","+47"), ("153","OM","Oman","+968"), ("154","PK","Pakistan","+92"), ("155","PW","Palau","+680"), ("156","PS","Palestine","+970"), ("157","PA","Panama","+507"), ("158","PG","Papua New Guinea","+675"), ("159","PY","Paraguay","+595"), ("160","PE","Peru","+51"), ("161","PH","Philippines","+63"), ("162","PL","Poland","+48"), ("163","PT","Portugal","+351"), ("164","PR","Puerto Rico","+1"), ("165","QA","Qatar","+974"), ("166","CG","Republic of the Congo","+242"), ("167","RE","Réunion","+262"), ("168","RO","Romania","+40"), ("169","RU","Russia","+7"), ("170","RW","Rwanda","+250"), ("171","BL","Saint Barthélemy","+590"), ("172","SH","Saint Helena","+290"), ("173","KN","Saint Kitts and Nevis","+1"), ("174","MF","Saint Martin","+590"), ("175","PM","Saint Pierre and Miquelon","+508"), ("176","VC","Saint Vincent and the Grenadines","+1"), ("177","WS","Samoa","+685"), ("178","SM","San Marino","+378"), ("179","ST","São Tomé and Príncipe","+239"), ("180","SA","Saudi Arabia","+966"), ("181","SN","Senegal","+221"), ("182","RS","Serbia","+381"), ("183","SC","Seychelles","+248"), ("184","SL","Sierra Leone","+232"), ("185","SG","Singapore","+65"), ("186","SK","Slovakia","+421"), ("187","SI","Slovenia","+386"), ("188","SB","Solomon Islands","+677"), ("189","SO","Somalia","+252"), ("190","ZA","South Africa","+27"), ("191","KR","South Korea","+82"), ("192","ES","Spain","+34"), ("193","LK","Sri Lanka","+94"), ("194","LC","St. Lucia","+1"), ("195","SD","Sudan","+249"), ("196","SR","Suriname","+597"), ("197","SZ","Swaziland","+268"), ("198","SE","Sweden","+46"), ("199","CH","Switzerland","+41"), ("200","SY","Syria","+963"); --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#country` VALUES("201","TW","Taiwan","+886"), ("202","TJ","Tajikistan","+992"), ("203","TZ","Tanzania","+255"), ("204","TH","Thailand","+66"), ("205","BS","The Bahamas","+1"), ("206","GM","The Gambia","+220"), ("207","TL","Timor-Leste","+670"), ("208","TG","Togo","+228"), ("209","TK","Tokelau","+690"), ("210","TO","Tonga","+676"), ("211","TT","Trinidad and Tobago","+1"), ("212","TN","Tunisia","+216"), ("213","TR","Turkey","+90"), ("214","TM","Turkmenistan","+993"), ("215","TC","Turks and Caicos Islands","+1"), ("216","TV","Tuvalu","+688"), ("217","UG","Uganda","+256"), ("218","UA","Ukraine","+380"), ("219","AE","United Arab Emirates","+971"), ("220","GB","United Kingdom","+44"), ("221","US","United States","+1"), ("222","UY","Uruguay","+598"), ("223","VI","US Virgin Islands","+1"), ("224","UZ","Uzbekistan","+998"), ("225","VU","Vanuatu","+678"), ("226","VA","Vatican City","+39"), ("227","VE","Venezuela","+58"), ("228","VN","Vietnam","+84"), ("229","WF","Wallis and Futuna","+681"), ("230","YE","Yemen","+967"), ("231","ZM","Zambia","+260"), ("232","ZW","Zimbabwe","+263"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#hashtag` ( `hashtag_id` int(11) NOT NULL AUTO_INCREMENT, `hashtag_name` varchar(255) NOT NULL, `hashtag_code` varchar(255) NOT NULL DEFAULT '0', `item_id` int(255) NOT NULL DEFAULT '0', `item_type` varchar(50) NOT NULL DEFAULT 'system', PRIMARY KEY (`hashtag_id`), FULLTEXT KEY `hashtag_code` (`hashtag_code`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#hashtag_stats` ( `stats_id` int(11) NOT NULL AUTO_INCREMENT, `hashtag_code` varchar(255) NOT NULL, `hashtag_counter` int(11) NOT NULL DEFAULT '0', `last_updated` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`stats_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#hook` ( `hook_id` int(11) NOT NULL AUTO_INCREMENT, `hook_name` varchar(255) NOT NULL, `module_name` varchar(55) NOT NULL, `is_active` tinyint(2) NOT NULL DEFAULT '1', `params` text, PRIMARY KEY (`hook_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#hook` VALUES("1","application_init_start","core","1",""), ("2","application_init_end","core","1",""); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#item_ordering` ( `ordering_id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL DEFAULT '0', `item_type` varchar(55) NOT NULL DEFAULT 'machine', `item_ordering_value` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ordering_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#language` ( `language_id` int(11) NOT NULL AUTO_INCREMENT, `language_name` varchar(255) NOT NULL, `language_code` varchar(3) NOT NULL, `is_active` int(1) NOT NULL DEFAULT '1', `is_default` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`language_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#language` VALUES("1","English (US)","en","1","1"), ("2","Ti?ng Vi?t","vi","1","0"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#language_patch` ( `phrase_id` int(11) NOT NULL AUTO_INCREMENT, `var_name` varchar(500) NOT NULL, `language_code` varchar(3) NOT NULL, `value` text, PRIMARY KEY (`phrase_id`), KEY `language_code` (`language_code`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#language_patch` VALUES("1","language.nice_a","en","nice a"), ("2","language.nice_a","vi","dep a"), ("3","core.phrase_var","en","Phrase Var"), ("4","core.phrase_var","vi","Phrase Var"), ("5","core.phrase_value","en","Value"), ("6","core.phrase_value","vi","Value"), ("7","language.nice_1","en","2"), ("8","language.nice_1","vi","33"), ("11","language.aa","en","f22"), ("12","language.aa","vi","2323"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#layout` ( `layout_id` int(11) NOT NULL AUTO_INCREMENT, `layout_title` varchar(255) NOT NULL, `layout_name` varchar(50) NOT NULL, `header` int(1) NOT NULL DEFAULT '1', `footer` int(1) NOT NULL DEFAULT '1', `layout_content` text, `is_template_default` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`layout_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#layout` VALUES("1","Page 3 Columns","Layout3Column.tpl","1","0","","0"), ("2","Page 3 Columns - Big Middle","Layout3ColumnMiddleBig.tpl","1","1","","0"), ("3","Page 3 Columns - Big Middle (1)","Layout3ColumnMiddleBig1.tpl","1","1","","0"), ("4","Page 3 Columns - Big Middle (2)","Layout3ColumnMiddleBig2.tpl","1","1","","1"), ("5","Page 2 Columns - Big Left","Layout2ColumnBigLeft.tpl","1","1","","0"), ("6","Page 2 Columns - Big Right","Layout2ColumnBigRight.tpl","1","1","","0"), ("7","Page 2 Columns","Layout2Column.tpl","1","1","","0"), ("8","nice to","layout-design-1478576321.tpl","1","1"," <div class=\"row-design\"> <div class=\"page-location-header\"> <span> Global Header <span> <a href=\"javascript:void(0);\" class=\"hide_on_this_page h-header\" df=\"0\" t=\"header\"> Hide on this page </a> </span> </span> </div> <div class=\"col-md-12 col-sm-12 main-contain-wrapper frame-wrapper ui-sortable\" id=\"page-design-skeleton\"> <div class=\"frame-item col-md-11 col-sm-11 col-xs-11 frame-wrapper-child\">{{ Location(1) }}</div><div class=\"frame-item col-md-9 col-sm-9 col-xs-9 frame-wrapper-child\">{{ Location(2) }}</div><div class=\"frame-item col-md-5 col-sm-5 col-xs-5 frame-wrapper-child\">{{ Location(3) }}</div></div> <div class=\"page-location-footer\"> <span> Global Footer <span> <a href=\"javascript:void(0);\" class=\"hide_on_this_page h-footer\" df=\"0\" t=\"footer\"> Hide on this page </a> </span> </span> </div> </div> ","0"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#layout_design` ( `pw_id` int(11) NOT NULL AUTO_INCREMENT, `layout_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `widget_id` int(11) NOT NULL, `param_values` text, `ordering` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`pw_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#layout_widgets` ( `pw_id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL DEFAULT '0', `item_type` varchar(50) NOT NULL, `widget_id` int(11) NOT NULL DEFAULT '0', `location_id` int(11) NOT NULL DEFAULT '0', `layout_id` int(11) NOT NULL DEFAULT '0', `param_values` text, `ordering` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`pw_id`), KEY `item_id` (`item_id`,`item_type`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#media` ( `media_id` int(11) NOT NULL AUTO_INCREMENT, `media_title` varchar(255) NOT NULL, `owner_id` int(11) NOT NULL DEFAULT '0', `destination` varchar(255) NOT NULL, `uploaded_time` int(11) NOT NULL DEFAULT '0', `file_type` varchar(15) DEFAULT NULL, `item_id` int(11) NOT NULL DEFAULT '0', `item_type` varchar(55) NOT NULL DEFAULT 'system', `meta_file` text, PRIMARY KEY (`media_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#meta_tags` ( `meta_tag_id` int(11) NOT NULL AUTO_INCREMENT, `meta_tag` varchar(255) NOT NULL, `meta_content` text, `meta_group` varchar(50) NOT NULL DEFAULT 'default', `params` text, `item_type` varchar(55) NOT NULL, `item_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`meta_tag_id`) ) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#menu` ( `menu_id` int(11) NOT NULL AUTO_INCREMENT, `menu_name` varchar(255) NOT NULL, `menu_type` varchar(50) NOT NULL DEFAULT 'main_menu', `parent_id` int(11) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', `is_active` tinyint(2) NOT NULL DEFAULT '1', `url` varchar(255) NOT NULL, `params` int(11) DEFAULT NULL, PRIMARY KEY (`menu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#module` ( `module_id` int(11) NOT NULL AUTO_INCREMENT, `module_name` varchar(55) NOT NULL, `module_title` varchar(255) NOT NULL, `module_description` varchar(500) DEFAULT NULL, `module_version` varchar(10) NOT NULL, `owner` varchar(255) DEFAULT NULL, `is_core` tinyint(2) NOT NULL DEFAULT '0', `is_active` int(11) NOT NULL DEFAULT '0', `params` text, PRIMARY KEY (`module_id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#module` VALUES("1","core","Simple App Core","Simple App Core","1.0","System","1","1",""), ("3","page","Dynamic Page HTML","Dynamic Page HTML","1.0","System ","1","1",""), ("4","theme","Manage Theme","Manage Theme","1.0","System","1","1",""), ("7","user","User","Manage User","1.0","System","1","1",""), ("16","blog","Blog","Blog News","1.0","lego","0","1",""); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#module_controller` ( `controller_id` int(11) NOT NULL AUTO_INCREMENT, `controller_name` varchar(255) NOT NULL, `router_name` varchar(255) NOT NULL, `module_name` varchar(55) NOT NULL, `layout_id` int(11) NOT NULL DEFAULT '0', `hide_header_layout` int(1) NOT NULL DEFAULT '0', `hide_footer_layout` int(1) NOT NULL DEFAULT '0', `custom_js` text, `custom_css` text, PRIMARY KEY (`controller_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#note` ( `note_id` int(11) NOT NULL AUTO_INCREMENT, `note_type` varchar(50) NOT NULL DEFAULT 'system', `note_title` varchar(255) NOT NULL, `note_description` text, `last_update` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`note_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#note` VALUES("1","system","core.note_title","GNU GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright (C) 2007 Free Software Foundation, Inc. <http://fsf.org/> Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. ","1476343421"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#notification` ( `notification_id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) DEFAULT NULL, `item_type` varchar(50) DEFAULT NULL, `created_time` int(11) DEFAULT NULL, `params` text, `user_id` int(11) NOT NULL, `is_read` int(3) NOT NULL DEFAULT '0', `is_push` int(3) NOT NULL DEFAULT '0', `module` varchar(55) NOT NULL DEFAULT 'core', PRIMARY KEY (`notification_id`) ) ENGINE=InnoDB AUTO_INCREMENT=465 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#page` ( `page_id` int(11) NOT NULL AUTO_INCREMENT, `page_layout` int(11) NOT NULL DEFAULT '0', `page_url` varchar(255) NOT NULL, `page_title` varchar(255) NOT NULL, `page_content` text, `page_status` tinyint(2) NOT NULL DEFAULT '1', `custom_css` text, `custom_js` text, `created_time` int(11) NOT NULL DEFAULT '0', `owner_id` int(11) NOT NULL DEFAULT '0', `hide_header_layout` int(1) NOT NULL DEFAULT '0', `hide_footer_layout` int(1) NOT NULL DEFAULT '0', `is_landing_page` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`page_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#permission` ( `permission_id` int(11) NOT NULL AUTO_INCREMENT, `module` varchar(45) DEFAULT NULL, `var_name` varchar(255) DEFAULT NULL, `permission_title` varchar(255) NOT NULL, `description` text, `is_active` int(11) NOT NULL DEFAULT '0', `is_default` int(3) DEFAULT '0', `params` text, PRIMARY KEY (`permission_id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#permission` VALUES("1","Core","can_access_admincp","core.can_access_admincp_title","core.can_access_admincp_description","1","0",""), ("2","Core","can_access_maintenance_page","core.can_access_maintenance_page_title","core.can_access_maintenance_page_description","1","0",""), ("3","Core","can_update_setting","core.can_update_setting_title","core.can_update_setting_description","1","0",""), ("4","Core","can_access_menu_page","core.can_access_menu_page_title","core.can_access_menu_page_description","1","0",""), ("5","Core","can_access_group_page","core.can_access_group_page_title","core.can_access_group_page_description","1","0",""), ("6","Core","can_access_module_page","core.can_access_module_page_title","core.can_access_module_page_description","1","0",""), ("7","Core","can_access_language_page","core.can_access_language_page_title","core.can_access_language_page_description","1","0",""), ("8","Core","can_access_module_user","core.can_access_module_user_title","core.can_access_module_user_description","1","0",""), ("9","Core","can_add_user","core.can_add_user_title","core.can_add_user_description","1","0",""), ("10","Core","can_delete_user","core.can_delete_user_title","core.can_delete_user_description","1","0",""), ("11","Core","can_delete_blog","core.can_delete_blog_title","core.can_delete_blog_description","1","0",""), ("12","Core","can_access_blog","core.can_access_blog_title","core.can_access_blog_description","1","0",""), ("13","Core","can_add_blog","core.can_add_blog_title","core.can_add_blog_description","1","0",""), ("14","Core","can_edit_blog","core.can_edit_blog_title","core.can_edit_blog_description","1","0",""), ("15","Core","can_access_theme_page","core.can_access_theme_page_title","core.can_access_theme_page_description","1","0",""), ("16","Page","can_access_page","page.can_access_page_title","page.can_access_page_description","1","0",""), ("17","Page","can_edit_page","page.can_edit_page_title","page.can_edit_page_description","1","0",""), ("18","Core","can_edit_user","core.can_edit_user_title","core.can_edit_user_description","1","0",""), ("19","Page","can_add_page","page.can_add_page_title","page.can_add_page_description","1","0",""), ("20","Core","can_access_widget_page","core.can_access_widget_page_title","core.can_access_widget_page_description","1","0",""), ("21","Core","can_access_layout_page","core.can_access_layout_page_title","core.can_access_layout_page_description","1","0",""), ("22","Page","can_design_layout","page.can_design_layout_title","page.can_design_layout_description","1","0",""), ("23","Core","can_delete_layout","core.can_delete_layout_title","core.can_delete_layout_description","1","0",""), ("24","Core","can_delete_page","core.can_delete_page_title","core.can_delete_page_description","1","0",""), ("25","Core","can_delete_controller_design","core.can_delete_controller_design_title","core.can_delete_controller_design_description","1","0",""), ("26","Theme","can_edit_controller_layout","theme.can_edit_controller_layout_title","theme.can_edit_controller_layout_description","1","0",""), ("27","Core","can_delete_user_group","core.can_delete_user_group_title","core.can_delete_user_group_description","1","0",""); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#request_token` ( `token_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `code` varchar(100) NOT NULL, `verified_time` int(11) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '0', `request_type` varchar(255) NOT NULL DEFAULT 'user_verification', `params` TEXT NULL, PRIMARY KEY (`token_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#seo_data` ( `seo_id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL DEFAULT '0', `item_type` varchar(50) NOT NULL DEFAULT 'page', `title_tag` varchar(255) NOT NULL, `description_tag` varchar(500) NOT NULL, `keyword_tag` varchar(500) NOT NULL, PRIMARY KEY (`seo_id`), KEY `item_id` (`item_id`,`item_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#setting` ( `setting_id` int(11) NOT NULL AUTO_INCREMENT, `module` varchar(55) NOT NULL DEFAULT 'core', `var_name` varchar(255) NOT NULL, `setting_type` varchar(255) NOT NULL DEFAULT 'textbox', `default_value` text NOT NULL, `real_value` text, `setting_title` varchar(255) DEFAULT NULL, `description` text, `updated_time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`setting_id`) ) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#setting` VALUES("1","core","current_language","textbox","en","en","core.current_language","core.current_language_descripition","0"), ("2","core","default_description","textbox","Simple CMS System","Simple CMS System","core.default_title","core.default_description","0"), ("8","core","default_site_description","textarea","Simple CMS for your business","Simple cms for your business","core.default_site_title_description","core.default_site_description","0"), ("9","core","cache_hook","boolean","0","1","core.cache_hook_title","core.cache_hook_description","0"), ("10","core","disable_ie_warning","boolean","0","0","core.disable_ie_warning_title","core.disable_ie_warning_description","0"), ("11","core","copy_right","textbox","0","LegoPHP","core.copy_right_title","core.copy_right_description","0"), ("12","core","default_site_keywords","textarea","0","LegoPHP","core.default_site_keywords_title","core.default_site_keywords_description","0"), ("13","core","site_delimiter_title","textbox","0","|","core.site_delimiter_title","core.site_delimiter_description","0"), ("14","core","global_time_stamp","textbox","F j, Y","d/m/Y H:i:s","core.global_time_stamp_title","core.global_time_stamp_description","0"), ("15","mail","enable_mail_system","boolean","true","1","mail.enable_mail_system_title","mail.enable_mail_system_description","0"), ("16","mail","send_mail_method","textbox","mail","smtp","mail.send_mail_method_title","mail.send_mail_method_description","0"), ("17","mail","from_name","textbox","","SimpleCMS","mail.from_name_title","mail.from_name_description","0"), ("18","mail","default_sent_out_email","textbox","no-reply@mail.com","","mail.default_sent_out_email_title","mail.default_sent_out_email_description","0"), ("19","mail","smtp_host","textbox","","smtp.gmail.com","mail.smtp_host_title","mail.smtp_host_description","0"), ("20","mail","smtp_user","textbox","","","mail.smtp_user_title","mail.smtp_user_description","0"), ("21","mail","smtp_password","textbox","","","mail.smtp_password_title","mail.smtp_password_description","0"), ("22","mail","smtp_port","textbox","","587","mail.smtp_port_title","mail.smtp_port_description","0"), ("23","mail","smtp_authentication","boolean","0","1","mail.smtp_authentication_title","mail.smtp_authentication_description","0"), ("24","core","site_name","textbox","SimpleCMS","LegoPHP","core.site_name_title","core.site_name_description","0"), ("25","core","support_upload_file_type","textarea","flv,mp3,png,zip,rar,jpg,gif,docx,doc,xls,xlsx,ppt,pptx,bmp,tiff,pdf,mp4","flv,mp3,png,zip,rar,jpg,gif,docx,doc,xls,xlsx,ppt,pptx,bmp,tiff,pdf,mp4","core.supported_upload_file_types","core.supported_upload_file_types_description","0"), ("27","core","default_time_zone","textbox","Asia/Ho_Chi_Minh","Asia/Singapore","core.default_time_zone","core.default_time_zone_description","0"), ("28","core","paypal_email_account","textbox","","lorem@payment.com","core.paypal_email_account","core.paypal_email_account_description","0"), ("29","mail","default_receive_support_email","textbox","","mailman@molisys.com","core.default_receive_support_email","core.default_receive_support_email_description","0"), ("30","core","payment_mode","textbox","sandbox","sandbox","core.payment_mode","core.payment_mode_description","0"), ("31","core","payment_default_gateway","textbox","paypal","paypal","core.payment_default_gateway_title","core.payment_default_gateway_description","0"), ("33","mail","signature_footer","textarea","<span style=\"margin-bottom:15px; margin-top:15px; display:inline-block; font-weight:bold; font-style:italic;\">Kind Regards </span><br> <span style=\"margin-bottom:15px; display:inline-block; font-weight:bold; font-style:italic;\">FWS</span>","Kind Regards","mail.signature_footer","mail.signature_footer_description","0"), ("34","core","enable_recaptcha","boolean","0","1","core.enable_recaptcha","core.enable_recaptcha_description","0"), ("35","core","recaptcha_public_key","textbox","","","core.recaptcha_public_key","core.recaptcha_public_key_description","0"), ("36","core","recaptcha_private_key","textbox","","","core.recaptcha_private_key","core.recaptcha_private_key_description","0"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#system_stats` ( `stats_id` int(11) NOT NULL AUTO_INCREMENT, `stats_type` varchar(255) NOT NULL, `stats_value` int(11) NOT NULL, `module_name` varchar(50) NOT NULL DEFAULT 'core', `last_update` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`stats_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#theme` ( `theme_id` int(11) NOT NULL AUTO_INCREMENT, `folder` varchar(50) NOT NULL, `theme_title` varchar(255) NOT NULL, `theme_version` varchar(30) DEFAULT 'N/A', `theme_owner` varchar(255) DEFAULT NULL, `is_active` tinyint(2) NOT NULL DEFAULT '1', `is_default` tinyint(2) NOT NULL DEFAULT '0', `params` text, `logo` varchar(255) DEFAULT NULL, `type` varchar(50) NOT NULL DEFAULT 'frontend', PRIMARY KEY (`theme_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#theme` VALUES("1","Default","Default Theme SimpleApp","1.0","System","1","1","","Image/Logo/logo.png","frontend"); --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `user_name` varchar(55) NOT NULL, `full_name` varchar(255) NOT NULL, `user_title` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `hash` varchar(55) NOT NULL, `birthday` varchar(55) NOT NULL, `joined_day` int(11) DEFAULT NULL, `lasted_login` int(11) NOT NULL, `main_group_id` int(11) NOT NULL DEFAULT '2', `user_text` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `user_image` varchar(255) NOT NULL, `address` text, `extra_permission` text, `session_login` varchar(255) DEFAULT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#user_configuration` ( `user_config_id` int(11) NOT NULL AUTO_INCREMENT, `config_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `user_value` text, PRIMARY KEY (`user_config_id`), KEY `fk_vms_configuration_has_vms_user_vms_user1_idx` (`user_id`), KEY `fk_vms_configuration_has_vms_user_vms_configuration1_idx` (`config_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#user_group` ( `user_group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(255) NOT NULL, `parent_group_id` int(11) NOT NULL DEFAULT '0', `is_active` tinyint(4) NOT NULL DEFAULT '1', `total_member` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`user_group_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#user_group_permission` ( `group_permission_id` int(11) NOT NULL AUTO_INCREMENT, `user_group_id` int(11) NOT NULL DEFAULT '0', `permission_id` int(11) NOT NULL DEFAULT '0', `gp_value` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`group_permission_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- CREATE TABLE IF NOT EXISTS `#_#####_#widgets` ( `widget_id` int(11) NOT NULL AUTO_INCREMENT, `widget_name` varchar(255) NOT NULL, `widget_router` varchar(255) NOT NULL, `module_name` varchar(255) NOT NULL, `params` text, `can_remove` int(3) NOT NULL DEFAULT '1', `params_template` varchar(255) DEFAULT NULL, PRIMARY KEY (`widget_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; --------------------------------------- --------------------------------------- INSERT INTO `#_#####_#widgets` VALUES("1","blog.featured_blog","blog/featured","blog","{\"title\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.title\"},\"limit\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.limit\"}}","1",""), ("2","blog.recent_blog","blog/recent","blog","{\"title\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.title\"},\"limit\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.limit\"}}","1",""), ("3","page.widget_html","page/html","page","{\"title\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.title\"},\"html_content\":{\"type\":\"editor\",\"value\":\"\",\"title\":\"core.content\"}}","0",""), ("4","page.page_content","page/content","page","","0",""), ("5","core.slider","core/slider","core","{\"title\":{\"type\":\"text\",\"value\":\"\",\"title\":\"core.title\"},\"images\":{\"type\":\"slider\",\"value\":\"\",\"title\":\"core.slider\"}}","0","slider"); ---------------------------------------