aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGraham Eames <grahamje@users.sourceforge.net>2006-05-06 21:00:08 +0000
committerGraham Eames <grahamje@users.sourceforge.net>2006-05-06 21:00:08 +0000
commit75db5992742ee7b6a820a3e8f6033abf791d65b4 (patch)
tree819a783a4c123bba334f3547537a620b5e6454e5
parent6d3a8bd107bbd40d7afa3cc7adc5d5f46a3de63d (diff)
downloadforums-75db5992742ee7b6a820a3e8f6033abf791d65b4.tar
forums-75db5992742ee7b6a820a3e8f6033abf791d65b4.tar.gz
forums-75db5992742ee7b6a820a3e8f6033abf791d65b4.tar.bz2
forums-75db5992742ee7b6a820a3e8f6033abf791d65b4.tar.xz
forums-75db5992742ee7b6a820a3e8f6033abf791d65b4.zip
A minor change to the default icon_id, so that there is no icon if someone directly inserts into the db without specifying one
git-svn-id: file:///svn/phpbb/trunk@5892 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat
-rw-r--r--phpBB/install/schemas/firebird_schema.sql2
-rw-r--r--phpBB/install/schemas/mssql_schema.sql2
-rw-r--r--phpBB/install/schemas/mysql_schema.sql2
-rw-r--r--phpBB/install/schemas/oracle_schema.sql2
-rw-r--r--phpBB/install/schemas/postgres_schema.sql2
-rw-r--r--phpBB/install/schemas/schema_data.sql2
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql2
7 files changed, 7 insertions, 7 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index ccd89d8cf5..9872d96d00 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -607,7 +607,7 @@ CREATE TABLE phpbb_posts (
topic_id INTEGER DEFAULT 0 NOT NULL,
forum_id INTEGER DEFAULT 0 NOT NULL,
poster_id INTEGER DEFAULT 0 NOT NULL,
- icon_id INTEGER DEFAULT 1 NOT NULL,
+ icon_id INTEGER DEFAULT 0 NOT NULL,
poster_ip VARCHAR(40) NOT NULL,
post_time INTEGER DEFAULT 0 NOT NULL,
post_approved INTEGER DEFAULT 1 NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 4fc78b4b71..66f2261b57 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -960,7 +960,7 @@ ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
CONSTRAINT [DF_phpbb_posts__topic_id] DEFAULT (0) FOR [topic_id],
CONSTRAINT [DF_phpbb_posts__forum_id] DEFAULT (0) FOR [forum_id],
CONSTRAINT [DF_phpbb_posts__poster_id] DEFAULT (0) FOR [poster_id],
- CONSTRAINT [DF_phpbb_posts__icon_id] DEFAULT (1) FOR [icon_id],
+ CONSTRAINT [DF_phpbb_posts__icon_id] DEFAULT (0) FOR [icon_id],
CONSTRAINT [DF_phpbb_posts__post_time] DEFAULT (0) FOR [post_time],
CONSTRAINT [DF_phpbb_posts__post_approved] DEFAULT (1) FOR [post_approved],
CONSTRAINT [DF_phpbb_posts__post_reported] DEFAULT (0) FOR [post_reported],
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index a53b5b6fc7..1e02aea031 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -392,7 +392,7 @@ CREATE TABLE phpbb_posts (
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
+ icon_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
poster_ip varchar(40) NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
post_approved tinyint(1) DEFAULT '1' NOT NULL,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 297b346631..12d194c555 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -827,7 +827,7 @@ CREATE TABLE phpbb_posts (
topic_id number(8) DEFAULT '0' NOT NULL,
forum_id number(5) DEFAULT '0' NOT NULL,
poster_id number(8) DEFAULT '0' NOT NULL,
- icon_id number(4) DEFAULT '1' NOT NULL,
+ icon_id number(4) DEFAULT '0' NOT NULL,
poster_ip varchar2(40),
post_time number(11) DEFAULT '0' NOT NULL,
post_approved number(1) DEFAULT '1' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 9eb0f49323..7c00b86203 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -554,7 +554,7 @@ CREATE TABLE phpbb_posts (
topic_id INT4 DEFAULT '0' NOT NULL,
forum_id INT2 DEFAULT '0' NOT NULL,
poster_id INT4 DEFAULT '0' NOT NULL,
- icon_id INT2 DEFAULT '1' NOT NULL,
+ icon_id INT2 DEFAULT '0' NOT NULL,
poster_ip varchar(40) NOT NULL,
post_time INT4 DEFAULT '0' NOT NULL,
post_approved INT2 DEFAULT '1' NOT NULL,
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index 582d7102b4..8891b012bd 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -625,7 +625,7 @@ INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, topic_views, to
# MSSQL IDENTITY phpbb_posts ON #
# -- Demo Post
-INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_time, post_username, poster_ip, post_subject, post_text, post_checksum, bbcode_uid) VALUES (1, 2, 2, 972086460, NULL, '127.0.0.1', 'Welcome to phpBB 3', 'This is an example post in your phpBB 3.0 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!', '', '');
+INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, icon_id, post_time, post_username, poster_ip, post_subject, post_text, post_checksum, bbcode_uid) VALUES (1, 2, 2, 1, 972086460, NULL, '127.0.0.1', 'Welcome to phpBB 3', 'This is an example post in your phpBB 3.0 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!', '', '');
# MSSQL IDENTITY phpbb_posts OFF #
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 6c20a82ea0..a78186fb64 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -425,7 +425,7 @@ CREATE TABLE phpbb_posts (
topic_id mediumint(8) NOT NULL DEFAULT '0',
forum_id smallint(5) NOT NULL DEFAULT '0',
poster_id mediumint(8) NOT NULL DEFAULT '0',
- icon_id tinyint(4) NOT NULL DEFAULT '1',
+ icon_id tinyint(4) NOT NULL DEFAULT '0',
poster_ip varchar(40) NOT NULL,
post_time int(11) NOT NULL DEFAULT '0',
post_approved tinyint(1) NOT NULL DEFAULT '1',
generated by cgit v1.2.1 (git 2.21.0) at 2025-08-21 15:35:20 +0000