diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-26 01:17:40 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-26 01:17:40 +0000 |
| commit | 5362625eabd86278d9f7cbc7175e02e3b5f613ca (patch) | |
| tree | 34adeecdc30441ba7c4b497b986415d7608b933a /phpBB/install | |
| parent | 4e43cb51536fdfff64d8560b054ad601949deb6d (diff) | |
| download | forums-5362625eabd86278d9f7cbc7175e02e3b5f613ca.tar forums-5362625eabd86278d9f7cbc7175e02e3b5f613ca.tar.gz forums-5362625eabd86278d9f7cbc7175e02e3b5f613ca.tar.bz2 forums-5362625eabd86278d9f7cbc7175e02e3b5f613ca.tar.xz forums-5362625eabd86278d9f7cbc7175e02e3b5f613ca.zip | |
Various changes, and tests ... marking/tracking is not complete ... tinkering, changing, etc. still to be done ... it's just I've made numerous and various changes to different files so a commit really is due
git-svn-id: file:///svn/phpbb/trunk@3953 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 20a9e01696..49eaed8d05 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -229,6 +229,19 @@ CREATE TABLE phpbb_forums ( KEY forum_last_post_id (forum_last_post_id) ); + +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_forums_marking' +# +CREATE TABLE phpbb_forums_marking ( + user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, + forum_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, + mark_time int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (user_id, forum_id) +); + + # -------------------------------------------------------- # # Table structure for table 'phpbb_forums_watch' @@ -744,7 +757,6 @@ CREATE TABLE phpbb_topics ( # CREATE TABLE phpbb_topics_marking ( user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, - forum_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, topic_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, mark_type tinyint(4) DEFAULT '0' NOT NULL, mark_time int(11) DEFAULT '0' NOT NULL, |