diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-05-12 20:52:58 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-05-12 20:52:58 +0000 |
| commit | a8d99f2228cc042c8410553f5f3ec375148552f5 (patch) | |
| tree | 11ccbd184cbc222775a08852d633d74ced7b2695 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 7dd067bf5a532e4c30908cca24449274a4863326 (diff) | |
| download | forums-a8d99f2228cc042c8410553f5f3ec375148552f5.tar forums-a8d99f2228cc042c8410553f5f3ec375148552f5.tar.gz forums-a8d99f2228cc042c8410553f5f3ec375148552f5.tar.bz2 forums-a8d99f2228cc042c8410553f5f3ec375148552f5.tar.xz forums-a8d99f2228cc042c8410553f5f3ec375148552f5.zip | |
- introduce new function build_url to easily build a valid url from the user->page object as well as optionally removing certain keys
- changed attachment config to utilize the config build methods
- cleaned up posting.php
- the submit/delete_post functions are now usable (functions_posting.php)
- adjusted header icons (transparency)
- a bunch of fixes for mssql
- bug fixes
git-svn-id: file:///svn/phpbb/trunk@5902 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 62 |
1 files changed, 31 insertions, 31 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 1e02aea031..ce43ba56ad 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -401,19 +401,19 @@ CREATE TABLE phpbb_posts ( enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, - post_username varchar(255), - post_subject text, - post_text mediumtext, + post_username varchar(255) NULL, + post_subject text NOT NULL, + post_text mediumtext NOT NULL, post_checksum varchar(32) NOT NULL, post_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL, post_attachment tinyint(1) DEFAULT '0' NOT NULL, bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, bbcode_uid varchar(5) DEFAULT '' NOT NULL, - post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, - post_edit_reason text, - post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + post_edit_time int(11) UNSIGNED DEFAULT '0' NULL, + post_edit_reason text NULL, + post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NULL, + post_edit_count smallint(5) UNSIGNED DEFAULT '0' NULL, + post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NULL, PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), @@ -642,7 +642,7 @@ CREATE TABLE phpbb_sitelist ( # Table: 'phpbb_smilies' CREATE TABLE phpbb_smilies ( smiley_id tinyint(4) UNSIGNED NOT NULL auto_increment, - code varchar(10), + code varchar(50), emotion varchar(50), smiley_url varchar(50), smiley_width tinyint(4) UNSIGNED NOT NULL, @@ -674,7 +674,7 @@ CREATE TABLE phpbb_styles_template ( template_name varchar(255) NOT NULL, template_copyright varchar(255) NOT NULL, template_path varchar(100) NOT NULL, - bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + bbcode_bitfield int(11) UNSIGNED DEFAULT '6921' NOT NULL, template_storedb tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (template_id), UNIQUE template_name (template_name) @@ -874,31 +874,31 @@ CREATE TABLE phpbb_users ( user_id mediumint(8) UNSIGNED NOT NULL auto_increment, user_type tinyint(1) DEFAULT '0' NOT NULL, group_id mediumint(8) DEFAULT '3' NOT NULL, - user_permissions text, + user_permissions text NULL, user_perm_from mediumint(8) DEFAULT '0' NOT NULL, user_ip varchar(40) DEFAULT '' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, user_password varchar(40) DEFAULT '' NOT NULL, - user_passchg int(11) DEFAULT '0' NOT NULL, + user_passchg int(11) DEFAULT '0' NULL, user_email varchar(100) DEFAULT '' NOT NULL, user_email_hash bigint(20) DEFAULT '0' NOT NULL, - user_birthday varchar(10) DEFAULT '' NOT NULL, + user_birthday varchar(10) DEFAULT '' NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, user_lastmark int(11) DEFAULT '0' NOT NULL, user_lastpost_time int(11) DEFAULT '0' NOT NULL, user_lastpage varchar(200) DEFAULT '' NOT NULL, - 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_last_confirm_key varchar(10) DEFAULT '' NULL, + user_warnings tinyint(4) DEFAULT '0' NULL, + user_last_warning int(11) DEFAULT '0' NULL, + user_login_attempts smallint(4) DEFAULT '0' 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, user_dst tinyint(1) DEFAULT '0' NOT NULL, user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL, user_style tinyint(4) DEFAULT '0' NOT NULL, - user_rank int(11) DEFAULT '0', + user_rank int(11) DEFAULT '0' NULL, user_colour varchar(6) DEFAULT '' NOT NULL, user_new_privmsg tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, user_unread_privmsg tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, @@ -925,20 +925,20 @@ CREATE TABLE phpbb_users ( user_avatar_type tinyint(2) DEFAULT '0' NOT NULL, user_avatar_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, user_avatar_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_sig text, - user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield int(11) DEFAULT '0' NOT NULL, - user_from varchar(100) DEFAULT '' NOT NULL, - user_icq varchar(15) DEFAULT '' NOT NULL, - user_aim varchar(255) DEFAULT '' NOT NULL, - user_yim varchar(255) DEFAULT '' NOT NULL, - user_msnm varchar(255) DEFAULT '' NOT NULL, - user_jabber varchar(255) DEFAULT '' NOT NULL, - user_website varchar(200) DEFAULT '' NOT NULL, - user_occ varchar(255) DEFAULT '' NOT NULL, - user_interests varchar(255) DEFAULT '' NOT NULL, + user_sig text NULL, + user_sig_bbcode_uid varchar(5) DEFAULT '' NULL, + user_sig_bbcode_bitfield int(11) DEFAULT '0' NULL, + user_from varchar(100) DEFAULT '' NULL, + user_icq varchar(15) DEFAULT '' NULL, + user_aim varchar(255) DEFAULT '' NULL, + user_yim varchar(255) DEFAULT '' NULL, + user_msnm varchar(255) DEFAULT '' NULL, + user_jabber varchar(255) DEFAULT '' NULL, + user_website varchar(200) DEFAULT '' NULL, + user_occ varchar(255) DEFAULT '' NULL, + user_interests varchar(255) DEFAULT '' NULL, user_actkey varchar(32) DEFAULT '' NOT NULL, - user_newpasswd varchar(32) DEFAULT '' NOT NULL, + user_newpasswd varchar(32) DEFAULT '' NULL, PRIMARY KEY (user_id), KEY user_birthday (user_birthday(6)), KEY user_email_hash (user_email_hash), |