diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-08-30 22:54:24 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-08-30 22:54:24 +0200 |
| commit | 625e7ef58aab1b2d61505f756d53c7d85d9f2d2b (patch) | |
| tree | 216725609e8f37268a6a4f5f0ae2ed6b5f74846c | |
| parent | a6d3432f8bb39f20a93a65f9145eec608ea7fd37 (diff) | |
| download | forums-625e7ef58aab1b2d61505f756d53c7d85d9f2d2b.tar forums-625e7ef58aab1b2d61505f756d53c7d85d9f2d2b.tar.gz forums-625e7ef58aab1b2d61505f756d53c7d85d9f2d2b.tar.bz2 forums-625e7ef58aab1b2d61505f756d53c7d85d9f2d2b.tar.xz forums-625e7ef58aab1b2d61505f756d53c7d85d9f2d2b.zip | |
[feature/soft-delete] Update development scripts with new column names
PHPBB3-9657
| -rw-r--r-- | phpBB/develop/benchmark.php | 2 | ||||
| -rw-r--r-- | phpBB/develop/fill.php | 2 | ||||
| -rw-r--r-- | phpBB/develop/merge_post_tables.php | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/develop/benchmark.php b/phpBB/develop/benchmark.php index c867b9262e..11fbd38d76 100644 --- a/phpBB/develop/benchmark.php +++ b/phpBB/develop/benchmark.php @@ -263,7 +263,7 @@ function make_post($new_topic_id, $forum_id, $user_id, $post_username, $text, $m $post_message = prepare_message($text, $html_on, $bbcode_on, $smilies_on, $bbcode_uid); - $sql = "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, attach_id, icon_id, post_username, post_time, poster_ip, post_approved, bbcode_uid, enable_bbcode, enable_html, enable_smilies, enable_sig, post_subject, post_text) + $sql = "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, attach_id, icon_id, post_username, post_time, poster_ip, post_visibility, bbcode_uid, enable_bbcode, enable_html, enable_smilies, enable_sig, post_subject, post_text) VALUES ($new_topic_id, $forum_id, $user_id, 0, 0, '$post_username', $current_time, '$user_ip', 1, '$bbcode_uid', $bbcode_on, $html_on, $smilies_on, $attach_sig, '$post_subject', '$post_message')"; $result = $db->sql_query($sql); diff --git a/phpBB/develop/fill.php b/phpBB/develop/fill.php index e3b986e163..696b1e31c0 100644 --- a/phpBB/develop/fill.php +++ b/phpBB/develop/fill.php @@ -86,7 +86,7 @@ switch ($mode) $topic_rows[] = "($topic_id, $forum_id, '$forum_id-$topic_id', " . (($topic_id % 34) ? '0' : '1') . ')'; - $sql = 'INSERT IGNORE INTO ' . POSTS_TABLE . ' (topic_id, forum_id, poster_id, post_subject, post_text, post_username, post_approved, post_time, post_reported) + $sql = 'INSERT IGNORE INTO ' . POSTS_TABLE . ' (topic_id, forum_id, poster_id, post_subject, post_text, post_username, post_visibility, post_time, post_reported) VALUES '; $rows = array(); diff --git a/phpBB/develop/merge_post_tables.php b/phpBB/develop/merge_post_tables.php index 8edc330a0a..520591a4de 100644 --- a/phpBB/develop/merge_post_tables.php +++ b/phpBB/develop/merge_post_tables.php @@ -50,7 +50,7 @@ switch ($db->sql_layer) ADD PRIMARY KEY (post_id), ADD INDEX topic_id (topic_id), ADD INDEX poster_ip (poster_ip), - ADD INDEX post_approved (post_approved), + ADD INDEX post_visibility (post_visibility), MODIFY COLUMN post_id mediumint(8) UNSIGNED NOT NULL auto_increment, ADD COLUMN post_encoding varchar(11) DEFAULT \'iso-8859-15\' NOT NULL'; break; |