Changeset 18787 for branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

Timestamp:

2010/08/18 15:12:25 (14 years ago)

Author:

nanasess

bzr:base-revision:

ohkouchi@loop-az.jp-20100818034225-loyoujma8pjbxn2u

bzr:committer:

Kentaro Ohkouchi <ohkouchi@loop-az.jp>

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:

ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

ohkouchi@loop-az.jp-20100818061207-vgzu2onofgbq0k0i

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 ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
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 ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981

bzr:text-revisions:

html/install/index.php ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_view.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9

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 に統合

File:

• branches/version-2_5-dev/html/install/sql/create_table_mysql.sql (modified) (2 diffs)

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

@@ -562 +562 @@
     PRIMARY KEY (customer_id)
 ) TYPE=InnoDB;
-
-CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
 
 CREATE TABLE dtb_order (
@@ -1172 +1170 @@
     PRIMARY KEY (id)
 ) TYPE=InnoDB;
+
+CREATE TABLE dtb_mobile_ext_session_id (
+    session_id text NOT NULL,
+    param_key text,
+    param_value text,
+    url text,
+    create_date timestamp NOT NULL DEFAULT now()
+);
+
+CREATE TABLE dtb_mobile_kara_mail (
+    kara_mail_id serial PRIMARY KEY,
+    session_id text NOT NULL,
+    token text NOT NULL,
+    next_url text NOT NULL,
+    create_date timestamp NOT NULL DEFAULT now(),
+    email text,
+    receive_date timestamp
+);
+
+CREATE TABLE dtb_module (
+    module_id int NOT NULL UNIQUE,
+    module_code text NOT NULL,
+    module_name text NOT NULL,
+    sub_data text,
+    auto_update_flg smallint NOT NULL DEFAULT 0,
+    del_flg smallint NOT NULL DEFAULT 0,
+    create_date datetime NOT NULL ,
+    update_date datetime NOT NULL
+) TYPE=InnoDB;
+
+CREATE TABLE dtb_session (
+    sess_id varchar(50) NOT NULL,
+    sess_data text,
+    create_date datetime NOT NULL,
+    update_date datetime NOT NULL,
+    PRIMARY KEY (sess_id)
+) TYPE=InnoDB;
+
+CREATE TABLE dtb_site_control (
+    control_id int auto_increment NOT NULL,
+    control_title varchar(255) ,
+    control_text text ,
+    control_flg int NOT NULL DEFAULT 2,
+    del_flg int NOT NULL DEFAULT 0,
+    memo text ,
+    create_date datetime NOT NULL,
+    update_date datetime NOT NULL,
+    PRIMARY KEY  (control_id)
+) TYPE=InnoDB;
+
+CREATE TABLE dtb_trackback (
+    trackback_id int auto_increment NOT NULL,
+    product_id int NOT NULL,
+    blog_name varchar(255) NOT NULL DEFAULT '',
+    title varchar(255) NOT NULL DEFAULT '',
+    excerpt text NOT NULL ,
+    url text NOT NULL ,
+    status int NOT NULL DEFAULT 2,
+    del_flg int NOT NULL DEFAULT 0,
+    create_date datetime NOT NULL,
+    update_date datetime NOT NULL,
+    PRIMARY KEY (trackback_id)
+) TYPE=InnoDB;
+
+CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
+CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id);
+CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
+CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id);
+CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key(64));
+CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value(64));
+CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url(64));
+CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date);
+CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64));
+CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date);
+CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);