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

Timestamp:

2010/08/06 14:52:59 (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

@@ -149 +149 @@
     regular_holiday_ids text,
     latitude text,
-    longitude text
+    longitude text,
+    downloadable_days numeric DEFAULT 30,
+    downloadable_days_unlimited smallint
 );
 
@@ -341 +343 @@
     update_date timestamp,
     deliv_date_id int,
+    down int2 NOT NULL ,
+    down_filename text,
+    down_realfilename text,
     PRIMARY KEY (product_id)
 );
@@ -1290 +1295 @@
     PRIMARY KEY (id)
 );
+
+CREATE TABLE mtb_down (
+    id int2,
+    name text,
+    rank int2 NOT NULL,
+    PRIMARY KEY (id)
+);
+