View GitHub Repository ai-fosuser

Schedule Inspection
Subscribe
Completed
Push — master ( e2df0f...9383f4 )
by Aimeos
05:13
created
Status
Category
Toggle Patches
lib/custom/setup/default/schema/customer.php 1 patch
Spacing   +149 added lines, -149 removed lines patch added patch discarded remove patch 
@@ -8,170 +8,170 @@
 
 block discarded – undo
8 8
9 9 
 return array(
10 10 
 	'table' => array(
11 
-		'fos_user' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
12 
-
13 
-			$table = $schema->createTable( 'fos_user' );
14 
-
15 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
16 
-			$table->addColumn( 'siteid', 'integer', array( 'notnull' => false ) );
17 
-			$table->addColumn( 'username', 'string', array( 'length' => 255 ) );
18 
-			$table->addColumn( 'username_canonical', 'string', array( 'length' => 255 ) );
19 
-			$table->addColumn( 'email', 'string', array( 'length' => 255 ) );
20 
-			$table->addColumn( 'email_canonical', 'string', array( 'length' => 255 ) );
21 
-			$table->addColumn( 'enabled', 'smallint', [] );
22 
-			$table->addColumn( 'salt', 'string', array( 'length' => 255 ) );
23 
-			$table->addColumn( 'password', 'string', array( 'length' => 255 ) );
24 
-			$table->addColumn( 'last_login', 'datetime', array( 'notnull' => false ) );
25 
-			$table->addColumn( 'locked', 'smallint', [] );
26 
-			$table->addColumn( 'expired', 'smallint', [] );
27 
-			$table->addColumn( 'expires_at', 'datetime', array( 'notnull' => false ) );
28 
-			$table->addColumn( 'confirmation_token', 'string', array( 'length' => 255, 'notnull' => false ) );
29 
-			$table->addColumn( 'password_requested_at', 'datetime', array( 'notnull' => false ) );
30 
-			$table->addColumn( 'roles', 'text', array( 'length' => 0x7fffffff, 'comment' => '(DC2Type:array)' ) );
31 
-			$table->addColumn( 'credentials_expired', 'smallint', [] );
32 
-			$table->addColumn( 'credentials_expire_at', 'datetime', array( 'notnull' => false ) );
33 
-			$table->addColumn( 'salutation', 'string', array( 'length' => 8, 'default' => '' ) );
34 
-			$table->addColumn( 'company', 'string', array( 'length' => 100, 'default' => '' ) );
35 
-			$table->addColumn( 'vatid', 'string', array( 'length' => 32, 'default' => '' ) );
36 
-			$table->addColumn( 'title', 'string', array( 'length' => 64, 'default' => '' ) );
37 
-			$table->addColumn( 'firstname', 'string', array( 'length' => 64, 'default' => '' ) );
38 
-			$table->addColumn( 'lastname', 'string', array( 'length' => 64, 'default' => '' ) );
39 
-			$table->addColumn( 'address1', 'string', array( 'length' => 200, 'default' => '' ) );
40 
-			$table->addColumn( 'address2', 'string', array( 'length' => 200, 'default' => '' ) );
41 
-			$table->addColumn( 'address3', 'string', array( 'length' => 200, 'default' => '' ) );
42 
-			$table->addColumn( 'postal', 'string', array( 'length' => 16, 'default' => '' ) );
43 
-			$table->addColumn( 'city', 'string', array( 'length' => 200, 'default' => '' ) );
44 
-			$table->addColumn( 'state', 'string', array( 'length' => 200, 'default' => '' ) );
45 
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
46 
-			$table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
47 
-			$table->addColumn( 'telephone', 'string', array( 'length' => 32, 'default' => '' ) );
48 
-			$table->addColumn( 'telefax', 'string', array( 'length' => 32, 'default' => '' ) );
49 
-			$table->addColumn( 'website', 'string', array( 'length' => 255, 'default' => '' ) );
50 
-			$table->addColumn( 'longitude', 'decimal', array( 'precision' => 8, 'scale' => 6, 'notnull' => false ) );
51 
-			$table->addColumn( 'latitude', 'decimal', array( 'precision' => 8, 'scale' => 6, 'notnull' => false ) );
52 
-			$table->addColumn( 'birthday', 'date', array( 'notnull' => false ) );
53 
-			$table->addColumn( 'vdate', 'date', array( 'notnull' => false ) );
54 
-			$table->addColumn( 'mtime', 'datetime', array( 'notnull' => false ) );
55 
-			$table->addColumn( 'ctime', 'datetime', array( 'notnull' => false ) );
56 
-			$table->addColumn( 'editor', 'string', array('length' => 255, 'default' => '' ) );
57 
-
58 
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosus_id' );
59 
-			$table->addUniqueIndex( array( 'username_canonical' ), 'unq_fosus_username' );
60 
-			$table->addUniqueIndex( array( 'email_canonical' ), 'unq_fosus_email' );
61 
-			$table->addIndex( array( 'langid' ), 'idx_fosus_langid' );
62 
-			$table->addIndex( array( 'lastname', 'firstname' ), 'idx_fosus_last_first' );
63 
-			$table->addIndex( array( 'postal', 'address1' ), 'idx_fosus_post_addr1' );
64 
-			$table->addIndex( array( 'postal', 'city' ), 'idx_fosus_post_city' );
65 
-			$table->addIndex( array( 'lastname' ), 'idx_fosus_lastname' );
66 
-			$table->addIndex( array( 'address1' ), 'idx_fosus_address1' );
67 
-			$table->addIndex( array( 'city' ), 'idx_fosus_city' );
11 
+		'fos_user' => function(\Doctrine\DBAL\Schema\Schema $schema) {
12 
+
13 
+			$table = $schema->createTable('fos_user');
14 
+
15 
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
16 
+			$table->addColumn('siteid', 'integer', array('notnull' => false));
17 
+			$table->addColumn('username', 'string', array('length' => 255));
18 
+			$table->addColumn('username_canonical', 'string', array('length' => 255));
19 
+			$table->addColumn('email', 'string', array('length' => 255));
20 
+			$table->addColumn('email_canonical', 'string', array('length' => 255));
21 
+			$table->addColumn('enabled', 'smallint', []);
22 
+			$table->addColumn('salt', 'string', array('length' => 255));
23 
+			$table->addColumn('password', 'string', array('length' => 255));
24 
+			$table->addColumn('last_login', 'datetime', array('notnull' => false));
25 
+			$table->addColumn('locked', 'smallint', []);
26 
+			$table->addColumn('expired', 'smallint', []);
27 
+			$table->addColumn('expires_at', 'datetime', array('notnull' => false));
28 
+			$table->addColumn('confirmation_token', 'string', array('length' => 255, 'notnull' => false));
29 
+			$table->addColumn('password_requested_at', 'datetime', array('notnull' => false));
30 
+			$table->addColumn('roles', 'text', array('length' => 0x7fffffff, 'comment' => '(DC2Type:array)'));
31 
+			$table->addColumn('credentials_expired', 'smallint', []);
32 
+			$table->addColumn('credentials_expire_at', 'datetime', array('notnull' => false));
33 
+			$table->addColumn('salutation', 'string', array('length' => 8, 'default' => ''));
34 
+			$table->addColumn('company', 'string', array('length' => 100, 'default' => ''));
35 
+			$table->addColumn('vatid', 'string', array('length' => 32, 'default' => ''));
36 
+			$table->addColumn('title', 'string', array('length' => 64, 'default' => ''));
37 
+			$table->addColumn('firstname', 'string', array('length' => 64, 'default' => ''));
38 
+			$table->addColumn('lastname', 'string', array('length' => 64, 'default' => ''));
39 
+			$table->addColumn('address1', 'string', array('length' => 200, 'default' => ''));
40 
+			$table->addColumn('address2', 'string', array('length' => 200, 'default' => ''));
41 
+			$table->addColumn('address3', 'string', array('length' => 200, 'default' => ''));
42 
+			$table->addColumn('postal', 'string', array('length' => 16, 'default' => ''));
43 
+			$table->addColumn('city', 'string', array('length' => 200, 'default' => ''));
44 
+			$table->addColumn('state', 'string', array('length' => 200, 'default' => ''));
45 
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
46 
+			$table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
47 
+			$table->addColumn('telephone', 'string', array('length' => 32, 'default' => ''));
48 
+			$table->addColumn('telefax', 'string', array('length' => 32, 'default' => ''));
49 
+			$table->addColumn('website', 'string', array('length' => 255, 'default' => ''));
50 
+			$table->addColumn('longitude', 'decimal', array('precision' => 8, 'scale' => 6, 'notnull' => false));
51 
+			$table->addColumn('latitude', 'decimal', array('precision' => 8, 'scale' => 6, 'notnull' => false));
52 
+			$table->addColumn('birthday', 'date', array('notnull' => false));
53 
+			$table->addColumn('vdate', 'date', array('notnull' => false));
54 
+			$table->addColumn('mtime', 'datetime', array('notnull' => false));
55 
+			$table->addColumn('ctime', 'datetime', array('notnull' => false));
56 
+			$table->addColumn('editor', 'string', array('length' => 255, 'default' => ''));
57 
+
58 
+			$table->setPrimaryKey(array('id'), 'pk_fosus_id');
59 
+			$table->addUniqueIndex(array('username_canonical'), 'unq_fosus_username');
60 
+			$table->addUniqueIndex(array('email_canonical'), 'unq_fosus_email');
61 
+			$table->addIndex(array('langid'), 'idx_fosus_langid');
62 
+			$table->addIndex(array('lastname', 'firstname'), 'idx_fosus_last_first');
63 
+			$table->addIndex(array('postal', 'address1'), 'idx_fosus_post_addr1');
64 
+			$table->addIndex(array('postal', 'city'), 'idx_fosus_post_city');
65 
+			$table->addIndex(array('lastname'), 'idx_fosus_lastname');
66 
+			$table->addIndex(array('address1'), 'idx_fosus_address1');
67 
+			$table->addIndex(array('city'), 'idx_fosus_city');
68 68
69 69 
 			return $schema;
70 70 
 		},
71 71
72 
-		'fos_user_address' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
73 
-
74 
-			$table = $schema->createTable( 'fos_user_address' );
75 
-
76 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
77 
-			$table->addColumn( 'siteid', 'integer', [] );
78 
-			$table->addColumn( 'parentid', 'integer', [] );
79 
-			$table->addColumn( 'company', 'string', array( 'length' => 100 ) );
80 
-			$table->addColumn( 'vatid', 'string', array( 'length' => 32 ) );
81 
-			$table->addColumn( 'salutation', 'string', array( 'length' => 8 ) );
82 
-			$table->addColumn( 'title', 'string', array( 'length' => 64 ) );
83 
-			$table->addColumn( 'firstname', 'string', array( 'length' => 64 ) );
84 
-			$table->addColumn( 'lastname', 'string', array( 'length' => 64 ) );
85 
-			$table->addColumn( 'address1', 'string', array( 'length' => 200 ) );
86 
-			$table->addColumn( 'address2', 'string', array( 'length' => 200 ) );
87 
-			$table->addColumn( 'address3', 'string', array( 'length' => 200 ) );
88 
-			$table->addColumn( 'postal', 'string', array( 'length' => 16 ) );
89 
-			$table->addColumn( 'city', 'string', array( 'length' => 200 ) );
90 
-			$table->addColumn( 'state', 'string', array( 'length' => 200 ) );
91 
-			$table->addColumn( 'langid', 'string', array( 'length' => 5, 'notnull' => false ) );
92 
-			$table->addColumn( 'countryid', 'string', array( 'length' => 2, 'notnull' => false, 'fixed' => true ) );
93 
-			$table->addColumn( 'telephone', 'string', array( 'length' => 32 ) );
94 
-			$table->addColumn( 'email', 'string', array( 'length' => 255 ) );
95 
-			$table->addColumn( 'telefax', 'string', array( 'length' => 255 ) );
96 
-			$table->addColumn( 'website', 'string', array( 'length' => 255 ) );
97 
-			$table->addColumn( 'longitude', 'decimal', array( 'precision' => 8, 'scale' => 6, 'notnull' => false ) );
98 
-			$table->addColumn( 'latitude', 'decimal', array( 'precision' => 8, 'scale' => 6, 'notnull' => false ) );
99 
-			$table->addColumn( 'flag', 'integer', [] );
100 
-			$table->addColumn( 'pos', 'smallint', [] );
101 
-			$table->addColumn( 'mtime', 'datetime', [] );
102 
-			$table->addColumn( 'ctime', 'datetime', [] );
103 
-			$table->addColumn( 'editor', 'string', array('length' => 255 ) );
104 
-
105 
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosad_id' );
106 
-			$table->addIndex( array( 'parentid' ), 'idx_fosad_pid' );
107 
-			$table->addIndex( array( 'lastname', 'firstname' ), 'idx_fosad_last_first' );
108 
-			$table->addIndex( array( 'postal', 'address1' ), 'idx_fosad_post_addr1' );
109 
-			$table->addIndex( array( 'postal', 'city' ), 'idx_fosad_post_city' );
110 
-			$table->addIndex( array( 'address1' ), 'idx_fosad_address1' );
111 
-			$table->addIndex( array( 'city' ), 'idx_fosad_city' );
112 
-			$table->addIndex( array( 'email' ), 'idx_fosad_email' );
113 
-
114 
-			$table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
115 
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosad_pid' );
72 
+		'fos_user_address' => function(\Doctrine\DBAL\Schema\Schema $schema) {
73 
+
74 
+			$table = $schema->createTable('fos_user_address');
75 
+
76 
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
77 
+			$table->addColumn('siteid', 'integer', []);
78 
+			$table->addColumn('parentid', 'integer', []);
79 
+			$table->addColumn('company', 'string', array('length' => 100));
80 
+			$table->addColumn('vatid', 'string', array('length' => 32));
81 
+			$table->addColumn('salutation', 'string', array('length' => 8));
82 
+			$table->addColumn('title', 'string', array('length' => 64));
83 
+			$table->addColumn('firstname', 'string', array('length' => 64));
84 
+			$table->addColumn('lastname', 'string', array('length' => 64));
85 
+			$table->addColumn('address1', 'string', array('length' => 200));
86 
+			$table->addColumn('address2', 'string', array('length' => 200));
87 
+			$table->addColumn('address3', 'string', array('length' => 200));
88 
+			$table->addColumn('postal', 'string', array('length' => 16));
89 
+			$table->addColumn('city', 'string', array('length' => 200));
90 
+			$table->addColumn('state', 'string', array('length' => 200));
91 
+			$table->addColumn('langid', 'string', array('length' => 5, 'notnull' => false));
92 
+			$table->addColumn('countryid', 'string', array('length' => 2, 'notnull' => false, 'fixed' => true));
93 
+			$table->addColumn('telephone', 'string', array('length' => 32));
94 
+			$table->addColumn('email', 'string', array('length' => 255));
95 
+			$table->addColumn('telefax', 'string', array('length' => 255));
96 
+			$table->addColumn('website', 'string', array('length' => 255));
97 
+			$table->addColumn('longitude', 'decimal', array('precision' => 8, 'scale' => 6, 'notnull' => false));
98 
+			$table->addColumn('latitude', 'decimal', array('precision' => 8, 'scale' => 6, 'notnull' => false));
99 
+			$table->addColumn('flag', 'integer', []);
100 
+			$table->addColumn('pos', 'smallint', []);
101 
+			$table->addColumn('mtime', 'datetime', []);
102 
+			$table->addColumn('ctime', 'datetime', []);
103 
+			$table->addColumn('editor', 'string', array('length' => 255));
104 
+
105 
+			$table->setPrimaryKey(array('id'), 'pk_fosad_id');
106 
+			$table->addIndex(array('parentid'), 'idx_fosad_pid');
107 
+			$table->addIndex(array('lastname', 'firstname'), 'idx_fosad_last_first');
108 
+			$table->addIndex(array('postal', 'address1'), 'idx_fosad_post_addr1');
109 
+			$table->addIndex(array('postal', 'city'), 'idx_fosad_post_city');
110 
+			$table->addIndex(array('address1'), 'idx_fosad_address1');
111 
+			$table->addIndex(array('city'), 'idx_fosad_city');
112 
+			$table->addIndex(array('email'), 'idx_fosad_email');
113 
+
114 
+			$table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
115 
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosad_pid');
116 116
117 117 
 			return $schema;
118 118 
 		},
119 119
120 
-		'fos_user_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
120 
+		'fos_user_list_type' => function(\Doctrine\DBAL\Schema\Schema $schema) {
121 121
122 
-			$table = $schema->createTable( 'fos_user_list_type' );
122 
+			$table = $schema->createTable('fos_user_list_type');
123 123
124 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
125 
-			$table->addColumn( 'siteid', 'integer', [] );
126 
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
127 
-			$table->addColumn( 'code', 'string', array( 'length' => 32 ) );
128 
-			$table->addColumn( 'label', 'string', array( 'length' => 255 ) );
129 
-			$table->addColumn( 'status', 'smallint', [] );
130 
-			$table->addColumn( 'mtime', 'datetime', [] );
131 
-			$table->addColumn( 'ctime', 'datetime', [] );
132 
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
124 
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
125 
+			$table->addColumn('siteid', 'integer', []);
126 
+			$table->addColumn('domain', 'string', array('length' => 32));
127 
+			$table->addColumn('code', 'string', array('length' => 32));
128 
+			$table->addColumn('label', 'string', array('length' => 255));
129 
+			$table->addColumn('status', 'smallint', []);
130 
+			$table->addColumn('mtime', 'datetime', []);
131 
+			$table->addColumn('ctime', 'datetime', []);
132 
+			$table->addColumn('editor', 'string', array('length' => 255));
133 133
134 
-			$table->setPrimaryKey( array( 'id' ), 'pk_foslity_id' );
135 
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_foslity_sid_dom_code' );
136 
-			$table->addIndex( array( 'siteid', 'status' ), 'idx_foslity_sid_status' );
137 
-			$table->addIndex( array( 'siteid', 'label' ), 'idx_foslity_sid_label' );
138 
-			$table->addIndex( array( 'siteid', 'code' ), 'idx_foslity_sid_code' );
134 
+			$table->setPrimaryKey(array('id'), 'pk_foslity_id');
135 
+			$table->addUniqueIndex(array('siteid', 'domain', 'code'), 'unq_foslity_sid_dom_code');
136 
+			$table->addIndex(array('siteid', 'status'), 'idx_foslity_sid_status');
137 
+			$table->addIndex(array('siteid', 'label'), 'idx_foslity_sid_label');
138 
+			$table->addIndex(array('siteid', 'code'), 'idx_foslity_sid_code');
139 139
140 140 
 			return $schema;
141 141 
 		},
142 142
143 
-		'fos_user_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) {
144 
-
145 
-			$table = $schema->createTable( 'fos_user_list' );
146 
-
147 
-			$table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) );
148 
-			$table->addColumn( 'parentid', 'integer', [] );
149 
-			$table->addColumn( 'siteid', 'integer', [] );
150 
-			$table->addColumn( 'typeid', 'integer', [] );
151 
-			$table->addColumn( 'domain', 'string', array( 'length' => 32 ) );
152 
-			$table->addColumn( 'refid', 'string', array( 'length' => 32 ) );
153 
-			$table->addColumn( 'start', 'datetime', array( 'notnull' => false ) );
154 
-			$table->addColumn( 'end', 'datetime', array( 'notnull' => false ) );
155 
-			$table->addColumn( 'config', 'text', array( 'length' => 0xffff ) );
156 
-			$table->addColumn( 'pos', 'integer', [] );
157 
-			$table->addColumn( 'status', 'smallint', [] );
158 
-			$table->addColumn( 'mtime', 'datetime', [] );
159 
-			$table->addColumn( 'ctime', 'datetime', [] );
160 
-			$table->addColumn( 'editor', 'string', array( 'length' => 255 ) );
161 
-
162 
-			$table->setPrimaryKey( array( 'id' ), 'pk_fosli_id' );
163 
-			$table->addUniqueIndex( array( 'siteid', 'domain', 'refid', 'typeid', 'parentid' ), 'unq_fosli_sid_dm_rid_tid_pid' );
164 
-			$table->addIndex( array( 'siteid', 'status', 'start', 'end' ), 'idx_fosli_sid_stat_start_end' );
165 
-			$table->addIndex( array( 'parentid', 'siteid', 'refid', 'domain', 'typeid' ), 'idx_fosli_pid_sid_rid_dom_tid' );
166 
-			$table->addIndex( array( 'parentid', 'siteid', 'start' ), 'idx_fosli_pid_sid_start' );
167 
-			$table->addIndex( array( 'parentid', 'siteid', 'end' ), 'idx_fosli_pid_sid_end' );
168 
-			$table->addIndex( array( 'parentid', 'siteid', 'pos' ), 'idx_fosli_pid_sid_pos' );
169 
-
170 
-			$table->addForeignKeyConstraint( 'fos_user', array( 'parentid' ), array( 'id' ),
171 
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_pid' );
172 
-
173 
-			$table->addForeignKeyConstraint( 'fos_user_list_type', array( 'typeid' ), array( 'id' ),
174 
-				array( 'onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE' ), 'fk_fosli_typeid' );
143 
+		'fos_user_list' => function(\Doctrine\DBAL\Schema\Schema $schema) {
144 
+
145 
+			$table = $schema->createTable('fos_user_list');
146 
+
147 
+			$table->addColumn('id', 'integer', array('autoincrement' => true));
148 
+			$table->addColumn('parentid', 'integer', []);
149 
+			$table->addColumn('siteid', 'integer', []);
150 
+			$table->addColumn('typeid', 'integer', []);
151 
+			$table->addColumn('domain', 'string', array('length' => 32));
152 
+			$table->addColumn('refid', 'string', array('length' => 32));
153 
+			$table->addColumn('start', 'datetime', array('notnull' => false));
154 
+			$table->addColumn('end', 'datetime', array('notnull' => false));
155 
+			$table->addColumn('config', 'text', array('length' => 0xffff));
156 
+			$table->addColumn('pos', 'integer', []);
157 
+			$table->addColumn('status', 'smallint', []);
158 
+			$table->addColumn('mtime', 'datetime', []);
159 
+			$table->addColumn('ctime', 'datetime', []);
160 
+			$table->addColumn('editor', 'string', array('length' => 255));
161 
+
162 
+			$table->setPrimaryKey(array('id'), 'pk_fosli_id');
163 
+			$table->addUniqueIndex(array('siteid', 'domain', 'refid', 'typeid', 'parentid'), 'unq_fosli_sid_dm_rid_tid_pid');
164 
+			$table->addIndex(array('siteid', 'status', 'start', 'end'), 'idx_fosli_sid_stat_start_end');
165 
+			$table->addIndex(array('parentid', 'siteid', 'refid', 'domain', 'typeid'), 'idx_fosli_pid_sid_rid_dom_tid');
166 
+			$table->addIndex(array('parentid', 'siteid', 'start'), 'idx_fosli_pid_sid_start');
167 
+			$table->addIndex(array('parentid', 'siteid', 'end'), 'idx_fosli_pid_sid_end');
168 
+			$table->addIndex(array('parentid', 'siteid', 'pos'), 'idx_fosli_pid_sid_pos');
169 
+
170 
+			$table->addForeignKeyConstraint('fos_user', array('parentid'), array('id'),
171 
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_pid');
172 
+
173 
+			$table->addForeignKeyConstraint('fos_user_list_type', array('typeid'), array('id'),
174 
+				array('onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'), 'fk_fosli_typeid');
175 175
176 176 
 			return $schema;
177 177 
 		},
Please login to merge, or discard this patch.