diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-06-20 00:09:45 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-06-20 00:09:45 +0000 |
| commit | 9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4 (patch) | |
| tree | f75c591fb179cdfd197f9787f0ec0f0e0ad954c0 /phpBB/install | |
| parent | 52045ff2631cdfa14efd3379b64843cafd00df8f (diff) | |
| download | forums-9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4.tar forums-9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4.tar.gz forums-9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4.tar.bz2 forums-9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4.tar.xz forums-9b0d2143bb5d8de42c10ac74cbbf81feafb7ecb4.zip | |
what? yeah...
- turns out the backup issue was not a backup issue but a schema issue
- let there be color
git-svn-id: file:///svn/phpbb/trunk@6105 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 2 |
6 files changed, 6 insertions, 5 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index a505ed9578..3b03c818bc 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -16,7 +16,7 @@ CREATE TABLE phpbb_attachments ( comment BLOB SUB_TYPE TEXT, extension VARCHAR(100), mimetype VARCHAR(100), - filesize INTEGER NOT NULL, + filesize INTEGER DEFAULT 0 NOT NULL, filetime INTEGER DEFAULT 0 NOT NULL, thumbnail INTEGER DEFAULT 0 NOT NULL );; diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 72db08a523..a74e214aa7 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -44,6 +44,7 @@ ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_attach_poster_id] DEFAULT (0) FOR [poster_id], CONSTRAINT [DF_phpbb_attach_download_count] DEFAULT (0) FOR [download_count], CONSTRAINT [DF_phpbb_attach_filetime] DEFAULT (0) FOR [filetime], + CONSTRAINT [DF_phpbb_attach_filesize] DEFAULT (0) FOR [filesize], CONSTRAINT [DF_phpbb_attach_thumbnail] DEFAULT (0) FOR [thumbnail] GO diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 88d02429ef..f89f468085 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -17,7 +17,7 @@ CREATE TABLE phpbb_attachments ( comment text, extension varchar(100), mimetype varchar(100), - filesize int(20) UNSIGNED NOT NULL, + filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 900232b79a..5851bed653 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -54,7 +54,7 @@ CREATE TABLE phpbb_attachments ( "COMMENT" clob, extension varchar2(100), mimetype varchar2(100), - filesize number(20) NOT NULL, + filesize number(20) DEFAULT '0' NOT NULL, filetime number(11) DEFAULT '0' NOT NULL, thumbnail number(1) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_attachments PRIMARY KEY (attach_id) diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index f52d6fe278..8dc3d9d977 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -95,7 +95,7 @@ CREATE TABLE phpbb_attachments ( comment varchar(8000), extension varchar(100), mimetype varchar(100), - filesize INT4 NOT NULL, + filesize INT4 DEFAULT '0' NOT NULL, filetime INT4 DEFAULT '0' NOT NULL, thumbnail INT2 DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 74ac458057..af59df634b 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -19,7 +19,7 @@ CREATE TABLE phpbb_attachments ( comment text(65535), extension varchar(100), mimetype varchar(100), - filesize int(20) NOT NULL, + filesize int(20) NOT NULL DEFAULT '0', filetime int(11) NOT NULL DEFAULT '0', thumbnail tinyint(1) NOT NULL DEFAULT '0' ); |