diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-25 23:22:42 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-25 23:22:42 +0000 |
| commit | 0def8048964599f6f821517e164fc69ba4a0fb0d (patch) | |
| tree | 00be4e42ab8e2e53133af8b859485ea019597ba2 /phpBB/db | |
| parent | 2a228a29ed4955b98bf5a16b29d9df2dcd93d064 (diff) | |
| download | forums-0def8048964599f6f821517e164fc69ba4a0fb0d.tar forums-0def8048964599f6f821517e164fc69ba4a0fb0d.tar.gz forums-0def8048964599f6f821517e164fc69ba4a0fb0d.tar.bz2 forums-0def8048964599f6f821517e164fc69ba4a0fb0d.tar.xz forums-0def8048964599f6f821517e164fc69ba4a0fb0d.zip | |
Admin definable max sig size
git-svn-id: file:///svn/phpbb/trunk@1087 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mssql_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 5 | ||||
| -rwxr-xr-x | phpBB/db/oracle_basic.sql | 1 | ||||
| -rwxr-xr-x | phpBB/db/oracle_schema.sql | 3 | ||||
| -rwxr-xr-x | phpBB/db/postgres_basic.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 3 |
8 files changed, 9 insertions, 11 deletions
diff --git a/phpBB/db/mssql_basic.sql b/phpBB/db/mssql_basic.sql index 144c583f26..65d761815d 100644 --- a/phpBB/db/mssql_basic.sql +++ b/phpBB/db/mssql_basic.sql @@ -34,12 +34,12 @@ 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 ('max_sig_chars','255'); INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management'); INSERT INTO phpbb_config VALUES ('board_email','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 ('require_admin_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'); diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql index f88c5fd914..ad29e5323e 100644 --- a/phpBB/db/mssql_schema.sql +++ b/phpBB/db/mssql_schema.sql @@ -438,7 +438,7 @@ CREATE TABLE [phpbb_users] ( [user_icq] [varchar] (15) NULL , [user_website] [varchar] (50) NULL , [user_from] [varchar] (200) NULL , - [user_sig] [varchar] (255) NULL , + [user_sig] [text] NULL , [user_sig_bbcode_uid] [char] (10) NULL, [user_aim] [varchar] (50) NULL , [user_yim] [varchar] (50) NULL , diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 679a20a1f3..ce52b05bf8 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -28,12 +28,12 @@ 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 ('max_sig_chars','255'); INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management'); INSERT INTO phpbb_config VALUES ('board_email','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 ('require_admin_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'); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index c7a4ecd818..76e62f2e0f 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -358,8 +358,7 @@ CREATE TABLE phpbb_themes ( span_class1 varchar(25) default NULL, span_class2 varchar(25) default NULL, span_class3 varchar(25) default NULL, - PRIMARY KEY (themes_id), - KEY themes_name (themes_name) + PRIMARY KEY (themes_id) ); @@ -476,7 +475,7 @@ CREATE TABLE phpbb_users ( user_icq varchar(15), user_website varchar(100), user_from varchar(100), - user_sig varchar(255), + user_sig text, user_sig_bbcode_uid char(10), user_aim varchar(255), user_yim varchar(255), diff --git a/phpBB/db/oracle_basic.sql b/phpBB/db/oracle_basic.sql index 4386150cb4..301e6d1e6c 100755 --- a/phpBB/db/oracle_basic.sql +++ b/phpBB/db/oracle_basic.sql @@ -28,6 +28,7 @@ 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 ('max_sig_chars','255'); INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management'); INSERT INTO phpbb_config VALUES ('board_email','youraddress@yourdomain.com'); INSERT INTO phpbb_config VALUES ('smtp_delivery','0'); diff --git a/phpBB/db/oracle_schema.sql b/phpBB/db/oracle_schema.sql index 58f13740a4..193464efde 100755 --- a/phpBB/db/oracle_schema.sql +++ b/phpBB/db/oracle_schema.sql @@ -340,7 +340,6 @@ CREATE TABLE phpbb_themes ( span_class3 varchar(25), CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id) ); -CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); /* -------------------------------------------------------- @@ -442,7 +441,7 @@ CREATE TABLE phpbb_users ( user_occ varchar(100), user_from varchar(100), user_interests varchar(255), - user_sig varchar(255), + user_sig varchar(2000), user_sig_bbcode_uid char(10), user_style number(4), user_aim varchar(255), diff --git a/phpBB/db/postgres_basic.sql b/phpBB/db/postgres_basic.sql index c8cc1d3136..a1c2452cbe 100755 --- a/phpBB/db/postgres_basic.sql +++ b/phpBB/db/postgres_basic.sql @@ -28,12 +28,12 @@ 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 ('max_sig_chars','255'); INSERT INTO phpbb_config VALUES ('board_email_sig','Thanks, The Management'); INSERT INTO phpbb_config VALUES ('board_email','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 ('require_admin_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'); diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 6befe005ba..f16b39bb49 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -321,7 +321,6 @@ CREATE TABLE phpbb_themes ( span_class3 varchar(25), CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id) ); -CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); /* -------------------------------------------------------- @@ -429,7 +428,7 @@ CREATE TABLE phpbb_users ( user_occ varchar(100), user_from varchar(100), user_interests varchar(255), - user_sig varchar(255), + user_sig text, user_sig_bbcode_uid char(10), user_style int4, user_aim varchar(255), |