+
+ function updateDBSchema() {
+ $newSchema = $this->getDBSchema();
+ $synchronizer = new \Doctrine\DBAL\Schema\Synchronizer\SingleDatabaseSynchronizer($this->db);
+ $up_sql = $synchronizer->getUpdateSchema($newSchema); // for logging only
+ $synchronizer->updateSchema($newSchema);
+ $this->log('db_checked', implode("\n", $up_sql));
+ }
+
+ function getDBSchema() {
+ $schema = new \Doctrine\DBAL\Schema\Schema();
+
+ $table = $schema->createTable('auth_sessions');
+ $table->addColumn('id', 'bigint', array('unsigned' => true, 'notnull' => true, 'autoincrement' => true));
+ $table->addColumn('sesskey', 'string', array('length' => 150, 'notnull' => true, 'default' => ''));
+ $table->addColumn('user', 'integer', array('unsigned' => true, 'notnull' => false, 'default' => null));
+ $table->addColumn('logged_in', 'boolean', array('notnull' => true, 'default' => false));
+ $table->addColumn('time_created', 'datetime', array('notnull' => true, 'default' => 'CURRENT_TIMESTAMP'));
+ $table->addColumn('time_expire', 'datetime', array('notnull' => true, 'default' => 'CURRENT_TIMESTAMP'));
+ $table->addColumn('saved_redirect', 'string', array('length' => 255, 'notnull' => true, 'default' => ''));
+ $table->setPrimaryKey(array('id'), 'id');
+ $table->addIndex(array('sesskey'), 'sesskey');
+ $table->addIndex(array('time_expire'), 'time_expire');
+
+ $table = $schema->createTable('auth_users');
+ $table->addColumn('id', 'integer', array('unsigned' => true, 'notnull' => true, 'autoincrement' => true));
+ $table->addColumn('email', 'string', array('length' => 255, 'notnull' => true, 'default' => ''));
+ $table->addColumn('pwdhash', 'string', array('length' => 255, 'notnull' => true, 'default' => ''));
+ $table->addColumn('status', 'string', array('length' => 20, 'notnull' => true, 'default' => 'unverified'));
+ $table->addColumn('verify_hash', 'string', array('length' => 150, 'notnull' => false, 'default' => null));
+ $table->addColumn('group_id', 'integer', array('unsigned' => true, 'notnull' => true, 'default' => 0));
+ $table->setPrimaryKey(array('id'), 'id');
+ $table->addUniqueIndex(array('email'), 'email');
+
+ $table = $schema->createTable('auth_log');
+ $table->addColumn('id', 'bigint', array('unsigned' => true, 'notnull' => true, 'autoincrement' => true));
+ $table->addColumn('code', 'string', array('length' => 100, 'notnull' => true, 'default' => ''));
+ $table->addColumn('info', 'text', array('notnull' => false, 'default' => null));
+ $table->addColumn('ip_addr', 'string', array('length' => 50, 'notnull' => false, 'default' => null));
+ $table->addColumn('time_logged', 'datetime', array('notnull' => true, 'default' => 'CURRENT_TIMESTAMP'));
+ $table->setPrimaryKey(array('id'), 'id');
+ $table->addIndex(array('time_logged'), 'time_logged');
+
+ /* Doctrine DBAL variant of http://bshaffer.github.io/oauth2-server-php-docs/cookbook/#define-your-schema */
+ $table = $schema->createTable('oauth_clients');
+ $table->addColumn('client_id', 'string', array('length' => 80, 'notnull' => true));
+ $table->addColumn('client_secret', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('redirect_uri', 'string', array('length' => 2000, 'notnull' => true));
+ $table->addColumn('grant_types', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('scope', 'string', array('length' => 100, 'notnull' => false));
+ $table->addColumn('user_id', 'string', array('length' => 80, 'notnull' => false));
+ $table->setPrimaryKey(array('client_id'), 'clients_client_id_pk');
+
+ $table = $schema->createTable('oauth_access_tokens');
+ $table->addColumn('access_token', 'string', array('length' => 40, 'notnull' => true));
+ $table->addColumn('client_id', 'string', array('length' => 80, 'notnull' => true));
+ $table->addColumn('user_id', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('expires', 'datetime', array('notnull' => true));
+ $table->addColumn('scope', 'string', array('length' => 2000, 'notnull' => false));
+ $table->setPrimaryKey(array('access_token'), 'access_token_pk');
+
+ $table = $schema->createTable('oauth_authorization_codes');
+ $table->addColumn('authorization_code', 'string', array('length' => 40, 'notnull' => true));
+ $table->addColumn('client_id', 'string', array('length' => 80, 'notnull' => true));
+ $table->addColumn('user_id', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('redirect_uri', 'string', array('length' => 2000, 'notnull' => false));
+ $table->addColumn('expires', 'datetime', array('notnull' => true));
+ $table->addColumn('scope', 'string', array('length' => 2000, 'notnull' => false));
+ $table->setPrimaryKey(array('authorization_code'), 'auth_code_pk');
+
+ $table = $schema->createTable('oauth_refresh_tokens');
+ $table->addColumn('refresh_token', 'string', array('length' => 40, 'notnull' => true));
+ $table->addColumn('client_id', 'string', array('length' => 80, 'notnull' => true));
+ $table->addColumn('user_id', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('expires', 'datetime', array('notnull' => true));
+ $table->addColumn('scope', 'string', array('length' => 2000, 'notnull' => false));
+ $table->setPrimaryKey(array('refresh_token'), 'refresh_token_pk');
+
+ $table = $schema->createTable('oauth_users');
+ $table->addColumn('username', 'string', array('length' => 255, 'notnull' => true));
+ $table->addColumn('password', 'string', array('length' => 2000, 'notnull' => false));
+ $table->addColumn('first_name', 'string', array('length' => 255, 'notnull' => false));
+ $table->addColumn('last_name', 'string', array('length' => 255, 'notnull' => false));
+ $table->setPrimaryKey(array('username'), 'username_pk');
+
+ $table = $schema->createTable('oauth_scopes');
+ $table->addColumn('scope', 'text', array('notnull' => false));
+ $table->addColumn('is_default', 'boolean', array('notnull' => false));
+
+ $table = $schema->createTable('oauth_jwt');
+ $table->addColumn('client_id', 'string', array('length' => 80, 'notnull' => true));
+ $table->addColumn('subject', 'string', array('length' => 80, 'notnull' => false));
+ $table->addColumn('public_key', 'string', array('length' => 2000, 'notnull' => false));
+ $table->setPrimaryKey(array('client_id'), 'client_id_pk');
+
+ return $schema;
+ }