ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 830


Ignore:
Timestamp:
Nov 22, 2006, 3:31:00 PM (14 years ago)
Author:
takanashi
Message:

updateSQLを更新

Location:
OpenPNE/branches/2_4/setup/sql/upgrade
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/2_4/setup/sql/upgrade/upgrade-2.2to2.4-mysql40.sql

    r330 r830  
    125125ADD `symbol` TEXT NOT NULL;
    126126
     127SELECT @t1:=value FROM c_admin_config WHERE name = 'SKIN_BG_11';
     128SELECT @t2:=value FROM c_admin_config WHERE name = 'SKIN_BG_12';
     129SELECT @t3:=value FROM c_admin_config WHERE name = 'SKIN_BG_13';
     130UPDATE c_sns_config SET `bg_11` = @t1 WHERE c_sns_config_id=1;
     131UPDATE c_sns_config SET `bg_12` = @t2 WHERE c_sns_config_id=1;
     132UPDATE c_sns_config SET `bg_13` = @t3 WHERE c_sns_config_id=1;
     133
    127134UPDATE `c_sns_config` SET
    128 bg_11 = 'C1C6CF',bg_12 = 'FFFFFF',bg_13 = 'E9EAF0',caption = '戻す',symbol='E9EAF0'
     135caption = '戻す',symbol='E9EAF0'
    129136WHERE c_sns_config_id=1;
    130137
     
    180187-- update15
    181188INSERT INTO `c_admin_config` values (NULL,'OPENPNE_ENABLE_ROLLOVER',0);
     189
     190INSERT INTO `c_admin_config` values (NULL,'OPENPNE_USE_FLASH_LIST',0);
  • OpenPNE/branches/2_4/setup/sql/upgrade/upgrade-2.2to2.4-mysql41.sql

    r329 r830  
    126126
    127127UPDATE `c_sns_config` SET
    128 bg_11 = 'C1C6CF',bg_12 = 'FFFFFF',bg_13 = 'E9EAF0',caption = '戻す',symbol='E9EAF0'
     128caption = '戻す',symbol='E9EAF0'
    129129WHERE c_sns_config_id=1;
     130
     131
     132UPDATE c_sns_config SET `bg_11` = (SELECT value FROM `c_admin_config` WHERE name = 'SKIN_BG_11') WHERE  c_sns_config_id=1;
     133UPDATE c_sns_config SET `bg_12` = (SELECT value FROM `c_admin_config` WHERE name = 'SKIN_BG_12') WHERE  c_sns_config_id=1;
     134UPDATE c_sns_config SET `bg_13` = (SELECT value FROM `c_admin_config` WHERE name = 'SKIN_BG_13') WHERE  c_sns_config_id=1;
    130135
    131136INSERT INTO `c_sns_config` VALUES
     
    180185-- update15
    181186INSERT INTO `c_admin_config` values (NULL,'OPENPNE_ENABLE_ROLLOVER',0);
     187
     188INSERT INTO `c_admin_config` values (NULL,'OPENPNE_USE_FLASH_LIST',0);
Note: See TracChangeset for help on using the changeset viewer.