/** * @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 upGroupTable */ public function upMemberTable($up) { if ($up) { $this->db()->createTable(self::GROUP_MEMBER_TABLE, [TableColumn::getPK(UserGroupMemberEntity::C_ID), TableColumn::getInteger(UserGroupMemberEntity::C_GROUP_ID), TableColumn::getInteger(UserGroupMemberEntity::C_USER_ID), TableColumn::getTimestamp(UserGroupMemberEntity::C_TIMESTAMP_X)]); } else { $this->db()->dropTable(self::GROUP_MEMBER_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); } }