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

Changeset 4943 for OpenPNE/trunk


Ignore:
Timestamp:
Jan 15, 2008, 4:34:23 PM (15 years ago)
Author:
ogawa
Message:

#1788:開発版セットアップ用SQLの作成

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

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.3-create_tables.sql

    r4941 r4943  
    789789
    790790CREATE TABLE `c_pc_address_pre` (
    791   `c_pc_addess_pre_id` int(11) NOT NULL auto_increment,
     791  `c_pc_address_pre_id` int(11) NOT NULL auto_increment,
    792792  `c_member_id` int(11) NOT NULL default '0',
    793793  `pc_address` text NOT NULL,
    794794  `session` varchar(32) NOT NULL default '',
    795795  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    796   PRIMARY KEY  (`c_pc_addess_pre_id`),
     796  PRIMARY KEY  (`c_pc_address_pre_id`),
    797797  KEY `c_member_id` (`c_member_id`)
    798798) TYPE=MyISAM;
  • OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.3-insert_data.sql

    r4942 r4943  
    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-jp','和書',1);
    200 INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
    201 INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
    202 INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
    203 INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
    204 INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
    205 INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
    206 INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
    207 INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
    208 INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ&ホビー',10);
    209 INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
    210 INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス&ビューティー',12);
     199INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
     200INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
     201INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
     202INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
     203INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
     204INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
     205INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
     206INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
     207INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
     208INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ&ホビー',10);
     209INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
     210INSERT 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/mysql41/install/install-2.11.3-create_tables.sql

    r4941 r4943  
    791791
    792792CREATE TABLE `c_pc_address_pre` (
    793   `c_pc_addess_pre_id` int(11) NOT NULL auto_increment,
     793  `c_pc_address_pre_id` int(11) NOT NULL auto_increment,
    794794  `c_member_id` int(11) NOT NULL default '0',
    795795  `pc_address` text NOT NULL,
    796796  `session` varchar(32) NOT NULL default '',
    797797  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    798   PRIMARY KEY  (`c_pc_addess_pre_id`),
     798  PRIMARY KEY  (`c_pc_address_pre_id`),
    799799  KEY `c_member_id` (`c_member_id`)
    800800) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  • OpenPNE/trunk/setup/sql/mysql41/install/install-2.11.3-insert_data.sql

    r4942 r4943  
    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-jp','和書',1);
    202 INSERT INTO `c_review_category` VALUES (NULL,'books-us','洋書',2);
    203 INSERT INTO `c_review_category` VALUES (NULL,'music-jp','CDポピュラー',3);
    204 INSERT INTO `c_review_category` VALUES (NULL,'classical-jp','CDクラシック',4);
    205 INSERT INTO `c_review_category` VALUES (NULL,'dvd-jp','DVD',5);
    206 INSERT INTO `c_review_category` VALUES (NULL,'videogames-jp','ゲーム',6);
    207 INSERT INTO `c_review_category` VALUES (NULL,'software-jp','ソフトウェア',7);
    208 INSERT INTO `c_review_category` VALUES (NULL,'electronics-jp','エレクトロニクス',8);
    209 INSERT INTO `c_review_category` VALUES (NULL,'kitchen-jp','キッチン',9);
    210 INSERT INTO `c_review_category` VALUES (NULL,'toys-jp','おもちゃ&ホビー',10);
    211 INSERT INTO `c_review_category` VALUES (NULL,'sporting-goods-jp','スポーツ',11);
    212 INSERT INTO `c_review_category` VALUES (NULL,'hpc-jp','ヘルス&ビューティー',12);
     201INSERT INTO `c_review_category` VALUES (NULL,'Books','和書',1);
     202INSERT INTO `c_review_category` VALUES (NULL,'ForeignBooks','洋書',2);
     203INSERT INTO `c_review_category` VALUES (NULL,'Music','CDポピュラー',3);
     204INSERT INTO `c_review_category` VALUES (NULL,'Classical','CDクラシック',4);
     205INSERT INTO `c_review_category` VALUES (NULL,'DVD','DVD',5);
     206INSERT INTO `c_review_category` VALUES (NULL,'VideoGames','ゲーム',6);
     207INSERT INTO `c_review_category` VALUES (NULL,'Software','ソフトウェア',7);
     208INSERT INTO `c_review_category` VALUES (NULL,'Electronics','エレクトロニクス',8);
     209INSERT INTO `c_review_category` VALUES (NULL,'Kitchen','キッチン',9);
     210INSERT INTO `c_review_category` VALUES (NULL,'Toys','おもちゃ&ホビー',10);
     211INSERT INTO `c_review_category` VALUES (NULL,'SportingGoods','スポーツ',11);
     212INSERT 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/postgres74/install/install-2.11.3-insert_data.sql

    r4942 r4943  
    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-jp','和書',1);
    200 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'books-us','洋書',2);
    201 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'music-jp','CDポピュラー',3);
    202 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'classical-jp','CDクラシック',4);
    203 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'dvd-jp','DVD',5);
    204 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'videogames-jp','ゲーム',6);
    205 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'software-jp','ソフトウェア',7);
    206 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'electronics-jp','エレクトロニクス',8);
    207 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'kitchen-jp','キッチン',9);
    208 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'toys-jp','おもちゃ&ホビー',10);
    209 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'sporting-goods-jp','スポーツ',11);
    210 INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'hpc-jp','ヘルス&ビューティー',12);
     199INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Books','和書',1);
     200INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'ForeignBooks','洋書',2);
     201INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Music','CDポピュラー',3);
     202INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Classical','CDクラシック',4);
     203INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'DVD','DVD',5);
     204INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'VideoGames','ゲーム',6);
     205INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Software','ソフトウェア',7);
     206INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Electronics','エレクトロニクス',8);
     207INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Kitchen','キッチン',9);
     208INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'Toys','おもちゃ&ホビー',10);
     209INSERT INTO c_review_category VALUES (nextval('c_review_category_c_review_category_id_seq'),'SportingGoods','スポーツ',11);
     210INSERT 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());
Note: See TracChangeset for help on using the changeset viewer.