Ignore:
Timestamp:
2010/08/18 15:12:25 (16 years ago)
Author:
nanasess
bzr:base-revision:
[email protected]
bzr:committer:
Kentaro Ohkouchi <[email protected]>
bzr:file-ids:

html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/column_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcolumn_comment.sql
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/drop_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_view.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
bzr:mapping-version:
v4
bzr:merge:

[email protected]
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
[email protected]
bzr:revno:
2270
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-parents:

html/install/index.php [email protected]
html/install/sql/column_comment.sql [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/insert_data.sql [email protected]
bzr:text-revisions:

html/install/index.php [email protected]
html/install/sql/column_comment.sql [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql [email protected]
html/install/sql/insert_data.sql [email protected]
bzr:timestamp:
2010-08-18 15:12:07.440000057 +0900
bzr:user-agent:
bzr2.1.2+bzr-svn1.0.2
svn:original-date:
2010-08-18T06:12:07.440000Z
Message:

インストーラの改善(#633)

  • add 配下の SQL ファイルを統合
  • INDEX の生成を create_table_*.sql に統合
Location:
branches/version-2_5-dev/html/install/sql
Files:
1 deleted
4 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r18786 r18787  
    562562    PRIMARY KEY (customer_id) 
    563563) TYPE=InnoDB; 
    564  
    565 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    566564 
    567565CREATE TABLE dtb_order ( 
    … …  
    11721170    PRIMARY KEY (id) 
    11731171) TYPE=InnoDB; 
     1172 
     1173CREATE TABLE dtb_mobile_ext_session_id ( 
     1174    session_id text NOT NULL, 
     1175    param_key text, 
     1176    param_value text, 
     1177    url text, 
     1178    create_date timestamp NOT NULL DEFAULT now() 
     1179); 
     1180 
     1181CREATE TABLE dtb_mobile_kara_mail ( 
     1182    kara_mail_id serial PRIMARY KEY, 
     1183    session_id text NOT NULL, 
     1184    token text NOT NULL, 
     1185    next_url text NOT NULL, 
     1186    create_date timestamp NOT NULL DEFAULT now(), 
     1187    email text, 
     1188    receive_date timestamp 
     1189); 
     1190 
     1191CREATE TABLE dtb_module ( 
     1192    module_id int NOT NULL UNIQUE, 
     1193    module_code text NOT NULL, 
     1194    module_name text NOT NULL, 
     1195    sub_data text, 
     1196    auto_update_flg smallint NOT NULL DEFAULT 0, 
     1197    del_flg smallint NOT NULL DEFAULT 0, 
     1198    create_date datetime NOT NULL , 
     1199    update_date datetime NOT NULL 
     1200) TYPE=InnoDB; 
     1201 
     1202CREATE TABLE dtb_session ( 
     1203    sess_id varchar(50) NOT NULL, 
     1204    sess_data text, 
     1205    create_date datetime NOT NULL, 
     1206    update_date datetime NOT NULL, 
     1207    PRIMARY KEY (sess_id) 
     1208) TYPE=InnoDB; 
     1209 
     1210CREATE TABLE dtb_site_control ( 
     1211    control_id int auto_increment NOT NULL, 
     1212    control_title varchar(255) , 
     1213    control_text text , 
     1214    control_flg int NOT NULL DEFAULT 2, 
     1215    del_flg int NOT NULL DEFAULT 0, 
     1216    memo text , 
     1217    create_date datetime NOT NULL, 
     1218    update_date datetime NOT NULL, 
     1219    PRIMARY KEY  (control_id) 
     1220) TYPE=InnoDB; 
     1221 
     1222CREATE TABLE dtb_trackback ( 
     1223    trackback_id int auto_increment NOT NULL, 
     1224    product_id int NOT NULL, 
     1225    blog_name varchar(255) NOT NULL DEFAULT '', 
     1226    title varchar(255) NOT NULL DEFAULT '', 
     1227    excerpt text NOT NULL , 
     1228    url text NOT NULL , 
     1229    status int NOT NULL DEFAULT 2, 
     1230    del_flg int NOT NULL DEFAULT 0, 
     1231    create_date datetime NOT NULL, 
     1232    update_date datetime NOT NULL, 
     1233    PRIMARY KEY (trackback_id) 
     1234) TYPE=InnoDB; 
     1235 
     1236CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
     1237CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 
     1238CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); 
     1239CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id); 
     1240CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key(64)); 
     1241CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value(64)); 
     1242CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url(64)); 
     1243CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); 
     1244CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64)); 
     1245CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date); 
     1246CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); 

  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r18786 r18787  
    563563    PRIMARY KEY (customer_id) 
    564564); 
    565  
    566 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
    567565 
    568566CREATE TABLE dtb_order ( 
    … …  
    11711169); 
    11721170 
     1171CREATE TABLE dtb_mobile_ext_session_id ( 
     1172    session_id text NOT NULL, 
     1173    param_key text, 
     1174    param_value text, 
     1175    url text, 
     1176    create_date timestamp NOT NULL DEFAULT now() 
     1177); 
     1178 
     1179CREATE TABLE dtb_mobile_kara_mail ( 
     1180    kara_mail_id serial PRIMARY KEY, 
     1181    session_id text NOT NULL, 
     1182    token text NOT NULL, 
     1183    next_url text NOT NULL, 
     1184    create_date timestamp NOT NULL DEFAULT now(), 
     1185    email text, 
     1186    receive_date timestamp 
     1187); 
     1188 
     1189CREATE TABLE dtb_session ( 
     1190    sess_id text NOT NULL, 
     1191    sess_data text, 
     1192    create_date timestamp NOT NULL, 
     1193    update_date timestamp NOT NULL, 
     1194    PRIMARY KEY (sess_id) 
     1195); 
     1196 
     1197CREATE TABLE dtb_module ( 
     1198    module_id int NOT NULL UNIQUE, 
     1199    module_code text NOT NULL, 
     1200    module_name text NOT NULL, 
     1201    sub_data text, 
     1202    auto_update_flg int2 NOT NULL DEFAULT 0, 
     1203    del_flg int2 NOT NULL DEFAULT 0, 
     1204    create_date timestamp NOT NULL DEFAULT NOW(), 
     1205    update_date timestamp NOT NULL 
     1206); 
     1207 
     1208CREATE TABLE dtb_site_control ( 
     1209    control_id serial primary key NOT NULL, 
     1210    control_title text , 
     1211    control_text text , 
     1212    control_flg int2 NOT NULL DEFAULT 2, 
     1213    del_flg int2 NOT NULL DEFAULT 0, 
     1214    memo text , 
     1215    create_date timestamp NOT NULL DEFAULT now(), 
     1216    update_date timestamp NOT NULL DEFAULT now() 
     1217); 
     1218 
     1219CREATE TABLE dtb_trackback ( 
     1220    trackback_id serial primary key NOT NULL, 
     1221    product_id int NOT NULL, 
     1222    blog_name varchar(255) NOT NULL DEFAULT '', 
     1223    title varchar(255) NOT NULL DEFAULT '', 
     1224    excerpt text NOT NULL DEFAULT '', 
     1225    url text NOT NULL DEFAULT '', 
     1226    status int2 NOT NULL DEFAULT 2, 
     1227    del_flg int2 NOT NULL DEFAULT 0, 
     1228    create_date timestamp NOT NULL, 
     1229    update_date timestamp NOT NULL 
     1230); 
     1231 
     1232CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
     1233CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 
     1234CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); 
     1235CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id); 
     1236 
     1237CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key); 
     1238CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value); 
     1239CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); 
     1240CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); 
     1241 
     1242CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token); 
     1243CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date); 
     1244CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); 

  • branches/version-2_5-dev/html/install/sql/drop_table.sql

    r18786 r18787  
    8888DROP TABLE dtb_customer_favorite_products; 
    8989DROP TABLE mtb_down; 
     90DROP TABLE dtb_module; 
     91DROP TABLE dtb_session; 
     92DROP TABLE dtb_mobile_ext_session_id; 
     93DROP TABLE dtb_mobile_kara_mail; 
     94DROP TABLE dtb_site_control; 
     95DROP TABLE dtb_trackback; 
    9096 

  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r18786 r18787  
    1 CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 
    2 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); 
    3 CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id); 
    4  
    51INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date) 
    62VALUES ('dummy','dummy',' ',0,0,1,1, now(), now()); 
    … …  
    181177insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_date','お届け指定日',54,now(),now()); 
    182178INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'order_id','注文番号',1,now(),now()); 
    183 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'campaign_id','キャンペーンID',2,now(),now()); 
    184179INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'customer_id','顧客ID',3,now(),now()); 
    185180INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'message','要望等',4,now(),now()); 
    … …  
    11031098 
    11041099INSERT INTO dtb_module (module_id,module_code,module_name,update_date,create_date) VALUES (0,0,'patch',now(),now()); 
     1100 
     1101INSERT INTO dtb_site_control (control_title, control_text) VALUES('トラックバック機能', 'トラックバック機能を使用するかどうかを決定します。'); 
Note: See TracChangeset for help on using the changeset viewer.