diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-11-16 18:00:49 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-11-16 18:00:49 +0000 |
| commit | 6228512203af6e542d18f2f936b6a5c25ddb1b78 (patch) | |
| tree | 7d09c5ad4cd757ea846c48c4b10cbf872dfef35f /phpBB/db | |
| parent | 4f310f8777338db610968099367768d3518e551b (diff) | |
| download | forums-6228512203af6e542d18f2f936b6a5c25ddb1b78.tar forums-6228512203af6e542d18f2f936b6a5c25ddb1b78.tar.gz forums-6228512203af6e542d18f2f936b6a5c25ddb1b78.tar.bz2 forums-6228512203af6e542d18f2f936b6a5c25ddb1b78.tar.xz forums-6228512203af6e542d18f2f936b6a5c25ddb1b78.zip | |
This is an initial 'final' DB schema, effectively complete but may undergo some (hopefully minor) updates
git-svn-id: file:///svn/phpbb/trunk@1335 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 4810b3e812..a0755c7dd4 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -271,13 +271,13 @@ CREATE TABLE phpbb_search_results ( # Table structure for table `phpbb_search_wordlist` # DROP TABLE IF EXISTS phpbb_search_wordlist; -CREATE TABLE `phpbb_search_wordlist` ( - `word_text` varchar(50) binary NOT NULL default '', - `word_id` int(11) NOT NULL auto_increment, - `word_weight` tinyint(4) NOT NULL default '0', - `word_common` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`word_text`), - KEY `word_id`(`word_id`) +CREATE TABLE phpbb_search_wordlist ( + word_text varchar(50) binary NOT NULL default '', + word_id int(11) NOT NULL auto_increment, + word_weight tinyint(4) NOT NULL default '0', + word_common tinyint(1) unsigned NOT NULL default '0', + PRIMARY KEY (word_text), + KEY word_id (word_id) ) # -------------------------------------------------------- @@ -480,12 +480,16 @@ CREATE TABLE phpbb_users ( username varchar(25) NOT NULL, user_password varchar(32) NOT NULL, user_autologin_key varchar(32), + user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', user_posts int(11) DEFAULT '0' NOT NULL, user_timezone int(11) DEFAULT '0' NOT NULL, - user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, user_style int(11), user_lang varchar(255), + user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, + user_lastvisit int(11) DEFAULT '0' NOT NULL, + user_new_privmsg smallint(6) DEFAULT '0' NOT NULL, + user_unread_privmsg smallint(6) DEFAULT '0' NOT NULL, user_emailtime int(11), user_viewemail tinyint(1), user_attachsig tinyint(1), @@ -497,7 +501,6 @@ CREATE TABLE phpbb_users ( user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, user_notify tinyint(1) DEFAULT '1' NOT NULL, user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, - user_regdate int(11) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), user_avatar_type tinyint(4) DEFAULT '0' NOT NULL, |