aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2006-08-01 15:29:47 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2006-08-01 15:29:47 +0000
commitced8624b8e86bc6aac143163e538f87376319079 (patch)
tree7479c2699efb9bd9c6785e0f5ecd4f792d8ca59e /phpBB/install
parent541dbf8af07874e9507249a7e62cc3c32475d475 (diff)
downloadforums-ced8624b8e86bc6aac143163e538f87376319079.tar
forums-ced8624b8e86bc6aac143163e538f87376319079.tar.gz
forums-ced8624b8e86bc6aac143163e538f87376319079.tar.bz2
forums-ced8624b8e86bc6aac143163e538f87376319079.tar.xz
forums-ced8624b8e86bc6aac143163e538f87376319079.zip
- fixing some bugs
- shortening some db columns to meet the requirements - correctly increase/decrease user post counts - fix the topic title length bug(s) git-svn-id: file:///svn/phpbb/trunk@6224 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql54
-rw-r--r--phpBB/install/schemas/mssql_schema.sql56
-rw-r--r--phpBB/install/schemas/mysql_schema.sql54
-rw-r--r--phpBB/install/schemas/oracle_schema.sql55
-rw-r--r--phpBB/install/schemas/postgres_schema.sql56
-rw-r--r--phpBB/install/schemas/schema_data.sql4
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql54
7 files changed, 174 insertions, 159 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 942d802318..c7b9a2d1b7 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -660,6 +660,7 @@ CREATE TABLE phpbb_posts (
post_attachment INTEGER DEFAULT 0 NOT NULL,
bbcode_bitfield CHAR(255) DEFAULT '' NOT NULL,
bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,
+ post_postcount INTEGER DEFAULT 1 NOT NULL,
post_edit_time INTEGER DEFAULT 0 NOT NULL,
post_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
post_edit_user INTEGER DEFAULT 0 NOT NULL,
@@ -674,6 +675,7 @@ CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;
CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts(post_approved);;
+CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts(post_postcount);;
CREATE INDEX phpbb_posts_post_time ON phpbb_posts(post_time);;
CREATE GENERATOR phpbb_posts_gen;;
@@ -1234,41 +1236,41 @@ CREATE TABLE phpbb_styles_imageset (
sub_forum_new VARCHAR(200) DEFAULT '' NOT NULL,
folder VARCHAR(200) DEFAULT '' NOT NULL,
folder_moved VARCHAR(200) DEFAULT '' NOT NULL,
- folder_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_new_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_hot VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_hot_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_hot_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_global_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_hot_new_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_new_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_announce VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_global VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_global_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_post VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_sticky VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_sticky_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_sticky_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_sticky_new_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_announce VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_announce_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_announce_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_announce_new_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_global VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global_post VARCHAR(200) DEFAULT '' NOT NULL,
folder_global_new VARCHAR(200) DEFAULT '' NOT NULL,
- folder_global_new_posted VARCHAR(200) DEFAULT '' NOT NULL,
+ folder_global_new_post VARCHAR(200) DEFAULT '' NOT NULL,
poll_left VARCHAR(200) DEFAULT '' NOT NULL,
poll_center VARCHAR(200) DEFAULT '' NOT NULL,
poll_right VARCHAR(200) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index a6d1b7bfa7..241fdc3be8 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -676,6 +676,7 @@ CREATE TABLE [phpbb_posts] (
[post_attachment] [int] DEFAULT (0) NOT NULL ,
[bbcode_bitfield] [varbinary] (255) DEFAULT (0x) NOT NULL ,
[bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,
+ [post_postcount] [int] DEFAULT (1) NOT NULL ,
[post_edit_time] [int] DEFAULT (0) NOT NULL ,
[post_edit_reason] [varchar] (3000) DEFAULT ('') NOT NULL ,
[post_edit_user] [int] DEFAULT (0) NOT NULL ,
@@ -706,6 +707,9 @@ GO
CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY]
GO
+CREATE INDEX [post_postcount] ON [phpbb_posts]([post_postcount]) ON [PRIMARY]
+GO
+
CREATE INDEX [post_time] ON [phpbb_posts]([post_time]) ON [PRIMARY]
GO
@@ -1246,41 +1250,41 @@ CREATE TABLE [phpbb_styles_imageset] (
[sub_forum_new] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_moved] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_hot] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_hot_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_hot_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_hot_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_hot_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_announce] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_announce_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_announce_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_announce_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_global] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_global_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_global_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_global_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_sticky] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_sticky_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_locked_sticky_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_hot_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_new] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_announce] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_announce_new] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_announce_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_announce_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_global] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_global_new] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_global_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_global_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_sticky] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_sticky_post] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_lock_sticky_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_sticky] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_sticky_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_sticky_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_sticky_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_sticky_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_announce] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_announce_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_announce_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_announce_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_announce_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_announce_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_global] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_global_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_global_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[folder_global_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [folder_global_new_posted] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [folder_global_new_post] [varchar] (200) DEFAULT ('') NOT NULL ,
[poll_left] [varchar] (200) DEFAULT ('') NOT NULL ,
[poll_center] [varchar] (200) DEFAULT ('') NOT NULL ,
[poll_right] [varchar] (200) DEFAULT ('') NOT NULL ,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 79640beacf..8d2ceebe7d 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -433,6 +433,7 @@ CREATE TABLE phpbb_posts (
post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
bbcode_uid varchar(5) DEFAULT '' NOT NULL,
+ post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
post_edit_reason text DEFAULT '' NOT NULL,
post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -444,6 +445,7 @@ CREATE TABLE phpbb_posts (
KEY poster_ip (poster_ip),
KEY poster_id (poster_id),
KEY post_approved (post_approved),
+ KEY post_postcount (post_postcount),
KEY post_time (post_time)
);
@@ -798,41 +800,41 @@ CREATE TABLE phpbb_styles_imageset (
sub_forum_new varchar(200) DEFAULT '' NOT NULL,
folder varchar(200) DEFAULT '' NOT NULL,
folder_moved varchar(200) DEFAULT '' NOT NULL,
- folder_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_post varchar(200) DEFAULT '' NOT NULL,
folder_new varchar(200) DEFAULT '' NOT NULL,
- folder_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_new_post varchar(200) DEFAULT '' NOT NULL,
folder_hot varchar(200) DEFAULT '' NOT NULL,
- folder_hot_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_hot_post varchar(200) DEFAULT '' NOT NULL,
folder_hot_new varchar(200) DEFAULT '' NOT NULL,
- folder_hot_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked varchar(200) DEFAULT '' NOT NULL,
- folder_locked_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_hot_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new_post varchar(200) DEFAULT '' NOT NULL,
folder_sticky varchar(200) DEFAULT '' NOT NULL,
- folder_sticky_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_sticky_post varchar(200) DEFAULT '' NOT NULL,
folder_sticky_new varchar(200) DEFAULT '' NOT NULL,
- folder_sticky_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_sticky_new_post varchar(200) DEFAULT '' NOT NULL,
folder_announce varchar(200) DEFAULT '' NOT NULL,
- folder_announce_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_announce_post varchar(200) DEFAULT '' NOT NULL,
folder_announce_new varchar(200) DEFAULT '' NOT NULL,
- folder_announce_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_announce_new_post varchar(200) DEFAULT '' NOT NULL,
folder_global varchar(200) DEFAULT '' NOT NULL,
- folder_global_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_global_post varchar(200) DEFAULT '' NOT NULL,
folder_global_new varchar(200) DEFAULT '' NOT NULL,
- folder_global_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_global_new_post varchar(200) DEFAULT '' NOT NULL,
poll_left varchar(200) DEFAULT '' NOT NULL,
poll_center varchar(200) DEFAULT '' NOT NULL,
poll_right varchar(200) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index e4e28db8a7..f6a1038d2d 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -779,6 +779,7 @@ CREATE TABLE phpbb_posts (
post_attachment number(1) DEFAULT '0' NOT NULL,
bbcode_bitfield raw(255) DEFAULT '' NOT NULL,
bbcode_uid varchar2(5) DEFAULT '' NOT NULL,
+ post_postcount number(1) DEFAULT '1' NOT NULL,
post_edit_time number(11) DEFAULT '0' NOT NULL,
post_edit_reason varchar2(3000) DEFAULT '' NOT NULL,
post_edit_user number(8) DEFAULT '0' NOT NULL,
@@ -798,6 +799,8 @@ CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id)
/
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved)
/
+CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts (post_postcount)
+/
CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time)
/
@@ -1433,41 +1436,41 @@ CREATE TABLE phpbb_styles_imageset (
sub_forum_new varchar2(200) DEFAULT '' NOT NULL,
folder varchar2(200) DEFAULT '' NOT NULL,
folder_moved varchar2(200) DEFAULT '' NOT NULL,
- folder_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_post varchar2(200) DEFAULT '' NOT NULL,
folder_new varchar2(200) DEFAULT '' NOT NULL,
- folder_new_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_new_post varchar2(200) DEFAULT '' NOT NULL,
folder_hot varchar2(200) DEFAULT '' NOT NULL,
- folder_hot_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_hot_post varchar2(200) DEFAULT '' NOT NULL,
folder_hot_new varchar2(200) DEFAULT '' NOT NULL,
- folder_hot_new_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_new varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_new_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_announce varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_announce_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_global varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_global_new varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_global_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_global_new_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_sticky varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_posted varchar2(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_hot_new_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_new varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_new_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_announce varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_global varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_global_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_post varchar2(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new_post varchar2(200) DEFAULT '' NOT NULL,
folder_sticky varchar2(200) DEFAULT '' NOT NULL,
- folder_sticky_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_sticky_post varchar2(200) DEFAULT '' NOT NULL,
folder_sticky_new varchar2(200) DEFAULT '' NOT NULL,
- folder_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_sticky_new_post varchar2(200) DEFAULT '' NOT NULL,
folder_announce varchar2(200) DEFAULT '' NOT NULL,
- folder_announce_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_announce_post varchar2(200) DEFAULT '' NOT NULL,
folder_announce_new varchar2(200) DEFAULT '' NOT NULL,
- folder_announce_new_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_announce_new_post varchar2(200) DEFAULT '' NOT NULL,
folder_global varchar2(200) DEFAULT '' NOT NULL,
- folder_global_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_global_post varchar2(200) DEFAULT '' NOT NULL,
folder_global_new varchar2(200) DEFAULT '' NOT NULL,
- folder_global_new_posted varchar2(200) DEFAULT '' NOT NULL,
+ folder_global_new_post varchar2(200) DEFAULT '' NOT NULL,
poll_left varchar2(200) DEFAULT '' NOT NULL,
poll_center varchar2(200) DEFAULT '' NOT NULL,
poll_right varchar2(200) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 8f4a5ecffd..7feffaacc6 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -537,6 +537,7 @@ CREATE TABLE phpbb_posts (
post_attachment INT2 DEFAULT '0' NOT NULL CHECK (post_attachment >= 0),
bbcode_bitfield bytea DEFAULT '\000' NOT NULL,
bbcode_uid varchar(5) DEFAULT '' NOT NULL,
+ post_postcount INT2 DEFAULT '1' NOT NULL CHECK (post_postcount >= 0),
post_edit_time INT4 DEFAULT '0' NOT NULL CHECK (post_edit_time >= 0),
post_edit_reason varchar(3000) DEFAULT '' NOT NULL,
post_edit_user INT4 DEFAULT '0' NOT NULL CHECK (post_edit_user >= 0),
@@ -550,6 +551,7 @@ CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip);
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id);
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved);
+CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts (post_postcount);
CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time);
/* Table: 'phpbb_privmsgs' */
@@ -694,7 +696,7 @@ CREATE SEQUENCE phpbb_ranks_seq;
CREATE TABLE phpbb_ranks (
rank_id INT4 DEFAULT nextval('phpbb_ranks_seq'),
rank_title varchar(255) DEFAULT '' NOT NULL,
- rank_min INT4 DEFAULT '0' NOT NULL CHECK (rank_min >= -1),
+ rank_min INT4 DEFAULT '0' NOT NULL CHECK (rank_min >= 0),
rank_special INT2 DEFAULT '0' NOT NULL CHECK (rank_special >= 0),
rank_image varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (rank_id)
@@ -932,41 +934,41 @@ CREATE TABLE phpbb_styles_imageset (
sub_forum_new varchar(200) DEFAULT '' NOT NULL,
folder varchar(200) DEFAULT '' NOT NULL,
folder_moved varchar(200) DEFAULT '' NOT NULL,
- folder_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_post varchar(200) DEFAULT '' NOT NULL,
folder_new varchar(200) DEFAULT '' NOT NULL,
- folder_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_new_post varchar(200) DEFAULT '' NOT NULL,
folder_hot varchar(200) DEFAULT '' NOT NULL,
- folder_hot_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_hot_post varchar(200) DEFAULT '' NOT NULL,
folder_hot_new varchar(200) DEFAULT '' NOT NULL,
- folder_hot_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked varchar(200) DEFAULT '' NOT NULL,
- folder_locked_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_announce_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_global_new_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_posted varchar(200) DEFAULT '' NOT NULL,
- folder_locked_sticky_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_hot_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_announce_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_global_new_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_post varchar(200) DEFAULT '' NOT NULL,
+ folder_lock_sticky_new_post varchar(200) DEFAULT '' NOT NULL,
folder_sticky varchar(200) DEFAULT '' NOT NULL,
- folder_sticky_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_sticky_post varchar(200) DEFAULT '' NOT NULL,
folder_sticky_new varchar(200) DEFAULT '' NOT NULL,
- folder_sticky_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_sticky_new_post varchar(200) DEFAULT '' NOT NULL,
folder_announce varchar(200) DEFAULT '' NOT NULL,
- folder_announce_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_announce_post varchar(200) DEFAULT '' NOT NULL,
folder_announce_new varchar(200) DEFAULT '' NOT NULL,
- folder_announce_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_announce_new_post varchar(200) DEFAULT '' NOT NULL,
folder_global varchar(200) DEFAULT '' NOT NULL,
- folder_global_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_global_post varchar(200) DEFAULT '' NOT NULL,
folder_global_new varchar(200) DEFAULT '' NOT NULL,
- folder_global_new_posted varchar(200) DEFAULT '' NOT NULL,
+ folder_global_new_post varchar(200) DEFAULT '' NOT NULL,
poll_left varchar(200) DEFAULT '' NOT NULL,
poll_center varchar(200) DEFAULT '' NOT NULL,
poll_right varchar(200) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index fe8d612e4c..cd0c9349c9 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -381,7 +381,7 @@ INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order)
INSERT INTO phpbb_styles (style_name, style_copyright, template_id, theme_id, imageset_id) VALUES ('subSilver', '&copy; phpBB Group', 1, 1, 1);
# -- phpbb_styles_imageset
-INSERT INTO phpbb_styles_imageset (imageset_name, imageset_copyright, imageset_path, site_logo, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_info, btn_quote, btn_search, btn_edit, btn_report, btn_warn, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_jabber, btn_online, btn_offline, btn_friend, btn_foe, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, forum_link, sub_forum, sub_forum_new, folder, folder_moved, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_locked_announce, folder_locked_announce_new, folder_locked_announce_posted, folder_locked_announce_new_posted, folder_locked_global, folder_locked_global_new, folder_locked_global_posted, folder_locked_global_new_posted, folder_locked_sticky, folder_locked_sticky_new, folder_locked_sticky_posted, folder_locked_sticky_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, folder_global, folder_global_posted, folder_global_new, folder_global_new_posted, poll_left, poll_center, poll_right, attach_progress_bar, user_icon1, user_icon2, user_icon3, user_icon4, user_icon5, user_icon6, user_icon7, user_icon8, user_icon9, user_icon10) VALUES ('subSilver', '&copy; phpBB Group', 'subSilver', 'sitelogo.gif*94*170', '{LANG}/btn_post.gif*27*97', '{LANG}/btn_post_pm.gif*27*97', '{LANG}/btn_reply.gif*27*97', '{LANG}/btn_reply_pm.gif*20*90', '{LANG}/btn_locked.gif*27*97', '{LANG}/btn_profile.gif*20*72', '{LANG}/btn_pm.gif*20*72', '{LANG}/btn_delete.gif*20*20', '{LANG}/btn_info.gif*20*20', '{LANG}/btn_quote.gif*20*90', '{LANG}/btn_search.gif*20*72', '{LANG}/btn_edit.gif*20*90', '{LANG}/btn_report.gif*20*20', '{LANG}/btn_warn.gif*20*20', '{LANG}/btn_email.gif*20*72', '{LANG}/btn_www.gif*20*72', '{LANG}/btn_icq.gif*20*72', '{LANG}/btn_aim.gif*20*72', '{LANG}/btn_yim.gif*20*72', '{LANG}/btn_msnm.gif*20*72', '{LANG}/btn_jabber.gif*20*72', '{LANG}/btn_online.gif*20*72', '{LANG}/btn_offline.gif*20*72', '', '', 'icon_unapproved.gif*18*19', 'icon_reported.gif*18*19', 'icon_attach.gif*18*14', 'icon_minipost.gif*9*12', 'icon_minipost_new.gif*9*12', 'icon_latest_reply.gif*9*18', 'icon_newest_reply.gif*9*18', 'folder_big.gif*25*46', 'folder_new_big.gif*25*46', 'folder_locked_big.gif*25*46', 'folder_link_big.gif*25*46', 'subfolder_big.gif*25*46', 'subfolder_new_big.gif*25*46', 'folder.gif*18*19', 'folder_moved.gif*18*19', 'folder_posted.gif*18*19', 'folder_new.gif*18*19', 'folder_new_posted.gif*18*19', 'folder_hot.gif*18*19', 'folder_hot_posted.gif*18*19', 'folder_new_hot.gif*18*19', 'folder_new_hot_posted.gif*18*19', 'folder_lock.gif*18*19', 'folder_lock_posted.gif*18*19', 'folder_lock_new.gif*18*19', 'folder_lock_new_posted.gif*18*19', 'folder_lock_announce.gif*18*19', 'folder_lock_announce_new.gif*18*19', 'folder_lock_announce_posted.gif*18*19', 'folder_lock_announce_new_posted.gif*18*19', 'folder_lock_announce.gif*18*19', 'folder_lock_announce_new.gif*18*19', 'folder_lock_announce_posted.gif*18*19', 'folder_lock_announce_new_posted.gif*18*19', 'folder_lock_sticky.gif*18*19', 'folder_lock_sticky_new.gif*18*19', 'folder_lock_sticky_posted.gif*18*19', 'folder_lock_sticky_new_posted.gif*18*19', 'folder_sticky.gif*18*19', 'folder_sticky_posted.gif*18*19', 'folder_sticky_new.gif*18*19', 'folder_sticky_new_posted.gif*18*19', 'folder_announce.gif*18*19', 'folder_announce_posted.gif*18*19', 'folder_announce_new.gif*18*19', 'folder_announce_new_posted.gif*18*19', 'folder_announce.gif*18*19', 'folder_announce_posted.gif*18*19', 'folder_announce_new.gif*18*19', 'folder_announce_new_posted.gif*18*19', 'vote_lcap.gif*12*4', 'voting_bar.gif*12', 'vote_rcap.gif*12*4', 'progress_bar.gif*16*280', '', '', '', '', '', '', '', '', '', '');
+INSERT INTO phpbb_styles_imageset (imageset_name, imageset_copyright, imageset_path, site_logo, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_info, btn_quote, btn_search, btn_edit, btn_report, btn_warn, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_jabber, btn_online, btn_offline, btn_friend, btn_foe, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, forum_link, sub_forum, sub_forum_new, folder, folder_moved, folder_post, folder_new, folder_new_post, folder_hot, folder_hot_post, folder_hot_new, folder_hot_new_post, folder_lock, folder_lock_post, folder_lock_new, folder_lock_new_post, folder_lock_announce, folder_lock_announce_new, folder_lock_announce_post, folder_lock_announce_new_post, folder_lock_global, folder_lock_global_new, folder_lock_global_post, folder_lock_global_new_post, folder_lock_sticky, folder_lock_sticky_new, folder_lock_sticky_post, folder_lock_sticky_new_post, folder_sticky, folder_sticky_post, folder_sticky_new, folder_sticky_new_post, folder_announce, folder_announce_post, folder_announce_new, folder_announce_new_post, folder_global, folder_global_post, folder_global_new, folder_global_new_post, poll_left, poll_center, poll_right, attach_progress_bar, user_icon1, user_icon2, user_icon3, user_icon4, user_icon5, user_icon6, user_icon7, user_icon8, user_icon9, user_icon10) VALUES ('subSilver', '&copy; phpBB Group', 'subSilver', 'sitelogo.gif*94*170', '{LANG}/btn_post.gif*27*97', '{LANG}/btn_post_pm.gif*27*97', '{LANG}/btn_reply.gif*27*97', '{LANG}/btn_reply_pm.gif*20*90', '{LANG}/btn_locked.gif*27*97', '{LANG}/btn_profile.gif*20*72', '{LANG}/btn_pm.gif*20*72', '{LANG}/btn_delete.gif*20*20', '{LANG}/btn_info.gif*20*20', '{LANG}/btn_quote.gif*20*90', '{LANG}/btn_search.gif*20*72', '{LANG}/btn_edit.gif*20*90', '{LANG}/btn_report.gif*20*20', '{LANG}/btn_warn.gif*20*20', '{LANG}/btn_email.gif*20*72', '{LANG}/btn_www.gif*20*72', '{LANG}/btn_icq.gif*20*72', '{LANG}/btn_aim.gif*20*72', '{LANG}/btn_yim.gif*20*72', '{LANG}/btn_msnm.gif*20*72', '{LANG}/btn_jabber.gif*20*72', '{LANG}/btn_online.gif*20*72', '{LANG}/btn_offline.gif*20*72', '', '', 'icon_unapproved.gif*18*19', 'icon_reported.gif*18*19', 'icon_attach.gif*18*14', 'icon_minipost.gif*9*12', 'icon_minipost_new.gif*9*12', 'icon_latest_reply.gif*9*18', 'icon_newest_reply.gif*9*18', 'folder_big.gif*25*46', 'folder_new_big.gif*25*46', 'folder_locked_big.gif*25*46', 'folder_link_big.gif*25*46', 'subfolder_big.gif*25*46', 'subfolder_new_big.gif*25*46', 'folder.gif*18*19', 'folder_moved.gif*18*19', 'folder_posted.gif*18*19', 'folder_new.gif*18*19', 'folder_new_posted.gif*18*19', 'folder_hot.gif*18*19', 'folder_hot_posted.gif*18*19', 'folder_new_hot.gif*18*19', 'folder_new_hot_posted.gif*18*19', 'folder_lock.gif*18*19', 'folder_lock_posted.gif*18*19', 'folder_lock_new.gif*18*19', 'folder_lock_new_posted.gif*18*19', 'folder_lock_announce.gif*18*19', 'folder_lock_announce_new.gif*18*19', 'folder_lock_announce_posted.gif*18*19', 'folder_lock_announce_new_posted.gif*18*19', 'folder_lock_announce.gif*18*19', 'folder_lock_announce_new.gif*18*19', 'folder_lock_announce_posted.gif*18*19', 'folder_lock_announce_new_posted.gif*18*19', 'folder_lock_sticky.gif*18*19', 'folder_lock_sticky_new.gif*18*19', 'folder_lock_sticky_posted.gif*18*19', 'folder_lock_sticky_new_posted.gif*18*19', 'folder_sticky.gif*18*19', 'folder_sticky_posted.gif*18*19', 'folder_sticky_new.gif*18*19', 'folder_sticky_new_posted.gif*18*19', 'folder_announce.gif*18*19', 'folder_announce_posted.gif*18*19', 'folder_announce_new.gif*18*19', 'folder_announce_new_posted.gif*18*19', 'folder_announce.gif*18*19', 'folder_announce_posted.gif*18*19', 'folder_announce_new.gif*18*19', 'folder_announce_new_posted.gif*18*19', 'vote_lcap.gif*12*4', 'voting_bar.gif*12', 'vote_rcap.gif*12*4', 'progress_bar.gif*16*280', '', '', '', '', '', '', '', '', '', '');
# -- phpbb_styles_template
INSERT INTO phpbb_styles_template (template_name, template_copyright, template_path) VALUES ('subSilver', '&copy; phpBB Group', 'subSilver');
@@ -417,7 +417,7 @@ INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VAL
INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (7, 2, 0, 1);
# -- Ranks
-INSERT INTO phpbb_ranks (rank_title, rank_min, rank_special, rank_image) VALUES ('Site Admin', -1, 1, '');
+INSERT INTO phpbb_ranks (rank_title, rank_min, rank_special, rank_image) VALUES ('Site Admin', 0, 1, '');
# -- Roles data
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 816ee95cfa..9e109815d1 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -435,6 +435,7 @@ CREATE TABLE phpbb_posts (
post_attachment tinyint(1) NOT NULL DEFAULT '0',
bbcode_bitfield blob NOT NULL DEFAULT '',
bbcode_uid varchar(5) NOT NULL DEFAULT '',
+ post_postcount tinyint(1) NOT NULL DEFAULT '1',
post_edit_time int(11) NOT NULL DEFAULT '0',
post_edit_reason text(65535) NOT NULL DEFAULT '',
post_edit_user mediumint(8) NOT NULL DEFAULT '0',
@@ -448,6 +449,7 @@ CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);;
CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip);;
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id);;
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved);;
+CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts (post_postcount);;
CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time);;
# Table: 'phpbb_privmsgs'
@@ -807,41 +809,41 @@ CREATE TABLE phpbb_styles_imageset (
sub_forum_new varchar(200) NOT NULL DEFAULT '',
folder varchar(200) NOT NULL DEFAULT '',
folder_moved varchar(200) NOT NULL DEFAULT '',
- folder_posted varchar(200) NOT NULL DEFAULT '',
+ folder_post varchar(200) NOT NULL DEFAULT '',
folder_new varchar(200) NOT NULL DEFAULT '',
- folder_new_posted varchar(200) NOT NULL DEFAULT '',
+ folder_new_post varchar(200) NOT NULL DEFAULT '',
folder_hot varchar(200) NOT NULL DEFAULT '',
- folder_hot_posted varchar(200) NOT NULL DEFAULT '',
+ folder_hot_post varchar(200) NOT NULL DEFAULT '',
folder_hot_new varchar(200) NOT NULL DEFAULT '',
- folder_hot_new_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked varchar(200) NOT NULL DEFAULT '',
- folder_locked_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_new varchar(200) NOT NULL DEFAULT '',
- folder_locked_new_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_announce varchar(200) NOT NULL DEFAULT '',
- folder_locked_announce_new varchar(200) NOT NULL DEFAULT '',
- folder_locked_announce_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_announce_new_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_global varchar(200) NOT NULL DEFAULT '',
- folder_locked_global_new varchar(200) NOT NULL DEFAULT '',
- folder_locked_global_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_global_new_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_sticky varchar(200) NOT NULL DEFAULT '',
- folder_locked_sticky_new varchar(200) NOT NULL DEFAULT '',
- folder_locked_sticky_posted varchar(200) NOT NULL DEFAULT '',
- folder_locked_sticky_new_posted varchar(200) NOT NULL DEFAULT '',
+ folder_hot_new_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock varchar(200) NOT NULL DEFAULT '',
+ folder_lock_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_new varchar(200) NOT NULL DEFAULT '',
+ folder_lock_new_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_announce varchar(200) NOT NULL DEFAULT '',
+ folder_lock_announce_new varchar(200) NOT NULL DEFAULT '',
+ folder_lock_announce_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_announce_new_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_global varchar(200) NOT NULL DEFAULT '',
+ folder_lock_global_new varchar(200) NOT NULL DEFAULT '',
+ folder_lock_global_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_global_new_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_sticky varchar(200) NOT NULL DEFAULT '',
+ folder_lock_sticky_new varchar(200) NOT NULL DEFAULT '',
+ folder_lock_sticky_post varchar(200) NOT NULL DEFAULT '',
+ folder_lock_sticky_new_post varchar(200) NOT NULL DEFAULT '',
folder_sticky varchar(200) NOT NULL DEFAULT '',
- folder_sticky_posted varchar(200) NOT NULL DEFAULT '',
+ folder_sticky_post varchar(200) NOT NULL DEFAULT '',
folder_sticky_new varchar(200) NOT NULL DEFAULT '',
- folder_sticky_new_posted varchar(200) NOT NULL DEFAULT '',
+ folder_sticky_new_post varchar(200) NOT NULL DEFAULT '',
folder_announce varchar(200) NOT NULL DEFAULT '',
- folder_announce_posted varchar(200) NOT NULL DEFAULT '',
+ folder_announce_post varchar(200) NOT NULL DEFAULT '',
folder_announce_new varchar(200) NOT NULL DEFAULT '',
- folder_announce_new_posted varchar(200) NOT NULL DEFAULT '',
+ folder_announce_new_post varchar(200) NOT NULL DEFAULT '',
folder_global varchar(200) NOT NULL DEFAULT '',
- folder_global_posted varchar(200) NOT NULL DEFAULT '',
+ folder_global_post varchar(200) NOT NULL DEFAULT '',
folder_global_new varchar(200) NOT NULL DEFAULT '',
- folder_global_new_posted varchar(200) NOT NULL DEFAULT '',
+ folder_global_new_post varchar(200) NOT NULL DEFAULT '',
poll_left varchar(200) NOT NULL DEFAULT '',
poll_center varchar(200) NOT NULL DEFAULT '',
poll_right varchar(200) NOT NULL DEFAULT '',
generated by cgit v1.2.1 (git 2.21.0) at 2026-01-03 14:27:16 +0000