diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-16 23:07:17 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-04-16 23:07:17 +0000 |
| commit | 4af673dcf1b1fdee46be7edfd7eea850e8071cb5 (patch) | |
| tree | a68d9f4971a83d5e7949fb3b9431dd0225f9645e /phpBB/install | |
| parent | c2e73ed65698195685d6e4dfbaa69628a4ec86aa (diff) | |
| download | forums-4af673dcf1b1fdee46be7edfd7eea850e8071cb5.tar forums-4af673dcf1b1fdee46be7edfd7eea850e8071cb5.tar.gz forums-4af673dcf1b1fdee46be7edfd7eea850e8071cb5.tar.bz2 forums-4af673dcf1b1fdee46be7edfd7eea850e8071cb5.tar.xz forums-4af673dcf1b1fdee46be7edfd7eea850e8071cb5.zip | |
Add bbcode_bitfield to user table schema for sig ... for time being at least
git-svn-id: file:///svn/phpbb/trunk@3864 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 63 |
1 files changed, 32 insertions, 31 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 70537fb4ed..e84ec56d8f 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -796,15 +796,15 @@ CREATE TABLE phpbb_user_group ( # 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', + user_active tinyint(1) DEFAULT '1' NOT NULL, + user_founder tinyint(1) DEFAULT '0' NOT NULL, group_id mediumint(8) DEFAULT '3' NOT NULL, - user_permissions text NULL, - user_ip varchar(40), + user_permissions text DEFAULT '' NOT NULL, + user_ip varchar(40) DEFAULT '' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, - username varchar(30) NOT NULL, - user_password varchar(32) NOT NULL, - user_email varchar(60), + username varchar(30) DEFAULT '' NOT NULL, + user_password varchar(32) DEFAULT '' NOT NULL, + user_email varchar(60) DEFAULT '' NOT NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, user_lastpage varchar(100) DEFAULT '' NOT NULL, user_karma tinyint(1) DEFAULT '3' NOT NULL, @@ -812,16 +812,16 @@ CREATE TABLE phpbb_users ( user_startpage varchar(100) DEFAULT '', user_colour varchar(6) DEFAULT '' NOT NULL, user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_lang varchar(30), - user_timezone decimal(5,2) 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(15) DEFAULT 'd M Y H:i' NOT NULL, - user_style tinyint(4), + user_style tinyint(4) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_last_privmsg int(11) DEFAULT '0' NOT NULL, - user_emailtime int(11), + user_emailtime int(11) DEFAULT '0' NOT NULL, user_sortby_type varchar(1) DEFAULT 'l' NOT NULL, user_sortby_dir varchar(1) DEFAULT 'd' NOT NULL, user_show_days tinyint(1) DEFAULT '0' NOT NULL, @@ -829,10 +829,10 @@ CREATE TABLE phpbb_users ( user_viewsigs tinyint(1) DEFAULT '1' NOT NULL, user_viewavatars tinyint(1) DEFAULT '1' NOT NULL, user_viewimg tinyint(1) DEFAULT '1' NOT NULL, - user_attachsig tinyint(1), - user_allowhtml tinyint(1) DEFAULT '1', - user_allowbbcode tinyint(1) DEFAULT '1', - user_allowsmile tinyint(1) DEFAULT '1', + user_attachsig tinyint(1) DEFAULT '1' NOT NULL, + user_allowhtml tinyint(1) DEFAULT '1' NOT NULL, + user_allowbbcode tinyint(1) DEFAULT '1' NOT NULL, + user_allowsmile tinyint(1) DEFAULT '1' NOT NULL, user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, user_allow_email tinyint(1) DEFAULT '1' NOT NULL, @@ -840,22 +840,23 @@ CREATE TABLE phpbb_users ( user_notify tinyint(1) DEFAULT '1' NOT NULL, user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, user_popup_pm tinyint(1) DEFAULT '0' NOT NULL, - user_avatar char(100), - user_avatar_type tinyint(4) DEFAULT '0', - user_avatar_width tinyint(4) UNSIGNED, - user_avatar_height tinyint(4) UNSIGNED, - user_sig text, - user_sig_bbcode_uid varchar(10), - user_from varchar(100), - user_icq varchar(15), - user_aim varchar(255), - user_yim varchar(255), - user_msnm varchar(255), - user_website varchar(100), - user_actkey varchar(32), - user_newpasswd varchar(32), - user_occ varchar(100), - user_interests varchar(255), + user_avatar varchar(100) DEFAULT '' NOT NULL, + user_avatar_type tinyint(4) 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 DEFAULT '' NOT NULL, + user_sig_bbcode_uid varchar(10) 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_website varchar(100) DEFAULT '' NOT NULL, + user_actkey varchar(32 DEFAULT '' NOT NULL), + user_newpasswd varchar(32) DEFAULT '' NOT NULL, + user_occ varchar(100) DEFAULT '' NOT NULL, + user_interests varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (user_id) ); |