Changeset 20435 for branches/version-2_5-dev/html/install

Timestamp:

2011/02/28 12:35:00 (15 years ago)

Author:

nanasess

bzr:base-revision:

[email protected]

bzr:committer:

Kentaro Ohkouchi <[email protected]>

bzr:file-ids:

data/class/SC_Fpdf.php 17182@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2FSC_Fpdf.php
data/class/helper/SC_Helper_Mail.php 15618@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mail.php
data/class/helper/SC_Helper_Purchase.php sc_helper_purchase.p-20101020100530-jyaoa7ch9pdfjqzp-1
data/class/pages/admin/LC_Page_Admin_Home.php 15287@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2FLC_Page_Admin_Home.php
data/class/pages/mypage/LC_Page_Mypage_Order.php 16238@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Order.php
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.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/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:

3163

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-revisions:

data/class/SC_Fpdf.php [email protected]
data/class/helper/SC_Helper_Mail.php [email protected]
data/class/helper/SC_Helper_Purchase.php [email protected]
data/class/pages/admin/LC_Page_Admin_Home.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Order.php [email protected]
html/install/index.php [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/insert_data.sql [email protected]

bzr:timestamp:

2011-02-28 12:34:42.974999905 +0900

bzr:user-agent:

bzr2.2.1+bzr-svn1.0.4

svn:original-date:

2011-02-28T03:34:42.975000Z

Message:

#937(dtb_order_detail に主キーが無い)

• dtb_order_detail.order_detail_id を作成
• 受注詳細の並び順を order_detail_id に変更

#624(軽微な表示乱れを修正)

• 受注完了のメッセージを修正

Location:

branches/version-2_5-dev/html/install

Files:

• index.php (modified) (1 diff)
• sql/create_table_mysql.sql (modified) (2 diffs)
• sql/create_table_pgsql.sql (modified) (2 diffs)
• sql/insert_data.sql (modified) (2 diffs)

branches/version-2_5-dev/html/install/index.php

@@ -999 +999 @@
                  array("dtb_news", "news_id"),
                  array("dtb_order", "order_id"),
+                 array("dtb_order_detail", "order_detail_id"),
                  array("dtb_other_deliv", "other_deliv_id"),
                  array("dtb_pagelayout", "page_id"),

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

@@ -707 +707 @@
 
 CREATE TABLE dtb_order_detail (
+    order_detail_id int NOT NULL,
     order_id int NOT NULL,
     product_id int NOT NULL,
@@ -716 +717 @@
     price numeric,
     quantity numeric,
-    point_rate numeric
+    point_rate numeric,
+    PRIMARY KEY (order_detail_id)
 ) ENGINE=InnoDB;
 

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

@@ -707 +707 @@
 
 CREATE TABLE dtb_order_detail (
+    order_detail_id int NOT NULL,
     order_id int NOT NULL,
     product_id int NOT NULL,
@@ -716 +717 @@
     price numeric,
     quantity numeric,
-    point_rate numeric
+    point_rate numeric,
+    PRIMARY KEY (order_detail_id)
 );
 

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

@@ -476 +476 @@
 
 ', '
-
-===============================================================
+============================================
 
 
@@ -485 +484 @@
 
 ご質問やご不明な点がございましたら、こちらからお願いいたします。
-http://------.co.jp
 
 ', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);