Changeset 2664

Timestamp:

12/14/06 21:56:49 (2 years ago)

Author:

inureyes

Message:

#240 : DB 스키마와 관련된 최적화

• 휴지통에 휴지가 넘치는 경우 누가 휴지인지 색칠해주도록 데이터베이스를 변경.
  

Location:

branches/1.1-beta

Files:

• blog/checkup/index.php (modified) (2 diffs)
• lib/config.php (modified) (1 diff)
• setup.php (modified) (2 diffs)

branches/1.1-beta/blog/checkup/index.php

@@ -383 +383 @@
 }
 
-// Since 1.1.0.3
+// Since 1.1.1
 $indexes = DBQuery::queryAll("Show index from {$database['prefix']}Entries");
 $idkey = FALSE;
@@ -397 +397 @@
 }
 
+if (DBQuery::queryCell("DESC {$database['prefix']}Comments isFiltered", 'Key') != 'MUL') {
+    $changed = true;
+    echo '<li>', _text('댓글 테이블에 필터 인덱스를 추가합니다.'), ': ';
+    if (DBQuery::execute("ALTER TABLE {$database['prefix']}Comments ADD INDEX isFiltered (isFiltered)"))
+        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+    else
+        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
+}
+
+if (DBQuery::queryCell("DESC {$database['prefix']}Trackbacks isFiltered", 'Key') != 'MUL') {
+    $changed = true;
+    echo '<li>', _text('글걸기 테이블에 필터 인덱스를 추가합니다.'), ': ';
+    if (DBQuery::execute("ALTER TABLE {$database['prefix']}Trackbacks ADD INDEX isFiltered (isFiltered)"))
+        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+    else
+        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
+}
 
 $filename = ROOT . '/.htaccess';

branches/1.1-beta/lib/config.php

@@ -4 +4 @@
 /// See the GNU General Public License for more details. (/doc/LICENSE, /doc/COPYRIGHT)
 define('TATTERTOOLS_NAME', 'Tattertools');
-define('TATTERTOOLS_VERSION', '1.1.0.3a1 : Friends');
+define('TATTERTOOLS_VERSION', '1.1.1a1 : Friends');
 define('TATTERTOOLS_COPYRIGHT', 'Copyright © 2004-2006. Tatter & Company / Tatter & Friends. All rights reserved. Licensed under the GPL.');
 define('TATTERTOOLS_HOMEPAGE', 'http://www.tattertools.com/');

branches/1.1-beta/setup.php

@@ -1054 +1054 @@
   KEY owner (owner),
   KEY entry (entry),
-  KEY parent (parent)
+  KEY parent (parent),
+  KEY isFiltered (isFiltered)
 ) $charset;
 CREATE TABLE {$_POST['dbPrefix']}CommentsNotified (
@@ -1312 +1313 @@
   isFiltered int(11) NOT NULL default '0',
   PRIMARY KEY (id),
-  UNIQUE KEY owner (owner, entry, url)
+  UNIQUE KEY owner (owner, entry, url),
+  KEY isFiltered (isFiltered)
 ) $charset;
 CREATE TABLE {$_POST['dbPrefix']}Users (