@@ 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 |