diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-22 16:45:43 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-22 16:45:43 +0000 |
| commit | 6fc1cb6b49e41b410504af142f059fd56af67159 (patch) | |
| tree | 6653ba708cf637dc4e9d007da98bd4ae36cba533 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 3bdde3d41f0f009666105c2eaa02610b84363b44 (diff) | |
| download | forums-6fc1cb6b49e41b410504af142f059fd56af67159.tar forums-6fc1cb6b49e41b410504af142f059fd56af67159.tar.gz forums-6fc1cb6b49e41b410504af142f059fd56af67159.tar.bz2 forums-6fc1cb6b49e41b410504af142f059fd56af67159.tar.xz forums-6fc1cb6b49e41b410504af142f059fd56af67159.zip | |
Wrong name for poll end caps in style imagesets, added poll_max_options to topic table ... ignore two new marking tables for time being ... code utilising one or both is yet to be committed and one or other may vanish.
git-svn-id: file:///svn/phpbb/trunk@3918 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 31 |
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 ( |