Example #1
0
 /**
  * @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);
     }
 }
Example #2
0
 /**
  * @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);
     }
 }
Example #3
0
 /**
  * @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);
     }
 }
Example #4
0
 /**
  * @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);
     }
 }