Inspection of "Simplified customer payment address handling" - aimeos/ai-ezpublish - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 89095d...9bae21 )

by Aimeos

created 2018-11-25 23:21 UTC

Status

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

@@ -8,176 +8,176 @@
 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( '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('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', 'domain', 'refid', 'typeid' ), 'idx_ezpli_pid_sid_dom_rid_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', 'domain', 'refid', 'typeid'), 'idx_ezpli_pid_sid_dom_rid_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,176 +8,176 @@
		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( 'pos', 'smallint', [] );
54		- $table->addColumn( 'mtime', 'datetime', [] );
55		- $table->addColumn( 'ctime', 'datetime', [] );
56		- $table->addColumn( 'editor', 'string', array('length' => 255 ) );
57		-
58		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpad_id' );
59		- $table->addIndex( array( 'lastname', 'firstname' ), 'idx_ezpad_ln_fn' );
60		- $table->addIndex( array( 'address1', 'address2' ), 'idx_ezpad_ad1_ad2' );
61		- $table->addIndex( array( 'postal', 'city' ), 'idx_ezpad_post_ci' );
62		- $table->addIndex( array( 'parentid' ), 'idx_ezpad_pid' );
63		- $table->addIndex( array( 'city' ), 'idx_ezpad_city' );
64		-
65		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
66		- 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('pos', 'smallint', []);
	54	+ $table->addColumn('mtime', 'datetime', []);
	55	+ $table->addColumn('ctime', 'datetime', []);
	56	+ $table->addColumn('editor', 'string', array('length' => 255));
	57	+
	58	+ $table->setPrimaryKey(array('id'), 'pk_ezpad_id');
	59	+ $table->addIndex(array('lastname', 'firstname'), 'idx_ezpad_ln_fn');
	60	+ $table->addIndex(array('address1', 'address2'), 'idx_ezpad_ad1_ad2');
	61	+ $table->addIndex(array('postal', 'city'), 'idx_ezpad_post_ci');
	62	+ $table->addIndex(array('parentid'), 'idx_ezpad_pid');
	63	+ $table->addIndex(array('city'), 'idx_ezpad_city');
	64	+
	65	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	66	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpad_pid');
67	67
68	68	return $schema;
69	69	},
70	70
71		- 'ezuser_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	71	+ 'ezuser_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
72	72
73		- $table = $schema->createTable( 'ezuser_list_type' );
	73	+ $table = $schema->createTable('ezuser_list_type');
74	74
75		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
76		- $table->addColumn( 'siteid', 'integer', [] );
77		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
78		- $table->addColumn( 'code', 'string', array( 'length' => 32 ) );
79		- $table->addColumn( 'label', 'string', array( 'length' => 255 ) );
80		- $table->addColumn( 'pos', 'integer', ['default' => 0] );
81		- $table->addColumn( 'status', 'smallint', [] );
82		- $table->addColumn( 'mtime', 'datetime', [] );
83		- $table->addColumn( 'ctime', 'datetime', [] );
84		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	75	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	76	+ $table->addColumn('siteid', 'integer', []);
	77	+ $table->addColumn('domain', 'string', array('length' => 32));
	78	+ $table->addColumn('code', 'string', array('length' => 32));
	79	+ $table->addColumn('label', 'string', array('length' => 255));
	80	+ $table->addColumn('pos', 'integer', ['default' => 0]);
	81	+ $table->addColumn('status', 'smallint', []);
	82	+ $table->addColumn('mtime', 'datetime', []);
	83	+ $table->addColumn('ctime', 'datetime', []);
	84	+ $table->addColumn('editor', 'string', array('length' => 255));
85	85
86		- $table->setPrimaryKey( array( 'id' ), 'pk_ezplity_id' );
87		- $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezplity_sid_dom_code' );
88		- $table->addIndex( array( 'siteid', 'status' ), 'idx_ezplity_sid_status' );
89		- $table->addIndex( array( 'siteid', 'label' ), 'idx_ezplity_sid_label' );
90		- $table->addIndex( array( 'siteid', 'code' ), 'idx_ezplity_sid_code' );
	86	+ $table->setPrimaryKey(array('id'), 'pk_ezplity_id');
	87	+ $table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezplity_sid_dom_code');
	88	+ $table->addIndex(array('siteid', 'status'), 'idx_ezplity_sid_status');
	89	+ $table->addIndex(array('siteid', 'label'), 'idx_ezplity_sid_label');
	90	+ $table->addIndex(array('siteid', 'code'), 'idx_ezplity_sid_code');
