aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/install/schemas/firebird_schema.sql3
-rw-r--r--phpBB/install/schemas/oracle_schema.sql14
-rw-r--r--phpBB/install/schemas/schema_data.sql4
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql1
4 files changed, 11 insertions, 11 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index d049725d58..00d4af653d 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -1508,4 +1508,5 @@ CREATE TABLE phpbb_zebra (
);;
CREATE INDEX phpbb_zebra_user_id ON phpbb_zebra(user_id);;
-CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra(zebra_id);; \ No newline at end of file
+CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra(zebra_id);;
+
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 9bd8df274b..44fd379df8 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -477,7 +477,7 @@ CREATE TABLE phpbb_forums (
forum_parents clob DEFAULT '' ,
forum_name varchar2(3000) DEFAULT '' ,
forum_desc clob DEFAULT '' ,
- forum_desc_bitfield varchar(252) DEFAULT '' ,
+ forum_desc_bitfield varchar2(252) DEFAULT '' ,
forum_desc_options number(11) DEFAULT '0' NOT NULL,
forum_desc_uid varchar2(5) DEFAULT '' ,
forum_link varchar2(255) DEFAULT '' ,
@@ -486,7 +486,7 @@ CREATE TABLE phpbb_forums (
forum_image varchar2(255) DEFAULT '' ,
forum_rules clob DEFAULT '' ,
forum_rules_link varchar2(255) DEFAULT '' ,
- forum_rules_bitfield varchar(252) DEFAULT '' ,
+ forum_rules_bitfield varchar2(252) DEFAULT '' ,
forum_rules_options number(11) DEFAULT '0' NOT NULL,
forum_rules_uid varchar2(5) DEFAULT '' ,
forum_topics_per_page number(4) DEFAULT '0' NOT NULL,
@@ -582,7 +582,7 @@ CREATE TABLE phpbb_groups (
group_type number(4) DEFAULT '1' NOT NULL,
group_name varchar2(252) DEFAULT '' ,
group_desc clob DEFAULT '' ,
- group_desc_bitfield varchar(252) DEFAULT '' ,
+ group_desc_bitfield varchar2(252) DEFAULT '' ,
group_desc_options number(11) DEFAULT '0' NOT NULL,
group_desc_uid varchar2(5) DEFAULT '' ,
group_display number(1) DEFAULT '0' NOT NULL,
@@ -847,7 +847,7 @@ CREATE TABLE phpbb_posts (
post_checksum varchar2(32) DEFAULT '' ,
post_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL,
post_attachment number(1) DEFAULT '0' NOT NULL,
- bbcode_bitfield varchar(252) DEFAULT '' ,
+ bbcode_bitfield varchar2(252) DEFAULT '' ,
bbcode_uid varchar2(5) DEFAULT '' ,
post_postcount number(1) DEFAULT '1' NOT NULL,
post_edit_time number(11) DEFAULT '0' NOT NULL,
@@ -910,7 +910,7 @@ CREATE TABLE phpbb_privmsgs (
message_edit_user number(8) DEFAULT '0' NOT NULL,
message_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL,
message_attachment number(1) DEFAULT '0' NOT NULL,
- bbcode_bitfield varchar(252) DEFAULT '' ,
+ bbcode_bitfield varchar2(252) DEFAULT '' ,
bbcode_uid varchar2(5) DEFAULT '' ,
message_edit_time number(11) DEFAULT '0' NOT NULL,
message_edit_count number(4) DEFAULT '0' NOT NULL,
@@ -1418,7 +1418,7 @@ CREATE TABLE phpbb_styles_template (
template_name varchar2(252) DEFAULT '' ,
template_copyright varchar2(255) DEFAULT '' ,
template_path varchar2(100) DEFAULT '' ,
- bbcode_bitfield varchar(252) DEFAULT 'kNg=' NOT NULL,
+ bbcode_bitfield varchar2(252) DEFAULT 'kNg=' NOT NULL,
template_storedb number(1) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id),
CONSTRAINT u_phpbb_tmplte_nm UNIQUE (template_name)
@@ -1819,7 +1819,7 @@ CREATE TABLE phpbb_users (
user_avatar_height number(4) DEFAULT '0' NOT NULL,
user_sig clob DEFAULT '' ,
user_sig_bbcode_uid varchar2(5) DEFAULT '' ,
- user_sig_bbcode_bitfield varchar(252) DEFAULT '' ,
+ user_sig_bbcode_bitfield varchar2(252) DEFAULT '' ,
user_from varchar2(100) DEFAULT '' ,
user_icq varchar2(15) DEFAULT '' ,
user_aim varchar2(255) DEFAULT '' ,
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index e884c35642..96e4dbe192 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -9,7 +9,7 @@
# -- Config
INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments', '1');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '0');
@@ -129,7 +129,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile',
INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_user_activity', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments_pm', '1');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize_pm', '262144');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '3');
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index b18ffb61ef..562cec10a1 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -1030,5 +1030,4 @@ CREATE INDEX phpbb_zebra_user_id ON phpbb_zebra (user_id);
CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra (zebra_id);
-
COMMIT; \ No newline at end of file