Changeset 15166 for branches

Timestamp:

2007/08/02 20:06:59 (16 years ago)

Author:

nanasess

Message:

mtb_constants にコメント欄追加

Location:

branches/feature-module-update/html/install/sql

Files:

• create_table_mysql.sql (modified) (13 diffs)
• create_table_pgsql.sql (modified) (2 diffs)

branches/feature-module-update/html/install/sql/create_table_mysql.sql

@@ -36 +36 @@
     member smallint,
     order_date datetime,
-    create_date datetime NOT NULL 
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -230 +230 @@
     creator_id int NOT NULL,
     create_date datetime NOT NULL ,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -391 +391 @@
     hour smallint NOT NULL DEFAULT 0,
     order_date datetime ,
-    create_date datetime NOT NULL 
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -402 +402 @@
     creator_id int NOT NULL,
     create_date datetime NOT NULL ,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -426 +426 @@
     customer_id int NOT NULL,
     create_date datetime NOT NULL,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -432 +432 @@
     category_id int NOT NULL,
     product_count int NOT NULL,
-    create_date datetime NOT NULL 
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -438 +438 @@
     category_id int NOT NULL,
     product_count int,
-    create_date datetime NOT NULL 
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -530 +530 @@
     end_flag smallint,
     update_date datetime NOT NULL ,
-    create_data datetime NOT NULL 
+    create_data datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -792 +792 @@
     relate_product_id int,
     customer_id int,
-    create_date datetime 
+    create_date datetime
 ) TYPE=InnoDB ;
 
@@ -811 +811 @@
     del_flg smallint NOT NULL DEFAULT 0,
     create_date datetime NOT NULL,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -835 +835 @@
     update_url text,
     create_date datetime NOT NULL ,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -865 +865 @@
     status smallint NOT NULL DEFAULT 1,
     create_date datetime NOT NULL ,
-    update_date datetime NOT NULL 
+    update_date datetime NOT NULL
 ) TYPE=InnoDB ;
 
@@ -891 +891 @@
     del_flg smallint DEFAULT 0,
     create_date datetime NOT NULL,
-    update_date datetime NOT NULL 
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_templates 
+    update_date datetime NOT NULL
+) TYPE=InnoDB ;
+
+CREATE TABLE dtb_templates
 (
     template_code        varchar(50) NOT NULL UNIQUE    ,
     template_name        text            ,
     create_date        datetime        NOT NULL    ,
-    update_date        datetime        NOT NULL    
+    update_date        datetime        NOT NULL
 ) TYPE=InnoDB ;
 

branches/feature-module-update/html/install/sql/create_table_pgsql.sql

@@ -733 +733 @@
     pref_id int2 NOT NULL,
     pref_name text,
-    rank int2 NOT NULL DEFAULT 0
+    rank int2 NOT NULL DEFAULT 0,
+    PRIMARY KEY (pref_id)
 );
 
@@ -894 +895 @@
 );
 
-create table dtb_templates 
+create table dtb_templates
 (
 template_code        text        NOT NULL UNIQUE    ,