|
@@ -8,7 +8,7 @@ discard block |
|
|
block discarded – undo |
|
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
|
|
|
@@ -17,23 +17,23 @@ discard block |
|
|
block discarded – undo |
|
17
|
17
|
$table->addColumn( 'siteid', 'integer', array( 'notnull' => false ) ); |
|
18
|
18
|
$table->addColumn( 'name', 'string', array( 'length' => 255 ) ); |
|
19
|
19
|
$table->addColumn( 'remember_token', 'string', array( 'length' => 100, 'notnull' => false ) ); |
|
20
|
|
- $table->addColumn( 'salutation', 'string', array( 'length' => 8, ) ); |
|
21
|
|
- $table->addColumn( 'company', 'string', array( 'length' => 100, ) ); |
|
22
|
|
- $table->addColumn( 'vatid', 'string', array( 'length' => 32, ) ); |
|
23
|
|
- $table->addColumn( 'title', 'string', array( 'length' => 64, ) ); |
|
24
|
|
- $table->addColumn( 'firstname', 'string', array( 'length' => 64, ) ); |
|
25
|
|
- $table->addColumn( 'lastname', 'string', array( 'length' => 64, ) ); |
|
26
|
|
- $table->addColumn( 'address1', 'string', array( 'length' => 200, ) ); |
|
27
|
|
- $table->addColumn( 'address2', 'string', array( 'length' => 200, ) ); |
|
28
|
|
- $table->addColumn( 'address3', 'string', array( 'length' => 200, ) ); |
|
29
|
|
- $table->addColumn( 'postal', 'string', array( 'length' => 16, ) ); |
|
30
|
|
- $table->addColumn( 'city', 'string', array( 'length' => 200, ) ); |
|
31
|
|
- $table->addColumn( 'state', 'string', array( 'length' => 200, ) ); |
|
|
20
|
+ $table->addColumn( 'salutation', 'string', array( 'length' => 8,) ); |
|
|
21
|
+ $table->addColumn( 'company', 'string', array( 'length' => 100,) ); |
|
|
22
|
+ $table->addColumn( 'vatid', 'string', array( 'length' => 32,) ); |
|
|
23
|
+ $table->addColumn( 'title', 'string', array( 'length' => 64,) ); |
|
|
24
|
+ $table->addColumn( 'firstname', 'string', array( 'length' => 64,) ); |
|
|
25
|
+ $table->addColumn( 'lastname', 'string', array( 'length' => 64,) ); |
|
|
26
|
+ $table->addColumn( 'address1', 'string', array( 'length' => 200,) ); |
|
|
27
|
+ $table->addColumn( 'address2', 'string', array( 'length' => 200,) ); |
|
|
28
|
+ $table->addColumn( 'address3', 'string', array( 'length' => 200,) ); |
|
|
29
|
+ $table->addColumn( 'postal', 'string', array( 'length' => 16,) ); |
|
|
30
|
+ $table->addColumn( 'city', 'string', array( 'length' => 200,) ); |
|
|
31
|
+ $table->addColumn( 'state', 'string', array( 'length' => 200,) ); |
|
32
|
32
|
$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) ); |
|
33
|
33
|
$table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false ) ); |
|
34
|
|
- $table->addColumn( 'telephone', 'string', array( 'length' => 32, ) ); |
|
35
|
|
- $table->addColumn( 'telefax', 'string', array( 'length' => 32, ) ); |
|
36
|
|
- $table->addColumn( 'website', 'string', array( 'length' => 255, ) ); |
|
|
34
|
+ $table->addColumn( 'telephone', 'string', array( 'length' => 32,) ); |
|
|
35
|
+ $table->addColumn( 'telefax', 'string', array( 'length' => 32,) ); |
|
|
36
|
+ $table->addColumn( 'website', 'string', array( 'length' => 255,) ); |
|
37
|
37
|
$table->addColumn( 'email', 'string', array( 'length' => 255 ) ); |
|
38
|
38
|
$table->addColumn( 'password', 'string', array( 'length' => 255 ) ); |
|
39
|
39
|
$table->addColumn( 'longitude', 'float', array( 'notnull' => false ) ); |
|
@@ -43,7 +43,7 @@ discard block |
|
|
block discarded – undo |
|
43
|
43
|
$table->addColumn( 'status', 'smallint', array( 'default' => 1 ) ); |
|
44
|
44
|
$table->addColumn( 'updated_at', 'datetime', [] ); |
|
45
|
45
|
$table->addColumn( 'created_at', 'datetime', [] ); |
|
46
|
|
- $table->addColumn( 'editor', 'string', array('length' => 255, ) ); |
|
|
46
|
+ $table->addColumn( 'editor', 'string', array( 'length' => 255,) ); |
|
47
|
47
|
|
|
48
|
48
|
$table->setPrimaryKey( array( 'id' ), 'pk_lvusr_id' ); |
|
49
|
49
|
$table->addUniqueIndex( array( 'email' ), 'unq_lvusr_email' ); |
|
@@ -58,7 +58,7 @@ discard block |
|
|
block discarded – undo |
|
58
|
58
|
return $schema; |
|
59
|
59
|
}, |
|
60
|
60
|
|
|
61
|
|
- 'users_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
|
61
|
+ 'users_address' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
62
|
62
|
|
|
63
|
63
|
$table = $schema->createTable( 'users_address' ); |
|
64
|
64
|
|
|
@@ -88,7 +88,7 @@ discard block |
|
|
block discarded – undo |
|
88
|
88
|
$table->addColumn( 'latitude', 'float', array( 'notnull' => false ) ); |
|
89
|
89
|
$table->addColumn( 'mtime', 'datetime', [] ); |
|
90
|
90
|
$table->addColumn( 'ctime', 'datetime', [] ); |
|
91
|
|
- $table->addColumn( 'editor', 'string', array('length' => 255 ) ); |
|
|
91
|
+ $table->addColumn( 'editor', 'string', array( 'length' => 255 ) ); |
|
92
|
92
|
|
|
93
|
93
|
$table->setPrimaryKey( array( 'id' ), 'pk_lvuad_id' ); |
|
94
|
94
|
$table->addIndex( array( 'parentid' ), 'idx_lvuad_pid' ); |
|
@@ -105,7 +105,7 @@ discard block |
|
|
block discarded – undo |
|
105
|
105
|
return $schema; |
|
106
|
106
|
}, |
|
107
|
107
|
|
|
108
|
|
- 'users_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
|
108
|
+ 'users_list_type' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
109
|
109
|
|
|
110
|
110
|
$table = $schema->createTable( 'users_list_type' ); |
|
111
|
111
|
|
|
@@ -129,7 +129,7 @@ discard block |
|
|
block discarded – undo |
|
129
|
129
|
return $schema; |
|
130
|
130
|
}, |
|
131
|
131
|
|
|
132
|
|
- 'users_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
|
132
|
+ 'users_list' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
133
|
133
|
|
|
134
|
134
|
$table = $schema->createTable( 'users_list' ); |
|
135
|
135
|
|
|
@@ -160,7 +160,7 @@ discard block |
|
|
block discarded – undo |
|
160
|
160
|
return $schema; |
|
161
|
161
|
}, |
|
162
|
162
|
|
|
163
|
|
- 'users_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
|
163
|
+ 'users_property_type' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
164
|
164
|
|
|
165
|
165
|
$table = $schema->createTable( 'users_property_type' ); |
|
166
|
166
|
|
|
@@ -184,7 +184,7 @@ discard block |
|
|
block discarded – undo |
|
184
|
184
|
return $schema; |
|
185
|
185
|
}, |
|
186
|
186
|
|
|
187
|
|
- 'users_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
|
187
|
+ 'users_property' => function( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
188
|
188
|
|
|
189
|
189
|
$table = $schema->createTable( 'users_property' ); |
|
190
|
190
|
|
aimeos /
ai-laravel
