1.0.8.0.sql

来自「一、修改产品详细页面的附件块 二、添加上浏览历史模块 三、在后台加入自定义首」· SQL 代码 · 共 124 行

/* PHP */
/* PHP:AttributeGroup::cleanDeadCombinations(); */;

/* STRUCTURE */
SET NAMES 'utf8';

CREATE TABLE `PREFIX_own_page` (
  `id` int(11) NOT NULL auto_increment,
  `own_type` varchar(30) NOT NULL,
  `page_html` text NOT NULL,
  `theme_name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `PREFIX_own_page_categore` (
  `id` int(11) NOT NULL auto_increment,
  `categorename` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `PREFIX_advchild` (
  `id_advchild` int(10) unsigned NOT NULL auto_increment,
  `src_url` char(200) character set utf8 default NULL,
  `adv_url` char(200) character set utf8 default NULL,
  `src_txt` text character set utf8,
  `adv_type` char(10) character set utf8 default NULL,
  `txt_color` char(20) character set utf8 default NULL,
  `bg_color` char(20) character set utf8 default NULL,
  `txt_size` char(10) character set utf8 default NULL,
  `txt_family` tinytext character set utf8,
  `txt_move_direction` int(1) unsigned default NULL,
  `txt_move_speed` int(10) unsigned default NULL,
  `acvchild_height` int(5) unsigned default NULL,
  `add_admin` char(50) character set utf8 default NULL,
  `adv_position` int(5) unsigned default NULL,
  PRIMARY KEY  (`id_advchild`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE `PREFIX_advermgr` (
  `id_advermgr` int(10) unsigned NOT NULL auto_increment,
  `id_adimg` char(50) character set utf8 default NULL,
  `id_adtext` char(50) character set utf8 default NULL,
  `id_adflash` char(50) character set utf8 default NULL,
  `deleted` int(1) unsigned default '0',
  `active` int(1) unsigned default '1',
  `add_admin` char(50) character set utf8 default NULL,
  `name` char(32) character set utf8 default NULL,
  `id_module` int(10) unsigned NOT NULL,
  `id_hook` int(10) unsigned NOT NULL,
  `width` int(10) unsigned,
  `position` tinyint(2) unsigned NOT NULL,
  PRIMARY KEY  (`id_advermgr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE `PREFIX_imgadv` (
  `id_imgadv` int(10) unsigned NOT NULL auto_increment,
  `scr_idchild` char(100) character set utf8 default NULL,
  PRIMARY KEY  (`id_imgadv`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

ALTER TABLE `PREFIX_category` ADD `id_order` INT NOT NULL DEFAULT '0';

/*  CONTENTS */

UPDATE `PREFIX_tab` SET `id_parent` = '67' WHERE `id_tab` =38;

INSERT INTO `PREFIX_tab` (`id_tab`, `id_parent`, `class_name`, `position`) VALUES
(67, 0, 'AdminThemes', 8),
(68, 67, 'AdminTheme', 2),
(69, 9, 'AdminBackup', 11),
(70, 67, 'AdminGlobalCss', 3),
(71, 67, 'AdminModulesTheme', 4);

INSERT INTO `PREFIX_tab_lang` (`id_lang`, `id_tab`, `name`) VALUES
(22, 67, '外观'),
(24, 67, '外觀'),
(1, 67, 'Appearance'),
(22, 68, '模板'),
(24, 68, '模板'),
(1, 68, 'themes'),
(22, 69, '数据库备份'),
(24, 69, '數據庫備份'),
(1, 69, 'Database backup'),
(22, 70, '全局CSS编辑'),
(24, 70, '全局CSS編輯'),
(1, 70, 'Global css edit'),
(22, 71, '编辑模块模板'),
(24, 71, '編輯模塊模板'),
(1, 71, 'Edit modules theme');

UPDATE `PREFIX_tab_lang` SET `name` = '設置' WHERE `id_lang` =24 AND `id_tab` =38;
UPDATE `PREFIX_tab_lang` SET `name` = '设置' WHERE `id_lang` =22 AND `id_tab` =38;
UPDATE `PREFIX_tab_lang` SET `name` = 'Setting' WHERE `id_lang` =1 AND `id_tab` =38;

INSERT INTO `PREFIX_access` (`id_access`, `id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES
(67, 1, 67, 1, 1, 1, 1),
(68, 1, 68, 1, 1, 1, 1),
(69, 1, 69, 1, 1, 1, 1),
(70, 1, 70, 1, 1, 1, 1),
(71, 1, 71, 1, 1, 1, 1);


INSERT INTO `PREFIX_own_page_categore` (`id`, `categorename`) VALUES
(1, 'home'),
(2, 'header'),
(3, 'headermenu'),
(4, 'footer');


INSERT INTO `PREFIX_advchild` (`id_advchild`, `src_url`, `adv_url`, `src_txt`, `adv_type`, `txt_color`, `bg_color`, `txt_size`, `txt_family`, `txt_move_direction`, `txt_move_speed`, `acvchild_height`, `add_admin`, `adv_position`) VALUES
(1, '12299984007U97P40611.jpg', 'http://www.85king.com', '外包王', 'image', NULL, NULL, NULL, NULL, NULL, NULL, 153, NULL, 1);

INSERT INTO `PREFIX_advermgr` (`id_advermgr`, `id_adimg`, `id_adtext`, `id_adflash`, `deleted`, `active`, `add_admin`, `name`, `id_module`, `id_hook`,`width` , `position`) VALUES
(1, '1:', '', '', 0, 1, NULL, 'ADVERTISEBLOCK_RL_SET', 122, 6, 191, 4);

INSERT INTO `PREFIX_imgadv` (`id_imgadv`, `scr_idchild`) VALUES
(1, '1:');




/* CONFIGURATION VARIABLE */