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