Inspection of "Revert "Use binary character set for columns refer..." - aimeos/ai-ezpublish - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 269c8b...1f6bd3 )

by Aimeos

created 2018-10-07 09:44 UTC

Status

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

@@ -8,177 +8,177 @@
 block discarded – undo
 
 return array(
 	'table' => array(
-		'ezuser' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
+		'ezuser' => function(\Doctrine\DBAL\Schema\Schema $schema) {
 
-			$table = $schema->createTable( 'ezuser' );
+			$table = $schema->createTable('ezuser');
 
-			$table->addColumn( 'contentobject_id', 'integer', [] );
-			$table->addColumn( 'email', 'string', array( 'length' => 150 ) );
-			$table->addColumn( 'login', 'string', array( 'length' => 150 ) );
-			$table->addColumn( 'login_normalized', 'string', array( 'length' => 150 ) );
-			$table->addColumn( 'password_hash', 'string', array( 'length' => 50 ) );
-			$table->addColumn( 'password_hash_type', 'integer', array( 'default' => 1 ) );
+			$table->addColumn('contentobject_id', 'integer', []);
+			$table->addColumn('email', 'string', array('length' => 150));
+			$table->addColumn('login', 'string', array('length' => 150));
+			$table->addColumn('login_normalized', 'string', array('length' => 150));
+			$table->addColumn('password_hash', 'string', array('length' => 50));
+			$table->addColumn('password_hash_type', 'integer', array('default' => 1));
 
-			$table->setPrimaryKey( array( 'contentobject_id' ) );
-			$table->addUniqueIndex( array( 'login_normalized' ), 'ezuser_login' );
+			$table->setPrimaryKey(array('contentobject_id'));
+			$table->addUniqueIndex(array('login_normalized'), 'ezuser_login');
 
 			return $schema;
 		},
 
-		'ezuser_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
-
-			$table = $schema->createTable( 'ezuser_address' );
-
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', [] );
-			$table->addColumn( 'parentid', 'integer', [] );
-			$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', [] );
-			$table->addColumn( 'pos', 'smallint', [] );
-			$table->addColumn( 'mtime', 'datetime', [] );
-			$table->addColumn( 'ctime', 'datetime', [] );
-			$table->addColumn( 'editor', 'string', array('length' => 255 ) );
-
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezpad_id' );
-			$table->addIndex( array( 'lastname', 'firstname' ), 'idx_ezpad_ln_fn' );
-			$table->addIndex( array( 'address1', 'address2' ), 'idx_ezpad_ad1_ad2' );
-			$table->addIndex( array( 'postal', 'city' ), 'idx_ezpad_post_ci' );
-			$table->addIndex( array( 'parentid' ), 'idx_ezpad_pid' );
-			$table->addIndex( array( 'city' ), 'idx_ezpad_city' );
-
-			$table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpad_pid' );
+		'ezuser_address' => function(\Doctrine\DBAL\Schema\Schema $schema) {
+
+			$table = $schema->createTable('ezuser_address');
+
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', []);
+			$table->addColumn('parentid', 'integer', []);
+			$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', []);
+			$table->addColumn('pos', 'smallint', []);
+			$table->addColumn('mtime', 'datetime', []);
+			$table->addColumn('ctime', 'datetime', []);
+			$table->addColumn('editor', 'string', array('length' => 255));
+
+			$table->setPrimaryKey(array('id'), 'pk_ezpad_id');
+			$table->addIndex(array('lastname', 'firstname'), 'idx_ezpad_ln_fn');
+			$table->addIndex(array('address1', 'address2'), 'idx_ezpad_ad1_ad2');
+			$table->addIndex(array('postal', 'city'), 'idx_ezpad_post_ci');
+			$table->addIndex(array('parentid'), 'idx_ezpad_pid');
+			$table->addIndex(array('city'), 'idx_ezpad_city');
+
+			$table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpad_pid');
 
 			return $schema;
 		},
 
-		'ezuser_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
+		'ezuser_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
 
-			$table = $schema->createTable( 'ezuser_list_type' );
+			$table = $schema->createTable('ezuser_list_type');
 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', [] );
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'code', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'label', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'pos', 'integer', ['default' => 0] );
-			$table->addColumn( 'status', 'smallint', [] );
-			$table->addColumn( 'mtime', 'datetime', [] );
-			$table->addColumn( 'ctime', 'datetime', [] );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', []);
+			$table->addColumn('domain', 'string', array('length' => 32));
+			$table->addColumn('code', 'string', array('length' => 32));
+			$table->addColumn('label', 'string', array('length' => 255));
+			$table->addColumn('pos', 'integer', ['default' => 0]);
+			$table->addColumn('status', 'smallint', []);
+			$table->addColumn('mtime', 'datetime', []);
+			$table->addColumn('ctime', 'datetime', []);
+			$table->addColumn('editor', 'string', array('length' => 255));
 
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezplity_id' );
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezplity_sid_dom_code' );
-			$table->addIndex( array( 'siteid', 'status' ), 'idx_ezplity_sid_status' );
-			$table->addIndex( array( 'siteid', 'label' ), 'idx_ezplity_sid_label' );
-			$table->addIndex( array( 'siteid', 'code' ), 'idx_ezplity_sid_code' );
+			$table->setPrimaryKey(array('id'), 'pk_ezplity_id');
+			$table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezplity_sid_dom_code');
+			$table->addIndex(array('siteid', 'status'), 'idx_ezplity_sid_status');
+			$table->addIndex(array('siteid', 'label'), 'idx_ezplity_sid_label');
+			$table->addIndex(array('siteid', 'code'), 'idx_ezplity_sid_code');
 
 			return $schema;
 		},
 
