diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-21 15:01:47 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-01-21 15:01:47 +0000 |
| commit | f0dcfa29f706cd47a94e2ebc86c78b5223663050 (patch) | |
| tree | 9c7ba6f6817d99f9dce8ec7319dc522a24ce1e5d /phpBB/install | |
| parent | c151eddbc3e6b59461634ef69a818fe9ea0582fb (diff) | |
| download | forums-f0dcfa29f706cd47a94e2ebc86c78b5223663050.tar forums-f0dcfa29f706cd47a94e2ebc86c78b5223663050.tar.gz forums-f0dcfa29f706cd47a94e2ebc86c78b5223663050.tar.bz2 forums-f0dcfa29f706cd47a94e2ebc86c78b5223663050.tar.xz forums-f0dcfa29f706cd47a94e2ebc86c78b5223663050.zip | |
ratings table
git-svn-id: file:///svn/phpbb/trunk@3345 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 42 |
1 files changed, 28 insertions, 14 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 44768c5ae2..01220befe1 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -110,6 +110,20 @@ CREATE TABLE phpbb_config ( # -------------------------------------------------------- # +# Table structure for table 'phpbb_confirm' +# +CREATE TABLE phpbb_confirm ( + confirm_id char(32) NOT NULL default '', + session_id char(32) NOT NULL default '', + code char(6) NOT NULL default '', + time int(11) NOT NULL, + PRIMARY KEY (session_id,confirm_id), + KEY time (time) +); + + +# -------------------------------------------------------- +# # Table structure for table 'phpbb_disallow' # CREATE TABLE phpbb_disallow ( @@ -394,6 +408,19 @@ CREATE TABLE phpbb_ranks ( # -------------------------------------------------------- # +# Table structure for table 'phpbb_ratings' +# +CREATE TABLE phpbb_ratings ( + post_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', + user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL DEFAULT '0', + rating tinyint(4) NOT NULL, + KEY post_id (post_id), + KEY user_id (user_id) +); + + +# -------------------------------------------------------- +# # Table structure for table `phpbb_search_results` # CREATE TABLE phpbb_search_results ( @@ -610,19 +637,6 @@ CREATE TABLE phpbb_topics ( # -------------------------------------------------------- # -# Table structure for table 'phpbb_topics_rating' -# -CREATE TABLE phpbb_topics_rating ( - topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', - user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL DEFAULT '0', - rating tinyint(4) NOT NULL, - KEY topic_id (topic_id), - KEY user_id (user_id) -); - - -# -------------------------------------------------------- -# # Table structure for table 'phpbb_topics_watch' # CREATE TABLE phpbb_topics_watch ( @@ -656,7 +670,7 @@ CREATE TABLE phpbb_users ( user_id mediumint(8) UNSIGNED NOT NULL auto_increment, user_active tinyint(1) DEFAULT '1', user_founder tinyint(1) DEFAULT '0' NOT NULL, - user_permissions text NULL, + user_permissions blob NULL, user_ip varchar(40), user_regdate int(11) DEFAULT '0' NOT NULL, username varchar(30) NOT NULL, |