aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql31
1 files changed, 16 insertions, 15 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 30656b11cc..6168f4c4ae 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -303,20 +303,6 @@ CREATE TABLE phpbb_lang (
# --------------------------------------------------------
#
-# Table structure for table 'phpbb_lastread'
-#
-CREATE TABLE phpbb_lastread (
- user_id mediumint(9) NOT NULL default '0',
- lastread_type tinyint(4) NOT NULL default '0',
- forum_id smallint(6) NOT NULL default '0',
- topic_id mediumint(9) NOT NULL default '0',
- lastread_time int(4) NOT NULL default '0',
- PRIMARY KEY (user_id,topic_id)
-);
-
-
-# --------------------------------------------------------
-#
# Table structure for table 'phpbb_log_moderator'
#
CREATE TABLE phpbb_log_moderator (
@@ -740,7 +726,8 @@ CREATE TABLE phpbb_topics (
topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
poll_title varchar(255) NOT NULL,
poll_start int(11) NOT NULL DEFAULT '0',
- poll_length int(11) NOT NULL DEFAULT '0',
+ poll_length int(11) NOT NULL DEFAULT '0',
+ poll_max_options tinyint(4) UNSIGNED NOT NULL DEFAULT '1',
poll_last_vote int(11),
PRIMARY KEY (topic_id),
KEY forum_id (forum_id),
@@ -752,6 +739,20 @@ CREATE TABLE phpbb_topics (
# --------------------------------------------------------
#
+# Table structure for table 'phpbb_topic_marking'
+#
+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,
+ PRIMARY KEY (user_id, topic_id)
+);
+
+
+# --------------------------------------------------------
+#
# Table structure for table 'phpbb_topics_watch'
#
CREATE TABLE phpbb_topics_watch (