From afb5f07213cc26bfd4f996a5a7f1c9eea7ddb550 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Fri, 6 Feb 2009 18:52:04 +0000 Subject: curtesty of toonarmy :) (shows cached sql queries to determine useless sql caches) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9313 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/collect_cache_stats.sh | 2 ++ 1 file changed, 2 insertions(+) create mode 100755 phpBB/develop/collect_cache_stats.sh (limited to 'phpBB/develop') diff --git a/phpBB/develop/collect_cache_stats.sh b/phpBB/develop/collect_cache_stats.sh new file mode 100755 index 0000000000..8231a3caea --- /dev/null +++ b/phpBB/develop/collect_cache_stats.sh @@ -0,0 +1,2 @@ +#!/bin/sh +cat sql_*.php | grep '/* SELECT' | sed 's,/\* ,,;s, \*/,,' | sort > _cache.txt -- cgit v1.2.1 From b6c056c1dbe401125a9bbf3e856f70cb1844ab52 Mon Sep 17 00:00:00 2001 From: Chris Smith Date: Sat, 7 Feb 2009 00:34:45 +0000 Subject: Small fix up should work now when ran from anywhere :) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9314 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/collect_cache_stats.sh | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'phpBB/develop') diff --git a/phpBB/develop/collect_cache_stats.sh b/phpBB/develop/collect_cache_stats.sh index 8231a3caea..5bb31c5173 100755 --- a/phpBB/develop/collect_cache_stats.sh +++ b/phpBB/develop/collect_cache_stats.sh @@ -1,2 +1,3 @@ #!/bin/sh -cat sql_*.php | grep '/* SELECT' | sed 's,/\* ,,;s, \*/,,' | sort > _cache.txt +DIR=$(dirname "$0")/../cache; +cat "$DIR/sql_*.php" | grep '/* SELECT' | sed 's,/\* ,,;s, \*/,,' | sort -- cgit v1.2.1 From 0f162568f241753ff3ec5a15c3ec9d3028c10f23 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Fri, 20 Mar 2009 13:22:19 +0000 Subject: Fix duplicate creation of acl options in acl_add_options() under certain conditions. (Bug #38385, #40225) Add unique key to ACL options table to prevent duplicate permission options. (Bug #41835) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9400 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/create_schema_files.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'phpBB/develop') diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 4d39d0c6b0..52c72fc72c 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -855,7 +855,7 @@ function get_schema_struct() ), 'PRIMARY_KEY' => 'auth_option_id', 'KEYS' => array( - 'auth_option' => array('INDEX', 'auth_option'), + 'auth_option' => array('UNIQUE', 'auth_option'), ), ); -- cgit v1.2.1 From dc1e334d073fdb191a4742e02b401749b794f984 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Tue, 28 Apr 2009 14:14:32 +0000 Subject: bring mysql upgrader up-to-date with 3.0.5-dev git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9493 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/mysql_upgrader.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'phpBB/develop') diff --git a/phpBB/develop/mysql_upgrader.php b/phpBB/develop/mysql_upgrader.php index bc1994bcb3..77341500e1 100644 --- a/phpBB/develop/mysql_upgrader.php +++ b/phpBB/develop/mysql_upgrader.php @@ -327,7 +327,7 @@ function get_schema_struct() ), 'PRIMARY_KEY' => 'auth_option_id', 'KEYS' => array( - 'auth_option' => array('INDEX', 'auth_option'), + 'auth_option' => array('UNIQUE', 'auth_option'), ), ); @@ -1082,6 +1082,8 @@ function get_schema_struct() 'template_path' => array('VCHAR:100', ''), 'bbcode_bitfield' => array('VCHAR:255', 'kNg='), 'template_storedb' => array('BOOL', 0), + 'template_inherits_id' => array('UINT:4', 0), + 'template_inherit_path' => array('VCHAR', ''), ), 'PRIMARY_KEY' => 'template_id', 'KEYS' => array( -- cgit v1.2.1