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

Changeset 6111 for OpenPNE/trunk


Ignore:
Timestamp:
Mar 27, 2008, 4:37:09 PM (15 years ago)
Author:
ebihara
Message:

#2135:PostgreSQLのセットアップ/アップデートSQLで、portal_configのプライマリキーを固定値で指定してインサートを行っている箇所があったのを修正

Location:
OpenPNE/trunk/setup/sql/postgres74
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/postgres74/install/install-2.11.5-insert_data.sql

    r6110 r6111  
    220220INSERT INTO mail_queue_seq VALUES (1);
    221221
    222 INSERT INTO portal_config VALUES (1,'USE_PORTAL','0');
    223 INSERT INTO portal_config VALUES (2,'HEAD_TEXT_TYPE','0');
    224 INSERT INTO portal_config VALUES (3,'HEAD_TEXT','');
    225 INSERT INTO portal_config VALUES (4,'LAYOUT_TYPE','2');
    226 INSERT INTO portal_config VALUES (5,'COLOR_TYPE','005_openpne_blue');
     222INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'USE_PORTAL','0');
     223INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT_TYPE','0');
     224INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT','');
     225INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'LAYOUT_TYPE','2');
     226INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'COLOR_TYPE','005_openpne_blue');
    227227
    228228INSERT INTO c_module VALUES(nextval('c_module_c_module_id_seq'), 'portal', 1);
  • OpenPNE/trunk/setup/sql/postgres74/update/update06-for2.11.5-install_portal.sql

    r6097 r6111  
    7171);
    7272
    73 INSERT INTO portal_config VALUES (1,'USE_PORTAL','0');
    74 INSERT INTO portal_config VALUES (2,'HEAD_TEXT_TYPE','0');
    75 INSERT INTO portal_config VALUES (3,'HEAD_TEXT','');
    76 INSERT INTO portal_config VALUES (4,'LAYOUT_TYPE','2');
    77 INSERT INTO portal_config VALUES (5,'COLOR_TYPE','005_openpne_blue');
     73INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'USE_PORTAL','0');
     74INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT_TYPE','0');
     75INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT','');
     76INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'LAYOUT_TYPE','2');
     77INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'COLOR_TYPE','005_openpne_blue');
    7878
    7979INSERT INTO c_module VALUES(nextval('c_module_c_module_id_seq'), 'portal', 1);
Note: See TracChangeset for help on using the changeset viewer.