Changeset 20887 for branches/version-2_11-dev/html

Timestamp:

2011/04/22 13:35:53 (13 years ago)

Author:

nanasess

bzr:base-revision:

svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_11-dev:20886

bzr:committer:

Kentaro Ohkouchi <ohkouchi@loop-az.jp>

bzr:file-ids:

html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql

bzr:mapping-version:

v4

bzr:merge:

ohkouchi@loop-az.jp-20110422043404-p09ogj7o0rg0q3bx

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

ohkouchi@loop-az.jp-20110422043550-bu8eu50po3uve0az

bzr:revno:

3598

bzr:revprop:branch-nick:

branches/version-2_11-dev

bzr:root:

branches/version-2_11-dev

bzr:text-revisions:

html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20110422043404-p09ogj7o0rg0q3bx
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20110422043404-p09ogj7o0rg0q3bx

bzr:timestamp:

2011-04-22 13:35:50.671000004 +0900

bzr:user-agent:

bzr2.2.1+bzr-svn1.0.4

svn:original-date:

2011-04-22T04:35:50.671000Z

Message:

#1272 (「NOT NULL DEFAULT 」 という制約で, バックアップ -> リストア時にシステムエラーとなる)

Location:

branches/version-2_11-dev/html/install/sql

Files:

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

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

@@ -1135 +1135 @@
 CREATE TABLE dtb_plugin (
     plugin_id int NOT NULL,
-    plugin_name varchar(255) NOT NULL DEFAULT '',
+    plugin_name varchar(255) NOT NULL,
     plugin_code varchar(255) NOT NULL,
-    author varchar(255) NOT NULL DEFAULT '',
-    plugin_site_url varchar(255) NOT NULL DEFAULT '',
-    plugin_version varchar(255) NOT NULL DEFAULT '',
-    plugin_description varchar(255) NOT NULL DEFAULT '',
-    plugin_setting_path varchar(255) NOT NULL DEFAULT '',
-    class_name varchar(255) NOT NULL DEFAULT '',
+    author varchar(255),
+    plugin_site_url varchar(255),
+    plugin_version varchar(255),
+    plugin_description varchar(255),
+    plugin_setting_path varchar(255),
+    class_name varchar(255) NOT NULL,
     rank int NOT NULL DEFAULT 0,
     status smallint NOT NULL DEFAULT 0,
@@ -1162 +1162 @@
 
 CREATE TABLE dtb_index_list (
-    table_name varchar(30) NOT NULL DEFAULT '',
-    column_name varchar(30) NOT NULL DEFAULT '',
+    table_name varchar(30) NOT NULL,
+    column_name varchar(30) NOT NULL,
     recommend_flg smallint NOT NULL DEFAULT 0,
     recommend_comment text,

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

@@ -1135 +1135 @@
 CREATE TABLE dtb_plugin (
     plugin_id int NOT NULL,
-    plugin_name text NOT NULL DEFAULT '',
+    plugin_name text NOT NULL,
     plugin_code text NOT NULL,
-    author text NOT NULL DEFAULT '',
-    plugin_site_url text NOT NULL DEFAULT '',
-    plugin_version text NOT NULL DEFAULT '',
-    plugin_description text NOT NULL DEFAULT '',
-    plugin_setting_path text NOT NULL DEFAULT '',
-    class_name text NOT NULL DEFAULT '',
+    author text,
+    plugin_site_url text,
+    plugin_version text,
+    plugin_description text,
+    plugin_setting_path text,
+    class_name text NOT NULL,
     rank int NOT NULL DEFAULT 0,
     status smallint NOT NULL DEFAULT 0,
@@ -1162 +1162 @@
 
 CREATE TABLE dtb_index_list (
-    table_name text NOT NULL DEFAULT '',
-    column_name text NOT NULL DEFAULT '',
+    table_name text NOT NULL,
+    column_name text NOT NULL,
     recommend_flg smallint NOT NULL DEFAULT 0,
     recommend_comment text,