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); }