|
|
2 éve | |
|---|---|---|
| src | 2 éve | |
| .gitignore | 2 éve | |
| README.md | 5 éve | |
| composer.json | 2 éve |
https://book.cakephp.org/3.0/en/phinx/migrations.html#working-with-columns
<?php
require('vendor/autoload.php');
use Schema\Wrapper as Wrapper;
$pdo = new \PDO('sqlite:database.sqlite3');
Wrapper::set_driver($pdo);
Wrapper::begin();
$table = Wrapper::get_table('Coisa');
$table->addColumn('ida','integer');
$table->addColumn('idb','integer');
$table->removeColumn('idb');
$table->save();
Wrapper::commit();
//Data Types
biginteger
binary
boolean
char
date
datetime
decimal
float
integer
smallinteger
string
text
time
timestamp
uuid
//Mysql-------------------
enum
set
blob
bit
json
//PostgreSql-------------
interval
json
jsonb
uuid
cidr
inet
macaddr