diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-21 00:46:04 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-21 00:46:04 +0000 |
| commit | 5706375aaccb53c902433c65b89621760c642c52 (patch) | |
| tree | 4c7c65d8e59e248b5e27a24cb3eb8aa6efa4131d | |
| parent | 82507fb44ce961ad777a3c5e644a1fbfc9399a53 (diff) | |
| download | forums-5706375aaccb53c902433c65b89621760c642c52.tar forums-5706375aaccb53c902433c65b89621760c642c52.tar.gz forums-5706375aaccb53c902433c65b89621760c642c52.tar.bz2 forums-5706375aaccb53c902433c65b89621760c642c52.tar.xz forums-5706375aaccb53c902433c65b89621760c642c52.zip | |
UG related update
git-svn-id: file:///svn/phpbb/trunk@718 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 1 |
2 files changed, 4 insertions, 3 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index fd25d3cebb..ad00a8c31d 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -44,6 +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_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator int(11) DEFAULT '0' NOT NULL, @@ -203,7 +204,7 @@ CREATE TABLE phpbb_posts ( post_time int(10) DEFAULT '0' NOT NULL, poster_ip char(8) NOT NULL, post_username varchar(30), - bbcode_uid varchar(10) NOT NULL, + bbcode_uid char(10) NOT NULL, post_edit_time int(11), post_edit_count smallint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), @@ -241,7 +242,7 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_to_userid int(11) DEFAULT '0' NOT NULL, privmsgs_date int(11) DEFAULT '0' NOT NULL, privmsgs_ip char(8) NOT NULL, - privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, + privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, PRIMARY KEY (privmsgs_id), KEY privmsgs_from_userid (privmsgs_from_userid), KEY privmsgs_to_userid (privmsgs_to_userid) @@ -411,7 +412,6 @@ CREATE TABLE phpbb_topics ( topic_replies int(11) DEFAULT '0' NOT NULL, topic_status tinyint(3) DEFAULT '0' NOT NULL, topic_type tinyint(3) DEFAULT '0' NOT NULL, - topic_notify tinyint(3) DEFAULT '0', topic_last_post_id int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (topic_id), KEY forum_id (forum_id), diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index c7427531d1..d6ddf134f7 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -181,6 +181,7 @@ CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id); -------------------------------------------------------- */ CREATE TABLE phpbb_groups ( group_id int4 DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL, + group_type int2 DEFAULT '1' NOT NULL, group_name varchar(100) NOT NULL, group_description varchar(255) NOT NULL, group_moderator int4 NOT NULL, |