Changeset 4936

Show
Ignore:
Timestamp:
01/13/08 14:29:25 (2 years ago)
Author:
ogawa
Message:

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

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • 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);