@@ -8,163 +8,163 @@ |
||
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 | }, |
@@ -57,25 +57,25 @@ |
||
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 |