@@ 109-131 (lines=23) @@ | ||
106 | return $schema; |
|
107 | }, |
|
108 | ||
109 | 'users_list_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
110 | ||
111 | $table = $schema->createTable( 'users_list_type' ); |
|
112 | ||
113 | $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) ); |
|
114 | $table->addColumn( 'siteid', 'integer', [] ); |
|
115 | $table->addColumn( 'domain', 'string', array( 'length' => 32 ) ); |
|
116 | $table->addColumn( 'code', 'string', array( 'length' => 32 ) ); |
|
117 | $table->addColumn( 'label', 'string', array( 'length' => 255 ) ); |
|
118 | $table->addColumn( 'pos', 'integer', ['default' => 0] ); |
|
119 | $table->addColumn( 'status', 'smallint', [] ); |
|
120 | $table->addColumn( 'mtime', 'datetime', [] ); |
|
121 | $table->addColumn( 'ctime', 'datetime', [] ); |
|
122 | $table->addColumn( 'editor', 'string', array( 'length' => 255 ) ); |
|
123 | ||
124 | $table->setPrimaryKey( array( 'id' ), 'pk_lvulity_id' ); |
|
125 | $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_lvulity_sid_dom_code' ); |
|
126 | $table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_lvulity_sid_status_pos' ); |
|
127 | $table->addIndex( array( 'siteid', 'label' ), 'idx_lvulity_sid_label' ); |
|
128 | $table->addIndex( array( 'siteid', 'code' ), 'idx_lvulity_sid_code' ); |
|
129 | ||
130 | return $schema; |
|
131 | }, |
|
132 | ||
133 | 'users_list' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
134 | ||
@@ 162-184 (lines=23) @@ | ||
159 | return $schema; |
|
160 | }, |
|
161 | ||
162 | 'users_property_type' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
163 | ||
164 | $table = $schema->createTable( 'users_property_type' ); |
|
165 | ||
166 | $table->addColumn( 'id', 'integer', array( 'autoincrement' => true ) ); |
|
167 | $table->addColumn( 'siteid', 'integer', [] ); |
|
168 | $table->addColumn( 'domain', 'string', array( 'length' => 32 ) ); |
|
169 | $table->addColumn( 'code', 'string', array( 'length' => 32 ) ); |
|
170 | $table->addColumn( 'label', 'string', array( 'length' => 255 ) ); |
|
171 | $table->addColumn( 'pos', 'integer', ['default' => 0] ); |
|
172 | $table->addColumn( 'status', 'smallint', [] ); |
|
173 | $table->addColumn( 'mtime', 'datetime', [] ); |
|
174 | $table->addColumn( 'ctime', 'datetime', [] ); |
|
175 | $table->addColumn( 'editor', 'string', array( 'length' => 255 ) ); |
|
176 | ||
177 | $table->setPrimaryKey( array( 'id' ), 'pk_lvuprty_id' ); |
|
178 | $table->addUniqueIndex( array( 'siteid', 'domain', 'code' ), 'unq_lvuprty_sid_dom_code' ); |
|
179 | $table->addIndex( array( 'siteid', 'status', 'pos' ), 'idx_lvuprty_sid_status_pos' ); |
|
180 | $table->addIndex( array( 'siteid', 'label' ), 'idx_lvuprty_sid_label' ); |
|
181 | $table->addIndex( array( 'siteid', 'code' ), 'idx_lvuprty_sid_code' ); |
|
182 | ||
183 | return $schema; |
|
184 | }, |
|
185 | ||
186 | 'users_property' => function ( \Doctrine\DBAL\Schema\Schema $schema ) { |
|
187 |