diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-21 21:38:57 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-21 21:38:57 +0000 |
| commit | d7415808ea3989ea26b7ce51a38c66047077bf94 (patch) | |
| tree | f1a459643543fb44e58682f1a46b4cd93f19cb31 /phpBB/db | |
| parent | b8c7a55d92c1a165a851eaa2618841be92035490 (diff) | |
| download | forums-d7415808ea3989ea26b7ce51a38c66047077bf94.tar forums-d7415808ea3989ea26b7ce51a38c66047077bf94.tar.gz forums-d7415808ea3989ea26b7ce51a38c66047077bf94.tar.bz2 forums-d7415808ea3989ea26b7ce51a38c66047077bf94.tar.xz forums-d7415808ea3989ea26b7ce51a38c66047077bf94.zip | |
Re-added topic notify
git-svn-id: file:///svn/phpbb/trunk@725 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index ad00a8c31d..1f78b7cfe3 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -44,7 +44,7 @@ CREATE TABLE phpbb_user_group ( DROP TABLE IF EXISTS phpbb_groups; CREATE TABLE phpbb_groups ( group_id int(11) NOT NULL auto_increment, - group_type smallint(4) DEFAULT '1' NOT NULL, + group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator int(11) DEFAULT '0' NOT NULL, @@ -163,9 +163,8 @@ CREATE TABLE phpbb_forums ( cat_id int(10) NOT NULL, forum_name varchar(150), forum_desc text, - forum_access tinyint(3), + forum_status tinyint(4) DEFAULT '0' NOT NULL, forum_order int(11) DEFAULT '1' NOT NULL, - forum_type tinyint(4), forum_posts int(11) DEFAULT '0' NOT NULL, forum_topics tinyint(4) DEFAULT '0' NOT NULL, forum_last_post_id int(11) DEFAULT '0' NOT NULL, @@ -413,6 +412,7 @@ CREATE TABLE phpbb_topics ( topic_status tinyint(3) DEFAULT '0' NOT NULL, topic_type tinyint(3) DEFAULT '0' NOT NULL, topic_last_post_id int(11) DEFAULT '0' NOT NULL, + topic_notify tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_id (topic_id) |