/** * @root */ public function up($up) { if ($up) { $this->db()->createTable(self::MIGRATE_TABLE, [TableColumn::getPK('ID'), TableColumn::getString(MigrationEntity::C_PACKAGE, 100)->setNotNull(), TableColumn::getString(MigrationEntity::C_SERVICE, 100)->setNotNull(), TableColumn::getString(MigrationEntity::C_FUNCTION, 100)->setNotNull(), TableColumn::getString(MigrationEntity::C_GUID, 30)->setNotNull(), TableColumn::getTimestamp(MigrationEntity::C_TIMESTAMP_X)->setNotNull()]); } else { $this->db()->dropTable(self::MIGRATE_TABLE); } }
/** * @root */ public function upCaptchaTable($up) { if ($up) { $this->db()->createTable(self::CAPTCHA_TABLE, [TableColumn::getPK(CaptchaEntity::C_ID), TableColumn::getString(CaptchaEntity::C_GUID, 50), TableColumn::getString(CaptchaEntity::C_CODE, 50), TableColumn::getTimestamp(CaptchaEntity::C_TIMESTAMP_X)]); } else { $this->db()->dropTable(self::CAPTCHA_TABLE); } }
/** * @parent upUserTable */ public function upGroupTable($up) { if ($up) { $this->db()->createTable(self::GROUP_TABLE, [TableColumn::getPK(UserGroupEntity::C_ID), TableColumn::getString(UserGroupEntity::C_GUID, 100), TableColumn::getBoolean(UserGroupEntity::C_ACTIVE), TableColumn::getTimestamp(UserGroupEntity::C_TIMESTAMP_X), TableColumn::getString(UserGroupEntity::C_NAME, 255), TableColumn::getText(UserGroupEntity::C_DESCRIPTION), TableColumn::getInteger(UserGroupEntity::C_SORT)]); } else { $this->db()->dropTable(self::GROUP_TABLE); } }
/** * @root */ public function upCreateTable($up) { if ($up) { $this->db()->createTable(self::CAPTCHA_TABLE, [TableColumn::getPK(CounterEntity::C_ID), TableColumn::getString(CounterEntity::C_ENTITY, 100), TableColumn::getString(CounterEntity::C_ENTITY_ID, 100), TableColumn::getInteger(CounterEntity::C_COUNTER), TableColumn::getTimestamp(CounterEntity::C_TIMESTAMP_X)]); } else { $this->db()->dropTable(self::CAPTCHA_TABLE); } }