Esempi in PHP per DragonX_Storage_Engine_ZendDbAdataper

Esempio n. 1

File: Resource.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_acl_record_resource` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`name` VARCHAR(255) NOT NULL, " . "`lft` BIGINT(20) UNSIGNED NOT NULL, " . "`rgt` BIGINT(20) UNSIGNED NOT NULL, " . "PRIMARY KEY (`id`), " . "KEY (`lft`), " . "KEY (`rgt`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
         $logicResource = new DragonX_Acl_Logic_Resource();
         $logicResource->addResource('All');
     }
 }

Esempio n. 2

File: Device.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_device_record_device` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`modified` INT(10) UNSIGNED NOT NULL, " . "`account_id` BIGINT(20) UNSIGNED NOT NULL, " . "`platform` VARCHAR(255) NOT NULL, " . "`name` VARCHAR(255) NOT NULL, " . "PRIMARY KEY (`id`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
     if (version_compare($version, '1.13.0', '<')) {
         $storage->executeSqlStatement("DROP TABLE `dragonx_device_record_device`");
         $storage->executeSqlStatement("CREATE TABLE `dragonx_device_record_device` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`modified` INT(10) UNSIGNED NOT NULL, " . "`account_id` BIGINT(20) UNSIGNED NOT NULL, " . "`platform` VARCHAR(255) NOT NULL, " . "`devicename` VARCHAR(255) NOT NULL, " . "`locale_register` CHAR(5) NOT NULL, " . "`locale_actual` CHAR(5) NOT NULL, " . "PRIMARY KEY (`id`), " . "KEY (`account_id`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 3

File: Account.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_clientmessage_record_account` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`account_id` BIGINT(20) UNSIGNED NOT NULL, " . "`key` VARCHAR(255) NOT NULL, " . "`result` TEXT NOT NULL, " . "PRIMARY KEY (`id`), " . "KEY (`account_id`, `created`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 4

File: Roleresource.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_acl_record_roleresource` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`role_id` BIGINT(20) UNSIGNED NOT NULL, " . "`resource_id` BIGINT(20) UNSIGNED NOT NULL, " . "PRIMARY KEY (`id`), " . "UNIQUE KEY (`role_id`, `resource_id`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 5

File: Credential.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.13.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_device_record_credential` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`device_id` BIGINT(20) UNSIGNED NOT NULL, " . "`key` VARCHAR(255) NOT NULL, " . "`value` CHAR(32) NOT NULL, " . "PRIMARY KEY (`id`), " . "UNIQUE KEY (`key`, `value`, `device_id`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 6

File: Emailaddress.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_emailaddress_record_emailaddress` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`modified` INT(10) UNSIGNED NOT NULL, " . "`account_id` BIGINT(20) UNSIGNED NOT NULL, " . "`emailaddress` VARCHAR(255) NOT NULL, " . "`passwordhash` CHAR(60) BINARY NOT NULL, " . "PRIMARY KEY (`id`), " . "UNIQUE KEY (`account_id`), " . "UNIQUE KEY (`emailaddress`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 7

File: Log.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_log_record_log` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`request_id` BIGINT(20) NULL, " . "`account_id` BIGINT(20) NULL, " . "`priority` INT(10) UNSIGNED NOT NULL, " . "`message` TEXT NOT NULL, " . "`params` TEXT NULL, " . "PRIMARY KEY (`id`) " . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 8

File: Account.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `application_account_record_account` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`modified` INT(10) UNSIGNED NOT NULL, " . "PRIMARY KEY (`id`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 9

File: Session.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_account_record_session` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`created` INT(10) UNSIGNED NOT NULL, " . "`account_id` BIGINT(20) UNSIGNED NOT NULL, " . "`sessionhash` CHAR(32) NOT NULL, " . "`data` TEXT NOT NULL, " . "PRIMARY KEY (`id`), " . "UNIQUE KEY (`sessionhash`)" . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }

Esempio n. 10

File: Request.php Progetto: dragonprojects/dragonjsonserver

 /**
  * Installiert das Plugin in der übergebenen Datenbank
  * @param DragonX_Storage_Engine_ZendDbAdataper $storage
  * @param string $version
  */
 public function install(DragonX_Storage_Engine_ZendDbAdataper $storage, $version = '0.0.0')
 {
     if (version_compare($version, '1.8.0', '<')) {
         $storage->executeSqlStatement("CREATE TABLE `dragonx_log_record_request` (" . "`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, " . "`rpcmethod` VARCHAR(255) NOT NULL, " . "`rpcid` VARCHAR(255) NOT NULL, " . "`rpcversion` VARCHAR(255) NOT NULL, " . "`requestparams` TEXT NOT NULL, " . "`requesttimestamp` INT(10) UNSIGNED NOT NULL, " . "`response` TEXT NULL, " . "`responsetimestamp` INT(10) UNSIGNED NULL, " . "PRIMARY KEY (`id`) " . ") ENGINE=InnoDB DEFAULT CHARSET=utf8");
     }
 }