src/Query/Dialects/MySQL/CreateTable.php 1 location
|
@@ 39-47 (lines=9) @@
|
36 |
|
$sql .= $this->ifNotExists ? 'IF NOT EXISTS ' : ''; |
37 |
|
$sql .= $this->quote($this->name); |
38 |
|
|
39 |
|
if(!empty($this->cols)){ |
40 |
|
$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols); |
41 |
|
|
42 |
|
if($this->primaryKey){ |
43 |
|
$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
44 |
|
} |
45 |
|
|
46 |
|
$sql .= PHP_EOL.')'; |
47 |
|
} |
48 |
|
|
49 |
|
if(!empty($this->collate)){ |
50 |
|
list($charset) = explode('_', $this->collate); |
src/Query/Dialects/Postgres/CreateTable.php 1 location
|
@@ 42-50 (lines=9) @@
|
39 |
|
|
40 |
|
$sql .= $this->quote($n[count($n)-1]); |
41 |
|
|
42 |
|
if(!empty($this->cols)){ |
43 |
|
$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols); |
44 |
|
|
45 |
|
if($this->primaryKey){ |
46 |
|
$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
47 |
|
} |
48 |
|
|
49 |
|
$sql .= PHP_EOL.')'; |
50 |
|
} |
51 |
|
|
52 |
|
$sql .= ''; |
53 |
|
|