| 0.0007 |
SHOW TABLES FROM `spskli01_mcquay`
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_debug` (
`time` double(18,8) NOT NULL,
`message` varchar(255) NOT NULL,
`asd` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_adminUsers` (
`userId` int(11) NOT NULL auto_increment,
`roleId` int(11) NOT NULL,
`login` varchar(50) NOT NULL,
`pass` varchar(50) NOT NULL,
`regDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`active` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_adminRoles` (
`roleId` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`roleName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`roles` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = MYISAM ;
|
| 0.0007 |
DROP TABLE IF EXISTS `c4c_settings`;
|
| 0.0001 |
DROP TABLE IF EXISTS `c4c_settings_desc`;
|
| 0.0114 |
CREATE TABLE IF NOT EXISTS `c4c_settings` (
`settingsId` INT NOT NULL AUTO_INCREMENT ,
`level` VARCHAR(255) NOT NULL ,
`settings` TEXT NOT NULL ,
PRIMARY KEY (`settingsId`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0036 |
SELECT *
FROM (`c4c_settings`)
WHERE `settingsId` = 1
|
| 0.0006 |
INSERT INTO `c4c_settings` (`settingsId`, `level`, `settings`) VALUES ('1', 'global', '');
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_language` (
`langId` int(11) NOT NULL auto_increment,
`langSymbol` varchar(255) NOT NULL,
`langName` varchar(255) NOT NULL,
PRIMARY KEY (`langId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_language_translations` (
`translationId` int(11) NOT NULL auto_increment,
`langId` int(11) NOT NULL,
`original` text NOT NULL,
`translated` text NOT NULL,
PRIMARY KEY (`translationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 0.0005 |
SELECT *
FROM (`c4c_settings`)
WHERE `level` = 'global'
|
| 0.0002 |
INSERT INTO `c4c_admin_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('673a15ff6d67069a9e86b72e419cb6a9', '38.107.179.223', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1337386765)
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_cms_pages` (
`pageId` INT NOT NULL AUTO_INCREMENT ,
`langId` INT NOT NULL ,
`name` VARCHAR(255) NOT NULL ,
`url` VARCHAR(255) NOT NULL ,
`urlLink` VARCHAR(255) NOT NULL ,
`mainPage` TINYINT(1) NOT NULL DEFAULT 0 ,
`settings` VARCHAR(255) NOT NULL ,
`submitDate` INT(11) NOT NULL ,
`lastModification` INT(11) NOT NULL ,
`templateFileName` VARCHAR(255) NOT NULL ,
`pageType` VARCHAR(255) NOT NULL ,
`typeId` INT(11) NOT NULL ,
PRIMARY KEY (`pageId`, `langId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0002 |
CREATE TABLE IF NOT EXISTS `c4c_cms_menu` (
`id` INT NOT NULL AUTO_INCREMENT ,
`menuId` VARCHAR(255) NOT NULL DEFAULT 'default' ,
`langId` INT NOT NULL ,
`pageId` INT NOT NULL ,
`parentId` INT NOT NULL DEFAULT 0 ,
`depth` INT NOT NULL DEFAULT 0 ,
`position` INT NOT NULL DEFAULT 1000 ,
`active` TINYINT(1) NOT NULL DEFAULT 0 ,
`showInMenu` TINYINT(1) NOT NULL DEFAULT 0 ,
`menuName` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`id`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_modules` (
`moduleBindId` INT NOT NULL AUTO_INCREMENT ,
`pageId` INT NOT NULL ,
`moduleId` INT NOT NULL ,
`moduleName` VARCHAR(45) NOT NULL ,
`templateItemType` VARCHAR(100) NULL ,
`templateItemId` VARCHAR(100) NULL ,
PRIMARY KEY (`moduleBindId`, `pageId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_article` (
`articleId` INT NOT NULL AUTO_INCREMENT,
`articleName` VARCHAR(255) NULL ,
`tresc` TEXT NULL ,
`more` INT,
PRIMARY KEY (`articleId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_gallery` (
`galleryId` INT NOT NULL AUTO_INCREMENT ,
`galleryName` VARCHAR(255) NULL ,
`gallerySettings` VARCHAR(255) NULL ,
`displayAsSlider` TINYINT(1) NULL ,
PRIMARY KEY (`galleryId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_gallery_items` (
`itemId` INT NOT NULL AUTO_INCREMENT ,
`galleryId` INT NOT NULL ,
`image` VARCHAR(255) NOT NULL ,
`tytul` VARCHAR(255) NOT NULL ,
`podpis` TEXT NOT NULL ,
`link` VARCHAR(255) NOT NULL ,
`position` INT NOT NULL ,
PRIMARY KEY (`itemId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_news` (
`newsId` INT NOT NULL AUTO_INCREMENT,
`newsName` VARCHAR(255) NULL ,
`newsSettings` VARCHAR(255) NULL ,
PRIMARY KEY (`newsId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_news_items` (
`entryId` INT NOT NULL AUTO_INCREMENT ,
`newsId` INT NULL ,
`tytul` VARCHAR(255) NOT NULL ,
`zajawka` VARCHAR(255) NOT NULL ,
`tresc` TEXT NOT NULL ,
`displayDate` INT(11) NOT NULL ,
`submitDate` INT(11) NOT NULL ,
PRIMARY KEY (`entryId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_gmap` (
`gmapId` INT NOT NULL AUTO_INCREMENT,
`gmapName` VARCHAR(255) NULL ,
`settings` TEXT NULL ,
PRIMARY KEY (`gmapId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_cms_module_contactform` (
`formId` INT NOT NULL AUTO_INCREMENT,
`formName` VARCHAR(255) NULL ,
`settings` TEXT NULL ,
PRIMARY KEY (`formId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_category` (
`categoryId` INT NOT NULL AUTO_INCREMENT ,
`parentId` INT NOT NULL DEFAULT 0 ,
`position` INT(4) NOT NULL DEFAULT 1000 ,
`depth` INT(4) NOT NULL DEFAULT 0,
`categoryName` VARCHAR(255) NOT NULL ,
`zajawka` TEXT NOT NULL ,
`opis` TEXT NOT NULL ,
`categoryEnabled` TINYINT(1) NOT NULL DEFAULT 1 ,
PRIMARY KEY (`categoryId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_products` (
`productId` INT NOT NULL AUTO_INCREMENT ,
`productName` VARCHAR(255) NOT NULL ,
`zajawka` TEXT NOT NULL ,
`opis` TEXT NOT NULL ,
`symbol` TEXT NOT NULL ,
`pictures` TEXT NOT NULL ,
`specyfikacja` TEXT NOT NULL ,
`files` TEXT NOT NULL ,
`icons` TEXT NOT NULL ,
PRIMARY KEY (`productId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_products` (
`productId` INT NOT NULL AUTO_INCREMENT ,
`productName` VARCHAR(255) NOT NULL ,
`zajawka` TEXT NOT NULL ,
`opis` TEXT NOT NULL ,
`symbol` TEXT NOT NULL ,
`pictures` TEXT NOT NULL ,
`specyfikacja` TEXT NOT NULL ,
`files` TEXT NOT NULL ,
`icons` TEXT NOT NULL ,
PRIMARY KEY (`productId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_product_bind` (
`bindId` INT NOT NULL AUTO_INCREMENT ,
`productId` INT NOT NULL ,
`categoryId` INT NOT NULL ,
PRIMARY KEY (`bindId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0001 |
CREATE TABLE IF NOT EXISTS `c4c_plugin_seo` (
`pageId` INT NOT NULL ,
`title` VARCHAR(255) NOT NULL ,
`description` TEXT NOT NULL ,
`keywords` TEXT NOT NULL ,
`GtrackerId` VARCHAR(40) NOT NULL ,
`meta` TEXT NOT NULL ,
PRIMARY KEY (`pageId`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
|
| 0.0012 |
UPDATE `c4c_settings` SET `settings` = 'a:5:{s:8:\"platform\";a:9:{s:12:\"viewAutoLoad\";b:0;s:16:\"modulesToInstall\";a:4:{i:0;s:3:\"cms\";i:1;s:7:\"catalog\";i:2;s:12:\"imagemanager\";i:3;s:11:\"filemanager\";}s:16:\"installedModules\";a:4:{i:0;s:3:\"cms\";i:1;s:7:\"catalog\";i:2;s:12:\"imagemanager\";i:3;s:11:\"filemanager\";}s:12:\"topMenuItems\";a:9:{i:0;a:5:{s:2:\"id\";s:14:\"administration\";s:4:\"name\";s:13:\"Administracja\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:10;s:6:\"parent\";s:0:\"\";}i:1;a:5:{s:2:\"id\";s:3:\"seo\";s:4:\"name\";s:3:\"SEO\";s:3:\"url\";s:11:\"seo/system/\";s:3:\"pos\";i:200;s:6:\"parent\";s:14:\"administration\";}i:2;a:5:{s:2:\"id\";s:3:\"cms\";s:4:\"name\";s:3:\"CMS\";s:3:\"url\";s:26:\"page/welcome/op-cms-nodata\";s:3:\"pos\";i:200;s:6:\"parent\";s:0:\"\";}i:3;a:5:{s:2:\"id\";s:7:\"catalog\";s:4:\"name\";s:7:\"Katalog\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:100;s:6:\"parent\";s:0:\"\";}i:4;a:5:{s:2:\"id\";s:8:\"products\";s:4:\"name\";s:8:\"Produkty\";s:3:\"url\";s:28:\"products/index/op-cms-nodata\";s:3:\"pos\";i:10;s:6:\"parent\";s:7:\"catalog\";}i:5;a:5:{s:2:\"id\";s:7:\"manager\";s:4:\"name\";s:9:\"Menadżer\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:100;s:6:\"parent\";s:0:\"\";}i:6;a:5:{s:2:\"id\";s:12:\"imagemanager\";s:4:\"name\";s:17:\"Menadżer zdjęć\";s:3:\"url\";s:17:\"imagemanager/show\";s:3:\"pos\";i:200;s:6:\"parent\";s:7:\"manager\";}i:7;a:5:{s:2:\"id\";s:7:\"manager\";s:4:\"name\";s:9:\"Menadżer\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:100;s:6:\"parent\";s:0:\"\";}i:8;a:5:{s:2:\"id\";s:11:\"filemanager\";s:4:\"name\";s:17:\"Menadżer plików\";s:3:\"url\";s:16:\"filemanager/show\";s:3:\"pos\";i:200;s:6:\"parent\";s:7:\"manager\";}}s:11:\"perPageList\";a:3:{i:0;s:1:\"5\";i:1;s:2:\"10\";i:2;s:2:\"15\";}s:14:\"perPageDefault\";i:5;s:7:\"plugins\";a:1:{i:0;s:3:\"seo\";}s:13:\"wysiwygConfig\";a:2:{s:7:\"default\";s:2761:\"\n // Location of TinyMCE script\n script_url : \"/admin/scripts/Editor/tiny_mce/tiny_mce.js\",\n\n mode : \"specific_textareas\",\n editor_selector : \"mceEditor\",\n extended_valid_elements : \"a[href|class|rel],span[class|style],p[class|style]\",\n\n // General options\n theme : \"advanced\",\n plugins : \"-c4cmsPlugin,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,advlist,imagemanager,filemanager\",\n \n // Theme options\n theme_advanced_buttons1 : \"bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontsizeselect,|,forecolor,backcolor\",\n theme_advanced_buttons2 : \"cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,insertimage,insertfile,cleanup,code\",\n theme_advanced_buttons3 : \"tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,iespell,advhr,|,print,|,fullscreen\",\n theme_advanced_buttons4 : \"c4cmsMenu,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,pagebreak,|,preview\",\n theme_advanced_toolbar_location : \"top\",\n theme_advanced_toolbar_align : \"left\",\n theme_advanced_statusbar_location : \"bottom\",\n theme_advanced_resizing : true,\n content_css : \"/css/wysiwyg.css\",\n \n // Drop lists for link/image/media/template dialogs\n template_external_list_url : \"lists/template_list.js\",\n external_link_list_url : \"/admin/tinymce_plugins/external_link_list/aa.js\",\n external_image_list_url : \"lists/image_list.js\",\n media_external_list_url : \"lists/media_list.js\",\n \n //imagemanager_rootpath : \"/_media/images\",\n relative_urls : false\n //imagemanager_relative_urls : true, \n //imagemanager_document_base_url : \"/\"\n \";s:6:\"simple\";s:2173:\"\n // Location of TinyMCE script\n script_url : \"/admin/scripts/Editor/tiny_mce/tiny_mce.js\",\n\n // General options\n theme : \"advanced\",\n plugins : \"pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,advlist\",\n\n // Theme options\n theme_advanced_buttons1 : \"bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,formatselect,fontsizeselect,|,forecolor,backcolor\",\n theme_advanced_buttons2 : \"bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,cleanup,help,code\",\n theme_advanced_buttons3 : \"hr,removeformat,visualaid,|,sub,sup,|,charmap,iespell,advhr,|,print,|,ltr,rtl,|,fullscreen\",\n //theme_advanced_buttons4 : \"insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,pagebreak,|,insertdate,inserttime,preview\",\n theme_advanced_toolbar_location : \"top\",\n theme_advanced_toolbar_align : \"left\",\n theme_advanced_statusbar_location : \"bottom\",\n theme_advanced_resizing : true,\n content_css : \"/css/wysiwyg.css\",\n\n // Drop lists for link/image/media/template dialogs\n template_external_list_url : \"lists/template_list.js\",\n external_link_list_url : \"/admin/tinymce_plugins/external_link_list/aa.js\",\n external_image_list_url : \"lists/image_list.js\",\n media_external_list_url : \"lists/media_list.js\",\n\n //imagemanager_rootpath : \"/_media/images\",\n relative_urls : false\n //imagemanager_relative_urls : true,\n //imagemanager_document_base_url : \"/\"\n \";}s:7:\"topMenu\";a:4:{s:3:\"cms\";a:5:{s:2:\"id\";s:3:\"cms\";s:4:\"name\";s:3:\"CMS\";s:3:\"url\";s:26:\"page/welcome/op-cms-nodata\";s:3:\"pos\";i:200;s:6:\"parent\";s:0:\"\";}s:7:\"catalog\";a:6:{s:2:\"id\";s:7:\"catalog\";s:4:\"name\";s:7:\"Katalog\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:100;s:6:\"parent\";s:0:\"\";s:3:\"sub\";a:1:{i:0;a:5:{s:2:\"id\";s:8:\"products\";s:4:\"name\";s:8:\"Produkty\";s:3:\"url\";s:28:\"products/index/op-cms-nodata\";s:3:\"pos\";i:10;s:6:\"parent\";s:7:\"catalog\";}}}s:7:\"manager\";a:6:{s:2:\"id\";s:7:\"manager\";s:4:\"name\";s:9:\"Menadżer\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:100;s:6:\"parent\";s:0:\"\";s:3:\"sub\";a:2:{i:0;a:5:{s:2:\"id\";s:12:\"imagemanager\";s:4:\"name\";s:17:\"Menadżer zdjęć\";s:3:\"url\";s:17:\"imagemanager/show\";s:3:\"pos\";i:200;s:6:\"parent\";s:7:\"manager\";}i:1;a:5:{s:2:\"id\";s:11:\"filemanager\";s:4:\"name\";s:17:\"Menadżer plików\";s:3:\"url\";s:16:\"filemanager/show\";s:3:\"pos\";i:200;s:6:\"parent\";s:7:\"manager\";}}}s:14:\"administration\";a:6:{s:2:\"id\";s:14:\"administration\";s:4:\"name\";s:13:\"Administracja\";s:3:\"url\";s:0:\"\";s:3:\"pos\";i:10;s:6:\"parent\";s:0:\"\";s:3:\"sub\";a:1:{i:0;a:5:{s:2:\"id\";s:3:\"seo\";s:4:\"name\";s:3:\"SEO\";s:3:\"url\";s:11:\"seo/system/\";s:3:\"pos\";i:200;s:6:\"parent\";s:14:\"administration\";}}}}}s:8:\"security\";a:2:{s:9:\"secretKey\";a:1:{i:0;s:31:\"vmgn98sdf3wcy4wn7d3f4hw938nc4dw\";}s:10:\"noLoginACL\";a:1:{i:0;s:5:\"login\";}}s:3:\"cms\";a:2:{s:7:\"modules\";a:5:{i:0;s:7:\"article\";i:1;s:7:\"gallery\";i:2;s:4:\"news\";i:3;s:4:\"gmap\";i:4;s:11:\"contactform\";}s:9:\"pageTypes\";a:3:{s:4:\"page\";s:6:\"Strona\";s:7:\"catalog\";s:7:\"Katalog\";s:6:\"search\";s:28:\"Strona wyników wyszukiwania\";}}s:7:\"catalog\";a:1:{s:7:\"modules\";a:2:{i:0;s:8:\"category\";i:1;s:8:\"products\";}}s:7:\"gallery\";a:2:{s:11:\"sliderSpeed\";i:800;s:11:\"sliderPause\";i:2000;}}' WHERE `level` = 'global'
|
