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

Changeset 4923 for OpenPNE/trunk


Ignore:
Timestamp:
Jan 12, 2008, 3:39:10 AM (15 years ago)
Author:
ebihara
Message:

#1774:レビューのカテゴリに「時計」「ベビー＆マタニティ」「アパレル＆シューズ」を追加

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

Legend:

Unmodified
Added
Removed

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

    r4922 r4923  
    209209INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
    210210INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス＆ビューティー',12);
     211INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     212INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     213INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);
    211214INSERT INTO `c_siteadmin` VALUES (NULL,'inc_page_footer_before','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a> <a href=\"http://www.openpne.jp/about/\" target=\"_blank\">OpenPNEとは</a>',NOW());
    212215INSERT INTO `c_siteadmin` VALUES (NULL,'inc_page_footer_after','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a>',NOW());

  • OpenPNE/trunk/setup/sql/mysql40/update/update02-for2.11.3-alter_c_review_category.sql

    r4922 r4923  
    1111UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `c_review_category_id` = 11;
    1212UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `c_review_category_id` = 12;
     13INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     14INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     15INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);

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

    r4922 r4923  
    211211INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
    212212INSERT INTO `c_review_category` VALUES (NULL,'HealthPersonalCare','ヘルス＆ビューティー',12);
     213INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     214INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     215INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);
    213216INSERT INTO `c_siteadmin` VALUES (NULL,'inc_page_footer_before','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a> <a href=\"http://www.openpne.jp/about/\" target=\"_blank\">OpenPNEとは</a>',NOW());
    214217INSERT INTO `c_siteadmin` VALUES (NULL,'inc_page_footer_after','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a>',NOW());

  • OpenPNE/trunk/setup/sql/mysql41/update/update02-for2.11.3-alter_c_review_category.sql

    r4922 r4923  
     1/*!40101 SET NAMES utf8 */;
     2
    13UPDATE `c_review_category` SET `category` = 'Books' WHERE `c_review_category_id` = 1;
    24UPDATE `c_review_category` SET `category` = 'ForeignBooks' WHERE `c_review_category_id` = 2;
    … …  
    1113UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `c_review_category_id` = 11;
    1214UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `c_review_category_id` = 12;
     15INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     16INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     17INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);

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

    r4922 r4923  
    209209INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'SportingGoods','スポーツ',11);
    210210INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'HealthPersonalCare','ヘルス＆ビューティー',12);
     211INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
     212INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Baby','ベビー＆マタニティ',14);
     213INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Apparel','アパレル＆シューズ',15);
    211214INSERT INTO c_siteadmin VALUES (nextval('c_siteadmin_c_siteadmin_id_seq'),'inc_page_footer_before','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a> <a href=\"http://www.openpne.jp/about/\" target=\"_blank\">OpenPNEとは</a>',NOW());
    212215INSERT INTO c_siteadmin VALUES (nextval('c_siteadmin_c_siteadmin_id_seq'),'inc_page_footer_after','<a href=\"./?m=pc&amp;a=page_o_sns_kiyaku\" target=\"_blank\">利用規約</a> <a href=\"./?m=pc&amp;a=page_o_sns_privacy\" target=\"_blank\">プライバシーポリシー</a>',NOW());

  • OpenPNE/trunk/setup/sql/postgres74/update/update01-for2.11.3-alter_c_review_category.sql

    r4922 r4923  
    1111UPDATE c_review_category SET category = 'SportingGoods' WHERE c_review_category_id = 11;
    1212UPDATE c_review_category SET category = 'HealthPersonalCare' WHERE c_review_category_id = 12;
     13INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
     14INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Baby','ベビー＆マタニティ',14);
     15INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Apparel','アパレル＆シューズ',15);
Note: See TracChangeset for help on using the changeset viewer.