diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-20 01:32:57 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-20 01:32:57 +0000 |
| commit | 115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9 (patch) | |
| tree | 633cd13186e4bf1094f8b0a8bf96ea29359eb9a1 /phpBB/install | |
| parent | 229242acf52621d91ef3df8d82af5ab74edbc60b (diff) | |
| download | forums-115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9.tar forums-115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9.tar.gz forums-115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9.tar.bz2 forums-115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9.tar.xz forums-115a2cc9e0bb3345ccfbb25134a6f54e96c4e8f9.zip | |
And from the flames rose the might phoenix ... well, a little crisp around the edges with the odd missing feather ...
git-svn-id: file:///svn/phpbb/trunk@3688 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 2dfe4f7324..5ccfd80bf7 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -208,12 +208,12 @@ CREATE TABLE phpbb_forums ( forum_last_post_id INTEGER DEFAULT 0 NOT NULL, forum_last_poster_id INTEGER DEFAULT 0 NOT NULL, forum_last_post_time INTEGER DEFAULT 0 NOT NULL, - forum_last_poster_name VARCHAR(30), + forum_last_poster_name VARCHAR(30) DEFAULT '' NOT NULL, display_on_index SMALLINT DEFAULT 1 NOT NULL, enable_icons SMALLINT DEFAULT 1 NOT NULL, enable_prune SMALLINT DEFAULT 0 NOT NULL, - prune_next INTEGER, - prune_days SMALLINT NOT NULL, + prune_next INTEGER DEFAULT 0 NOT NULL, + prune_days SMALLINT DEFAULT 0 NOT NULL, prune_freq SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (forum_id) ); @@ -252,13 +252,13 @@ CREATE INDEX phpbb_forums_watch_status ON phpbb_forums_watch (notify_status); CREATE TABLE phpbb_groups ( group_id INTEGER NOT NULL, group_type SMALLINT DEFAULT 1 NOT NULL, - group_name VARCHAR(40) NOT NULL, + group_name VARCHAR(40) DEFAULT '' NOT NULL, group_display SMALLINT DEFAULT 0 NOT NULL, - group_avatar VARCHAR(100), - group_avatar_type SMALLINT, - group_rank INTEGER DEFAULT 0, + group_avatar VARCHAR(100) DEFAULT '' NOT NULL, + group_avatar_type SMALLINT DEFAULT 0 NOT NULL, + group_rank INTEGER DEFAULT 0 NOT NULL, group_colour VARCHAR(6) DEFAULT '' NOT NULL, - group_description VARCHAR(255) NOT NULL, + group_description VARCHAR(255) DEFAULT '' NOT NULL, PRIMARY KEY (group_id) ); @@ -462,7 +462,7 @@ CREATE TABLE phpbb_posts ( poster_id INTEGER DEFAULT 0 NOT NULL, attach_id INTEGER DEFAULT 0 NOT NULL, icon_id SMALLINT DEFAULT 1 NOT NULL, - poster_ip VARCHAR(40) NOT NULL, + poster_ip VARCHAR(40) DEFAULT '' NOT NULL, post_time INTEGER DEFAULT 0 NOT NULL, post_approved SMALLINT DEFAULT 1 NOT NULL, post_reported SMALLINT DEFAULT 0 NOT NULL, @@ -471,14 +471,14 @@ CREATE TABLE phpbb_posts ( enable_smilies SMALLINT DEFAULT 1 NOT NULL, enable_magic_url SMALLINT DEFAULT 1 NOT NULL, enable_sig SMALLINT DEFAULT 1 NOT NULL, - post_username VARCHAR(30), - post_subject VARCHAR(60), - post_text BLOB SUB_TYPE 1, - post_checksum VARCHAR(32) NOT NULL, + post_username VARCHAR(30) DEFAULT '', + post_subject VARCHAR(60) DEFAULT '', + post_text BLOB SUB_TYPE 1 DEFAULT '' NOT NULL, + post_checksum VARCHAR(32) DEFAULT '' NOT NULL, post_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, - bbcode_uid VARCHAR(10) NOT NULL, - post_edit_time INTEGER, + bbcode_uid VARCHAR(10) DEFAULT '' NOT NULL, + post_edit_time INTEGER DEFAULT 0 NOT NULL, post_edit_count SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (post_id) ); @@ -892,7 +892,7 @@ CREATE TABLE phpbb_topics ( topic_last_poster_name VARCHAR(30), topic_last_post_time INTEGER DEFAULT 0 NOT NULL, topic_moved_id INTEGER DEFAULT 0 NOT NULL, - poll_title VARCHAR(255) NOT NULL, + poll_title VARCHAR(255) DEFAULT '' NOT NULL, poll_start INTEGER DEFAULT 0 NOT NULL, poll_length INTEGER DEFAULT 0 NOT NULL, poll_last_vote INTEGER, |