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

Timestamp:

2012/03/17 16:40:27 (12 years ago)

Author:

Seasoft

Message:

#1705 (NOT NULL 制約)

• ポイント周り

#1613 (typo修正・ソース整形・ソースコメントの改善)
#1692 (プラグイン機能（α版）)

• DB 間で列順を揃えた

File:

• branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql (modified) (5 diffs)

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

@@ -315 +315 @@
     price02 numeric NOT NULL,
     deliv_fee numeric,
-    point_rate numeric,
+    point_rate numeric NOT NULL DEFAULT 0,
     creator_id int NOT NULL,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -500 +500 @@
     buy_times numeric DEFAULT 0,
     buy_total numeric DEFAULT 0,
-    point numeric DEFAULT 0,
+    point numeric NOT NULL DEFAULT 0,
     note text,
     status smallint NOT NULL DEFAULT 1,
@@ -541 +541 @@
     deliv_fee numeric,
     charge numeric,
-    use_point numeric,
-    add_point numeric,
-    birth_point numeric DEFAULT 0,
+    use_point numeric NOT NULL DEFAULT 0,
+    add_point numeric NOT NULL DEFAULT 0,
+    birth_point numeric NOT NULL DEFAULT 0,
     tax numeric,
     total numeric,
@@ -598 +598 @@
     deliv_fee numeric,
     charge numeric,
-    use_point numeric,
-    add_point numeric,
-    birth_point numeric DEFAULT 0,
+    use_point numeric NOT NULL DEFAULT 0,
+    add_point numeric NOT NULL DEFAULT 0,
+    birth_point numeric NOT NULL DEFAULT 0,
     tax numeric,
     total numeric,
@@ -701 +701 @@
     price numeric,
     quantity numeric,
-    point_rate numeric,
+    point_rate numeric NOT NULL DEFAULT 0,
     PRIMARY KEY (order_detail_id)
 );