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

Timestamp:

2011/01/10 13:59:23 (13 years ago)

Author:

nanasess

bzr:base-revision:

svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:19859

bzr:committer:

Kentaro Ohkouchi <nanasess@fsm.ne.jp>

bzr:file-ids:

data/Smarty/templates/default/shopping/deliv.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fshopping%2Fdeliv.tpl
data/Smarty/templates/default/shopping/multiple.tpl multiple.tpl-20110109122547-u3fq5xmi1b4jn5n4-1
data/Smarty/templates/default/shopping/nonmember_input.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fshopping%2Fnonmember_input.tpl
data/Smarty/templates/default/shopping/payment.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fshopping%2Fpayment.tpl
data/class/SC_CartSession.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_CartSession.php
data/class/SC_Customer.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Customer.php
data/class/helper/SC_Helper_DB.php 15176@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_DB.php
data/class/helper/SC_Helper_Purchase.php sc_helper_purchase.p-20101020100530-jyaoa7ch9pdfjqzp-1
data/class/pages/error/LC_Page_Error.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Ferror%2FLC_Page_Error.php
data/class/pages/mypage/LC_Page_Mypage_DeliveryAddr.php 16093@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_DeliveryAddr.php
data/class/pages/shopping/LC_Page_Shopping.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping.php
data/class/pages/shopping/LC_Page_Shopping_Confirm.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Confirm.php
data/class/pages/shopping/LC_Page_Shopping_Deliv.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Deliv.php
data/class/pages/shopping/LC_Page_Shopping_Multiple.php lc_page_shopping_mul-20110109122547-u3fq5xmi1b4jn5n4-2
data/class/pages/shopping/LC_Page_Shopping_Payment.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Payment.php
data/class/util/SC_Utils.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Futil%2FSC_Utils.php
data/class_extends/page_extends/shopping/LC_Page_Shopping_Multiple_Ex.php lc_page_shopping_mul-20110109122547-u3fq5xmi1b4jn5n4-3
data/install.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Finstall.php
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/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
html/js/site.js site.js-20101208110316-7ungq6kj49bhw4d1-7
html/shopping/multiple.php multiple.php-20110109122547-u3fq5xmi1b4jn5n4-4
html/user_data/packages/default/css/under02.css 16708@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Fuser_data%2Fpackages%2Fdefault%2Fcss%2Funder02.css

bzr:mapping-version:

v4

bzr:merge:

nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18

bzr:repository-uuid:

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

bzr:revision-id:

nanasess@fsm.ne.jp-20110110045915-6b02oxleldtyw7ee

bzr:revno:

2589

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-revisions:

data/Smarty/templates/default/shopping/deliv.tpl nanasess@fsm.ne.jp-20110109122851-7ox5o3sn0yp5rjpn
data/Smarty/templates/default/shopping/multiple.tpl nanasess@fsm.ne.jp-20110109122851-7ox5o3sn0yp5rjpn
data/Smarty/templates/default/shopping/nonmember_input.tpl nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/Smarty/templates/default/shopping/payment.tpl nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/SC_CartSession.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/SC_Customer.php nanasess@fsm.ne.jp-20110109122851-7ox5o3sn0yp5rjpn
data/class/helper/SC_Helper_DB.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/helper/SC_Helper_Purchase.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/pages/error/LC_Page_Error.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/pages/mypage/LC_Page_Mypage_DeliveryAddr.php nanasess@fsm.ne.jp-20110109122851-7ox5o3sn0yp5rjpn
data/class/pages/shopping/LC_Page_Shopping.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/pages/shopping/LC_Page_Shopping_Confirm.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/pages/shopping/LC_Page_Shopping_Deliv.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/pages/shopping/LC_Page_Shopping_Multiple.php nanasess@fsm.ne.jp-20110109122851-7ox5o3sn0yp5rjpn
data/class/pages/shopping/LC_Page_Shopping_Payment.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class/util/SC_Utils.php nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
data/class_extends/page_extends/shopping/LC_Page_Shopping_Multiple_Ex.php nanasess@fsm.ne.jp-20110109122604-8059rgcurt250q06
html/install/sql/create_table_mysql.sql nanasess@fsm.ne.jp-20110109121902-2oqes35heyjm5nlc
html/install/sql/create_table_pgsql.sql nanasess@fsm.ne.jp-20110109121902-2oqes35heyjm5nlc
html/install/sql/drop_table.sql nanasess@fsm.ne.jp-20110109121902-2oqes35heyjm5nlc
html/install/sql/insert_data.sql nanasess@fsm.ne.jp-20110109122604-8059rgcurt250q06
html/js/site.js nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18
html/shopping/multiple.php nanasess@fsm.ne.jp-20110109122604-8059rgcurt250q06
html/user_data/packages/default/css/under02.css nanasess@fsm.ne.jp-20110110045555-wppbrefvyq7ccz18

