| @@ 51-55 (lines=5) @@ | ||
| 48 | //Alter the database so that it can store $data |
|
| 49 | private function createTable($table, array $primaryKey, $data) { |
|
| 50 | $parts = []; |
|
| 51 | foreach ($primaryKey as $key) { |
|
| 52 | $pk = $data->$key; |
|
| 53 | if ($pk == null) $parts[] = $key . ' INT(11) NOT NULL AUTO_INCREMENT'; |
|
| 54 | else $parts[] = $key . ' ' . $this->getType($pk) . ' NOT NULL'; |
|
| 55 | } |
|
| 56 | ||
| 57 | $pkField = implode(', ', $parts) . ', PRIMARY KEY(' . implode(', ', $primaryKey) . ')'; |
|
| 58 | $this->pdo->query('CREATE TABLE IF NOT EXISTS ' . $table . ' (' . $pkField . ')'); |
|
| @@ 109-113 (lines=5) @@ | ||
| 106 | ||
| 107 | public function createTable($table, array $primaryKey, $data) { |
|
| 108 | $parts = []; |
|
| 109 | foreach ($primaryKey as $key) { |
|
| 110 | $pk = $data->$key; |
|
| 111 | if ($pk == null) $parts[] = $key . ' INTEGER'; |
|
| 112 | else $parts[] = $key . ' ' . $this->getType($pk) . ' NOT NULL'; |
|
| 113 | } |
|
| 114 | ||
| 115 | $pkField = implode(', ', $parts) . ', PRIMARY KEY(' . implode(', ', $primaryKey) . ')'; |
|
| 116 | ||