diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-03-12 23:19:55 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-03-12 23:19:55 +0000 |
| commit | 9988679d567a8bba9bade92dd9524bb012a1fe43 (patch) | |
| tree | 72da21e7465fed3ca99f20bd809a3df9c020530d /phpBB/install/schemas/mysql_schema.sql | |
| parent | f4cfd3665f7cf1ed96ce4c2eca03ac6854aae258 (diff) | |
| download | forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.gz forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.bz2 forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.xz forums-9988679d567a8bba9bade92dd9524bb012a1fe43.zip | |
- streamlined reports to consist of the feature set we decided upon (Nils, your turn now)
- use getenv instead of $_ENV (with $_ENV the case could be wrong)
- permission fixes (there was a bug arising with getting permission flags - re-added them and handled roles deletion differently)
- implemented max login attempts
- changed the expected return parameters for logins/sessions
- added acp page for editing report/denial reasons
- other fixes here and there
git-svn-id: file:///svn/phpbb/trunk@5622 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 43 |
1 files changed, 14 insertions, 29 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 9fb2e4b302..2f5fa88bd1 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -151,6 +151,7 @@ CREATE TABLE phpbb_config ( CREATE TABLE phpbb_confirm ( confirm_id char(32) DEFAULT '' NOT NULL, session_id char(32) DEFAULT '' NOT NULL, + confirm_type tinyint(3) DEFAULT '0' NOT NULL, code char(8) DEFAULT '' NOT NULL, PRIMARY KEY (session_id,confirm_id) ); @@ -425,7 +426,6 @@ CREATE TABLE phpbb_privmsgs ( icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, author_ip varchar(40) DEFAULT '' NOT NULL, message_time int(11) DEFAULT '0' NOT NULL, - message_reported tinyint(1) DEFAULT '0' NOT NULL, enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) DEFAULT '1' NOT NULL, @@ -551,43 +551,27 @@ CREATE TABLE phpbb_ranks ( ); # Table: 'phpbb_reports' -CREATE TABLE `phpbb_reports` ( - `report_id` smallint(5) unsigned NOT NULL auto_increment, - `report_type` tinyint(4) unsigned NOT NULL default '0', - `reason_id` smallint(5) unsigned NOT NULL default '0', - `post_id` mediumint(8) unsigned NOT NULL default '0', - `user_id` mediumint(8) unsigned NOT NULL default '0', - `user_notify` tinyint(1) NOT NULL default '0', - `report_time` int(10) unsigned NOT NULL default '0', - `report_text` text NOT NULL, - `report_status` tinyint(4) NOT NULL default '0', - `bbcode_uid` varchar(5) NOT NULL default '', - `bbcode_bitfield` int(11) NOT NULL default '0', - PRIMARY KEY (`report_id`) +CREATE TABLE phpbb_reports ( + report_id smallint(5) UNSIGNED NOT NULL auto_increment, + reason_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, + post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_notify tinyint(1) DEFAULT '0' NOT NULL, + report_closed tinyint(1) DEFAULT '0' NOT NULL, + report_time int(11) UNSIGNED DEFAULT '0' NOT NULL, + report_text text NOT NULL, + PRIMARY KEY (report_id) ); # Table: 'phpbb_reports_reasons' CREATE TABLE phpbb_reports_reasons ( reason_id smallint(6) NOT NULL auto_increment, - report_type tinyint(4) unsigned NOT NULL default '0', - reason_priority tinyint(4) DEFAULT '0' NOT NULL, - reason_name varchar(255) DEFAULT '' NOT NULL, + reason_title varchar(255) DEFAULT '' NOT NULL, reason_description text NOT NULL, + reason_order tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (reason_id) ); -# Table: `phpbb_reports_replies` -CREATE TABLE `phpbb_reports_replies` ( - `reply_id` mediumint(8) unsigned NOT NULL auto_increment, - `report_id` mediumint(8) unsigned NOT NULL default '0', - `reply_time` int(10) unsigned NOT NULL default '0', - `reply_text` text NOT NULL, - `from_user_id` mediumint(9) NOT NULL default '0', - `status` tinyint(4) NOT NULL default '0', - `to_user_id` mediumint(9) NOT NULL default '0', - PRIMARY KEY (`reply_id`) -); - # Table: 'phpbb_search_results' CREATE TABLE phpbb_search_results ( search_key varchar(32) DEFAULT '' NOT NULL, @@ -901,6 +885,7 @@ CREATE TABLE phpbb_users ( user_last_confirm_key varchar(10) DEFAULT '' NOT NULL, user_warnings tinyint(4) DEFAULT '0' NOT NULL, user_last_warning int(11) DEFAULT '0' NOT NULL, + user_login_attempts smallint(4) DEFAULT '0' NOT NULL, user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_lang varchar(30) DEFAULT '' NOT NULL, user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL, |