You can add created_at and updated_at timestamps to a table using the addTimestamps() method. Set an action to be triggered when the row is updated (use with CURRENT_TIMESTAMP) (only applies to MySQL)Įnable or disable the with time zone option for time and timestamp columns (only applies to Postgres) Set default value (use with CURRENT_TIMESTAMP) Specify the column that a new column should be placed after, or use \Phinx\Db\Adapter\MysqlAdapter::FIRST to place the column at the start of the table (only applies to MySQL)Ĭombine with scale set to set decimal accuracyĬombine with precision to set decimal accuracyĮnable or disable the unsigned option (only applies to MySQL)Ĭan be a comma separated list or an array of values Set maximum length for strings, also hints column types in adapters (see note below)Īllow NULL values, defaults to false (should not be used with primary keys!) (see note below)
In addition, the Postgres adapter supports interval, json, jsonb, uuid, cidr, inet and macaddr column types Type will be based on required length (see Limit Option and MySQL for details) When providing a limit value and using binary, varbinary or blob and its subtypes, the retained column In addition, the MySQL adapter supports enum, set, blob, tinyblob, mediumblob, longblob, bit and json column types
Defined Types (Custom Data Domain).
0 kommentar(er)
