Changeset 18777 for branches/version-2_5-dev/html/install/sql/create_table_mysql.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_mysql.sql (modified) (3 diffs)

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

@@ -149 +149 @@
     regular_holiday_ids text,
     latitude text,
-    longitude text
+    longitude text,
+    regular_holiday_ids text,
+    downloadable_days numeric DEFAULT 30,
+    downloadable_days_unlimited smallint
 ) TYPE=InnoDB;
 
@@ -341 +344 @@
     update_date datetime,
     deliv_date_id int,
+    down smallint NOT NULL ,
+    down_filename text,
+    down_realfilename text,
     PRIMARY KEY (product_id)
 ) TYPE=InnoDB;
@@ -1292 +1298 @@
     PRIMARY KEY (id(64))
 ) TYPE=InnoDB;
+
+CREATE TABLE mtb_down (
+    id int2,
+    name text,
+    rank int2 NOT NULL,
+    PRIMARY KEY (id)
+) TYPE=InnoDB;