Changeset 3070

Timestamp:

03/31/07 11:57:07 (22 months ago)

Author:

crizin

Message:

• plugin db config에 autoincrement를 지정하면 index 필드로 추가하도록 함
  

Location:

sandbox/lib

Files:

• model/common.plugin.php (modified) (2 diffs)
• plugins.php (modified) (1 diff)

sandbox/lib/model/common.plugin.php

@@ -82 +82 @@
         $query = "CREATE TABLE {$database['prefix']}{$name} (owner int(11) NOT NULL default '0',";
         $isaiExists = false;
+        $index = '';
         foreach($fields as $field) {
             $ai = '';
             if( strtolower($field['attribute']) == 'int' || strtolower($field['attribute']) == 'mediumint'  ){
-                if( true == $field['autoincrement']  && ! $isaiExists){
+                if($field['autoincrement'] == 1 && !$isaiExists){
                     $ai = ' AUTO_INCREMENT ';
                     $isaiExists = true;
+                    if(!in_array($field['name'], $keys))
+                        $index = ", KEY({$field['name']})";
                 }
             }
@@ -99 +102 @@
         array_unshift($keys, 'owner');
         $query .= " PRIMARY KEY (" . implode(',',$keys) . ")";
+        $query .= $index;
         $query .= ") TYPE=MyISAM ";
         $query .= ($database['utf8'] == true) ? 'DEFAULT CHARSET=utf8' : '';

sandbox/lib/plugins.php

@@ -52 +52 @@
                             $fieldIsNull = isset($field['isnull']) ? $field['isnull'][0]['.value'] : 1;
                             $fieldDefault = isset($field['default']) ? $field['default'][0]['.value'] : null;
-                            $ai = isset($field['autoincrement']) ? $field['autoincrement'][0]['.value'] == '1' : false;
+                            $fieldAutoIncrement = isset($field['autoincrement']) ? $field['autoincrement'][0]['.value'] : 0;
                             
-                            array_push($storageMappings, array('name' => $fieldName, 'attribute' => $fieldAttribute, 'length' => $fieldLength, 'isnull' => $fieldIsNull, 'default' => $fieldDefault , 'autoincrement' => $ai));
+                            array_push($storageMappings, array('name' => $fieldName, 'attribute' => $fieldAttribute, 'length' => $fieldLength, 'isnull' => $fieldIsNull, 'default' => $fieldDefault, 'autoincrement' => $fieldAutoIncrement));
                         }
                     }