From 0e9f0ac4ecc636336603cc6932ce21a550c7087e Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Sun, 20 Oct 2002 19:19:07 +0000
Subject: Mostly changes to turn userdata into user->data, lang into user->lang
 + bitstring 2nd format + inheritance for permission admin and various other
 updates/fixes/changes ... note that user->lang & user->theme isn't final

git-svn-id: file:///svn/phpbb/trunk@2958 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 189f867e0c..5e1be1b64d 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -627,6 +627,7 @@ CREATE TABLE phpbb_users (
    user_session_time int(11) DEFAULT '0' NOT NULL,
    user_session_page smallint(5) DEFAULT '0' NOT NULL,
    user_lastvisit int(11) DEFAULT '0' NOT NULL,
+   user_startpage varchar(100) DEFAULT '',
    user_colour varchar(6) DEFAULT '' NOT NULL,
    user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    user_lang varchar(50),
@@ -634,6 +635,7 @@ CREATE TABLE phpbb_users (
    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_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,
@@ -651,12 +653,11 @@ CREATE TABLE phpbb_users (
    user_allowsmile tinyint(1) DEFAULT '1',
    user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
    user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
-   user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
    user_allow_email tinyint(1) DEFAULT '1' NOT NULL,
+   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_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
-   user_rank int(11) DEFAULT '0',
    user_avatar char(100),
    user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
    user_avatar_width tinyint(4) UNSIGNED,
-- 
cgit v1.2.1

