aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql3
-rw-r--r--phpBB/install/schemas/mssql_schema.sql4
-rw-r--r--phpBB/install/schemas/mysql_schema.sql5
-rw-r--r--phpBB/install/schemas/oracle_schema.sql5
-rw-r--r--phpBB/install/schemas/postgres_schema.sql5
-rw-r--r--phpBB/install/schemas/schema_data.sql14
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql5
7 files changed, 18 insertions, 23 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index f5c8986ee1..dfa2495282 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -366,7 +366,6 @@ CREATE TABLE phpbb_privmsgs (
message_text BLOB SUB_TYPE TEXT,
message_edit_reason VARCHAR(100),
message_edit_user INTEGER DEFAULT 0 NOT NULL,
- message_checksum VARCHAR(32) NOT NULL,
message_encoding VARCHAR(11) DEFAULT 'iso-8859-1' NOT NULL,
message_attachment INTEGER DEFAULT 0 NOT NULL,
bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
@@ -766,7 +765,7 @@ CREATE TABLE phpbb_users (
user_lang VARCHAR(30) NOT NULL,
user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
user_dst INTEGER DEFAULT 0 NOT NULL,
- user_dateformat VARCHAR(15) DEFAULT 'd M Y H:i' NOT NULL,
+ user_dateformat VARCHAR(30) DEFAULT 'd M Y H:i' NOT NULL,
user_style INTEGER DEFAULT 0 NOT NULL,
user_rank INTEGER DEFAULT 0 ,
user_colour VARCHAR(6) NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 1f41d0ead3..bd6e6b59af 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -372,7 +372,6 @@ CREATE TABLE [phpbb_privmsgs] (
[message_text] [text] NULL ,
[message_edit_reason] [varchar] (100) NULL ,
[message_edit_user] [int] NOT NULL ,
- [message_checksum] [varchar] (32) NOT NULL ,
[message_encoding] [varchar] (11) NOT NULL ,
[message_attachment] [int] NOT NULL ,
[bbcode_bitfield] [int] NOT NULL ,
@@ -772,7 +771,7 @@ CREATE TABLE [phpbb_users] (
[user_lang] [varchar] (30) NOT NULL ,
[user_timezone] [float] NOT NULL ,
[user_dst] [int] NOT NULL ,
- [user_dateformat] [varchar] (15) NOT NULL ,
+ [user_dateformat] [varchar] (30) NOT NULL ,
[user_style] [int] NOT NULL ,
[user_rank] [int] NULL ,
[user_colour] [varchar] (6) NOT NULL ,
@@ -1587,6 +1586,7 @@ ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
CONSTRAINT [DF_topics_topic_moved_id] DEFAULT (0) FOR [topic_moved_id],
CONSTRAINT [DF_topics_topic_bumped] DEFAULT (0) FOR [topic_bumped],
CONSTRAINT [DF_topics_topic_bumper] DEFAULT (0) FOR [topic_bumper],
+ CONSTRAINT [DF_topics_poll_title] DEFAULT ('') FOR [poll_title],
CONSTRAINT [DF_topics_poll_start] DEFAULT (0) FOR [poll_start],
CONSTRAINT [DF_topics_poll_length] DEFAULT (0) FOR [poll_length],
CONSTRAINT [DF_topics_poll_max_options] DEFAULT (1) FOR [poll_max_options],
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 2f5fa88bd1..be12faa9ab 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -434,7 +434,6 @@ CREATE TABLE phpbb_privmsgs (
message_text mediumtext,
message_edit_reason varchar(100),
message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- message_checksum varchar(32) DEFAULT '' NOT NULL,
message_encoding varchar(11) DEFAULT 'iso-8859-1' NOT NULL,
message_attachment tinyint(1) DEFAULT '0' NOT NULL,
bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
@@ -813,7 +812,7 @@ CREATE TABLE phpbb_topics (
topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poll_title varchar(255) NOT NULL,
+ poll_title varchar(255) DEFAULT '' NOT NULL,
poll_start int(11) DEFAULT '0' NOT NULL,
poll_length int(11) DEFAULT '0' NOT NULL,
poll_max_options tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
@@ -890,7 +889,7 @@ CREATE TABLE phpbb_users (
user_lang varchar(30) DEFAULT '' NOT NULL,
user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,
user_dst tinyint(1) DEFAULT '0' NOT NULL,
- user_dateformat varchar(15) DEFAULT 'd M Y H:i' NOT NULL,
+ user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
user_style tinyint(4) DEFAULT '0' NOT NULL,
user_rank int(11) DEFAULT '0',
user_colour varchar(6) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 25ffabbb32..a181532783 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -864,7 +864,6 @@ CREATE TABLE phpbb_privmsgs (
message_text clob,
message_edit_reason varchar2(100),
message_edit_user number(8) DEFAULT '0' NOT NULL,
- message_checksum varchar2(32) DEFAULT '',
message_encoding varchar2(11) DEFAULT 'iso-8859-1',
message_attachment number(1) DEFAULT '0' NOT NULL,
bbcode_bitfield number(11) DEFAULT '0' NOT NULL,
@@ -1551,7 +1550,7 @@ CREATE TABLE phpbb_topics (
topic_moved_id number(8) DEFAULT '0' NOT NULL,
topic_bumped number(1) DEFAULT '0' NOT NULL,
topic_bumper number(8) DEFAULT '0' NOT NULL,
- poll_title varchar2(255),
+ poll_title varchar2(255) DEFAULT '' NOT NULL,
poll_start number(11) DEFAULT '0' NOT NULL,
poll_length number(11) DEFAULT '0' NOT NULL,
poll_max_options number(4) DEFAULT '1' NOT NULL,
@@ -1672,7 +1671,7 @@ CREATE TABLE phpbb_users (
user_lang varchar2(30) DEFAULT '',
user_timezone number(5, 2) DEFAULT '1' NOT NULL,
user_dst number(1) DEFAULT '0' NOT NULL,
- user_dateformat varchar2(15) DEFAULT 'd M Y H:i',
+ user_dateformat varchar2(30) DEFAULT 'd M Y H:i',
user_style number(4) DEFAULT '0' NOT NULL,
user_rank number(11) DEFAULT '0',
user_colour varchar2(6) DEFAULT '',
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index c3bca14354..f695ab8be6 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -580,7 +580,6 @@ CREATE TABLE phpbb_privmsgs (
message_text text,
message_edit_reason varchar(100),
message_edit_user INT4 DEFAULT '0' NOT NULL,
- message_checksum varchar(32) DEFAULT '' NOT NULL,
message_encoding varchar(11) DEFAULT 'iso-8859-1' NOT NULL,
message_attachment INT2 DEFAULT '0' NOT NULL,
bbcode_bitfield INT4 DEFAULT '0' NOT NULL,
@@ -1066,7 +1065,7 @@ CREATE TABLE phpbb_topics (
topic_moved_id INT4 DEFAULT '0' NOT NULL,
topic_bumped INT2 DEFAULT '0' NOT NULL,
topic_bumper INT4 DEFAULT '0' NOT NULL,
- poll_title varchar(255) NOT NULL,
+ poll_title varchar(255) DEFAULT '' NOT NULL,
poll_start INT4 DEFAULT '0' NOT NULL,
poll_length INT4 DEFAULT '0' NOT NULL,
poll_max_options INT2 DEFAULT '1' NOT NULL,
@@ -1175,7 +1174,7 @@ CREATE TABLE phpbb_users (
user_lang varchar(30) DEFAULT '' NOT NULL,
user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,
user_dst INT2 DEFAULT '0' NOT NULL,
- user_dateformat varchar(15) DEFAULT 'd M Y H:i' NOT NULL,
+ user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
user_style INT2 DEFAULT '0' NOT NULL,
user_rank INT4 DEFAULT '0',
user_colour varchar(6) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index cf5d06afd0..00db91bd2e 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -62,7 +62,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('cache_gc', '7200')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chg_passforce', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('chg_passremind', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain', '');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name', 'phpbb22');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name', 'phpbb3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path', '/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_enable', '1');
@@ -722,15 +722,15 @@ INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_heigh
# -- icons ... these are just some of those in CVS
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/arrow_bold_rgt.gif', 19, 19, 1, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/redface_anim.gif', 19, 19, 9, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/mr_green.gif', 19, 19, 10, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/redface_anim.gif', 19, 19, 9, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/mr_green.gif', 19, 19, 10, 1);
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/musical.gif', 19, 19, 4, 1);
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/asterix.gif', 19, 19, 2, 1);
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/square.gif', 19, 19, 3, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/alien_grn.gif', 19, 19, 5, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/idea.gif', 19, 19, 8, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/question.gif', 19, 19, 6, 1);
-INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smilies/exclaim.gif', 19, 19, 7, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/alien_grn.gif', 19, 19, 5, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/idea.gif', 19, 19, 8, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/question.gif', 19, 19, 6, 1);
+INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/exclaim.gif', 19, 19, 7, 1);
# MSSQL IDENTITY phpbb_search_wordlist ON #
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 9679f061ef..39f12d16a7 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -438,7 +438,6 @@ CREATE TABLE phpbb_privmsgs (
message_text mediumtext(16777215),
message_edit_reason varchar(100),
message_edit_user mediumint(8) NOT NULL DEFAULT '0',
- message_checksum varchar(32) NOT NULL DEFAULT '',
message_encoding varchar(11) NOT NULL DEFAULT 'iso-8859-1',
message_attachment tinyint(1) NOT NULL DEFAULT '0',
bbcode_bitfield int(11) NOT NULL DEFAULT '0',
@@ -816,7 +815,7 @@ CREATE TABLE phpbb_topics (
topic_moved_id mediumint(8) NOT NULL DEFAULT '0',
topic_bumped tinyint(1) NOT NULL DEFAULT '0',
topic_bumper mediumint(8) NOT NULL DEFAULT '0',
- poll_title varchar(255) NOT NULL,
+ poll_title varchar(255) NOT NULL DEFAULT '',
poll_start int(11) NOT NULL DEFAULT '0',
poll_length int(11) NOT NULL DEFAULT '0',
poll_max_options tinyint(4) NOT NULL DEFAULT '1',
@@ -894,7 +893,7 @@ CREATE TABLE phpbb_users (
user_lang varchar(30) NOT NULL DEFAULT '',
user_timezone decimal(5,2) NOT NULL DEFAULT '0.0',
user_dst tinyint(1) NOT NULL DEFAULT '0',
- user_dateformat varchar(15) NOT NULL DEFAULT 'd M Y H:i',
+ user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i',
user_style tinyint(4) NOT NULL DEFAULT '0',
user_rank int(11) DEFAULT '0',
user_colour varchar(6) NOT NULL DEFAULT '',
generated by cgit v1.2.1 (git 2.21.0) at 2024-11-14 10:19:14 +0000