|
通过数据库管理软件手动执行 以下sql语句
UPDATE `ss_parameters` SET `val` = '2' WHERE `key` = 'THUMB_STATUS';
UPDATE `ss_parameters` SET `val` = 'frontpage,mod_article,mod_auth,mod_cart,mod_category_a,mod_category_p,mod_counter,mod_download,mod_download_category,mod_friendlink,mod_lang,mod_media,mod_menu,mod_message,mod_navigation,mod_offline,mod_onlinepay,mod_order,mod_product,mod_qq,mod_static,mod_template,mod_tool,mod_user,mod_menu_item,mod_modules,mod_param,mod_payaccount,mod_site,mod_news,mod_statistics,mod_database,mod_filemanager,mod_backup,mod_wizard,mod_about,mod_marquee,mod_attachment,mod_advert,mod_sitestarmaker,mod_bulletin,mod_page,mod_content,mod_roles,mod_category_d,mod_bshare,' WHERE `key` = 'ALLOWED_MOD';
UPDATE `ss_parameters` SET `val` = 'sitestar_v2.5' WHERE `key` = 'SYSVER';
insert into `ss_parameters`(id,`key`,`val`) value(NULL,'BACKGROUND_INFO','');
ALTER TABLE `ss_menu_items` CHANGE published published VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1';
ALTER TABLE `ss_products` CHANGE introduction introduction TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `ss_articles` CHANGE intro intro TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `ss_bulletins` CHANGE title title VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
UPDATE `ss_parameters` SET `val` = 'frontpage,mod_article,mod_auth,mod_cart,mod_category_a,mod_category_p,mod_counter,mod_download,mod_download_category,mod_friendlink,mod_lang,mod_media,mod_menu,mod_message,mod_navigation,mod_offline,mod_onlinepay,mod_order,mod_product,mod_qq,mod_static,mod_template,mod_tool,mod_user,mod_menu_item,mod_modules,mod_param,mod_payaccount,mod_site,mod_news,mod_statistics,mod_database,mod_filemanager,mod_backup,mod_wizard,mod_about,mod_marquee,mod_attachment,mod_advert,mod_sitestarmaker,mod_bulletin,mod_page,mod_content,mod_roles,mod_category_d,mod_bshare,mod_user_field,mod_third_account,mod_email,' WHERE `key` = 'ALLOWED_MOD';
alter table `ss_users` ADD COLUMN nickname VARCHAR(45);
alter table `ss_users` ADD COLUMN gender varchar(2);
alter table `ss_users` ADD COLUMN birthday varchar(20);
alter table `ss_users` ADD COLUMN country varchar(100);
alter table `ss_users` ADD COLUMN city varchar(100);
alter table `ss_users` ADD COLUMN addr1 varchar(255);
alter table `ss_users` ADD COLUMN addr2 VARCHAR(45);
alter table `ss_users` ADD COLUMN zipcode varchar(20);
alter table `ss_users` ADD COLUMN telphone varchar(50);
alter table `ss_users` ADD COLUMN params longtext;
CREATE TABLE `ss_user_fields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`field_type` int(11) NOT NULL,
`showinlist` enum('0','1') NOT NULL DEFAULT '0',
`required` enum('0','1') NOT NULL DEFAULT '0',
`i_order` int(11) NOT NULL,
`label` text NOT NULL,
`options` text,
PRIMARY KEY (`id`),
KEY `i_order` (`i_order`),
KEY `list_with_order` (`showinlist`,`i_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `ss_user_fields` (`id`, `field_type`, `showinlist`, `required`, `i_order`, `label`, `options`) VALUES (1, 0, '1', '0', 1, 'full_name', NULL),(2, 0, '0', '0', 3, 'nickname', NULL),(3, 0, '0', '0', 7, 'country', NULL),(4, 0, '0', '0', 8, 'city', NULL),(5, 0, '0', '0', 5, 'birthday', NULL),(6, 0, '0', '0', 9, 'addr1', NULL),(7, 0, '0', '0', 10, 'zipcode', NULL),(8, 0, '1', '0', 2, 'mobile', NULL),(9, 0, '0', '0', 4, 'gender', NULL),(10, 0, '0', '0', 6, 'telphone', NULL);
CREATE TABLE `ss_third_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_type` varchar(50) NOT NULL,
`appid` varchar(100) NOT NULL DEFAULT '',
`appsecret` varchar(100) NOT NULL DEFAULT '',
`active` smallint(6) NOT NULL DEFAULT '0',
`options` text,
PRIMARY KEY (`id`),
UNIQUE KEY `account_type` (`account_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ss_user_oauths` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`auth_type` varchar(50) NOT NULL,
`auth_key` varchar(200) NOT NULL,
`access_code` varchar(200) NOT NULL DEFAULT '',
`nickname` varchar(200) NOT NULL DEFAULT '',
`options` text,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_type` (`auth_type`,`auth_key`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ss_emails` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`user_id` int(6) NOT NULL,
`user_name` varchar(30) NOT NULL,
`is_mail` tinyint(1) NOT NULL,
`send_id` int(6) NOT NULL,
`is_read` tinyint(1) NOT NULL,
`is_ok` tinyint(1) NOT NULL default '1',
`create_time` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `ss_site_infos` CHANGE site_name site_name TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
UPDATE `ss_parameters` SET `val` = "sitestar_v2.6" WHERE `key` = "SYSVER";
alter table `ss_friendlinks` ADD COLUMN i_order int(5) not null default '0' after create_time;
alter table `ss_menu_items` ADD COLUMN url varchar(255) default '' after title;
alter table `ss_menu_items` ADD COLUMN content_id int(11) default '0' after url;
alter table `ss_messages` ADD COLUMN param text null after message;
alter table `ss_online_qqs` ADD COLUMN i_order int(3) not null default '0' after category;
alter table `ss_static_contents` ADD COLUMN flag varchar(45) not null default 'static' after for_roles;
alter table `ss_user_extends` ADD COLUMN total_point int(11) null after user_id;
alter table `ss_marquees` ADD COLUMN i_order int(5) not null default '0' after link;
alter table `ss_marquees` ADD COLUMN create_time varchar(20) not null after i_order;
delete from `ss_module_blocks` where module='mod_static' and action='custom_html' and alias='mb_foot' and s_pos='footer' and s_param like '%www.sitestar.cn%';
INSERT INTO `ss_parameters` (`id`, `key`, `val`) VALUES (NULL, 'INIT3', '0'),(NULL, 'QQ_SHOW_TYPE', '1');
ALTER TABLE `ss_users` CHANGE gender gender VARCHAR(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;
ALTER TABLE `ss_users` CHANGE birthday birthday VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;
CREATE TABLE `ss_msg_fields` (
`id` int(11) NOT NULL auto_increment,
`field_type` int(11) NOT NULL,
`showinlist` enum('0','1') NOT NULL default '0',
`required` enum('0','1') NOT NULL default '0',
`i_order` int(11) NOT NULL,
`label` text NOT NULL,
`options` text,
PRIMARY KEY (`id`),
KEY `i_order` (`i_order`),
KEY `list_with_order` (`showinlist`,`i_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `ss_msg_fields` VALUES (1, 0, '1', '1', 1, 'username', NULL);
INSERT INTO `ss_msg_fields` VALUES (2, 0, '1', '1', 2, 'email', NULL);
INSERT INTO `ss_msg_fields` VALUES (3, 0, '1', '1', 3, 'tele', NULL);
INSERT INTO `ss_msg_fields` VALUES (4, 0, '1', '1', 4, 'message', NULL);
CREATE TABLE `ss_users_points` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`orderid` int(11) NOT NULL default '0',
`type` varchar(5) collate utf8_unicode_ci NOT NULL default 'in',
`point` int(11) NOT NULL default '0',
`momo` varchar(255) collate utf8_unicode_ci default NULL,
`create_time` bigint(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
UPDATE `ss_parameters` SET `val` = 'frontpage,mod_article,mod_auth,mod_cart,mod_category_a,mod_category_p,mod_counter,mod_download,mod_download_category,mod_friendlink,mod_lang,mod_media,mod_menu,mod_message,mod_navigation,mod_offline,mod_onlinepay,mod_order,mod_product,mod_qq,mod_static,mod_template,mod_tool,mod_user,mod_menu_item,mod_modules,mod_param,mod_payaccount,mod_site,mod_news,mod_statistics,mod_database,mod_filemanager,mod_backup,mod_wizard,mod_about,mod_marquee,mod_attachment,mod_advert,mod_sitestarmaker,mod_bulletin,mod_page,mod_content,mod_roles,mod_category_d,mod_bshare,mod_user_field,mod_third_account,mod_email,mod_msg_field,' WHERE `key` = 'ALLOWED_MOD';
UPDATE `ss_parameters` SET `val` = "sitestar_v2.7" WHERE `key` = "SYSVER";
UPDATE `ss_parameters` SET `val` = "sitestar_v2.7_build131012" WHERE `key` = "SYSVER"; |
|