-		'ezuser_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
-
-			$table = $schema->createTable( 'ezuser_list' );
-
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'parentid', 'integer', [] );
-			$table->addColumn( 'siteid', 'integer', [] );
-			$table->addColumn( 'typeid', 'integer', [] );
-			$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', [] );
-			$table->addColumn( 'status', 'smallint', [] );
-			$table->addColumn( 'mtime', 'datetime', [] );
-			$table->addColumn( 'ctime', 'datetime', [] );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
-
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezpli_id' );
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_ezpli_sid_dm_rid_tid_pid' );
-			$table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_ezpli_sid_stat_start_end' );
-			$table->addIndex( array( 'parentid', 'siteid', 'refid', 'domain', 'typeid' ), 'idx_ezpli_pid_sid_rid_dom_tid' );
-			$table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_ezpli_pid_sid_start' );
-			$table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_ezpli_pid_sid_end' );
-			$table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_ezpli_pid_sid_pos' );
-
-			$table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_pid' );
-
-			$table->addForeignKeyConstraint( 'ezuser_list_type', array( 'typeid' ), array( 'id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_typeid' );
+		'ezuser_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
+
+			$table = $schema->createTable('ezuser_list');
+
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('parentid', 'integer', []);
+			$table->addColumn('siteid', 'integer', []);
+			$table->addColumn('typeid', 'integer', []);
+			$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', []);
+			$table->addColumn('status', 'smallint', []);
+			$table->addColumn('mtime', 'datetime', []);
+			$table->addColumn('ctime', 'datetime', []);
+			$table->addColumn('editor', 'string', array('length' => 255));
+
+			$table->setPrimaryKey(array('id'), 'pk_ezpli_id');
+			$table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_ezpli_sid_dm_rid_tid_pid');
+			$table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_ezpli_sid_stat_start_end');
+			$table->addIndex(array('parentid', 'siteid', 'refid', 'domain', 'typeid'), 'idx_ezpli_pid_sid_rid_dom_tid');
+			$table->addIndex(array('parentid', 'siteid', 'start'), 'idx_ezpli_pid_sid_start');
+			$table->addIndex(array('parentid', 'siteid', 'end'), 'idx_ezpli_pid_sid_end');
+			$table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_ezpli_pid_sid_pos');
+
+			$table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_pid');
+
+			$table->addForeignKeyConstraint('ezuser_list_type', array('typeid'), array('id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_typeid');
 
 			return $schema;
 		},
 
-		'ezuser_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
+		'ezuser_property_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
 
-			$table = $schema->createTable( 'ezuser_property_type' );
+			$table = $schema->createTable('ezuser_property_type');
 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', [] );
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'code', 'string', array( 'length' => 32 ) );
-			$table->addColumn( 'label', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'pos', 'integer', ['default' => 0] );
-			$table->addColumn( 'status', 'smallint', [] );
-			$table->addColumn( 'mtime', 'datetime', [] );
-			$table->addColumn( 'ctime', 'datetime', [] );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', []);
+			$table->addColumn('domain', 'string', array('length' => 32));
+			$table->addColumn('code', 'string', array('length' => 32));
+			$table->addColumn('label', 'string', array('length' => 255));
+			$table->addColumn('pos', 'integer', ['default' => 0]);
+			$table->addColumn('status', 'smallint', []);
+			$table->addColumn('mtime', 'datetime', []);
+			$table->addColumn('ctime', 'datetime', []);
+			$table->addColumn('editor', 'string', array('length' => 255));
 
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezpprty_id' );
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezpprty_sid_dom_code' );
-			$table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_ezpprty_sid_status_pos' );
-			$table->addIndex( array( 'siteid', 'label' ), 'idx_ezpprty_sid_label' );
-			$table->addIndex( array( 'siteid', 'code' ), 'idx_ezpprty_sid_code' );
+			$table->setPrimaryKey(array('id'), 'pk_ezpprty_id');
+			$table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezpprty_sid_dom_code');
+			$table->addIndex(array('siteid', 'status', 'pos'), 'idx_ezpprty_sid_status_pos');
+			$table->addIndex(array('siteid', 'label'), 'idx_ezpprty_sid_label');
+			$table->addIndex(array('siteid', 'code'), 'idx_ezpprty_sid_code');
 
 			return $schema;
 		},
 
