Completed
Push — master ( 76477e...74ae33 )
by Aimeos
01:36
created
lib/custom/setup/default/schema/customer.php 1 patch
Spacing   +120 added lines, -120 removed lines patch added patch discarded remove patch
@@ -8,163 +8,163 @@
 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 ) {
95
+		'ezuser_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
96 96
 
97
-			$table = $schema->createTable( 'ezuser_list' );
97
+			$table = $schema->createTable('ezuser_list');
98 98
 
99
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
100
-			$table->addColumn( 'parentid', 'integer', [] );
101
-			$table->addColumn( 'siteid', 'integer', [] );
102
-			$table->addColumn( 'type', 'string', array( 'length' => 32 ) );
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 ) );
99
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
100
+			$table->addColumn('parentid', 'integer', []);
101
+			$table->addColumn('siteid', 'integer', []);
102
+			$table->addColumn('type', 'string', array('length' => 32));
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 113
 
114
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezpli_id' );
115
-			$table->addUniqueIndex( array( 'parentid', 'siteid', 'domain', 'type', 'refid' ), 'unq_ezpli_pid_sid_dm_ty_rid' );
116
-			$table->addIndex( array( 'parentid' ), 'fk_ezpli_pid' );
114
+			$table->setPrimaryKey(array('id'), 'pk_ezpli_id');
115
+			$table->addUniqueIndex(array('parentid', 'siteid', 'domain', 'type', 'refid'), 'unq_ezpli_pid_sid_dm_ty_rid');
116
+			$table->addIndex(array('parentid'), 'fk_ezpli_pid');
117 117
 
118
-			$table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
119
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezpli_pid' );
118
+			$table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
119
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezpli_pid');
120 120
 
121 121
 			return $schema;
122 122
 		},
123 123
 
124
-		'ezuser_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
124
+		'ezuser_property_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
125 125
 
126
-			$table = $schema->createTable( 'ezuser_property_type' );
126
+			$table = $schema->createTable('ezuser_property_type');
127 127
 
128
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
129
-			$table->addColumn( 'siteid', 'integer', [] );
130
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
131
-			$table->addColumn( 'code', 'string', array( 'length' => 32 ) );
132
-			$table->addColumn( 'label', 'string', array( 'length' => 255 ) );
133
-			$table->addColumn( 'pos', 'integer', ['default' => 0] );
134
-			$table->addColumn( 'status', 'smallint', [] );
135
-			$table->addColumn( 'mtime', 'datetime', [] );
136
-			$table->addColumn( 'ctime', 'datetime', [] );
137
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
128
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
129
+			$table->addColumn('siteid', 'integer', []);
130
+			$table->addColumn('domain', 'string', array('length' => 32));
131
+			$table->addColumn('code', 'string', array('length' => 32));
132
+			$table->addColumn('label', 'string', array('length' => 255));
133
+			$table->addColumn('pos', 'integer', ['default' => 0]);
134
+			$table->addColumn('status', 'smallint', []);
135
+			$table->addColumn('mtime', 'datetime', []);
136
+			$table->addColumn('ctime', 'datetime', []);
137
+			$table->addColumn('editor', 'string', array('length' => 255));
138 138
 
139
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezpprty_id' );
140
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_ezpprty_sid_dom_code' );
141
-			$table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_ezpprty_sid_status_pos' );
142
-			$table->addIndex( array( 'siteid', 'label' ), 'idx_ezpprty_sid_label' );
143
-			$table->addIndex( array( 'siteid', 'code' ), 'idx_ezpprty_sid_code' );
139
+			$table->setPrimaryKey(array('id'), 'pk_ezpprty_id');
140
+			$table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_ezpprty_sid_dom_code');
141
+			$table->addIndex(array('siteid', 'status', 'pos'), 'idx_ezpprty_sid_status_pos');
142
+			$table->addIndex(array('siteid', 'label'), 'idx_ezpprty_sid_label');
143
+			$table->addIndex(array('siteid', 'code'), 'idx_ezpprty_sid_code');
144 144
 
145 145
 			return $schema;
146 146
 		},
147 147
 
