暫無描述

ahwelp 235c58d1a9 Update 'README.md' 5 年之前
src 8b45dd556a Update 'src/Schema/Wrapper.php' 5 年之前
.gitignore b57229f582 Rudimentary support for table prefixing #1 6 年之前
README.md 235c58d1a9 Update 'README.md' 5 年之前
composer.json 9f66bb7c55 Changing name 6 年之前

README.md

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