diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-09 23:37:30 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-09 23:37:30 +0000 |
| commit | c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1 (patch) | |
| tree | 4bfc554c17484f1ebebf5b8158b35d4cfcef7891 | |
| parent | c0ac873a086d0d118fde15fbf5a13fed7c64af24 (diff) | |
| download | forums-c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1.tar forums-c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1.tar.gz forums-c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1.tar.bz2 forums-c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1.tar.xz forums-c342a3c365fdf1a2d7f7bf8f83b4ed7719f715c1.zip | |
Combined theme/templates in profile as suggested, added META refresh and made a couple of other changes
git-svn-id: file:///svn/phpbb/trunk@1019 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 43 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 51 |
2 files changed, 48 insertions, 46 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index e808ab78bc..49254f5656 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -4,7 +4,48 @@ # $Id$ # -- Config -INSERT INTO phpbb_config (config_id, board_disable, sitename, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_html_tags, allow_bbcode, allow_smilies, allow_sig, allow_namechange, allow_theme_create, allow_avatar_local, allow_avatar_remote, allow_avatar_upload, override_themes, posts_per_page, topics_per_page, hot_threshold, max_poll_options, email_sig, email_from, require_activation, flood_interval, avatar_filesize, avatar_max_width, avatar_max_height, avatar_path, smilies_path, default_theme, default_lang, default_dateformat, system_timezone, sys_template, prune_enable, gzip_compress, board_startdate, smtp_delivery, smtp_host) VALUES (1,0,'yourdomain.com','phpbb2mysql','/','','',900,'','b,i,u,pre',1,1,1,'','','',1,1,'',15,50,25,10,'Thanks, The Management','youraddress@yourdomain.com','',15,6144,80,80,'images/avatars','images/smiles',2,'english','D M d, Y g:i a',-8,'PSO',1,1,994190324,'',''); +INSERT INTO phpbb_config VALUES ('config_id','1'); +INSERT INTO phpbb_config VALUES ('board_disable','0'); +INSERT INTO phpbb_config VALUES ('board_startdate','994190324'); +INSERT INTO phpbb_config VALUES ('sitename','yourdomain.com'); +INSERT INTO phpbb_config VALUES ('cookie_name','phpbb2mysql'); +INSERT INTO phpbb_config VALUES ('cookie_path','/'); +INSERT INTO phpbb_config VALUES ('cookie_domain',''); +INSERT INTO phpbb_config VALUES ('cookie_secure','0'); +INSERT INTO phpbb_config VALUES ('session_length','900'); +INSERT INTO phpbb_config VALUES ('allow_html','0'); +INSERT INTO phpbb_config VALUES ('allow_html_tags','b,i,u,pre'); +INSERT INTO phpbb_config VALUES ('allow_bbcode','1'); +INSERT INTO phpbb_config VALUES ('allow_smilies','1'); +INSERT INTO phpbb_config VALUES ('allow_sig','1'); +INSERT INTO phpbb_config VALUES ('allow_namechange','0'); +INSERT INTO phpbb_config VALUES ('allow_theme_create','0'); +INSERT INTO phpbb_config VALUES ('allow_avatar_local','0'); +INSERT INTO phpbb_config VALUES ('allow_avatar_remote','0'); +INSERT INTO phpbb_config VALUES ('allow_avatar_upload','0'); +INSERT INTO phpbb_config VALUES ('override_themes','0'); +INSERT INTO phpbb_config VALUES ('posts_per_page','15'); +INSERT INTO phpbb_config VALUES ('topics_per_page','50'); +INSERT INTO phpbb_config VALUES ('hot_threshold','25'); +INSERT INTO phpbb_config VALUES ('max_poll_options','10'); +INSERT INTO phpbb_config VALUES ('email_sig','Thanks, The Management'); +INSERT INTO phpbb_config VALUES ('email_from','youraddress@yourdomain.com'); +INSERT INTO phpbb_config VALUES ('smtp_delivery','0'); +INSERT INTO phpbb_config VALUES ('smtp_host',''); +INSERT INTO phpbb_config VALUES ('require_activation','0'); +INSERT INTO phpbb_config VALUES ('flood_interval','15'); +INSERT INTO phpbb_config VALUES ('avatar_filesize','6144'); +INSERT INTO phpbb_config VALUES ('avatar_max_width','80'); +INSERT INTO phpbb_config VALUES ('avatar_max_height','80'); +INSERT INTO phpbb_config VALUES ('avatar_path','images/avatars'); +INSERT INTO phpbb_config VALUES ('smilies_path','images/smiles'); +INSERT INTO phpbb_config VALUES ('default_theme','2'); +INSERT INTO phpbb_config VALUES ('default_lang','english'); +INSERT INTO phpbb_config VALUES ('default_dateformat','D M d, Y g:i a'); +INSERT INTO phpbb_config VALUES ('board_timezone','-8'); +INSERT INTO phpbb_config VALUES ('board_template','PSO'); +INSERT INTO phpbb_config VALUES ('prune_enable','1'); +INSERT INTO phpbb_config VALUES ('gzip_compress','1'); # -- Categories INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index d3c942d3a0..c9a2156b61 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -49,7 +49,8 @@ CREATE TABLE phpbb_groups ( group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, - group_moderator int(11) DEFAULT '0' NOT NULL, + group_moderator int(11) DEFAULT '0' NOT NULL, + group_single_user tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ); @@ -89,50 +90,10 @@ CREATE TABLE phpbb_categories ( # Table structure for table 'phpbb_config' # DROP TABLE IF EXISTS phpbb_config; -CREATE TABLE phpbb_config ( - config_id int(11) NOT NULL auto_increment, - board_disable tinyint(1) DEFAULT '0' NOT NULL, - board_startdate int(11), - sitename varchar(100), - cookie_name char(20), - cookie_path char(25), - cookie_domain char(50), - cookie_secure tinyint(1), - session_length int(11), - allow_html tinyint(1), - allow_html_tags char(255) DEFAULT 'b,u,i,pre,font color' NOT NULL, - allow_bbcode tinyint(1), - allow_smilies tinyint(1), - allow_sig tinyint(1), - allow_namechange tinyint(1), - allow_theme_create tinyint(1), - allow_avatar_local tinyint(1) DEFAULT '0' NOT NULL, - allow_avatar_remote tinyint(1) DEFAULT '0' NOT NULL, - allow_avatar_upload tinyint(1) DEFAULT '0' NOT NULL, - override_themes tinyint(3), - posts_per_page int(11), - topics_per_page int(11), - hot_threshold int(11), - max_poll_options int(11), - email_sig varchar(255), - email_from varchar(100), - smtp_delivery tinyint(1) DEFAULT '0' NOT NULL, - smtp_host varchar(50), - require_activation tinyint(1) DEFAULT '0' NOT NULL, - flood_interval int(4) NOT NULL, - avatar_filesize int(11) DEFAULT '6144' NOT NULL, - avatar_max_width smallint(6) DEFAULT '70' NOT NULL, - avatar_max_height smallint(6) DEFAULT '70' NOT NULL, - avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, - smilies_path char(100) DEFAULT 'images/smiles' NOT NULL, - default_theme int(11) DEFAULT '1' NOT NULL, - default_lang varchar(255), - default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, - system_timezone int(11) DEFAULT '0' NOT NULL, - sys_template varchar(100) DEFAULT 'Default' NOT NULL, - prune_enable tinyint(1) DEFAULT '1' NOT NULL, - gzip_compress tinyint(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (config_id) +CREATE TABLE phpbb_config ( + config_name varchar(255) NOT NULL, + config_value varchar(255) NOT NULL, + PRIMARY KEY (config_name) ); |