-		'ezuser_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
+		'ezuser_property' => function(\Doctrine\DBAL\Schema\Schema $schema) {
 
-			$table = $schema->createTable( 'ezuser_property' );
+			$table = $schema->createTable('ezuser_property');
 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
-			$table->addColumn( 'siteid', 'integer', [] );
-			$table->addColumn( 'parentid', 'integer', [] );
-			$table->addColumn( 'typeid', 'integer', [] );
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
-			$table->addColumn( 'value', 'string', array( 'length' => 255 ) );
-			$table->addColumn( 'mtime', 'datetime', [] );
-			$table->addColumn( 'ctime', 'datetime', [] );
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
+			$table->addColumn('siteid', 'integer', []);
+			$table->addColumn('parentid', 'integer', []);
+			$table->addColumn('typeid', 'integer', []);
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
+			$table->addColumn('value', 'string', array('length' => 255));
+			$table->addColumn('mtime', 'datetime', []);
+			$table->addColumn('ctime', 'datetime', []);
+			$table->addColumn('editor', 'string', array('length' => 255));
 
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezppr_id' );
-			$table->addUniqueIndex( array( 'parentid', 'siteid', 'typeid', 'langid', 'value' ), 'unq_ezppr_sid_tid_lid_value' );
-			$table->addIndex( array( 'siteid', 'langid' ), 'idx_ezppr_sid_langid' );
-			$table->addIndex( array( 'siteid', 'value' ), 'idx_ezppr_sid_value' );
-			$table->addIndex( array( 'typeid' ), 'fk_ezppr_typeid' );
-			$table->addIndex( array( 'parentid' ), 'fk_ezppr_pid' );
+			$table->setPrimaryKey(array('id'), 'pk_ezppr_id');
+			$table->addUniqueIndex(array('parentid', 'siteid', 'typeid', 'langid', 'value'), 'unq_ezppr_sid_tid_lid_value');
+			$table->addIndex(array('siteid', 'langid'), 'idx_ezppr_sid_langid');
+			$table->addIndex(array('siteid', 'value'), 'idx_ezppr_sid_value');
+			$table->addIndex(array('typeid'), 'fk_ezppr_typeid');
+			$table->addIndex(array('parentid'), 'fk_ezppr_pid');
 
-			$table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_pid' );
+			$table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_pid');
 
-			$table->addForeignKeyConstraint( 'ezuser_property_type', array( 'typeid' ), array( 'id' ),
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_typeid' );
+			$table->addForeignKeyConstraint('ezuser_property_type', array('typeid'), array('id'),
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_typeid');
 
 			return $schema;
 		},

Please login to merge, or discard this patch.

		@@ -8,177 +8,177 @@
		block discarded – undo
8	8
9	9	return array(
10	10	'table' => array(
11		- 'ezuser' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	11	+ 'ezuser' => function(\Doctrine\DBAL\Schema\Schema $schema) {
12	12
13		- $table = $schema->createTable( 'ezuser' );
	13	+ $table = $schema->createTable('ezuser');
14	14
15		- $table->addColumn( 'contentobject_id', 'integer', [] );
16		- $table->addColumn( 'email', 'string', array( 'length' => 150 ) );
17		- $table->addColumn( 'login', 'string', array( 'length' => 150 ) );
18		- $table->addColumn( 'login_normalized', 'string', array( 'length' => 150 ) );
19		- $table->addColumn( 'password_hash', 'string', array( 'length' => 50 ) );
20		- $table->addColumn( 'password_hash_type', 'integer', array( 'default' => 1 ) );
	15	+ $table->addColumn('contentobject_id', 'integer', []);
	16	+ $table->addColumn('email', 'string', array('length' => 150));
	17	+ $table->addColumn('login', 'string', array('length' => 150));
	18	+ $table->addColumn('login_normalized', 'string', array('length' => 150));
	19	+ $table->addColumn('password_hash', 'string', array('length' => 50));
	20	+ $table->addColumn('password_hash_type', 'integer', array('default' => 1));
21	21
22		- $table->setPrimaryKey( array( 'contentobject_id' ) );
23		- $table->addUniqueIndex( array( 'login_normalized' ), 'ezuser_login' );
	22	+ $table->setPrimaryKey(array('contentobject_id'));
	23	+ $table->addUniqueIndex(array('login_normalized'), 'ezuser_login');
24	24
25	25	return $schema;
26	26	},
27	27
28		- 'ezuser_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
29		-
30		- $table = $schema->createTable( 'ezuser_address' );
31		-
32		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
33		- $table->addColumn( 'siteid', 'integer', [] );
34		- $table->addColumn( 'parentid', 'integer', [] );
35		- $table->addColumn( 'company', 'string', array( 'length' => 100 ) );
36		- $table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
37		- $table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
38		- $table->addColumn( 'title', 'string', array( 'length' => 64 ) );
39		- $table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
40		- $table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
41		- $table->addColumn( 'address1', 'string', array( 'length' => 255 ) );
42		- $table->addColumn( 'address2', 'string', array( 'length' => 255 ) );
43		- $table->addColumn( 'address3', 'string', array( 'length' => 255 ) );
44		- $table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
45		- $table->addColumn( 'city', 'string', array( 'length' => 255 ) );
46		- $table->addColumn( 'state', 'string', array( 'length' => 255 ) );
47		- $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
48		- $table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
49		- $table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
50		- $table->addColumn( 'email', 'string', array( 'length' => 255 ) );
51		- $table->addColumn( 'telefax', 'string', array( 'length' => 255 ) );
52		- $table->addColumn( 'website', 'string', array( 'length' => 255 ) );
53		- $table->addColumn( 'flag', 'integer', [] );
54		- $table->addColumn( 'pos', 'smallint', [] );
55		- $table->addColumn( 'mtime', 'datetime', [] );
56		- $table->addColumn( 'ctime', 'datetime', [] );
57		- $table->addColumn( 'editor', 'string', array('length' => 255 ) );
58		-
59		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpad_id' );
60		- $table->addIndex( array( 'lastname', 'firstname' ), 'idx_ezpad_ln_fn' );
61		- $table->addIndex( array( 'address1', 'address2' ), 'idx_ezpad_ad1_ad2' );
62		- $table->addIndex( array( 'postal', 'city' ), 'idx_ezpad_post_ci' );
63		- $table->addIndex( array( 'parentid' ), 'idx_ezpad_pid' );
64		- $table->addIndex( array( 'city' ), 'idx_ezpad_city' );
65		-
66		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
67		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpad_pid' );
	28	+ 'ezuser_address' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	29	+
	30	+ $table = $schema->createTable('ezuser_address');
	31	+
	32	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	33	+ $table->addColumn('siteid', 'integer', []);
	34	+ $table->addColumn('parentid', 'integer', []);
	35	+ $table->addColumn('company', 'string', array('length' => 100));
	36	+ $table->addColumn('vatid', 'string', array('length' => 32));
	37	+ $table->addColumn('salutation', 'string', array('length' => 8));
	38	+ $table->addColumn('title', 'string', array('length' => 64));
	39	+ $table->addColumn('firstname', 'string', array('length' => 64));
	40	+ $table->addColumn('lastname', 'string', array('length' => 64));
	41	+ $table->addColumn('address1', 'string', array('length' => 255));
	42	+ $table->addColumn('address2', 'string', array('length' => 255));
	43	+ $table->addColumn('address3', 'string', array('length' => 255));
	44	+ $table->addColumn('postal', 'string', array('length' => 16));
	45	+ $table->addColumn('city', 'string', array('length' => 255));
	46	+ $table->addColumn('state', 'string', array('length' => 255));
	47	+ $table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
	48	+ $table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
	49	+ $table->addColumn('telephone', 'string', array('length' => 32));
	50	+ $table->addColumn('email', 'string', array('length' => 255));
	51	+ $table->addColumn('telefax', 'string', array('length' => 255));
	52	+ $table->addColumn('website', 'string', array('length' => 255));
	53	+ $table->addColumn('flag', 'integer', []);
	54	+ $table->addColumn('pos', 'smallint', []);
	55	+ $table->addColumn('mtime', 'datetime', []);
	56	+ $table->addColumn('ctime', 'datetime', []);
	57	+ $table->addColumn('editor', 'string', array('length' => 255));
	58	+
	59	+ $table->setPrimaryKey(array('id'), 'pk_ezpad_id');
	60	+ $table->addIndex(array('lastname', 'firstname'), 'idx_ezpad_ln_fn');
	61	+ $table->addIndex(array('address1', 'address2'), 'idx_ezpad_ad1_ad2');
	62	+ $table->addIndex(array('postal', 'city'), 'idx_ezpad_post_ci');
	63	+ $table->addIndex(array('parentid'), 'idx_ezpad_pid');
	64	+ $table->addIndex(array('city'), 'idx_ezpad_city');
	65	+
	66	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	67	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpad_pid');
68	68
69	69	return $schema;
70	70	},
71	71
72		- 'ezuser_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	72	+ 'ezuser_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
73	73
74		- $table = $schema->createTable( 'ezuser_list_type' );
	74	+ $table = $schema->createTable('ezuser_list_type');
75	75
76		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
77		- $table->addColumn( 'siteid', 'integer', [] );
78		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
79		- $table->addColumn( 'code', 'string', array( 'length' => 32 ) );
80		- $table->addColumn( 'label', 'string', array( 'length' => 255 ) );
81		- $table->addColumn( 'pos', 'integer', ['default' => 0] );
82		- $table->addColumn( 'status', 'smallint', [] );
83		- $table->addColumn( 'mtime', 'datetime', [] );
84		- $table->addColumn( 'ctime', 'datetime', [] );
85		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	76	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	77	+ $table->addColumn('siteid', 'integer', []);
	78	+ $table->addColumn('domain', 'string', array('length' => 32));
	79	+ $table->addColumn('code', 'string', array('length' => 32));
	80	+ $table->addColumn('label', 'string', array('length' => 255));
	81	+ $table->addColumn('pos', 'integer', ['default' => 0]);
	82	+ $table->addColumn('status', 'smallint', []);
	83	+ $table->addColumn('mtime', 'datetime', []);
	84	+ $table->addColumn('ctime', 'datetime', []);
	85	+ $table->addColumn('editor', 'string', array('length' => 255));
86	86
87		- $table->setPrimaryKey( array( 'id' ), 'pk_ezplity_id' );
88		- $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezplity_sid_dom_code' );
89		- $table->addIndex( array( 'siteid', 'status' ), 'idx_ezplity_sid_status' );
90		- $table->addIndex( array( 'siteid', 'label' ), 'idx_ezplity_sid_label' );
91		- $table->addIndex( array( 'siteid', 'code' ), 'idx_ezplity_sid_code' );
	87	+ $table->setPrimaryKey(array('id'), 'pk_ezplity_id');
	88	+ $table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezplity_sid_dom_code');
	89	+ $table->addIndex(array('siteid', 'status'), 'idx_ezplity_sid_status');
	90	+ $table->addIndex(array('siteid', 'label'), 'idx_ezplity_sid_label');
	91	+ $table->addIndex(array('siteid', 'code'), 'idx_ezplity_sid_code');
92	92
93	93	return $schema;
94	94	},
95	95
96		- 'ezuser_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
97		-
98		- $table = $schema->createTable( 'ezuser_list' );
99		-
100		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
101		- $table->addColumn( 'parentid', 'integer', [] );
102		- $table->addColumn( 'siteid', 'integer', [] );
103		- $table->addColumn( 'typeid', 'integer', [] );
104		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
105		- $table->addColumn( 'refid', 'string', array( 'length' => 32 ) );
106		- $table->addColumn( 'start', 'datetime', array( 'notnull' => false ) );
107		- $table->addColumn( 'end', 'datetime', array( 'notnull' => false ) );
108		- $table->addColumn( 'config', 'text', array( 'length' => 0xffff ) );
109		- $table->addColumn( 'pos', 'integer', [] );
110		- $table->addColumn( 'status', 'smallint', [] );
111		- $table->addColumn( 'mtime', 'datetime', [] );
112		- $table->addColumn( 'ctime', 'datetime', [] );
113		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
114		-
115		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpli_id' );
116		- $table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_ezpli_sid_dm_rid_tid_pid' );
117		- $table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_ezpli_sid_stat_start_end' );
118		- $table->addIndex( array( 'parentid', 'siteid', 'refid', 'domain', 'typeid' ), 'idx_ezpli_pid_sid_rid_dom_tid' );
119		- $table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_ezpli_pid_sid_start' );
120		- $table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_ezpli_pid_sid_end' );
121		- $table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_ezpli_pid_sid_pos' );
122		-
123		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
124		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_pid' );
125		-
126		- $table->addForeignKeyConstraint( 'ezuser_list_type', array( 'typeid' ), array( 'id' ),
127		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_typeid' );
	96	+ 'ezuser_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	97	+
	98	+ $table = $schema->createTable('ezuser_list');
	99	+
	100	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	101	+ $table->addColumn('parentid', 'integer', []);
	102	+ $table->addColumn('siteid', 'integer', []);
	103	+ $table->addColumn('typeid', 'integer', []);
	104	+ $table->addColumn('domain', 'string', array('length' => 32));
	105	+ $table->addColumn('refid', 'string', array('length' => 32));
	106	+ $table->addColumn('start', 'datetime', array('notnull' => false));
	107	+ $table->addColumn('end', 'datetime', array('notnull' => false));
	108	+ $table->addColumn('config', 'text', array('length' => 0xffff));
	109	+ $table->addColumn('pos', 'integer', []);
	110	+ $table->addColumn('status', 'smallint', []);
	111	+ $table->addColumn('mtime', 'datetime', []);
	112	+ $table->addColumn('ctime', 'datetime', []);
	113	+ $table->addColumn('editor', 'string', array('length' => 255));
	114	+
	115	+ $table->setPrimaryKey(array('id'), 'pk_ezpli_id');
	116	+ $table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_ezpli_sid_dm_rid_tid_pid');
	117	+ $table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_ezpli_sid_stat_start_end');
	118	+ $table->addIndex(array('parentid', 'siteid', 'refid', 'domain', 'typeid'), 'idx_ezpli_pid_sid_rid_dom_tid');
	119	+ $table->addIndex(array('parentid', 'siteid', 'start'), 'idx_ezpli_pid_sid_start');
	120	+ $table->addIndex(array('parentid', 'siteid', 'end'), 'idx_ezpli_pid_sid_end');
	121	+ $table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_ezpli_pid_sid_pos');
	122	+
	123	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	124	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_pid');
	125	+
	126	+ $table->addForeignKeyConstraint('ezuser_list_type', array('typeid'), array('id'),
	127	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_typeid');
128	128
129	129	return $schema;
130	130	},
131	131
132		- 'ezuser_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	132	+ 'ezuser_property_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
133	133
134		- $table = $schema->createTable( 'ezuser_property_type' );
	134	+ $table = $schema->createTable('ezuser_property_type');
135	135
136		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
137		- $table->addColumn( 'siteid', 'integer', [] );
138		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
139		- $table->addColumn( 'code', 'string', array( 'length' => 32 ) );
140		- $table->addColumn( 'label', 'string', array( 'length' => 255 ) );
141		- $table->addColumn( 'pos', 'integer', ['default' => 0] );
142		- $table->addColumn( 'status', 'smallint', [] );
143		- $table->addColumn( 'mtime', 'datetime', [] );
144		- $table->addColumn( 'ctime', 'datetime', [] );
145		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	136	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	137	+ $table->addColumn('siteid', 'integer', []);
	138	+ $table->addColumn('domain', 'string', array('length' => 32));
	139	+ $table->addColumn('code', 'string', array('length' => 32));
	140	+ $table->addColumn('label', 'string', array('length' => 255));
	141	+ $table->addColumn('pos', 'integer', ['default' => 0]);
	142	+ $table->addColumn('status', 'smallint', []);
	143	+ $table->addColumn('mtime', 'datetime', []);
	144	+ $table->addColumn('ctime', 'datetime', []);
	145	+ $table->addColumn('editor', 'string', array('length' => 255));
146	146
147		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpprty_id' );
148		- $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezpprty_sid_dom_code' );
149		- $table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_ezpprty_sid_status_pos' );
150		- $table->addIndex( array( 'siteid', 'label' ), 'idx_ezpprty_sid_label' );
151		- $table->addIndex( array( 'siteid', 'code' ), 'idx_ezpprty_sid_code' );
	147	+ $table->setPrimaryKey(array('id'), 'pk_ezpprty_id');
	148	+ $table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezpprty_sid_dom_code');
	149	+ $table->addIndex(array('siteid', 'status', 'pos'), 'idx_ezpprty_sid_status_pos');
	150	+ $table->addIndex(array('siteid', 'label'), 'idx_ezpprty_sid_label');
	151	+ $table->addIndex(array('siteid', 'code'), 'idx_ezpprty_sid_code');
152	152
153	153	return $schema;
154	154	},
155	155
156		- 'ezuser_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	156	+ 'ezuser_property' => function(\Doctrine\DBAL\Schema\Schema $schema) {
157	157
158		- $table = $schema->createTable( 'ezuser_property' );
	158	+ $table = $schema->createTable('ezuser_property');
159	159
160		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
161		- $table->addColumn( 'siteid', 'integer', [] );
162		- $table->addColumn( 'parentid', 'integer', [] );
163		- $table->addColumn( 'typeid', 'integer', [] );
164		- $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
165		- $table->addColumn( 'value', 'string', array( 'length' => 255 ) );
166		- $table->addColumn( 'mtime', 'datetime', [] );
167		- $table->addColumn( 'ctime', 'datetime', [] );
168		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	160	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	161	+ $table->addColumn('siteid', 'integer', []);
	162	+ $table->addColumn('parentid', 'integer', []);
	163	+ $table->addColumn('typeid', 'integer', []);
	164	+ $table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
	165	+ $table->addColumn('value', 'string', array('length' => 255));
	166	+ $table->addColumn('mtime', 'datetime', []);
	167	+ $table->addColumn('ctime', 'datetime', []);
	168	+ $table->addColumn('editor', 'string', array('length' => 255));
169	169
170		- $table->setPrimaryKey( array( 'id' ), 'pk_ezppr_id' );
171		- $table->addUniqueIndex( array( 'parentid', 'siteid', 'typeid', 'langid', 'value' ), 'unq_ezppr_sid_tid_lid_value' );
172		- $table->addIndex( array( 'siteid', 'langid' ), 'idx_ezppr_sid_langid' );
173		- $table->addIndex( array( 'siteid', 'value' ), 'idx_ezppr_sid_value' );
174		- $table->addIndex( array( 'typeid' ), 'fk_ezppr_typeid' );
175		- $table->addIndex( array( 'parentid' ), 'fk_ezppr_pid' );
	170	+ $table->setPrimaryKey(array('id'), 'pk_ezppr_id');
	171	+ $table->addUniqueIndex(array('parentid', 'siteid', 'typeid', 'langid', 'value'), 'unq_ezppr_sid_tid_lid_value');
	172	+ $table->addIndex(array('siteid', 'langid'), 'idx_ezppr_sid_langid');
	173	+ $table->addIndex(array('siteid', 'value'), 'idx_ezppr_sid_value');
	174	+ $table->addIndex(array('typeid'), 'fk_ezppr_typeid');
	175	+ $table->addIndex(array('parentid'), 'fk_ezppr_pid');
176	176
177		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
178		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_pid' );
	177	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	178	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_pid');
179	179
180		- $table->addForeignKeyConstraint( 'ezuser_property_type', array( 'typeid' ), array( 'id' ),
181		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_typeid' );
	180	+ $table->addForeignKeyConstraint('ezuser_property_type', array('typeid'), array('id'),
	181	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_typeid');
182	182
183	183	return $schema;
184	184	},

aimeos / ai-ezpublish

Push — master ( 269c8b...1f6bd3 )

Status

Category

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