Changeset 6111

Timestamp:

Mar 27, 2008, 4:37:09 PM (14 years ago)

Author:

ebihara

Message:

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

Location:

OpenPNE/trunk/setup/sql/postgres74

Files:

• install/install-2.11.5-insert_data.sql (modified) (1 diff)
• update/update06-for2.11.5-install_portal.sql (modified) (1 diff)

OpenPNE/trunk/setup/sql/postgres74/install/install-2.11.5-insert_data.sql

@@ -220 +220 @@
 INSERT INTO mail_queue_seq VALUES (1);
 
-INSERT INTO portal_config VALUES (1,'USE_PORTAL','0');
-INSERT INTO portal_config VALUES (2,'HEAD_TEXT_TYPE','0');
-INSERT INTO portal_config VALUES (3,'HEAD_TEXT','');
-INSERT INTO portal_config VALUES (4,'LAYOUT_TYPE','2');
-INSERT INTO portal_config VALUES (5,'COLOR_TYPE','005_openpne_blue');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'USE_PORTAL','0');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT_TYPE','0');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT','');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'LAYOUT_TYPE','2');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'COLOR_TYPE','005_openpne_blue');
 
 INSERT 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

@@ -71 +71 @@
 );
 
-INSERT INTO portal_config VALUES (1,'USE_PORTAL','0');
-INSERT INTO portal_config VALUES (2,'HEAD_TEXT_TYPE','0');
-INSERT INTO portal_config VALUES (3,'HEAD_TEXT','');
-INSERT INTO portal_config VALUES (4,'LAYOUT_TYPE','2');
-INSERT INTO portal_config VALUES (5,'COLOR_TYPE','005_openpne_blue');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'USE_PORTAL','0');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT_TYPE','0');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'HEAD_TEXT','');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'LAYOUT_TYPE','2');
+INSERT INTO portal_config VALUES (nextval('portal_config_portal_config_id_seq'),'COLOR_TYPE','005_openpne_blue');
 
 INSERT INTO c_module VALUES(nextval('c_module_c_module_id_seq'), 'portal', 1);