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

Changeset 4940


Ignore:
Timestamp:
Jan 15, 2008, 12:50:31 PM (12 years ago)
Author:
ogawa
Message:

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

Location:
OpenPNE/trunk/setup/sql
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/mysql40/install/install-2.10-insert_data.sql

    r4923 r4940  
    197197INSERT INTO `c_rank` VALUES (NULL,'GOLD','r_3_gold.gif',1000);
    198198INSERT INTO `c_rank` VALUES (NULL,'PLATINUM','r_4_platinum.gif',10000);
    199 INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
    200 INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
    201 INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
    202 INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
    203 INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
    204 INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
    205 INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
    206 INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
    207 INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
    208 INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ&ホビー',10);
    209 INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
    210 INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス&ビューティー',12);
     199INSERT INTO `c_review_category` VALUES (NULL,'books-jp','和書',1);
     200INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
     201INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
     202INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
     203INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
     204INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
     205INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
     206INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
     207INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
     208INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ&ホビー',10);
     209INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
     210INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス&ビューティー',12);
    211211INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
    212212INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー&マタニティ',14);
  • OpenPNE/trunk/setup/sql/mysql41/install/install-2.10-insert_data.sql

    r4923 r4940  
    199199INSERT INTO `c_rank` VALUES (NULL,'GOLD','r_3_gold.gif',1000);
    200200INSERT INTO `c_rank` VALUES (NULL,'PLATINUM','r_4_platinum.gif',10000);
    201 INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
    202 INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
    203 INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
    204 INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
    205 INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
    206 INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
    207 INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
    208 INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
    209 INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
    210 INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ&ホビー',10);
    211 INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
    212 INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス&ビューティー',12);
     201INSERT INTO `c_review_category` VALUES (NULL,'books-jp','和書',1);
     202INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
     203INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
     204INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
     205INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
     206INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
     207INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
     208INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
     209INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
     210INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ&ホビー',10);
     211INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
     212INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス&ビューティー',12);
    213213INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
    214214INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー&マタニティ',14);
  • OpenPNE/trunk/setup/sql/postgres74/install/install-2.10-insert_data.sql

    r4923 r4940  
    197197INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'GOLD','r_3_gold.gif',1000);
    198198INSERT INTO c_rank VALUES (nextval('c_rank_c_rank_id_seq'),'PLATINUM','r_4_platinum.gif',10000);
    199 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Books','和書',1);
    200 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'ForeignBooks','洋書',2);
    201 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Music','CDポピュラー',3);
    202 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Classical','CDクラシック',4);
    203 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'DVD','DVD',5);
    204 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'VideoGames','ゲーム',6);
    205 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Software','ソフトウェア',7);
    206 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Electronics','エレクトロニクス',8);
    207 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Kitchen','キッチン',9);
    208 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Toys','おもちゃ&ホビー',10);
    209 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'SportingGoods','スポーツ',11);
    210 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'HealthPersonalCare','ヘルス&ビューティー',12);
     199INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'books-jp','和書',1);
     200INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'books-us','洋書',2);
     201INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'music-jp','CDポピュラー',3);
     202INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'classical-jp','CDクラシック',4);
     203INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'dvd-jp','DVD',5);
     204INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'videogames-jp','ゲーム',6);
     205INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'software-jp','ソフトウェア',7);
     206INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'electronics-jp','エレクトロニクス',8);
     207INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'kitchen-jp','キッチン',9);
     208INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'toys-jp','おもちゃ&ホビー',10);
     209INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'sporting-goods-jp','スポーツ',11);
     210INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'hpc-jp','ヘルス&ビューティー',12);
    211211INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
    212212INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Baby','ベビー&マタニティ',14);
Note: See TracChangeset for help on using the changeset viewer.