Changeset 4940 for OpenPNE/trunk

Timestamp:

Jan 15, 2008, 12:50:31 PM (15 years ago)

Author:

ogawa

Message:

#1747:r4922のinstallSQLの変更を差し戻し

Location:

OpenPNE/trunk/setup/sql

Files:

• mysql40/install/install-2.10-insert_data.sql (modified) (1 diff)
• mysql41/install/install-2.10-insert_data.sql (modified) (1 diff)
• postgres74/install/install-2.10-insert_data.sql (modified) (1 diff)

OpenPNE/trunk/setup/sql/mysql40/install/install-2.10-insert_data.sql

@@ -197 +197 @@
 INSERT INTO `c_rank` VALUES (NULL,'GOLD','r_3_gold.gif',1000);
 INSERT INTO `c_rank` VALUES (NULL,'PLATINUM','r_4_platinum.gif',10000);
-INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
-INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
-INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
-INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
-INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
-INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
-INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
-INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
-INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
-INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ＆ホビー',10);
-INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
-INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス＆ビューティー',12);
+INSERT INTO `c_review_category` VALUES (NULL,'books-jp','和書',1);
+INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
+INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
+INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
+INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
+INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
+INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
+INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
+INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
+INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ＆ホビー',10);
+INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
+INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス＆ビューティー',12);
 INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
 INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);

OpenPNE/trunk/setup/sql/mysql41/install/install-2.10-insert_data.sql

@@ -199 +199 @@
 INSERT INTO `c_rank` VALUES (NULL,'GOLD','r_3_gold.gif',1000);
 INSERT INTO `c_rank` VALUES (NULL,'PLATINUM','r_4_platinum.gif',10000);
-INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
-INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
-INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
-INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
-INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
-INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
-INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
-INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
-INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
-INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ＆ホビー',10);
-INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
-INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス＆ビューティー',12);
+INSERT INTO `c_review_category` VALUES (NULL,'books-jp','和書',1);
+INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
+INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
+INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
+INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
+INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
+INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
+INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
+INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
+INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ＆ホビー',10);
+INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
+INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス＆ビューティー',12);
 INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
 INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);

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

@@ -197 +197 @@
 INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'GOLD','r_3_gold.gif',1000);
 INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'PLATINUM','r_4_platinum.gif',10000);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Books','和書',1);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'ForeignBooks','洋書',2);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Music','CDポピュラー',3);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Classical','CDクラシック',4);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'DVD','DVD',5);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'VideoGames','ゲーム',6);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Software','ソフトウェア',7);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Electronics','エレクトロニクス',8);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Kitchen','キッチン',9);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Toys','おもちゃ＆ホビー',10);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'SportingGoods','スポーツ',11);
-INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'HealthPersonalCare','ヘルス＆ビューティー',12);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'books-jp','和書',1);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'books-us','洋書',2);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'music-jp','CDポピュラー',3);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'classical-jp','CDクラシック',4);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'dvd-jp','DVD',5);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'videogames-jp','ゲーム',6);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'software-jp','ソフトウェア',7);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'electronics-jp','エレクトロニクス',8);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'kitchen-jp','キッチン',9);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'toys-jp','おもちゃ＆ホビー',10);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'sporting-goods-jp','スポーツ',11);
+INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'hpc-jp','ヘルス＆ビューティー',12);
 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Baby','ベビー＆マタニティ',14);