bzr:timestamp:

2011-01-10 13:59:15.388999939 +0900

bzr:user-agent:

bzr2.2.2+bzr-svn1.0.4

svn:original-date:

2011-01-10T04:59:15.389000Z

Message:

#843(複数配送先の指定)

• とりあえず通常配送が通るように修正

File:

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

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

@@ -588 +588 @@
     order_birth datetime,
     order_job int,
-    deliv_name01 text,
-    deliv_name02 text,
-    deliv_kana01 text,
-    deliv_kana02 text,
-    deliv_tel01 text,
-    deliv_tel02 text,
-    deliv_tel03 text,
-    deliv_fax01 text,
-    deliv_fax02 text,
-    deliv_fax03 text,
-    deliv_zip01 text,
-    deliv_zip02 text,
-    deliv_pref smallint,
-    deliv_addr01 text,
-    deliv_addr02 text,
     subtotal numeric,
     discount numeric,
-    deliv_fee numeric,
     charge numeric,
     use_point numeric,
@@ -615 +599 @@
     payment_id int,
     payment_method text,
-    deliv_id int,
-    deliv_time_id int,
-    deliv_time text,
-    deliv_no text,
     note text,
     status smallint,
@@ -627 +607 @@
     device_type_id int,
     del_flg smallint NOT NULL DEFAULT 0,
-    deliv_date text,
     memo01 text,
     memo02 text,
@@ -664 +643 @@
     order_birth datetime,
     order_job int,
-    deliv_name01 text,
-    deliv_name02 text,
-    deliv_kana01 text,
-    deliv_kana02 text,
-    deliv_tel01 text,
-    deliv_tel02 text,
-    deliv_tel03 text,
-    deliv_fax01 text,
-    deliv_fax02 text,
-    deliv_fax03 text,
-    deliv_zip01 text,
-    deliv_zip02 text,
-    deliv_pref smallint,
-    deliv_addr01 text,
-    deliv_addr02 text,
     subtotal numeric,
     discount numeric,
-    deliv_fee numeric,
     charge numeric,
     use_point numeric,
@@ -691 +654 @@
     payment_id int,
     payment_method text,
-    deliv_id int,
-    deliv_time_id int,
-    deliv_time text,
-    deliv_no text,
     note text,
     mail_flag smallint,
     status smallint,
-    deliv_check smallint,
     point_check smallint,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -704 +662 @@
     device_type_id int,
     del_flg smallint NOT NULL DEFAULT 0,
-    deliv_date text,
     order_id int,
     memo01 text,
@@ -717 +674 @@
     memo10 text,
     session text
+) ENGINE=InnoDB;
+
+CREATE TABLE dtb_shipping (
+    shipping_id int NOT NULL,
+    order_id int NOT NULL,
+    shipping_name01 text,
+    shipping_name02 text,
+    shipping_kana01 text,
+    shipping_kana02 text,
+    shipping_tel01 text,
+    shipping_tel02 text,
+    shipping_tel03 text,
+    shipping_fax01 text,
+    shipping_fax02 text,
+    shipping_fax03 text,
+    shipping_pref smallint,
+    shipping_zip01 text,
+    shipping_zip02 text,
+    shipping_addr01 text,
+    shipping_addr02 text,
+    deliv_id int NOT NULL,
+    time_id int NOT NULL,
+    shipping_fee NUMERIC,
+    shipping_time TEXT,
+    shipping_num TEXT,
+    shipping_date datetime,
+    shipping_commit_date datetime,
+    rank int,
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    update_date timestamp NOT NULL,
+    del_flg smallint NOT NULL DEFAULT 0,
+    PRIMARY KEY (shipping_id, order_id)
+) ENGINE=InnoDB;
+
+CREATE TABLE dtb_shipment_item (
+    shipping_id int NOT NULL,
+    product_class_id int NOT NULL,
+    order_id int NOT NULL,
+    product_name text NOT NULL,
+    product_code text,
+    classcategory_name1 text,
+    classcategory_name2 text,
+    price numeric,
+    quantity numeric,
+    PRIMARY KEY (shipping_id, product_class_id, order_id)
 ) ENGINE=InnoDB;