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

Changeset 4936


Ignore:
Timestamp:
Jan 13, 2008, 2:29:25 PM (15 years ago)
Author:
ogawa
Message:

#1747:updateSQLを修正(INSERT IGNORE, WHEREの条件変更)

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

Legend:

Unmodified
Added
Removed

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

    r4923 r4936  
    1 UPDATE `c_review_category` SET `category` = 'Books' WHERE `c_review_category_id` = 1;
    2 UPDATE `c_review_category` SET `category` = 'ForeignBooks' WHERE `c_review_category_id` = 2;
    3 UPDATE `c_review_category` SET `category` = 'Music' WHERE `c_review_category_id` = 3;
    4 UPDATE `c_review_category` SET `category` = 'Classical' WHERE `c_review_category_id` = 4;
    5 UPDATE `c_review_category` SET `category` = 'DVD' WHERE `c_review_category_id` = 5;
    6 UPDATE `c_review_category` SET `category` = 'VideoGames' WHERE `c_review_category_id` = 6;
    7 UPDATE `c_review_category` SET `category` = 'Software' WHERE `c_review_category_id` = 7;
    8 UPDATE `c_review_category` SET `category` = 'Electronics' WHERE `c_review_category_id` = 8;
    9 UPDATE `c_review_category` SET `category` = 'Kitchen' WHERE `c_review_category_id` = 9;
    10 UPDATE `c_review_category` SET `category` = 'Toys' WHERE `c_review_category_id` = 10;
    11 UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `c_review_category_id` = 11;
    12 UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `c_review_category_id` = 12;
    13 INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
    14 INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
    15 INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);
     1UPDATE `c_review_category` SET `category` = 'Books' WHERE `category` = 'books-jp';
     2UPDATE `c_review_category` SET `category` = 'ForeignBooks' WHERE `category` = 'books-us';
     3UPDATE `c_review_category` SET `category` = 'Music' WHERE `category` = 'music-jp';
     4UPDATE `c_review_category` SET `category` = 'Classical' WHERE `category` = 'classical-jp';
     5UPDATE `c_review_category` SET `category` = 'DVD' WHERE `category` = 'dvd-jp';
     6UPDATE `c_review_category` SET `category` = 'VideoGames' WHERE `category` = 'videogames-jp';
     7UPDATE `c_review_category` SET `category` = 'Software' WHERE `category` = 'software-jp';
     8UPDATE `c_review_category` SET `category` = 'Electronics' WHERE `category` = 'electronics-jp';
     9UPDATE `c_review_category` SET `category` = 'Kitchen' WHERE `category` = 'kitchen-jp';
     10UPDATE `c_review_category` SET `category` = 'Toys' WHERE `category` = 'toys-jp';
     11UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `category` = 'sporting-goods-jp';
     12UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `category` = 'hpc-jp';
     13INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     14INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     15INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);

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

    r4923 r4936  
    11/*!40101 SET NAMES utf8 */;
    22
    3 UPDATE `c_review_category` SET `category` = 'Books' WHERE `c_review_category_id` = 1;
    4 UPDATE `c_review_category` SET `category` = 'ForeignBooks' WHERE `c_review_category_id` = 2;
    5 UPDATE `c_review_category` SET `category` = 'Music' WHERE `c_review_category_id` = 3;
    6 UPDATE `c_review_category` SET `category` = 'Classical' WHERE `c_review_category_id` = 4;
    7 UPDATE `c_review_category` SET `category` = 'DVD' WHERE `c_review_category_id` = 5;
    8 UPDATE `c_review_category` SET `category` = 'VideoGames' WHERE `c_review_category_id` = 6;
    9 UPDATE `c_review_category` SET `category` = 'Software' WHERE `c_review_category_id` = 7;
    10 UPDATE `c_review_category` SET `category` = 'Electronics' WHERE `c_review_category_id` = 8;
    11 UPDATE `c_review_category` SET `category` = 'Kitchen' WHERE `c_review_category_id` = 9;
    12 UPDATE `c_review_category` SET `category` = 'Toys' WHERE `c_review_category_id` = 10;
    13 UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `c_review_category_id` = 11;
    14 UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `c_review_category_id` = 12;
    15 INSERT INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
    16 INSERT INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
    17 INSERT INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);
     3UPDATE `c_review_category` SET `category` = 'Books' WHERE `category` = 'books-jp';
     4UPDATE `c_review_category` SET `category` = 'ForeignBooks' WHERE `category` = 'books-us';
     5UPDATE `c_review_category` SET `category` = 'Music' WHERE `category` = 'music-jp';
     6UPDATE `c_review_category` SET `category` = 'Classical' WHERE `category` = 'classical-jp';
     7UPDATE `c_review_category` SET `category` = 'DVD' WHERE `category` = 'dvd-jp';
     8UPDATE `c_review_category` SET `category` = 'VideoGames' WHERE `category` = 'videogames-jp';
     9UPDATE `c_review_category` SET `category` = 'Software' WHERE `category` = 'software-jp';
     10UPDATE `c_review_category` SET `category` = 'Electronics' WHERE `category` = 'electronics-jp';
     11UPDATE `c_review_category` SET `category` = 'Kitchen' WHERE `category` = 'kitchen-jp';
     12UPDATE `c_review_category` SET `category` = 'Toys' WHERE `category` = 'toys-jp';
     13UPDATE `c_review_category` SET `category` = 'SportingGoods' WHERE `category` = 'sporting-goods-jp';
     14UPDATE `c_review_category` SET `category` = 'HealthPersonalCare' WHERE `category` = 'hpc-jp';
     15INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Watches','時計',13);
     16INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Baby','ベビー＆マタニティ',14);
     17INSERT IGNORE INTO `c_review_category` VALUES (NULL,'Apparel','アパレル＆シューズ',15);

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

    r4923 r4936  
    1 UPDATE c_review_category SET category = 'Books' WHERE c_review_category_id = 1;
    2 UPDATE c_review_category SET category = 'ForeignBooks' WHERE c_review_category_id = 2;
    3 UPDATE c_review_category SET category = 'Music' WHERE c_review_category_id = 3;
    4 UPDATE c_review_category SET category = 'Classical' WHERE c_review_category_id = 4;
    5 UPDATE c_review_category SET category = 'DVD' WHERE c_review_category_id = 5;
    6 UPDATE c_review_category SET category = 'VideoGames' WHERE c_review_category_id = 6;
    7 UPDATE c_review_category SET category = 'Software' WHERE c_review_category_id = 7;
    8 UPDATE c_review_category SET category = 'Electronics' WHERE c_review_category_id = 8;
    9 UPDATE c_review_category SET category = 'Kitchen' WHERE c_review_category_id = 9;
    10 UPDATE c_review_category SET category = 'Toys' WHERE c_review_category_id = 10;
    11 UPDATE c_review_category SET category = 'SportingGoods' WHERE c_review_category_id = 11;
    12 UPDATE c_review_category SET category = 'HealthPersonalCare' WHERE c_review_category_id = 12;
     1UPDATE c_review_category SET category = 'Books' WHERE category = 'books-jp';
     2UPDATE c_review_category SET category = 'ForeignBooks' WHERE category = 'books-us';
     3UPDATE c_review_category SET category = 'Music' WHERE category = 'music-jp';
     4UPDATE c_review_category SET category = 'Classical' WHERE category = 'classical-jp';
     5UPDATE c_review_category SET category = 'DVD' WHERE category = 'dvd-jp';
     6UPDATE c_review_category SET category = 'VideoGames' WHERE category = 'videogames-jp';
     7UPDATE c_review_category SET category = 'Software' WHERE category = 'software-jp';
     8UPDATE c_review_category SET category = 'Electronics' WHERE category = 'electronics-jp';
     9UPDATE c_review_category SET category = 'Kitchen' WHERE category = 'kitchen-jp';
     10UPDATE c_review_category SET category = 'Toys' WHERE category = 'toys-jp';
     11UPDATE c_review_category SET category = 'SportingGoods' WHERE category = 'sporting-goods-jp';
     12UPDATE c_review_category SET category = 'HealthPersonalCare' WHERE category = 'hpc-jp';
    1313INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Watches','時計',13);
    1414INSERT 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.