Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
0.00% |
0 / 112 |
n/a |
0 / 0 |
CRAP | n/a |
0 / 0 |
||
| 1 | <?php |
| 2 | |
| 3 | return [ |
| 4 | "CREATE TABLE IF NOT EXISTS `topic_service` ( |
| 5 | `topic_id` INTEGER NOT NULL, |
| 6 | `service_id` INTEGER NOT NULL, |
| 7 | PRIMARY KEY(`topic_id`,`service_id`) |
| 8 | );", |
| 9 | "CREATE TABLE IF NOT EXISTS `topic_links` ( |
| 10 | `topic_id` INTEGER NOT NULL, |
| 11 | `name` VARCHAR ( 255 ), |
| 12 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 13 | `rank` INTEGER NOT NULL, |
| 14 | `url` VARCHAR ( 255 ), |
| 15 | `highlight` TINYINT, |
| 16 | `search` TEXT, |
| 17 | `meta_json` TEXT, |
| 18 | `data_json` TEXT |
| 19 | );", |
| 20 | "CREATE TABLE IF NOT EXISTS `topic_cluster` ( |
| 21 | `topic_id` INTEGER NOT NULL, |
| 22 | `parent_id` INTEGER NOT NULL, |
| 23 | `rank` INTEGER NOT NULL |
| 24 | );", |
| 25 | "CREATE TABLE IF NOT EXISTS `topic` ( |
| 26 | `id` INTEGER NOT NULL, |
| 27 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 28 | `name` VARCHAR ( 255 ), |
| 29 | `path` VARCHAR ( 255 ) NOT NULL, |
| 30 | `navi` INTEGER, |
| 31 | `root` INTEGER, |
| 32 | `rank` INTEGER NOT NULL, |
| 33 | `data_json` TEXT, |
| 34 | PRIMARY KEY(`id`,`locale`) |
| 35 | );", |
| 36 | "CREATE TABLE IF NOT EXISTS `setting` ( |
| 37 | `name` VARCHAR ( 255 ) NOT NULL, |
| 38 | `value` TEXT, |
| 39 | PRIMARY KEY(`name`) |
| 40 | );", |
| 41 | "CREATE TABLE IF NOT EXISTS `service_information` ( |
| 42 | `service_id` INTEGER NOT NULL, |
| 43 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 44 | `name` TEXT, |
| 45 | `description` TEXT NOT NULL, |
| 46 | `link` TEXT, |
| 47 | `type` VARCHAR ( 255 ) NOT NULL, |
| 48 | `sort` TINYINT NOT NULL, |
| 49 | `data_json` TEXT, |
| 50 | PRIMARY KEY(`service_id`,`locale`,`type`,`sort`) |
| 51 | );", |
| 52 | "CREATE TABLE IF NOT EXISTS `service` ( |
| 53 | `id` INTEGER NOT NULL, |
| 54 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 55 | `leika` VARCHAR ( 14 ) NOT NULL, |
| 56 | `name` VARCHAR ( 255 ) NOT NULL, |
| 57 | `description` TEXT NOT NULL, |
| 58 | `hint` TEXT, |
| 59 | `fees` TEXT, |
| 60 | `residence` VARCHAR ( 255 ), |
| 61 | `representation` VARCHAR ( 255 ), |
| 62 | `responsibility` TEXT, |
| 63 | `responsibility_all` TINYINT, |
| 64 | `processing_time` TEXT, |
| 65 | `root_topic_id` INTEGER NOT NULL, |
| 66 | `appointment_all_link` VARCHAR ( 255 ), |
| 67 | `onlineprocessing_json` TEXT, |
| 68 | `relation_json` TEXT, |
| 69 | `authorities_json` TEXT, |
| 70 | `data_json` TEXT, |
| 71 | PRIMARY KEY(`id`,`locale`) |
| 72 | );", |
| 73 | "CREATE TABLE IF NOT EXISTS `search` ( |
| 74 | `object_id` INTEGER NOT NULL, |
| 75 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 76 | `entity_type` VARCHAR ( 255 ), |
| 77 | `search_type` TEXT NOT NULL, |
| 78 | `search_value` TEXT, |
| 79 | PRIMARY KEY(`object_id`,`locale`,`search_type`) |
| 80 | );", |
| 81 | "CREATE TABLE IF NOT EXISTS `meta` ( |
| 82 | `object_id` INTEGER NOT NULL, |
| 83 | `hash` VARCHAR ( 255 ) NOT NULL, |
| 84 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 85 | `lastupdate` DATETIME NOT NULL, |
| 86 | `keywords` TEXT, |
| 87 | `url` VARCHAR ( 255 ), |
| 88 | `type` VARCHAR ( 25 ) NOT NULL, |
| 89 | `titles_json` TEXT, |
| 90 | PRIMARY KEY(`object_id`,`locale`,`type`) |
| 91 | );", |
| 92 | "CREATE TABLE IF NOT EXISTS `location_service` ( |
| 93 | `location_id` INTEGER NOT NULL, |
| 94 | `service_id` INTEGER NOT NULL, |
| 95 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 96 | `appointment_slots` TINYINT, |
| 97 | `appointment_bookable` TINYINT, |
| 98 | `appointment_external` TINYINT, |
| 99 | `appointment_multiple` TINYINT, |
| 100 | `appointment_link` VARCHAR ( 255 ), |
| 101 | `appointment_note` TEXT, |
| 102 | `contact_json` TEXT, |
| 103 | PRIMARY KEY(`location_id`,`service_id`,`locale`) |
| 104 | );", |
| 105 | "CREATE TABLE IF NOT EXISTS `location` ( |
| 106 | `id` INTEGER NOT NULL, |
| 107 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 108 | `name` VARCHAR ( 255 ) NOT NULL, |
| 109 | `category_name` VARCHAR ( 255 ) NOT NULL, |
| 110 | `category_identifier` VARCHAR ( 255 ) NOT NULL, |
| 111 | `authority_id` INTEGER, |
| 112 | `authority_name` VARCHAR ( 255 ) NOT NULL, |
| 113 | `note` TEXT, |
| 114 | `category_json` TEXT, |
| 115 | `urgent_json` TEXT, |
| 116 | `opening_times_json` TEXT, |
| 117 | `transit_json` TEXT, |
| 118 | `deviating_postal_address_json` TEXT, |
| 119 | `payment_json` TEXT, |
| 120 | `accessibility_json` TEXT, |
| 121 | `appointment_json` TEXT, |
| 122 | `data_json` TEXT, |
| 123 | PRIMARY KEY(`id`,`locale`) |
| 124 | );", |
| 125 | "CREATE TABLE IF NOT EXISTS `contact` ( |
| 126 | `object_id` INTEGER NOT NULL, |
| 127 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 128 | `name` VARCHAR ( 255 ), |
| 129 | `contact_json` TEXT, |
| 130 | `address_json` TEXT, |
| 131 | `deviating_postal_address_json` TEXT, |
| 132 | `geo_json` TEXT, |
| 133 | PRIMARY KEY(`object_id`,`locale`) |
| 134 | );", |
| 135 | "CREATE TABLE IF NOT EXISTS `authority_service` ( |
| 136 | `authority_id` INTEGER NOT NULL, |
| 137 | `service_id` INTEGER NOT NULL, |
| 138 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 139 | PRIMARY KEY(`authority_id`,`service_id`,`locale`) |
| 140 | );", |
| 141 | "CREATE TABLE IF NOT EXISTS `authority_location` ( |
| 142 | `authority_id` INTEGER NOT NULL, |
| 143 | `location_id` INTEGER NOT NULL, |
| 144 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 145 | PRIMARY KEY(`authority_id`,`location_id`,`locale`) |
| 146 | );", |
| 147 | "CREATE TABLE IF NOT EXISTS `authority` ( |
| 148 | `id` INTEGER NOT NULL, |
| 149 | `locale` VARCHAR ( 4 ) NOT NULL, |
| 150 | `name` VARCHAR ( 255 ), |
| 151 | `parent_id` INTEGER NOT NULL, |
| 152 | `locations_json` TEXT, |
| 153 | `relation_json` TEXT, |
| 154 | `contact_json` TEXT, |
| 155 | `data_json` TEXT, |
| 156 | PRIMARY KEY(`id`,`locale`) |
| 157 | );", |
| 158 | "CREATE INDEX IF NOT EXISTS `topic_root_index` ON `topic` ( |
| 159 | `root` |
| 160 | );", |
| 161 | "CREATE INDEX IF NOT EXISTS `topic_rank_index` ON `topic` ( |
| 162 | `rank` |
| 163 | );", |
| 164 | "CREATE INDEX IF NOT EXISTS `topic_path_index` ON `topic` ( |
| 165 | `path` |
| 166 | );", |
| 167 | "CREATE INDEX IF NOT EXISTS `topic_navi_index` ON `topic` ( |
| 168 | `navi` |
| 169 | );", |
| 170 | "CREATE INDEX IF NOT EXISTS `topic_links_topic_id_index` ON `topic_links` ( |
| 171 | `topic_id` |
| 172 | );", |
| 173 | "CREATE INDEX IF NOT EXISTS `topic_links_rank_index` ON `topic_links` ( |
| 174 | `rank` |
| 175 | );", |
| 176 | "CREATE INDEX IF NOT EXISTS `topic_links_locale_index` ON `topic_links` ( |
| 177 | `locale` |
| 178 | );", |
| 179 | "CREATE INDEX IF NOT EXISTS `topic_links_keywords_search_index` ON `topic_links` ( |
| 180 | `search` |
| 181 | );", |
| 182 | "CREATE INDEX IF NOT EXISTS `topic_cluster_topic_id_index` ON `topic_cluster` ( |
| 183 | `topic_id` |
| 184 | );", |
| 185 | "CREATE INDEX IF NOT EXISTS `topic_cluster_rank_index` ON `topic_cluster` ( |
| 186 | `rank` |
| 187 | );", |
| 188 | "CREATE INDEX IF NOT EXISTS `topic_cluster_parent_id_index` ON `topic_cluster` ( |
| 189 | `parent_id` |
| 190 | );", |
| 191 | "CREATE INDEX IF NOT EXISTS `service_search_index` ON `service` ( |
| 192 | `description` |
| 193 | );", |
| 194 | "CREATE INDEX IF NOT EXISTS `service_information_type_index` ON `service_information` ( |
| 195 | `type` |
| 196 | );", |
| 197 | "CREATE INDEX IF NOT EXISTS `service_information_service_id_index` ON `service_information` ( |
| 198 | `service_id` |
| 199 | );", |
| 200 | "CREATE INDEX IF NOT EXISTS `search_search_type_index` ON `search` ( |
| 201 | `search_type` |
| 202 | );", |
| 203 | "CREATE INDEX IF NOT EXISTS `search_search_index` ON `search` ( |
| 204 | `search_value` |
| 205 | );", |
| 206 | "CREATE INDEX IF NOT EXISTS `search_object_id_index` ON `search` ( |
| 207 | `object_id` |
| 208 | );", |
| 209 | "CREATE INDEX IF NOT EXISTS `search_locale_index` ON `search` ( |
| 210 | `locale` |
| 211 | );", |
| 212 | "CREATE INDEX IF NOT EXISTS `search_entity_type_index` ON `search` ( |
| 213 | `entity_type` |
| 214 | );", |
| 215 | "CREATE INDEX IF NOT EXISTS `meta_type_index` ON `meta` ( |
| 216 | `type` |
| 217 | );", |
| 218 | "CREATE INDEX IF NOT EXISTS `meta_object_id_index` ON `meta` ( |
| 219 | `object_id` |
| 220 | );", |
| 221 | "CREATE INDEX IF NOT EXISTS `meta_hash_index` ON `meta` ( |
| 222 | `hash` |
| 223 | );", |
| 224 | "CREATE INDEX IF NOT EXISTS `location_service_service_id_locale_index` ON `location_service` ( |
| 225 | `service_id`, |
| 226 | `locale` |
| 227 | );", |
| 228 | "CREATE INDEX IF NOT EXISTS `location_service_service_id_index` ON `location_service` ( |
| 229 | `service_id` |
| 230 | );", |
| 231 | "CREATE INDEX IF NOT EXISTS `location_service_location_id_locale_index` ON `location_service` ( |
| 232 | `location_id`, |
| 233 | `locale` |
| 234 | );", |
| 235 | "CREATE INDEX IF NOT EXISTS `location_service_location_id_index` ON `location_service` ( |
| 236 | `location_id` |
| 237 | );", |
| 238 | "CREATE INDEX IF NOT EXISTS `location_service_locale_index` ON `location_service` ( |
| 239 | `locale` |
| 240 | );", |
| 241 | "CREATE INDEX IF NOT EXISTS `location_name_index` ON `location` ( |
| 242 | `name` |
| 243 | );", |
| 244 | "CREATE INDEX IF NOT EXISTS `location_category_identifier_index` ON `location` ( |
| 245 | `category_identifier` |
| 246 | );", |
| 247 | "CREATE INDEX IF NOT EXISTS `location_authority_id_index` ON `location` ( |
| 248 | `authority_id` |
| 249 | );", |
| 250 | "CREATE INDEX IF NOT EXISTS `authority_service_service_id_locale_index` ON `authority_service` ( |
| 251 | `service_id`, |
| 252 | `locale` |
| 253 | );", |
| 254 | "CREATE INDEX IF NOT EXISTS `authority_service_service_id_index` ON `authority_service` ( |
| 255 | `service_id` |
| 256 | );", |
| 257 | "CREATE INDEX IF NOT EXISTS `authority_service_locale_index` ON `authority_service` ( |
| 258 | `locale` |
| 259 | );", |
| 260 | "CREATE INDEX IF NOT EXISTS `authority_service_authority_id_locale_index` ON `authority_service` ( |
| 261 | `authority_id`, |
| 262 | `locale` |
| 263 | );", |
| 264 | "CREATE INDEX IF NOT EXISTS `authority_service_authority_id_index` ON `authority_service` ( |
| 265 | `authority_id` |
| 266 | );", |
| 267 | "CREATE INDEX IF NOT EXISTS `authority_location_location_id_locale_index` ON `authority_location` ( |
| 268 | `location_id`, |
| 269 | `locale` |
| 270 | );", |
| 271 | "CREATE INDEX IF NOT EXISTS `authority_location_location_id_index` ON `authority_location` ( |
| 272 | `location_id` |
| 273 | );", |
| 274 | "CREATE INDEX IF NOT EXISTS `authority_location_locale_index` ON `authority_location` ( |
| 275 | `locale` |
| 276 | );", |
| 277 | "CREATE INDEX IF NOT EXISTS `authority_location_authority_id_locale_index` ON `authority_location` ( |
| 278 | `authority_id`, |
| 279 | `locale` |
| 280 | );", |
| 281 | "CREATE INDEX IF NOT EXISTS `authority_location_authority_id_index` ON `authority_location` ( |
| 282 | `authority_id` |
| 283 | );" |
| 284 | ]; |