91	91
92	92	return $schema;
93	93	},
94	94
95		- 'ezuser_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
96		-
97		- $table = $schema->createTable( 'ezuser_list' );
98		-
99		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
100		- $table->addColumn( 'parentid', 'integer', [] );
101		- $table->addColumn( 'siteid', 'integer', [] );
102		- $table->addColumn( 'typeid', 'integer', [] );
103		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
104		- $table->addColumn( 'refid', 'string', array( 'length' => 32 ) );
105		- $table->addColumn( 'start', 'datetime', array( 'notnull' => false ) );
106		- $table->addColumn( 'end', 'datetime', array( 'notnull' => false ) );
107		- $table->addColumn( 'config', 'text', array( 'length' => 0xffff ) );
108		- $table->addColumn( 'pos', 'integer', [] );
109		- $table->addColumn( 'status', 'smallint', [] );
110		- $table->addColumn( 'mtime', 'datetime', [] );
111		- $table->addColumn( 'ctime', 'datetime', [] );
112		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
113		-
114		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpli_id' );
115		- $table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_ezpli_sid_dm_rid_tid_pid' );
116		- $table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_ezpli_sid_stat_start_end' );
117		- $table->addIndex( array( 'parentid', 'siteid', 'domain', 'refid', 'typeid' ), 'idx_ezpli_pid_sid_dom_rid_tid' );
118		- $table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_ezpli_pid_sid_start' );
119		- $table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_ezpli_pid_sid_end' );
120		- $table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_ezpli_pid_sid_pos' );
121		-
122		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
123		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_pid' );
124		-
125		- $table->addForeignKeyConstraint( 'ezuser_list_type', array( 'typeid' ), array( 'id' ),
126		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_typeid' );
	95	+ 'ezuser_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
	96	+
	97	+ $table = $schema->createTable('ezuser_list');
	98	+
	99	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	100	+ $table->addColumn('parentid', 'integer', []);
	101	+ $table->addColumn('siteid', 'integer', []);
	102	+ $table->addColumn('typeid', 'integer', []);
	103	+ $table->addColumn('domain', 'string', array('length' => 32));
	104	+ $table->addColumn('refid', 'string', array('length' => 32));
	105	+ $table->addColumn('start', 'datetime', array('notnull' => false));
	106	+ $table->addColumn('end', 'datetime', array('notnull' => false));
	107	+ $table->addColumn('config', 'text', array('length' => 0xffff));
	108	+ $table->addColumn('pos', 'integer', []);
	109	+ $table->addColumn('status', 'smallint', []);
	110	+ $table->addColumn('mtime', 'datetime', []);
	111	+ $table->addColumn('ctime', 'datetime', []);
	112	+ $table->addColumn('editor', 'string', array('length' => 255));
	113	+
	114	+ $table->setPrimaryKey(array('id'), 'pk_ezpli_id');
	115	+ $table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_ezpli_sid_dm_rid_tid_pid');
	116	+ $table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_ezpli_sid_stat_start_end');
	117	+ $table->addIndex(array('parentid', 'siteid', 'domain', 'refid', 'typeid'), 'idx_ezpli_pid_sid_dom_rid_tid');
	118	+ $table->addIndex(array('parentid', 'siteid', 'start'), 'idx_ezpli_pid_sid_start');
	119	+ $table->addIndex(array('parentid', 'siteid', 'end'), 'idx_ezpli_pid_sid_end');
	120	+ $table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_ezpli_pid_sid_pos');
	121	+
	122	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	123	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_pid');
	124	+
	125	+ $table->addForeignKeyConstraint('ezuser_list_type', array('typeid'), array('id'),
	126	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_typeid');
127	127
128	128	return $schema;
129	129	},
130	130
131		- 'ezuser_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	131	+ 'ezuser_property_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
132	132
133		- $table = $schema->createTable( 'ezuser_property_type' );
	133	+ $table = $schema->createTable('ezuser_property_type');
134	134
135		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
136		- $table->addColumn( 'siteid', 'integer', [] );
137		- $table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
138		- $table->addColumn( 'code', 'string', array( 'length' => 32 ) );
139		- $table->addColumn( 'label', 'string', array( 'length' => 255 ) );
140		- $table->addColumn( 'pos', 'integer', ['default' => 0] );
141		- $table->addColumn( 'status', 'smallint', [] );
142		- $table->addColumn( 'mtime', 'datetime', [] );
143		- $table->addColumn( 'ctime', 'datetime', [] );
144		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	135	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	136	+ $table->addColumn('siteid', 'integer', []);
	137	+ $table->addColumn('domain', 'string', array('length' => 32));
	138	+ $table->addColumn('code', 'string', array('length' => 32));
	139	+ $table->addColumn('label', 'string', array('length' => 255));
	140	+ $table->addColumn('pos', 'integer', ['default' => 0]);
	141	+ $table->addColumn('status', 'smallint', []);
	142	+ $table->addColumn('mtime', 'datetime', []);
	143	+ $table->addColumn('ctime', 'datetime', []);
	144	+ $table->addColumn('editor', 'string', array('length' => 255));
145	145
146		- $table->setPrimaryKey( array( 'id' ), 'pk_ezpprty_id' );
147		- $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezpprty_sid_dom_code' );
148		- $table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_ezpprty_sid_status_pos' );
149		- $table->addIndex( array( 'siteid', 'label' ), 'idx_ezpprty_sid_label' );
150		- $table->addIndex( array( 'siteid', 'code' ), 'idx_ezpprty_sid_code' );
	146	+ $table->setPrimaryKey(array('id'), 'pk_ezpprty_id');
	147	+ $table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezpprty_sid_dom_code');
	148	+ $table->addIndex(array('siteid', 'status', 'pos'), 'idx_ezpprty_sid_status_pos');
	149	+ $table->addIndex(array('siteid', 'label'), 'idx_ezpprty_sid_label');
	150	+ $table->addIndex(array('siteid', 'code'), 'idx_ezpprty_sid_code');
151	151
152	152	return $schema;
153	153	},
154	154
155		- 'ezuser_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
	155	+ 'ezuser_property' => function(\Doctrine\DBAL\Schema\Schema $schema) {
156	156
157		- $table = $schema->createTable( 'ezuser_property' );
	157	+ $table = $schema->createTable('ezuser_property');
158	158
159		- $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
160		- $table->addColumn( 'siteid', 'integer', [] );
161		- $table->addColumn( 'parentid', 'integer', [] );
162		- $table->addColumn( 'typeid', 'integer', [] );
163		- $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
164		- $table->addColumn( 'value', 'string', array( 'length' => 255 ) );
165		- $table->addColumn( 'mtime', 'datetime', [] );
166		- $table->addColumn( 'ctime', 'datetime', [] );
167		- $table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
	159	+ $table->addColumn('id', 'integer', array('autoincrement' => true));
	160	+ $table->addColumn('siteid', 'integer', []);
	161	+ $table->addColumn('parentid', 'integer', []);
	162	+ $table->addColumn('typeid', 'integer', []);
	163	+ $table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
	164	+ $table->addColumn('value', 'string', array('length' => 255));
	165	+ $table->addColumn('mtime', 'datetime', []);
	166	+ $table->addColumn('ctime', 'datetime', []);
	167	+ $table->addColumn('editor', 'string', array('length' => 255));
168	168
169		- $table->setPrimaryKey( array( 'id' ), 'pk_ezppr_id' );
170		- $table->addUniqueIndex( array( 'parentid', 'siteid', 'typeid', 'langid', 'value' ), 'unq_ezppr_sid_tid_lid_value' );
171		- $table->addIndex( array( 'siteid', 'langid' ), 'idx_ezppr_sid_langid' );
172		- $table->addIndex( array( 'siteid', 'value' ), 'idx_ezppr_sid_value' );
173		- $table->addIndex( array( 'typeid' ), 'fk_ezppr_typeid' );
174		- $table->addIndex( array( 'parentid' ), 'fk_ezppr_pid' );
	169	+ $table->setPrimaryKey(array('id'), 'pk_ezppr_id');
	170	+ $table->addUniqueIndex(array('parentid', 'siteid', 'typeid', 'langid', 'value'), 'unq_ezppr_sid_tid_lid_value');
	171	+ $table->addIndex(array('siteid', 'langid'), 'idx_ezppr_sid_langid');
	172	+ $table->addIndex(array('siteid', 'value'), 'idx_ezppr_sid_value');
	173	+ $table->addIndex(array('typeid'), 'fk_ezppr_typeid');
	174	+ $table->addIndex(array('parentid'), 'fk_ezppr_pid');
175	175
176		- $table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
177		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_pid' );
	176	+ $table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
	177	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_pid');
178	178
179		- $table->addForeignKeyConstraint( 'ezuser_property_type', array( 'typeid' ), array( 'id' ),
180		- array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_typeid' );
	179	+ $table->addForeignKeyConstraint('ezuser_property_type', array('typeid'), array('id'),
	180	+ array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_typeid');
181	181
182	182	return $schema;
183	183	},

aimeos / ai-ezpublish

Push — master ( 89095d...9bae21 )

Status

Category

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