Changeset 2864

Timestamp:

01/20/07 15:10:13 (2 years ago)

Author:

sihwp

Message:

• 플러그인 storage 기능중 auto increment 기능 추가
  

Location:

sandbox/lib

Files:

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

sandbox/lib/model/plugin.php

@@ -81 +81 @@
     } else {
         $query = "CREATE TABLE {$database['prefix']}{$name} (owner int(11) NOT NULL default '0',";
-
+        $isaiExists = false;
         foreach($fields as $field) {
+            $ai = '';
+            if( strtolower($field['attribute']) == 'int' || strtolower($field['attribute']) == 'mediumint'  ){
+                if( true == $field['autoincrement']  && ! $isaiExists){
+                    $ai = ' AUTO_INCREMENT ';
+                    $isaiExists = true;
+                }
+            }
             $isNull = ($field['isnull'] == 0) ? ' NOT NULL ' : ' NULL ';
             $defaultValue = is_null($field['default']) ? '' : " DEFAULT '" . mysql_tt_escape_string($field['default']) . "' ";
             $fieldLength = ($field['length'] >= 0) ? "(".$field['length'].")" : '';
-            $sentence = $field['name'] . " " . $field['attribute'] . $fieldLength . $isNull . $defaultValue . ",";
+            $sentence = $field['name'] . " " . $field['attribute'] . $fieldLength . $isNull . $defaultValue . $ai . ",";
             $query .= $sentence;
         }
@@ -94 +101 @@
         $query .= ") TYPE=MyISAM ";
         $query .= ($database['utf8'] == true) ? 'DEFAULT CHARSET=utf8' : '';
-        
         if (DBQuery::execute($query)) {
                 $keyname = mysql_tt_escape_string(mysql_lessen('Database_' . $name, 32));

sandbox/lib/plugins.php

@@ -49 +49 @@
                             $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;
                             
-                            array_push($storageMappings, array('name' => $fieldName, 'attribute' => $fieldAttribute, 'length' => $fieldLength, 'isnull' => $fieldIsNull, 'default' => $fieldDefault));
+                            array_push($storageMappings, array('name' => $fieldName, 'attribute' => $fieldAttribute, 'length' => $fieldLength, 'isnull' => $fieldIsNull, 'default' => $fieldDefault , 'autoincrement' => $ai));
                         }
                     }