Changeset 20887


Ignore:
Timestamp:
2011/04/22 13:35:53 (11 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:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_11-dev/html/install/sql/create_table_mysql.sql

    r20870 r20887  
    11351135CREATE TABLE dtb_plugin ( 
    11361136    plugin_id int NOT NULL, 
    1137     plugin_name varchar(255) NOT NULL DEFAULT '', 
     1137    plugin_name varchar(255) NOT NULL, 
    11381138    plugin_code varchar(255) NOT NULL, 
    1139     author varchar(255) NOT NULL DEFAULT '', 
    1140     plugin_site_url varchar(255) NOT NULL DEFAULT '', 
    1141     plugin_version varchar(255) NOT NULL DEFAULT '', 
    1142     plugin_description varchar(255) NOT NULL DEFAULT '', 
    1143     plugin_setting_path varchar(255) NOT NULL DEFAULT '', 
    1144     class_name varchar(255) NOT NULL DEFAULT '', 
     1139    author varchar(255), 
     1140    plugin_site_url varchar(255), 
     1141    plugin_version varchar(255), 
     1142    plugin_description varchar(255), 
     1143    plugin_setting_path varchar(255), 
     1144    class_name varchar(255) NOT NULL, 
    11451145    rank int NOT NULL DEFAULT 0, 
    11461146    status smallint NOT NULL DEFAULT 0, 
     
    11621162 
    11631163CREATE TABLE dtb_index_list ( 
    1164     table_name varchar(30) NOT NULL DEFAULT '', 
    1165     column_name varchar(30) NOT NULL DEFAULT '', 
     1164    table_name varchar(30) NOT NULL, 
     1165    column_name varchar(30) NOT NULL, 
    11661166    recommend_flg smallint NOT NULL DEFAULT 0, 
    11671167    recommend_comment text, 
  • branches/version-2_11-dev/html/install/sql/create_table_pgsql.sql

    r20870 r20887  
    11351135CREATE TABLE dtb_plugin ( 
    11361136    plugin_id int NOT NULL, 
    1137     plugin_name text NOT NULL DEFAULT '', 
     1137    plugin_name text NOT NULL, 
    11381138    plugin_code text NOT NULL, 
    1139     author text NOT NULL DEFAULT '', 
    1140     plugin_site_url text NOT NULL DEFAULT '', 
    1141     plugin_version text NOT NULL DEFAULT '', 
    1142     plugin_description text NOT NULL DEFAULT '', 
    1143     plugin_setting_path text NOT NULL DEFAULT '', 
    1144     class_name text NOT NULL DEFAULT '', 
     1139    author text, 
     1140    plugin_site_url text, 
     1141    plugin_version text, 
     1142    plugin_description text, 
     1143    plugin_setting_path text, 
     1144    class_name text NOT NULL, 
    11451145    rank int NOT NULL DEFAULT 0, 
    11461146    status smallint NOT NULL DEFAULT 0, 
     
    11621162 
    11631163CREATE TABLE dtb_index_list ( 
    1164     table_name text NOT NULL DEFAULT '', 
    1165     column_name text NOT NULL DEFAULT '', 
     1164    table_name text NOT NULL, 
     1165    column_name text NOT NULL, 
    11661166    recommend_flg smallint NOT NULL DEFAULT 0, 
    11671167    recommend_comment text, 
Note: See TracChangeset for help on using the changeset viewer.