diff options
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mssql_basic.sql | 3 | ||||
| -rw-r--r-- | phpBB/db/mssql_schema.sql | 4 | ||||
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 3 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 4 | ||||
| -rwxr-xr-x | phpBB/db/oracle_basic.sql | 3 | ||||
| -rwxr-xr-x | phpBB/db/oracle_schema.sql | 6 | ||||
| -rwxr-xr-x | phpBB/db/postgres_basic.sql | 3 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 6 |
8 files changed, 26 insertions, 6 deletions
diff --git a/phpBB/db/mssql_basic.sql b/phpBB/db/mssql_basic.sql index 65d761815d..1cd27eba43 100644 --- a/phpBB/db/mssql_basic.sql +++ b/phpBB/db/mssql_basic.sql @@ -35,6 +35,9 @@ 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 ('max_inbox_privmsgs','50'); +INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25'); +INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50'); 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/mssql_schema.sql b/phpBB/db/mssql_schema.sql index ad29e5323e..e0e4fdcb0d 100644 --- a/phpBB/db/mssql_schema.sql +++ b/phpBB/db/mssql_schema.sql @@ -259,13 +259,13 @@ CREATE TABLE [phpbb_privmsgs] ( [privmsgs_enable_bbcode] [smallint] NULL , [privmsgs_enable_html] [smallint] NULL , [privmsgs_enable_smilies] [smallint] NULL , - [privmsgs_enable_sig] [smallint] NULL , - [privmsgs_bbcode_uid] [char] (10) NULL + [privmsgs_attach_sig] [smallint] NULL , ) ON [PRIMARY] GO CREATE TABLE [phpbb_privmsgs_text] ( [privmsgs_text_id] [int] NOT NULL , + [privmsgs_bbcode_uid] [char] (10) NULL [privmsgs_text] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 7fa9606d02..36b0503c4a 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -29,6 +29,9 @@ 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 ('max_inbox_privmsgs','50'); +INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25'); +INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50'); 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/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 76e62f2e0f..ab74d4b9ff 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -216,8 +216,7 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL, privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL, - privmsgs_enable_sig tinyint(1) DEFAULT '1' NOT NULL, - privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, + privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (privmsgs_id), KEY privmsgs_from_userid (privmsgs_from_userid), KEY privmsgs_to_userid (privmsgs_to_userid) @@ -231,6 +230,7 @@ CREATE TABLE phpbb_privmsgs ( DROP TABLE IF EXISTS phpbb_privmsgs_text; CREATE TABLE phpbb_privmsgs_text ( privmsgs_text_id int(11) DEFAULT '0' NOT NULL, + privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, privmsgs_text text, PRIMARY KEY (privmsgs_text_id) ); diff --git a/phpBB/db/oracle_basic.sql b/phpBB/db/oracle_basic.sql index 301e6d1e6c..3a1c358353 100755 --- a/phpBB/db/oracle_basic.sql +++ b/phpBB/db/oracle_basic.sql @@ -29,6 +29,9 @@ 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 ('max_inbox_privmsgs','50'); +INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25'); +INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50'); 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 193464efde..cbfc0e3139 100755 --- a/phpBB/db/oracle_schema.sql +++ b/phpBB/db/oracle_schema.sql @@ -231,7 +231,10 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_to_userid number(4) DEFAULT '0' NOT NULL, privmsgs_date number(4) DEFAULT '0' NOT NULL, privmsgs_ip char(8) NOT NULL, - privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, + privmsgs_enable_bbcode number(1) DEFAULT '1' NOT NULL, + privmsgs_enable_html number(1) DEFAULT '0' NOT NULL, + privmsgs_enable_smilies number(1) DEFAULT '1' NOT NULL, + privmsgs_attach_sig number(1) DEFAULT '1' NOT NULL, CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) ); CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); @@ -243,6 +246,7 @@ CREATE INDEX privmsgs_to_userid_index ON phpbb_privmsgs (privmsgs_to_userid); -------------------------------------------------------- */ CREATE TABLE phpbb_privmsgs_text ( privmsgs_text_id number(4) DEFAULT '0' NOT NULL, + privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, privmsgs_text varchar(2000), CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id) ); diff --git a/phpBB/db/postgres_basic.sql b/phpBB/db/postgres_basic.sql index a1c2452cbe..6427269d6f 100755 --- a/phpBB/db/postgres_basic.sql +++ b/phpBB/db/postgres_basic.sql @@ -29,6 +29,9 @@ 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 ('max_inbox_privmsgs','50'); +INSERT INTO phpbb_config VALUES ('max_sentbox_privmsgs','25'); +INSERT INTO phpbb_config VALUES ('max_savebox_privmsgs','50'); 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/postgres_schema.sql b/phpBB/db/postgres_schema.sql index f16b39bb49..17e5237494 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -198,7 +198,10 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_to_userid int4 DEFAULT '0' NOT NULL, privmsgs_date int4 DEFAULT '0' NOT NULL, privmsgs_ip char(8) NOT NULL, - privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, + privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL, + privmsgs_enable_html int2 DEFAULT '0' NOT NULL, + privmsgs_enable_smilies int2 DEFAULT '1' NOT NULL, + privmsgs_attach_sig int2 DEFAULT '1' NOT NULL, CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) ); CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); @@ -210,6 +213,7 @@ CREATE INDEX privmsgs_to_userid_index ON phpbb_privmsgs (privmsgs_to_userid); -------------------------------------------------------- */ CREATE TABLE phpbb_privmsgs_text ( privmsgs_text_id int4 DEFAULT '0' NOT NULL, + privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, privmsgs_text text, CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id) ); |