From 5362625eabd86278d9f7cbc7175e02e3b5f613ca Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sat, 26 Apr 2003 01:17:40 +0000 Subject: 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 --- phpBB/install/schemas/mysql_schema.sql | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'phpBB/install') 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, -- cgit v1.2.1