Changeset 22736 for branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql

Timestamp:

2013/03/15 19:12:17 (11 years ago)

Author:

h_yoshimoto

Message:

#2193 税率チームのコミットをマージ(from camp/camp-2_13-tax)

Location:

branches/version-2_13-dev

Files:

• . (modified) (1 prop)
• html/install/sql/create_table_pgsql.sql (modified) (10 diffs)

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

@@ -74 +74 @@
     zip01 text,
     zip02 text,
+    country_id int,
     pref smallint,
     addr01 text,
@@ -88 +89 @@
     law_zip01 text,
     law_zip02 text,
+    law_country_id int,
     law_pref smallint,
     law_addr01 text,
@@ -109 +111 @@
     law_term09 text,
     law_term10 text,
-    tax numeric NOT NULL DEFAULT 5,
-    tax_rule smallint NOT NULL DEFAULT 1,
     email01 text,
     email02 text,
@@ -485 +485 @@
     zip01 text,
     zip02 text,
+    country_id int,
     pref smallint,
     addr01 text,
@@ -538 +539 @@
     order_zip01 text,
     order_zip02 text,
+    order_country_id int,
     order_pref smallint,
     order_addr01 text,
@@ -597 +599 @@
     order_zip01 text,
     order_zip02 text,
+    order_country_id int,
     order_pref smallint,
     order_addr01 text,
@@ -655 +658 @@
     shipping_fax02 text,
     shipping_fax03 text,
+    shipping_country_id int,
     shipping_pref smallint,
     shipping_zip01 text,
@@ -694 +698 @@
     zip01 text,
     zip02 text,
+    country_id int,
     pref smallint,
     addr01 text,
@@ -1100 +1105 @@
     name text,
     rank smallint NOT NULL,
+    PRIMARY KEY (id)
+);
+
+CREATE TABLE mtb_country (
+    id int,
+    name text,
+    rank int NOT NULL,
     PRIMARY KEY (id)
 );
@@ -1204 +1216 @@
 );
 
+CREATE TABLE dtb_tax_rule (
+    tax_rule_id int NOT NULL,
+    country_id int NOT NULL DEFAULT 0,
+    pref_id int NOT NULL DEFAULT 0,
+    product_id int NOT NULL DEFAULT 0,
+    product_class_id int NOT NULL DEFAULT 0,
+    calc_rule smallint NOT NULL DEFAULT 1,
+    tax_rate numeric NOT NULL DEFAULT 5,
+    tax_adjust numeric NOT NULL DEFAULT 0,
+    apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    member_id int NOT NULL,
+    del_flg smallint NOT NULL DEFAULT 0,
+    create_date timestamp NOT NULL,
+    update_date timestamp NOT NULL,
+    PRIMARY KEY (tax_rule_id)
+);
 
 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);