Changeset 21942 for branches/version-2_12-dev/html/install/sql

Timestamp:

2012/06/26 21:28:06 (14 years ago)

Author:

h_yoshimoto

Message:

#1409 Myページに決済中のステータス表記を入れる

Location:

branches/version-2_12-dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• drop_table.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

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

@@ -998 +998 @@
 );
 
+CREATE TABLE mtb_customer_order_status (
+    id smallint,
+    name text,
+    rank smallint NOT NULL DEFAULT 0,
+    PRIMARY KEY (id)
+);
+
 CREATE TABLE mtb_order_status_color (
     id smallint,

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

@@ -998 +998 @@
 );
 
+CREATE TABLE mtb_customer_order_status (
+    id smallint,
+    name text,
+    rank smallint NOT NULL DEFAULT 0,
+    PRIMARY KEY (id)
+);
+
 CREATE TABLE mtb_order_status_color (
     id smallint,

branches/version-2_12-dev/html/install/sql/drop_table.sql

@@ -59 +59 @@
 DROP TABLE mtb_order_status_color;
 DROP TABLE mtb_order_status;
+DROP TABLE mtb_customer_order_status;
 DROP TABLE mtb_mail_type;
 DROP TABLE mtb_mail_tpl_path;

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

@@ -845 +845 @@
 INSERT INTO mtb_order_status_color (id, name, rank) VALUES (6, '#FFFFAB', 5);
 INSERT INTO mtb_order_status_color (id, name, rank) VALUES (7, '#FFCCCC', 6);
+
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (7, '注文未完了', 0);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (1, '注文受付', 1);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (2, '入金待ち', 2);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (6, '注文受付', 3);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (3, 'キャンセル', 4);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (4, '注文受付', 5);
+INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (5, '発送済み', 6);
 
 INSERT INTO mtb_ownersstore_err (id, name, rank) VALUES ('1000', '不明なエラーが発生しました。', 0);