diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-04-20 07:30:45 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-04-20 07:30:45 +0000 |
| commit | 42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed (patch) | |
| tree | 1ab1298273af80ec1cd4bf1776f2e0da094173b4 /phpBB/db | |
| parent | e150b48726535fa2639449a1bb2ad6b9e015dfe9 (diff) | |
| download | forums-42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed.tar forums-42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed.tar.gz forums-42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed.tar.bz2 forums-42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed.tar.xz forums-42039bc31a39b3c29bb1700dc5b0a3ea5b8348ed.zip | |
Added user selectable templates, and put the system template into the config database. Updated mysql_schema as well
git-svn-id: file:///svn/phpbb/trunk@200 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 39 |
2 files changed, 15 insertions, 30 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index dea9ae5c2a..158d802415 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -1,7 +1,7 @@ # $id$ # Some basic inserts to get you started. -INSERT INTO phpbb_config VALUES (1,'Test forum',1,1,1,1,1,25,10,50,0,0,'With regards, the Admin','admin@yoursite.com','d M Y h:i:s a','english',0); +INSERT INTO phpbb_config VALUES (1,'Test forum',1,1,1,1,1,25,10,50,0,0,'With regards, the Admin','admin@yoursite.com','d M Y h:i:s a','english',0,'Default'); INSERT INTO phpbb_categories VALUES (1,'Test category 1','1'); @@ -9,5 +9,5 @@ INSERT INTO phpbb_forums VALUES (1,'Test Forum 1','This is just a test forum, no INSERT INTO phpbb_forum_mods VALUES (1,1,0); -INSERT INTO phpbb_users VALUES (1,'admin','Jan 09, 2001','21232f297a57a5a743894a0e4a801fc3','admin@yourdomain.com','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,0,'',4,'','','',0,'-8',1); -INSERT INTO phpbb_users VALUES (-1,'Anonymous','May 12, 1978','','','','','','','','',0,0,'','','',0,0,0,0,0,0,'',0,'','','',0,'-8',1); +INSERT INTO phpbb_users VALUES (1,'admin',NOW(),'21232f297a57a5a743894a0e4a801fc3','admin@yourdomain.com','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,0,'',4,'','','',0,'-8',1, ''); +INSERT INTO phpbb_users VALUES (-1,'Anonymous',NOW(),'','','','','','','','',0,0,'','','',0,0,0,0,0,0,'',0,'','','',0,'-8',1,'Default'); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 8c62291bd8..d5d7936194 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -1,26 +1,9 @@ -# *************************************************************************** -# * mysql_schema.sql -# * ------------------- -# * begin : Thursday, Apr 19, 2001 -# * copyright : (C) 2001 The phpBB Group -# * email : support@phpbb.com -# * -# * $Id$ -# * -# * -# *************************************************************************** -# -# -# *************************************************************************** -# * -# * This program is free software; you can redistribute it and/or modify -# * it under the terms of the GNU General Public License as published by -# * the Free Software Foundation; either version 2 of the License, or -# * (at your option) any later version. -# * -# * -# *************************************************************************** +# MySQL dump 8.13 # +# Host: localhost Database: phpBBtest +#-------------------------------------------------------- +# Server version 3.23.35 + # # Table structure for table 'phpbb_banlist' # @@ -28,7 +11,7 @@ CREATE TABLE phpbb_banlist ( ban_id int(10) NOT NULL auto_increment, ban_userid int(10) default NULL, - ban_ip char(8) default NULL, + ban_ip int(11) default NULL, ban_start int(10) default NULL, ban_end int(10) default NULL, ban_time_type int(10) default NULL, @@ -68,6 +51,7 @@ CREATE TABLE phpbb_config ( default_dateformat varchar(20) default NULL, default_lang varchar(255) default NULL, system_timezone smallint(6) default NULL, + sys_template varchar(20) default NULL, PRIMARY KEY (config_id), UNIQUE KEY selected (selected) ) TYPE=MyISAM; @@ -144,7 +128,7 @@ CREATE TABLE phpbb_posts ( forum_id int(10) NOT NULL default '0', poster_id int(10) NOT NULL default '0', post_time int(10) NOT NULL default '0', - poster_ip char(8) NOT NULL default '0', + poster_ip int(10) NOT NULL default '0', bbcode_uid varchar(10) NOT NULL default '', PRIMARY KEY (post_id), KEY forum_id (forum_id), @@ -171,7 +155,7 @@ CREATE TABLE phpbb_priv_msgs ( from_userid int(10) NOT NULL default '0', to_userid int(10) NOT NULL default '0', msg_time int(10) NOT NULL default '0', - poster_ip char(8) NOT NULL default '0', + poster_ip int(10) NOT NULL default '0', msg_status int(10) NOT NULL default '0', msg_text text NOT NULL, PRIMARY KEY (msg_id), @@ -203,7 +187,7 @@ CREATE TABLE phpbb_session ( session_id int(10) unsigned NOT NULL default '0', session_user_id int(10) NOT NULL default '0', session_time int(10) unsigned NOT NULL default '0', - session_ip char(8) default NULL, + session_ip char(10) default NULL, session_page int(10) NOT NULL default '0', session_logged_in tinyint(1) NOT NULL default '0', PRIMARY KEY (session_id) @@ -290,8 +274,9 @@ CREATE TABLE phpbb_users ( user_actkey varchar(32) default NULL, user_newpasswd varchar(32) default NULL, user_notify tinyint(3) default NULL, - user_timezone int(4) default NULL, + user_timezone float default NULL, user_active int(2) default NULL, + user_template varchar(20) default NULL, PRIMARY KEY (user_id), KEY user_id (user_id) ) TYPE=MyISAM; |