Inspection of "Fixed indexes" - aimeos/ai-symfony - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( c2a44b...eca3c4 )

by Aimeos

created 2016-05-30 15:04 UTC

Status

Spacing +143 added lines, -143 removed lines patch added patch discarded remove patch

@@ -8,164 +8,164 @@
 block discarded – undo
 
 return array(
 	'table' => array(
-		'fos_user' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
-
-			$table = $schema->createTable( 'fos_user' );
-
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'username', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'username_canonical', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'email', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'email_canonical', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'enabled', 'smallint', array() );
-			$table->addColumn( 'salt', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'password', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'last_login', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'locked', 'smallint', array() );
-			$table->addColumn( 'expired', 'smallint', array() );
-			$table->addColumn( 'expires_at', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'confirmation_token', 'string', array( 'length' => 255, 'notnull' => false ) );
-			$table->addColumn( 'password_requested_at', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'roles', 'text', array( 'length' => 0x7fffffff, 'comment' => '(DC2Type:array)' ) );
-			$table->addColumn( 'credentials_expired', 'smallint', array() );
-			$table->addColumn( 'credentials_expire_at', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
-			$table->addColumn( 'company', 'string', array( 'length' => 100 ) );
-			$table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'title', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'address1', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'address2', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'address3', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
-			$table->addColumn( 'city', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'state', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
-			$table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
-			$table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'telefax', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'website', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'birthday', 'date', array( 'notnull' => false ) );
-			$table->addColumn( 'vdate', 'date', array( 'notnull' => false ) );
-			$table->addColumn( 'mtime', 'datetime', array() );
-			$table->addColumn( 'ctime', 'datetime', array() );
-			$table->addColumn( 'editor', 'string', array('length' => 255 ) );
-
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosus_id' );
-			$table->addUniqueIndex( array( 'username_canonical' ), 'unq_fosus_username' );
-			$table->addUniqueIndex( array( 'email_canonical' ), 'unq_fosus_email' );
-			$table->addIndex( array( 'langid' ), 'idx_fosus_langid' );
-			$table->addIndex( array( 'enabled', 'lastname', 'firstname' ), 'idx_fosus_enabled_ln_fn' );
-			$table->addIndex( array( 'enabled', 'address1', 'address2' ), 'idx_fosus_enabled_ad1_ad2' );
-			$table->addIndex( array( 'enabled', 'postal', 'city' ), 'idx_fosus_enabled_postal_city' );
-			$table->addIndex( array( 'lastname' ), 'idx_fosus_lastname' );
-			$table->addIndex( array( 'address1' ), 'idx_fosus_address1' );
-			$table->addIndex( array( 'postal' ), 'idx_fosus_postal' );
-			$table->addIndex( array( 'city' ), 'idx_fosus_city' );
+		'fos_user' => function(\Doctrine\DBAL\Schema\Schema $schema) {
+
+			$table = $schema->createTable('fos_user');
+
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('username', 'string', array('length' => 255));
+			$table->addColumn('username_canonical', 'string', array('length' => 255));
+			$table->addColumn('email', 'string', array('length' => 255));
+			$table->addColumn('email_canonical', 'string', array('length' => 255));
+			$table->addColumn('enabled', 'smallint', array());
+			$table->addColumn('salt', 'string', array('length' => 255));
+			$table->addColumn('password', 'string', array('length' => 255));
+			$table->addColumn('last_login', 'datetime', array('notnull' => false));
+			$table->addColumn('locked', 'smallint', array());
+			$table->addColumn('expired', 'smallint', array());
+			$table->addColumn('expires_at', 'datetime', array('notnull' => false));
+			$table->addColumn('confirmation_token', 'string', array('length' => 255, 'notnull' => false));
+			$table->addColumn('password_requested_at', 'datetime', array('notnull' => false));
+			$table->addColumn('roles', 'text', array('length' => 0x7fffffff, 'comment' => '(DC2Type:array)'));
+			$table->addColumn('credentials_expired', 'smallint', array());
+			$table->addColumn('credentials_expire_at', 'datetime', array('notnull' => false));
+			$table->addColumn('salutation', 'string', array('length' => 8));
+			$table->addColumn('company', 'string', array('length' => 100));
+			$table->addColumn('vatid', 'string', array('length' => 32));
+			$table->addColumn('title', 'string', array('length' => 64));
+			$table->addColumn('firstname', 'string', array('length' => 64));
+			$table->addColumn('lastname', 'string', array('length' => 64));
+			$table->addColumn('address1', 'string', array('length' => 255));
+			$table->addColumn('address2', 'string', array('length' => 255));
+			$table->addColumn('address3', 'string', array('length' => 255));
+			$table->addColumn('postal', 'string', array('length' => 16));
+			$table->addColumn('city', 'string', array('length' => 255));
+			$table->addColumn('state', 'string', array('length' => 255));
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
+			$table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
+			$table->addColumn('telephone', 'string', array('length' => 32));
+			$table->addColumn('telefax', 'string', array('length' => 32));
+			$table->addColumn('website', 'string', array('length' => 255));
+			$table->addColumn('birthday', 'date', array('notnull' => false));
+			$table->addColumn('vdate', 'date', array('notnull' => false));
+			$table->addColumn('mtime', 'datetime', array());
+			$table->addColumn('ctime', 'datetime', array());
+			$table->addColumn('editor', 'string', array('length' => 255));
+
+			$table->setPrimaryKey(array('id'), 'pk_fosus_id');
+			$table->addUniqueIndex(array('username_canonical'), 'unq_fosus_username');
+			$table->addUniqueIndex(array('email_canonical'), 'unq_fosus_email');
+			$table->addIndex(array('langid'), 'idx_fosus_langid');
+			$table->addIndex(array('enabled', 'lastname', 'firstname'), 'idx_fosus_enabled_ln_fn');
+			$table->addIndex(array('enabled', 'address1', 'address2'), 'idx_fosus_enabled_ad1_ad2');
+			$table->addIndex(array('enabled', 'postal', 'city'), 'idx_fosus_enabled_postal_city');
+			$table->addIndex(array('lastname'), 'idx_fosus_lastname');
+			$table->addIndex(array('address1'), 'idx_fosus_address1');
+			$table->addIndex(array('postal'), 'idx_fosus_postal');
+			$table->addIndex(array('city'), 'idx_fosus_city');
 
 			return $schema;
 		},
 
-		'fos_user_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
-
-			$table = $schema->createTable( 'fos_user_address' );
-
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', array() );
-			$table->addColumn( 'parentid', 'integer', array() );
-			$table->addColumn( 'company', 'string', array( 'length' => 100 ) );
-			$table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
-			$table->addColumn( 'title', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
-			$table->addColumn( 'address1', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'address2', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'address3', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
-			$table->addColumn( 'city', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'state', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
-			$table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
-			$table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'email', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'telefax', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'website', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'flag', 'integer', array() );
-			$table->addColumn( 'pos', 'smallint', array() );
-			$table->addColumn( 'mtime', 'datetime', array() );
-			$table->addColumn( 'ctime', 'datetime', array() );
-			$table->addColumn( 'editor', 'string', array('length' => 255 ) );
-
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosad_id' );
-			$table->addIndex( array( 'lastname', 'firstname' ), 'idx_fosad_ln_fn' );
-			$table->addIndex( array( 'address1', 'address2' ), 'idx_fosad_ad1_ad2' );
-			$table->addIndex( array( 'postal', 'city' ), 'idx_fosad_post_ci' );
-			$table->addIndex( array( 'parentid' ), 'idx_fosad_pid' );
-			$table->addIndex( array( 'city' ), 'idx_fosad_city' );
-
-			$table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosad_pid' );
+		'fos_user_address' => function(\Doctrine\DBAL\Schema\Schema $schema) {
+
+			$table = $schema->createTable('fos_user_address');
+
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', array());
+			$table->addColumn('parentid', 'integer', array());
+			$table->addColumn('company', 'string', array('length' => 100));
+			$table->addColumn('vatid', 'string', array('length' => 32));
+			$table->addColumn('salutation', 'string', array('length' => 8));
+			$table->addColumn('title', 'string', array('length' => 64));
+			$table->addColumn('firstname', 'string', array('length' => 64));
+			$table->addColumn('lastname', 'string', array('length' => 64));
+			$table->addColumn('address1', 'string', array('length' => 255));
+			$table->addColumn('address2', 'string', array('length' => 255));
+			$table->addColumn('address3', 'string', array('length' => 255));
+			$table->addColumn('postal', 'string', array('length' => 16));
+			$table->addColumn('city', 'string', array('length' => 255));
+			$table->addColumn('state', 'string', array('length' => 255));
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
+			$table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
+			$table->addColumn('telephone', 'string', array('length' => 32));
+			$table->addColumn('email', 'string', array('length' => 255));
+			$table->addColumn('telefax', 'string', array('length' => 255));
+			$table->addColumn('website', 'string', array('length' => 255));
+			$table->addColumn('flag', 'integer', array());
+			$table->addColumn('pos', 'smallint', array());
+			$table->addColumn('mtime', 'datetime', array());
+			$table->addColumn('ctime', 'datetime', array());
+			$table->addColumn('editor', 'string', array('length' => 255));
+
+			$table->setPrimaryKey(array('id'), 'pk_fosad_id');
+			$table->addIndex(array('lastname', 'firstname'), 'idx_fosad_ln_fn');
+			$table->addIndex(array('address1', 'address2'), 'idx_fosad_ad1_ad2');
+			$table->addIndex(array('postal', 'city'), 'idx_fosad_post_ci');
+			$table->addIndex(array('parentid'), 'idx_fosad_pid');
+			$table->addIndex(array('city'), 'idx_fosad_city');
+
+			$table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosad_pid');
 
 			return $schema;
 		},
 
-		'fos_user_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
+		'fos_user_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
 
-			$table = $schema->createTable( 'fos_user_list_type' );
+			$table = $schema->createTable('fos_user_list_type');
 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', array() );
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'code', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'label', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'status', 'smallint', array() );
-			$table->addColumn( 'mtime', 'datetime', array() );
-			$table->addColumn( 'ctime', 'datetime', array() );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', array());
+			$table->addColumn('domain', 'string', array('length' => 32));
+			$table->addColumn('code', 'string', array('length' => 32));
+			$table->addColumn('label', 'string', array('length' => 255));
+			$table->addColumn('status', 'smallint', array());
+			$table->addColumn('mtime', 'datetime', array());
+			$table->addColumn('ctime', 'datetime', array());
+			$table->addColumn('editor', 'string', array('length' => 255));
 
-			$table->setPrimaryKey( array( 'id' ), 'pk_foslity_id' );
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_foslity_sid_dom_code' );
-			$table->addIndex( array( 'siteid', 'status' ), 'idx_foslity_sid_status' );
-			$table->addIndex( array( 'siteid', 'label' ), 'idx_foslity_sid_label' );
-			$table->addIndex( array( 'siteid', 'code' ), 'idx_foslity_sid_code' );
+			$table->setPrimaryKey(array('id'), 'pk_foslity_id');
+			$table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_foslity_sid_dom_code');
+			$table->addIndex(array('siteid', 'status'), 'idx_foslity_sid_status');
+			$table->addIndex(array('siteid', 'label'), 'idx_foslity_sid_label');
+			$table->addIndex(array('siteid', 'code'), 'idx_foslity_sid_code');
 
 			return $schema;
 		},
 
-		'fos_user_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
-
-			$table = $schema->createTable( 'fos_user_list' );
-
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'parentid', 'integer', array() );
-			$table->addColumn( 'siteid', 'integer', array() );
-			$table->addColumn( 'typeid', 'integer', array() );
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'refid', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'start', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'end', 'datetime', array( 'notnull' => false ) );
-			$table->addColumn( 'config', 'text', array( 'length' => 0xffff ) );
-			$table->addColumn( 'pos', 'integer', array() );
-			$table->addColumn( 'status', 'smallint', array() );
-			$table->addColumn( 'mtime', 'datetime', array() );
-			$table->addColumn( 'ctime', 'datetime', array() );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
-
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosli_id' );
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_fosli_sid_dm_rid_tid_pid' );
-			$table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_fosli_sid_stat_start_end' );
-			$table->addIndex( array( 'parentid', 'siteid', 'refid', 'domain', 'typeid' ), 'idx_fosli_pid_sid_rid_dom_tid' );
-			$table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_fosli_pid_sid_start' );
-			$table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_fosli_pid_sid_end' );
-			$table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_fosli_pid_sid_pos' );
-
-			$table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_pid' );
-
-			$table->addForeignKeyConstraint( 'fos_user_list_type', array( 'typeid' ), array( 'id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_typeid' );
+		'fos_user_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
+
+			$table = $schema->createTable('fos_user_list');
+
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('parentid', 'integer', array());
+			$table->addColumn('siteid', 'integer', array());
+			$table->addColumn('typeid', 'integer', array());
+			$table->addColumn('domain', 'string', array('length' => 32));
+			$table->addColumn('refid', 'string', array('length' => 32));
+			$table->addColumn('start', 'datetime', array('notnull' => false));
+			$table->addColumn('end', 'datetime', array('notnull' => false));
+			$table->addColumn('config', 'text', array('length' => 0xffff));
+			$table->addColumn('pos', 'integer', array());
+			$table->addColumn('status', 'smallint', array());
+			$table->addColumn('mtime', 'datetime', array());
+			$table->addColumn('ctime', 'datetime', array());
+			$table->addColumn('editor', 'string', array('length' => 255));
+
+			$table->setPrimaryKey(array('id'), 'pk_fosli_id');
+			$table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_fosli_sid_dm_rid_tid_pid');
+			$table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_fosli_sid_stat_start_end');
+			$table->addIndex(array('parentid', 'siteid', 'refid', 'domain', 'typeid'), 'idx_fosli_pid_sid_rid_dom_tid');
+			$table->addIndex(array('parentid', 'siteid', 'start'), 'idx_fosli_pid_sid_start');
+			$table->addIndex(array('parentid', 'siteid', 'end'), 'idx_fosli_pid_sid_end');
+			$table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_fosli_pid_sid_pos');
+
+			$table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_pid');
+
+			$table->addForeignKeyConstraint('fos_user_list_type', array('typeid'), array('id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_typeid');
 
 			return $schema;
 		},

Please login to merge, or discard this patch.

		@@ -8,164 +8,164 @@
		block discarded – undo
8	8
9	9	return array(
10	10	'table' => array(
11		- 'fos_user' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
12		-
13		- $table = $schema->createTable( 'fos_user' );
14		-
15		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
16		- $table->addColumn( 'username', 'string', array( 'length' => 255 ) );
17		- $table->addColumn( 'username_canonical', 'string', array( 'length' => 255 ) );
18		- $table->addColumn( 'email', 'string', array( 'length' => 255 ) );
19		- $table->addColumn( 'email_canonical', 'string', array( 'length' => 255 ) );
20		- $table->addColumn( 'enabled', 'smallint', array() );
21		- $table->addColumn( 'salt', 'string', array( 'length' => 255 ) );
22		- $table->addColumn( 'password', 'string', array( 'length' => 255 ) );
23		- $table->addColumn( 'last_login', 'datetime', array( 'notnull' => false ) );
24		- $table->addColumn( 'locked', 'smallint', array() );
25		- $table->addColumn( 'expired', 'smallint', array() );
26		- $table->addColumn( 'expires_at', 'datetime', array( 'notnull' => false ) );
27		- $table->addColumn( 'confirmation_token', 'string', array( 'length' => 255, 'notnull' => false ) );
28		- $table->addColumn( 'password_requested_at', 'datetime', array( 'notnull' => false ) );
29		- $table->addColumn( 'roles', 'text', array( 'length' => 0x7fffffff, 'comment' => '(DC2Type:array)' ) );
30		- $table->addColumn( 'credentials_expired', 'smallint', array() );
31		- $table->addColumn( 'credentials_expire_at', 'datetime', array( 'notnull' => false ) );
32		- $table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
33		- $table->addColumn( 'company', 'string', array( 'length' => 100 ) );
34		- $table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
35		- $table->addColumn( 'title', 'string', array( 'length' => 64 ) );
36		- $table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
37		- $table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
38		- $table->addColumn( 'address1', 'string', array( 'length' => 255 ) );
39		- $table->addColumn( 'address2', 'string', array( 'length' => 255 ) );
40		- $table->addColumn( 'address3', 'string', array( 'length' => 255 ) );
41		- $table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
42		- $table->addColumn( 'city', 'string', array( 'length' => 255 ) );
43		- $table->addColumn( 'state', 'string', array( 'length' => 255 ) );
44		- $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
45		- $table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
46		- $table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
47		- $table->addColumn( 'telefax', 'string', array( 'length' => 32 ) );
48		- $table->addColumn( 'website', 'string', array( 'length' => 255 ) );
49		- $table->addColumn( 'birthday', 'date', array( 'notnull' => false ) );
50		- $table->addColumn( 'vdate', 'date', array( 'notnull' => false ) );
51		- $table->addColumn( 'mtime', 'datetime', array() );
52		- $table->addColumn( 'ctime', 'datetime', array() );
53		- $table->addColumn( 'editor', 'string', array('length' => 255 ) );
54		-
55		- $table->setPrimaryKey( array( 'id' ), 'pk_fosus_id' );
56		- $table->addUniqueIndex( array( 'username_canonical' ), 'unq_fosus_username' );
57		- $table->addUniqueIndex( array( 'email_canonical' ), 'unq_fosus_email' );
58		- $table->addIndex( array( 'langid' ), 'idx_fosus_langid' );
59		- $table->addIndex( array( 'enabled', 'lastname', 'firstname' ), 'idx_fosus_enabled_ln_fn' );
60		- $table->addIndex( array( 'enabled', 'address1', 'address2' ), 'idx_fosus_enabled_ad1_ad2' );
61		- $table->addIndex( array( 'enabled', 'postal', 'city' ), 'idx_fosus_enabled_postal_city' );
62		- $table->addIndex( array( 'lastname' ), 'idx_fosus_lastname' );
63		- $table->addIndex( array( 'address1' ), 'idx_fosus_address1' );
64		- $table->addIndex( array( 'postal' ), 'idx_fosus_postal' );
65		- $table->addIndex( array( 'city' ), 'idx_fosus_city' );
	11	+ 'fos_user' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	12	+
	13	+ $table = $schema->createTable('fos_user');
	14	+
	15	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	16	+ $table->addColumn('username', 'string', array('length' => 255));
	17	+ $table->addColumn('username_canonical', 'string', array('length' => 255));
	18	+ $table->addColumn('email', 'string', array('length' => 255));
	19	+ $table->addColumn('email_canonical', 'string', array('length' => 255));
	20	+ $table->addColumn('enabled', 'smallint', array());
	21	+ $table->addColumn('salt', 'string', array('length' => 255));
	22	+ $table->addColumn('password', 'string', array('length' => 255));
	23	+ $table->addColumn('last_login', 'datetime', array('notnull' => false));
	24	+ $table->addColumn('locked', 'smallint', array());
	25	+ $table->addColumn('expired', 'smallint', array());
	26	+ $table->addColumn('expires_at', 'datetime', array('notnull' => false));
	27	+ $table->addColumn('confirmation_token', 'string', array('length' => 255, 'notnull' => false));
	28	+ $table->addColumn('password_requested_at', 'datetime', array('notnull' => false));
	29	+ $table->addColumn('roles', 'text', array('length' => 0x7fffffff, 'comment' => '(DC2Type:array)'));
	30	+ $table->addColumn('credentials_expired', 'smallint', array());
	31	+ $table->addColumn('credentials_expire_at', 'datetime', array('notnull' => false));
	32	+ $table->addColumn('salutation', 'string', array('length' => 8));
	33	+ $table->addColumn('company', 'string', array('length' => 100));
	34	+ $table->addColumn('vatid', 'string', array('length' => 32));
	35	+ $table->addColumn('title', 'string', array('length' => 64));
	36	+ $table->addColumn('firstname', 'string', array('length' => 64));
	37	+ $table->addColumn('lastname', 'string', array('length' => 64));
	38	+ $table->addColumn('address1', 'string', array('length' => 255));
	39	+ $table->addColumn('address2', 'string', array('length' => 255));
	40	+ $table->addColumn('address3', 'string', array('length' => 255));
	41	+ $table->addColumn('postal', 'string', array('length' => 16));
	42	+ $table->addColumn('city', 'string', array('length' => 255));
	43	+ $table->addColumn('state', 'string', array('length' => 255));
	44	+ $table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
	45	+ $table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
	46	+ $table->addColumn('telephone', 'string', array('length' => 32));
	47	+ $table->addColumn('telefax', 'string', array('length' => 32));
	48	+ $table->addColumn('website', 'string', array('length' => 255));
	49	+ $table->addColumn('birthday', 'date', array('notnull' => false));
	50	+ $table->addColumn('vdate', 'date', array('notnull' => false));
	51	+ $table->addColumn('mtime', 'datetime', array());
	52	+ $table->addColumn('ctime', 'datetime', array());
	53	+ $table->addColumn('editor', 'string', array('length' => 255));
	54	+
	55	+ $table->setPrimaryKey(array('id'), 'pk_fosus_id');
	56	+ $table->addUniqueIndex(array('username_canonical'), 'unq_fosus_username');
	57	+ $table->addUniqueIndex(array('email_canonical'), 'unq_fosus_email');
	58	+ $table->addIndex(array('langid'), 'idx_fosus_langid');
	59	+ $table->addIndex(array('enabled', 'lastname', 'firstname'), 'idx_fosus_enabled_ln_fn');
	60	+ $table->addIndex(array('enabled', 'address1', 'address2'), 'idx_fosus_enabled_ad1_ad2');
	61	+ $table->addIndex(array('enabled', 'postal', 'city'), 'idx_fosus_enabled_postal_city');
	62	+ $table->addIndex(array('lastname'), 'idx_fosus_lastname');
	63	+ $table->addIndex(array('address1'), 'idx_fosus_address1');
	64	+ $table->addIndex(array('postal'), 'idx_fosus_postal');
	65	+ $table->addIndex(array('city'), 'idx_fosus_city');
66	66
67	67	return $schema;
68	68	},
69	69
70		- 'fos_user_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
71		-
72		- $table = $schema->createTable( 'fos_user_address' );
73		-
74		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
75		- $table->addColumn( 'siteid', 'integer', array() );
76		- $table->addColumn( 'parentid', 'integer', array() );
77		- $table->addColumn( 'company', 'string', array( 'length' => 100 ) );
78		- $table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
79		- $table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
80		- $table->addColumn( 'title', 'string', array( 'length' => 64 ) );
81		- $table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
82		- $table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
83		- $table->addColumn( 'address1', 'string', array( 'length' => 255 ) );
84		- $table->addColumn( 'address2', 'string', array( 'length' => 255 ) );
85		- $table->addColumn( 'address3', 'string', array( 'length' => 255 ) );
86		- $table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
87		- $table->addColumn( 'city', 'string', array( 'length' => 255 ) );
88		- $table->addColumn( 'state', 'string', array( 'length' => 255 ) );
89		- $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
90		- $table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
91		- $table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
92		- $table->addColumn( 'email', 'string', array( 'length' => 255 ) );
93		- $table->addColumn( 'telefax', 'string', array( 'length' => 255 ) );
94		- $table->addColumn( 'website', 'string', array( 'length' => 255 ) );
95		- $table->addColumn( 'flag', 'integer', array() );
96		- $table->addColumn( 'pos', 'smallint', array() );
97		- $table->addColumn( 'mtime', 'datetime', array() );
98		- $table->addColumn( 'ctime', 'datetime', array() );
99		- $table->addColumn( 'editor', 'string', array('length' => 255 ) );
100		-
101		- $table->setPrimaryKey( array( 'id' ), 'pk_fosad_id' );
102		- $table->addIndex( array( 'lastname', 'firstname' ), 'idx_fosad_ln_fn' );
103		- $table->addIndex( array( 'address1', 'address2' ), 'idx_fosad_ad1_ad2' );
104		- $table->addIndex( array( 'postal', 'city' ), 'idx_fosad_post_ci' );
105		- $table->addIndex( array( 'parentid' ), 'idx_fosad_pid' );
106		- $table->addIndex( array( 'city' ), 'idx_fosad_city' );
107		-
108		- $table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
109		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosad_pid' );
	70	+ 'fos_user_address' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	71	+
	72	+ $table = $schema->createTable('fos_user_address');
	73	+
	74	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	75	+ $table->addColumn('siteid', 'integer', array());
	76	+ $table->addColumn('parentid', 'integer', array());
	77	+ $table->addColumn('company', 'string', array('length' => 100));
	78	+ $table->addColumn('vatid', 'string', array('length' => 32));
	79	+ $table->addColumn('salutation', 'string', array('length' => 8));
	80	+ $table->addColumn('title', 'string', array('length' => 64));
	81	+ $table->addColumn('firstname', 'string', array('length' => 64));
	82	+ $table->addColumn('lastname', 'string', array('length' => 64));
	83	+ $table->addColumn('address1', 'string', array('length' => 255));
	84	+ $table->addColumn('address2', 'string', array('length' => 255));
	85	+ $table->addColumn('address3', 'string', array('length' => 255));
	86	+ $table->addColumn('postal', 'string', array('length' => 16));
	87	+ $table->addColumn('city', 'string', array('length' => 255));
	88	+ $table->addColumn('state', 'string', array('length' => 255));
	89	+ $table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
	90	+ $table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
	91	+ $table->addColumn('telephone', 'string', array('length' => 32));
	92	+ $table->addColumn('email', 'string', array('length' => 255));
	93	+ $table->addColumn('telefax', 'string', array('length' => 255));
	94	+ $table->addColumn('website', 'string', array('length' => 255));
	95	+ $table->addColumn('flag', 'integer', array());
	96	+ $table->addColumn('pos', 'smallint', array());
	97	+ $table->addColumn('mtime', 'datetime', array());
	98	+ $table->addColumn('ctime', 'datetime', array());
	99	+ $table->addColumn('editor', 'string', array('length' => 255));
	100	+
	101	+ $table->setPrimaryKey(array('id'), 'pk_fosad_id');
	102	+ $table->addIndex(array('lastname', 'firstname'), 'idx_fosad_ln_fn');
	103	+ $table->addIndex(array('address1', 'address2'), 'idx_fosad_ad1_ad2');
	104	+ $table->addIndex(array('postal', 'city'), 'idx_fosad_post_ci');
	105	+ $table->addIndex(array('parentid'), 'idx_fosad_pid');
	106	+ $table->addIndex(array('city'), 'idx_fosad_city');
	107	+
	108	+ $table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
	109	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosad_pid');
110	110
111	111	return $schema;
112	112	},
113	113
114		- 'fos_user_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	114	+ 'fos_user_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
115	115
116		- $table = $schema->createTable( 'fos_user_list_type' );
	116	+ $table = $schema->createTable('fos_user_list_type');
117	117
118		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
119		- $table->addColumn( 'siteid', 'integer', array() );
120		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
121		- $table->addColumn( 'code', 'string', array( 'length' => 32 ) );
122		- $table->addColumn( 'label', 'string', array( 'length' => 255 ) );
123		- $table->addColumn( 'status', 'smallint', array() );
124		- $table->addColumn( 'mtime', 'datetime', array() );
125		- $table->addColumn( 'ctime', 'datetime', array() );
126		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	118	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	119	+ $table->addColumn('siteid', 'integer', array());
	120	+ $table->addColumn('domain', 'string', array('length' => 32));
	121	+ $table->addColumn('code', 'string', array('length' => 32));
	122	+ $table->addColumn('label', 'string', array('length' => 255));
	123	+ $table->addColumn('status', 'smallint', array());
	124	+ $table->addColumn('mtime', 'datetime', array());
	125	+ $table->addColumn('ctime', 'datetime', array());
	126	+ $table->addColumn('editor', 'string', array('length' => 255));
127	127
128		- $table->setPrimaryKey( array( 'id' ), 'pk_foslity_id' );
129		- $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_foslity_sid_dom_code' );
130		- $table->addIndex( array( 'siteid', 'status' ), 'idx_foslity_sid_status' );
131		- $table->addIndex( array( 'siteid', 'label' ), 'idx_foslity_sid_label' );
132		- $table->addIndex( array( 'siteid', 'code' ), 'idx_foslity_sid_code' );
	128	+ $table->setPrimaryKey(array('id'), 'pk_foslity_id');
	129	+ $table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_foslity_sid_dom_code');
	130	+ $table->addIndex(array('siteid', 'status'), 'idx_foslity_sid_status');
	131	+ $table->addIndex(array('siteid', 'label'), 'idx_foslity_sid_label');
	132	+ $table->addIndex(array('siteid', 'code'), 'idx_foslity_sid_code');
133	133
134	134	return $schema;
135	135	},
136	136
137		- 'fos_user_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
138		-
139		- $table = $schema->createTable( 'fos_user_list' );
140		-
141		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
142		- $table->addColumn( 'parentid', 'integer', array() );
143		- $table->addColumn( 'siteid', 'integer', array() );
144		- $table->addColumn( 'typeid', 'integer', array() );
145		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
146		- $table->addColumn( 'refid', 'string', array( 'length' => 32 ) );
147		- $table->addColumn( 'start', 'datetime', array( 'notnull' => false ) );
148		- $table->addColumn( 'end', 'datetime', array( 'notnull' => false ) );
149		- $table->addColumn( 'config', 'text', array( 'length' => 0xffff ) );
150		- $table->addColumn( 'pos', 'integer', array() );
151		- $table->addColumn( 'status', 'smallint', array() );
152		- $table->addColumn( 'mtime', 'datetime', array() );
153		- $table->addColumn( 'ctime', 'datetime', array() );
154		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
155		-
156		- $table->setPrimaryKey( array( 'id' ), 'pk_fosli_id' );
157		- $table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_fosli_sid_dm_rid_tid_pid' );
158		- $table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_fosli_sid_stat_start_end' );
159		- $table->addIndex( array( 'parentid', 'siteid', 'refid', 'domain', 'typeid' ), 'idx_fosli_pid_sid_rid_dom_tid' );
160		- $table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_fosli_pid_sid_start' );
161		- $table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_fosli_pid_sid_end' );
162		- $table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_fosli_pid_sid_pos' );
163		-
164		- $table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
165		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_pid' );
166		-
167		- $table->addForeignKeyConstraint( 'fos_user_list_type', array( 'typeid' ), array( 'id' ),
168		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_typeid' );
	137	+ 'fos_user_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	138	+
	139	+ $table = $schema->createTable('fos_user_list');
	140	+
	141	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	142	+ $table->addColumn('parentid', 'integer', array());
	143	+ $table->addColumn('siteid', 'integer', array());
	144	+ $table->addColumn('typeid', 'integer', array());
	145	+ $table->addColumn('domain', 'string', array('length' => 32));
	146	+ $table->addColumn('refid', 'string', array('length' => 32));
	147	+ $table->addColumn('start', 'datetime', array('notnull' => false));
	148	+ $table->addColumn('end', 'datetime', array('notnull' => false));
	149	+ $table->addColumn('config', 'text', array('length' => 0xffff));
	150	+ $table->addColumn('pos', 'integer', array());
	151	+ $table->addColumn('status', 'smallint', array());
	152	+ $table->addColumn('mtime', 'datetime', array());
	153	+ $table->addColumn('ctime', 'datetime', array());
	154	+ $table->addColumn('editor', 'string', array('length' => 255));
	155	+
	156	+ $table->setPrimaryKey(array('id'), 'pk_fosli_id');
	157	+ $table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_fosli_sid_dm_rid_tid_pid');
	158	+ $table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_fosli_sid_stat_start_end');
	159	+ $table->addIndex(array('parentid', 'siteid', 'refid', 'domain', 'typeid'), 'idx_fosli_pid_sid_rid_dom_tid');
	160	+ $table->addIndex(array('parentid', 'siteid', 'start'), 'idx_fosli_pid_sid_start');
	161	+ $table->addIndex(array('parentid', 'siteid', 'end'), 'idx_fosli_pid_sid_end');
	162	+ $table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_fosli_pid_sid_pos');
	163	+
	164	+ $table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
	165	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_pid');
	166	+
	167	+ $table->addForeignKeyConstraint('fos_user_list_type', array('typeid'), array('id'),
	168	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_typeid');
169	169
170	170	return $schema;
171	171	},

aimeos / ai-symfony

Push — master ( c2a44b...eca3c4 )

Status

Category

Spacing +143 added lines, -143 removed lines patch added patch discarded remove patch