public function onUpdate(QueryBuilder $query)
{
$query->setSet($this->fieldName, serialize($this->value));
}
public function onCreateTable(QueryBuilder $queryBuilder)
{
$queryBuilder->addFields(sprintf('`%s` int not null auto_increment', $this->fieldName));
$queryBuilder->addFields(sprintf('primary key (`%s`) ', $this->fieldName));
$queryBuilder->setTableOptions('AUTO_INCREMENT=1');
}
public function onCreateTable(QueryBuilder $queryBuilder)
{
$queryBuilder->addFields(sprintf('`%s` datetime not null default "0000-00-00 00:00:00"', $this->fieldName));
}
public function onCreateTable(QueryBuilder $queryBuilder)
{
$queryBuilder->addFields(sprintf('`%s` varchar(255) not null default ""', $this->fieldName));
}
public function onCreateTable(QueryBuilder $queryBuilder)
{
$queryBuilder->addFields(sprintf('`%s` int unsigned not null default 0', $this->fieldName));
}
public function onCreateTable(QueryBuilder $queryBuilder)
{
$queryBuilder->addFields(sprintf('`%s` text null', $this->fieldName));
}
public function createDatabaseTable($dropTable = false)
{
$fields = $this->getFieldsInfo();
if ($dropTable) {
$this->dropTable();
}
$queryBuilder = new QueryBuilder('create');
$queryBuilder->setTableName($fields['table']);
foreach ($this->columns as $column) {
$column->onCreateTable($queryBuilder);
}
$sql = $queryBuilder->prepare();
DB::post($sql);
}