Changeset 16867

Timestamp:

2007/12/02 22:30:10 (16 years ago)

Author:

adachi

Message:

SQL修正

Location:

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

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)

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

@@ -1 +1 @@
 create table dtb_module_update_logs(
-    module_id int auto_increment primary key NOT NULL,
+    log_id int auto_increment primary key NOT NULL,
+    module_id int not null,
     buckup_path text,
     error_flg smallint DEFAULT 0,

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

@@ -1 +1 @@
 create table dtb_module_update_logs(
-    module_id serial,
+    log_id serial NOT NULL,
+    module_id int NOT NULL,
     buckup_path text,
     error_flg int2 default 0,