148
-		'ezuser_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
148
+		'ezuser_property' => function(\Doctrine\DBAL\Schema\Schema $schema) {
149 149
 
150
-			$table = $schema->createTable( 'ezuser_property' );
150
+			$table = $schema->createTable('ezuser_property');
151 151
 
152
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
153
-			$table->addColumn( 'siteid', 'integer', [] );
154
-			$table->addColumn( 'parentid', 'integer', [] );
155
-			$table->addColumn( 'type', 'string', array( 'length' => 32 ) );
156
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
157
-			$table->addColumn( 'value', 'string', array( 'length' => 255 ) );
158
-			$table->addColumn( 'mtime', 'datetime', [] );
159
-			$table->addColumn( 'ctime', 'datetime', [] );
160
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
152
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
153
+			$table->addColumn('siteid', 'integer', []);
154
+			$table->addColumn('parentid', 'integer', []);
155
+			$table->addColumn('type', 'string', array('length' => 32));
156
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
157
+			$table->addColumn('value', 'string', array('length' => 255));
158
+			$table->addColumn('mtime', 'datetime', []);
159
+			$table->addColumn('ctime', 'datetime', []);
160
+			$table->addColumn('editor', 'string', array('length' => 255));
161 161
 
162
-			$table->setPrimaryKey( array( 'id' ), 'pk_ezppr_id' );
163
-			$table->addUniqueIndex( array( 'parentid', 'siteid', 'type', 'langid', 'value' ), 'unq_ezppr_sid_ty_lid_value' );
164
-			$table->addIndex( array( 'parentid' ), 'fk_ezppr_pid' );
162
+			$table->setPrimaryKey(array('id'), 'pk_ezppr_id');
163
+			$table->addUniqueIndex(array('parentid', 'siteid', 'type', 'langid', 'value'), 'unq_ezppr_sid_ty_lid_value');
164
+			$table->addIndex(array('parentid'), 'fk_ezppr_pid');
165 165
 
166
-			$table->addForeignKeyConstraint( 'ezuser', array( 'parentid' ), array( 'contentobject_id' ),
167
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_ezppr_pid' );
166
+			$table->addForeignKeyConstraint('ezuser', array('parentid'), array('contentobject_id'),
167
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_ezppr_pid');
168 168
 
169 169
 			return $schema;
170 170
 		},
Please login to merge, or discard this patch.
lib/custom/setup/TypesMigrateColumnsEzpublish.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -57,25 +57,25 @@
 block discarded – undo
57 57
 	 */
58 58
 	public function migrate()
59 59
 	{
60
-		$this->msg( sprintf( 'Add new type columns for FosUser' ), 0 );
61
-		$this->status( '' );
60
+		$this->msg(sprintf('Add new type columns for FosUser'), 0);
61
+		$this->status('');
62 62
 
63
-		foreach( $this->tables as $rname => $list ) {
64
-			$this->addColumn( $rname, $list );
63
+		foreach ($this->tables as $rname => $list) {
64
+			$this->addColumn($rname, $list);
65 65
 		}
66 66
 
67
-		$this->msg( sprintf( 'Drop old unique indexes for FosUser' ), 0 );
68
-		$this->status( '' );
67
+		$this->msg(sprintf('Drop old unique indexes for FosUser'), 0);
68
+		$this->status('');
69 69
 
70
-		foreach( $this->constraints as $rname => $list ) {
71
-			$this->dropIndex( $rname, $list );
70
+		foreach ($this->constraints as $rname => $list) {
71
+			$this->dropIndex($rname, $list);
72 72
 		}
73 73
 
74
-		$this->msg( sprintf( 'Migrate typeid to type for FosUser' ), 0 );
75
-		$this->status( '' );
74
+		$this->msg(sprintf('Migrate typeid to type for FosUser'), 0);
75
+		$this->status('');
76 76
 
77
-		foreach( $this->migrations as $rname => $list ) {
78
-			$this->migrateData( $rname, $list );
77
+		foreach ($this->migrations as $rname => $list) {
78
+			$this->migrateData($rname, $list);
79 79
 		}
80 80
 	}
81 81
 }
82 82
\ No newline at end of file
Please login to merge, or discard this patch.