@@ -8,33 +8,33 @@ discard block |
||
8 | 8 | |
9 | 9 | return array( |
10 | 10 | 'table' => array( |
11 | - 'users' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
11 | + 'users' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
12 | 12 | |
13 | 13 | $table = $schema->createTable( 'users' ); |
14 | 14 | |
15 | 15 | $table->addColumn( 'id', 'integer', array( 'autoincrement' => true, 'unsigned' => true ) ); |
16 | 16 | $table->addColumn( 'superuser', 'smallint', array( 'default' => 0 ) ); |
17 | 17 | $table->addColumn( 'siteid', 'integer', array( 'notnull' => false ) ); |
18 | - $table->addColumn( 'label', 'string', array( 'length' => 255, ) ); |
|
18 | + $table->addColumn( 'label', 'string', array( 'length' => 255,) ); |
|
19 | 19 | $table->addColumn( 'name', 'string', array( 'length' => 255 ) ); |
20 | 20 | $table->addColumn( 'remember_token', 'string', array( 'length' => 100, 'notnull' => false ) ); |
21 | - $table->addColumn( 'salutation', 'string', array( 'length' => 8, ) ); |
|
22 | - $table->addColumn( 'company', 'string', array( 'length' => 100, ) ); |
|
23 | - $table->addColumn( 'vatid', 'string', array( 'length' => 32, ) ); |
|
24 | - $table->addColumn( 'title', 'string', array( 'length' => 64, ) ); |
|
25 | - $table->addColumn( 'firstname', 'string', array( 'length' => 64, ) ); |
|
26 | - $table->addColumn( 'lastname', 'string', array( 'length' => 64, ) ); |
|
27 | - $table->addColumn( 'address1', 'string', array( 'length' => 200, ) ); |
|
28 | - $table->addColumn( 'address2', 'string', array( 'length' => 200, ) ); |
|
29 | - $table->addColumn( 'address3', 'string', array( 'length' => 200, ) ); |
|
30 | - $table->addColumn( 'postal', 'string', array( 'length' => 16, ) ); |
|
31 | - $table->addColumn( 'city', 'string', array( 'length' => 200, ) ); |
|
32 | - $table->addColumn( 'state', 'string', array( 'length' => 200, ) ); |
|
21 | + $table->addColumn( 'salutation', 'string', array( 'length' => 8,) ); |
|
22 | + $table->addColumn( 'company', 'string', array( 'length' => 100,) ); |
|
23 | + $table->addColumn( 'vatid', 'string', array( 'length' => 32,) ); |
|
24 | + $table->addColumn( 'title', 'string', array( 'length' => 64,) ); |
|
25 | + $table->addColumn( 'firstname', 'string', array( 'length' => 64,) ); |
|
26 | + $table->addColumn( 'lastname', 'string', array( 'length' => 64,) ); |
|
27 | + $table->addColumn( 'address1', 'string', array( 'length' => 200,) ); |
|
28 | + $table->addColumn( 'address2', 'string', array( 'length' => 200,) ); |
|
29 | + $table->addColumn( 'address3', 'string', array( 'length' => 200,) ); |
|
30 | + $table->addColumn( 'postal', 'string', array( 'length' => 16,) ); |
|
31 | + $table->addColumn( 'city', 'string', array( 'length' => 200,) ); |
|
32 | + $table->addColumn( 'state', 'string', array( 'length' => 200,) ); |
|
33 | 33 | $table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) ); |
34 | 34 | $table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false ) ); |
35 | - $table->addColumn( 'telephone', 'string', array( 'length' => 32, ) ); |
|
36 | - $table->addColumn( 'telefax', 'string', array( 'length' => 32, ) ); |
|
37 | - $table->addColumn( 'website', 'string', array( 'length' => 255, ) ); |
|
35 | + $table->addColumn( 'telephone', 'string', array( 'length' => 32,) ); |
|
36 | + $table->addColumn( 'telefax', 'string', array( 'length' => 32,) ); |
|
37 | + $table->addColumn( 'website', 'string', array( 'length' => 255,) ); |
|
38 | 38 | $table->addColumn( 'email', 'string', array( 'length' => 255 ) ); |
39 | 39 | $table->addColumn( 'password', 'string', array( 'length' => 255 ) ); |
40 | 40 | $table->addColumn( 'longitude', 'float', array( 'notnull' => false ) ); |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | $table->addColumn( 'status', 'smallint', array( 'default' => 1 ) ); |
45 | 45 | $table->addColumn( 'updated_at', 'datetime', [] ); |
46 | 46 | $table->addColumn( 'created_at', 'datetime', [] ); |
47 | - $table->addColumn( 'editor', 'string', array('length' => 255, ) ); |
|
47 | + $table->addColumn( 'editor', 'string', array( 'length' => 255,) ); |
|
48 | 48 | |
49 | 49 | $table->setPrimaryKey( array( 'id' ), 'pk_lvusr_id' ); |
50 | 50 | $table->addUniqueIndex( array( 'email' ), 'unq_lvusr_email' ); |
@@ -59,7 +59,7 @@ discard block |
||
59 | 59 | return $schema; |
60 | 60 | }, |
61 | 61 | |
62 | - 'users_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
62 | + 'users_address' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
63 | 63 | |
64 | 64 | $table = $schema->createTable( 'users_address' ); |
65 | 65 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | $table->addColumn( 'latitude', 'float', array( 'notnull' => false ) ); |
90 | 90 | $table->addColumn( 'mtime', 'datetime', [] ); |
91 | 91 | $table->addColumn( 'ctime', 'datetime', [] ); |
92 | - $table->addColumn( 'editor', 'string', array('length' => 255 ) ); |
|
92 | + $table->addColumn( 'editor', 'string', array( 'length' => 255 ) ); |
|
93 | 93 | |
94 | 94 | $table->setPrimaryKey( array( 'id' ), 'pk_lvuad_id' ); |
95 | 95 | $table->addIndex( array( 'parentid' ), 'idx_lvuad_pid' ); |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | return $schema; |
107 | 107 | }, |
108 | 108 | |
109 | - 'users_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
109 | + 'users_list_type' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
110 | 110 | |
111 | 111 | $table = $schema->createTable( 'users_list_type' ); |
112 | 112 | |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | return $schema; |
131 | 131 | }, |
132 | 132 | |
133 | - 'users_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
133 | + 'users_list' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
134 | 134 | |
135 | 135 | $table = $schema->createTable( 'users_list' ); |
136 | 136 | |
@@ -161,7 +161,7 @@ discard block |
||
161 | 161 | return $schema; |
162 | 162 | }, |
163 | 163 | |
164 | - 'users_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
164 | + 'users_property_type' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
165 | 165 | |
166 | 166 | $table = $schema->createTable( 'users_property_type' ); |
167 | 167 | |
@@ -185,7 +185,7 @@ discard block |
||
185 | 185 | return $schema; |
186 | 186 | }, |
187 | 187 | |
188 | - 'users_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
188 | + 'users_property' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
189 | 189 | |
190 | 190 | $table = $schema->createTable( 'users_property' ); |
191 | 191 |