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

Timestamp:

2010/09/22 13:23:00 (14 years ago)

Author:

eccuore

Message:

#792(ダウンロード販売機能) 入金日追加、規格対応（規格構成変更と並行で作業中なので、作業途中の部分有）

File:

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

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

@@ -307 +307 @@
     update_date timestamp,
     deliv_date_id int,
-    down smallint NOT NULL DEFAULT 0,
-    down_filename text,
-    down_realfilename text,
     PRIMARY KEY (product_id)
 );
@@ -329 +326 @@
     create_date timestamp NOT NULL DEFAULT now(),
     update_date timestamp,
+    down int2 NOT NULL ,
+    down_filename text,
+    down_realfilename text,
     del_flg smallint NOT NULL DEFAULT 0,
     PRIMARY KEY (product_class_id)
@@ -658 +658 @@
     memo09 text,
     memo10 text,
+    payment_date timestamp,
     PRIMARY KEY (order_id)
 );