Project

General

Profile

1
SET standard_conforming_strings = off;
2
SET escape_string_warning = off;
3
-- MySQL dump 10.13  Distrib 5.5.29, for debian-linux-gnu (x86_64)
4
--
5
-- Host: localhost    Database: GBIF
6
-- ------------------------------------------------------
7
-- Server version	5.5.29-0ubuntu0.12.04.2
8

    
9
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12
SET NAMES 'latin1';
13
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14
/*!40103 SET TIME_ZONE='+00:00' */;
15
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;
18
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19

    
20
--
21
-- Table structure for table "QRTZ_BLOB_TRIGGERS"
22
--
23

    
24
DROP TABLE IF EXISTS "QRTZ_BLOB_TRIGGERS";
25
/*!40101 SET @saved_cs_client     = @@character_set_client */;
26
/*!40101 SET character_set_client = utf8 */;
27
CREATE TABLE "QRTZ_BLOB_TRIGGERS" (
28
  "trigger_name" varchar(100) NOT NULL,
29
  "trigger_group" varchar(100) NOT NULL,
30
  "blob_data" bytea,
31
  PRIMARY KEY ("trigger_name","trigger_group")
32
);
33
/*!40101 SET character_set_client = @saved_cs_client */;
34

    
35
--
36
-- Table structure for table "QRTZ_CALENDARS"
37
--
38

    
39
DROP TABLE IF EXISTS "QRTZ_CALENDARS";
40
/*!40101 SET @saved_cs_client     = @@character_set_client */;
41
/*!40101 SET character_set_client = utf8 */;
42
CREATE TABLE "QRTZ_CALENDARS" (
43
  "calendar_name" varchar(255) NOT NULL,
44
  "calendar" bytea NOT NULL,
45
  PRIMARY KEY ("calendar_name")
46
);
47
/*!40101 SET character_set_client = @saved_cs_client */;
48

    
49
--
50
-- Table structure for table "QRTZ_CRON_TRIGGERS"
51
--
52

    
53
DROP TABLE IF EXISTS "QRTZ_CRON_TRIGGERS";
54
/*!40101 SET @saved_cs_client     = @@character_set_client */;
55
/*!40101 SET character_set_client = utf8 */;
56
CREATE TABLE "QRTZ_CRON_TRIGGERS" (
57
  "trigger_name" varchar(100) NOT NULL,
58
  "trigger_group" varchar(100) NOT NULL,
59
  "cron_expression" varchar(255) NOT NULL,
60
  "time_zone_id" varchar(255) DEFAULT NULL,
61
  PRIMARY KEY ("trigger_name","trigger_group")
62
);
63
/*!40101 SET character_set_client = @saved_cs_client */;
64

    
65
--
66
-- Table structure for table "QRTZ_FIRED_TRIGGERS"
67
--
68

    
69
DROP TABLE IF EXISTS "QRTZ_FIRED_TRIGGERS";
70
/*!40101 SET @saved_cs_client     = @@character_set_client */;
71
/*!40101 SET character_set_client = utf8 */;
72
CREATE TABLE "QRTZ_FIRED_TRIGGERS" (
73
  "entry_id" varchar(95) NOT NULL,
74
  "trigger_name" varchar(100) NOT NULL,
75
  "trigger_group" varchar(100) NOT NULL,
76
  "is_volatile" varchar(1) NOT NULL,
77
  "instance_name" varchar(255) NOT NULL,
78
  "fired_time" bigint NOT NULL,
79
  "priority" integer NOT NULL,
80
  "state" varchar(16) NOT NULL,
81
  "job_name" varchar(100) DEFAULT NULL,
82
  "job_group" varchar(100) DEFAULT NULL,
83
  "is_stateful" varchar(1) DEFAULT NULL,
84
  "requests_recovery" varchar(1) DEFAULT NULL,
85
  PRIMARY KEY ("entry_id")
86
);
87
/*!40101 SET character_set_client = @saved_cs_client */;
88

    
89
--
90
-- Table structure for table "QRTZ_JOB_DETAILS"
91
--
92

    
93
DROP TABLE IF EXISTS "QRTZ_JOB_DETAILS";
94
/*!40101 SET @saved_cs_client     = @@character_set_client */;
95
/*!40101 SET character_set_client = utf8 */;
96
CREATE TABLE "QRTZ_JOB_DETAILS" (
97
  "job_name" varchar(100) NOT NULL,
98
  "job_group" varchar(100) NOT NULL,
99
  "description" varchar(255) DEFAULT NULL,
100
  "job_class_name" varchar(128) NOT NULL,
101
  "is_durable" varchar(1) NOT NULL,
102
  "is_volatile" varchar(1) NOT NULL,
103
  "is_stateful" varchar(1) NOT NULL,
104
  "requests_recovery" varchar(1) NOT NULL,
105
  "job_data" bytea,
106
  PRIMARY KEY ("job_name","job_group")
107
);
108
/*!40101 SET character_set_client = @saved_cs_client */;
109

    
110
--
111
-- Table structure for table "QRTZ_JOB_LISTENERS"
112
--
113

    
114
DROP TABLE IF EXISTS "QRTZ_JOB_LISTENERS";
115
/*!40101 SET @saved_cs_client     = @@character_set_client */;
116
/*!40101 SET character_set_client = utf8 */;
117
CREATE TABLE "QRTZ_JOB_LISTENERS" (
118
  "job_name" varchar(100) NOT NULL,
119
  "job_group" varchar(100) NOT NULL,
120
  "job_listener" varchar(100) NOT NULL,
121
  PRIMARY KEY ("job_name","job_group","job_listener")
122
);
123
/*!40101 SET character_set_client = @saved_cs_client */;
124

    
125
--
126
-- Table structure for table "QRTZ_LOCKS"
127
--
128

    
129
DROP TABLE IF EXISTS "QRTZ_LOCKS";
130
/*!40101 SET @saved_cs_client     = @@character_set_client */;
131
/*!40101 SET character_set_client = utf8 */;
132
CREATE TABLE "QRTZ_LOCKS" (
133
  "lock_name" varchar(40) NOT NULL,
134
  PRIMARY KEY ("lock_name")
135
);
136
/*!40101 SET character_set_client = @saved_cs_client */;
137

    
138
--
139
-- Table structure for table "QRTZ_PAUSED_TRIGGER_GRPS"
140
--
141

    
142
DROP TABLE IF EXISTS "QRTZ_PAUSED_TRIGGER_GRPS";
143
/*!40101 SET @saved_cs_client     = @@character_set_client */;
144
/*!40101 SET character_set_client = utf8 */;
145
CREATE TABLE "QRTZ_PAUSED_TRIGGER_GRPS" (
146
  "trigger_group" varchar(100) NOT NULL,
147
  PRIMARY KEY ("trigger_group")
148
);
149
/*!40101 SET character_set_client = @saved_cs_client */;
150

    
151
--
152
-- Table structure for table "QRTZ_SCHEDULER_STATE"
153
--
154

    
155
DROP TABLE IF EXISTS "QRTZ_SCHEDULER_STATE";
156
/*!40101 SET @saved_cs_client     = @@character_set_client */;
157
/*!40101 SET character_set_client = utf8 */;
158
CREATE TABLE "QRTZ_SCHEDULER_STATE" (
159
  "instance_name" varchar(255) NOT NULL,
160
  "last_checkin_time" bigint NOT NULL,
161
  "checkin_interval" bigint NOT NULL,
162
  PRIMARY KEY ("instance_name")
163
);
164
/*!40101 SET character_set_client = @saved_cs_client */;
165

    
166
--
167
-- Table structure for table "QRTZ_SIMPLE_TRIGGERS"
168
--
169

    
170
DROP TABLE IF EXISTS "QRTZ_SIMPLE_TRIGGERS";
171
/*!40101 SET @saved_cs_client     = @@character_set_client */;
172
/*!40101 SET character_set_client = utf8 */;
173
CREATE TABLE "QRTZ_SIMPLE_TRIGGERS" (
174
  "trigger_name" varchar(100) NOT NULL,
175
  "trigger_group" varchar(100) NOT NULL,
176
  "repeat_count" bigint NOT NULL,
177
  "repeat_interval" bigint NOT NULL,
178
  "times_triggered" bigint NOT NULL,
179
  PRIMARY KEY ("trigger_name","trigger_group")
180
);
181
/*!40101 SET character_set_client = @saved_cs_client */;
182

    
183
--
184
-- Table structure for table "QRTZ_TRIGGERS"
185
--
186

    
187
DROP TABLE IF EXISTS "QRTZ_TRIGGERS";
188
/*!40101 SET @saved_cs_client     = @@character_set_client */;
189
/*!40101 SET character_set_client = utf8 */;
190
CREATE TABLE "QRTZ_TRIGGERS" (
191
  "trigger_name" varchar(100) NOT NULL,
192
  "trigger_group" varchar(100) NOT NULL,
193
  "job_name" varchar(100) NOT NULL,
194
  "job_group" varchar(100) NOT NULL,
195
  "is_volatile" varchar(1) NOT NULL,
196
  "description" varchar(255) DEFAULT NULL,
197
  "next_fire_time" bigint DEFAULT NULL,
198
  "prev_fire_time" bigint DEFAULT NULL,
199
  "priority" integer DEFAULT NULL,
200
  "trigger_state" varchar(16) NOT NULL,
201
  "trigger_type" varchar(8) NOT NULL,
202
  "start_time" bigint NOT NULL,
203
  "end_time" bigint DEFAULT NULL,
204
  "calendar_name" varchar(255) DEFAULT NULL,
205
  "misfire_instr" integer DEFAULT NULL,
206
  "job_data" bytea,
207
  PRIMARY KEY ("trigger_name","trigger_group"),
208
  /*KEY "job_name" ("job_name","job_group")*/CHECK (true),
209
  /*KEY "ix_qrtz_nft" ("next_fire_time")*/CHECK (true)
210
);
211
/*!40101 SET character_set_client = @saved_cs_client */;
212

    
213
--
214
-- Table structure for table "QRTZ_TRIGGER_LISTENERS"
215
--
216

    
217
DROP TABLE IF EXISTS "QRTZ_TRIGGER_LISTENERS";
218
/*!40101 SET @saved_cs_client     = @@character_set_client */;
219
/*!40101 SET character_set_client = utf8 */;
220
CREATE TABLE "QRTZ_TRIGGER_LISTENERS" (
221
  "trigger_name" varchar(100) NOT NULL,
222
  "trigger_group" varchar(100) NOT NULL,
223
  "trigger_listener" varchar(100) NOT NULL,
224
  PRIMARY KEY ("trigger_name","trigger_group","trigger_listener")
225
);
226
/*!40101 SET character_set_client = @saved_cs_client */;
227

    
228
--
229
-- Table structure for table "agent"
230
--
231

    
232
DROP TABLE IF EXISTS "agent";
233
/*!40101 SET @saved_cs_client     = @@character_set_client */;
234
/*!40101 SET character_set_client = utf8 */;
235
CREATE TABLE "agent" (
236
  "id" integer NOT NULL,
237
  "name" varchar(255) NOT NULL,
238
  "address" varchar(255) DEFAULT NULL,
239
  "email" varchar(255) DEFAULT NULL,
240
  "telephone" varchar(255) DEFAULT NULL,
241
  "created" text/*datetime*/ DEFAULT NULL,
242
  "modified" text/*datetime*/ DEFAULT NULL,
243
  "deleted" text/*datetime*/ DEFAULT NULL,
244
  PRIMARY KEY ("id")
245
);
246
/*!40101 SET character_set_client = @saved_cs_client */;
247

    
248
--
249
-- Table structure for table "backup_data_provider_nov15_kyle"
250
--
251

    
252
DROP TABLE IF EXISTS "backup_data_provider_nov15_kyle";
253
/*!40101 SET @saved_cs_client     = @@character_set_client */;
254
/*!40101 SET character_set_client = utf8 */;
255
CREATE TABLE "backup_data_provider_nov15_kyle" (
256
  "id" integer NOT NULL,
257
  "name" varchar(255) DEFAULT NULL,
258
  "description" text,
259
  "address" varchar(255) DEFAULT NULL,
260
  "city" varchar(255) DEFAULT NULL,
261
  "at_latitude" float DEFAULT NULL,
262
  "at_longitude" float DEFAULT NULL,
263
  "website_url" varchar(255) DEFAULT NULL,
264
  "logo_url" varchar(255) DEFAULT NULL,
265
  "email" varchar(255) DEFAULT NULL,
266
  "telephone" varchar(255) DEFAULT NULL,
267
  "uuid" char(50) DEFAULT NULL,
268
  "concept_count" integer DEFAULT '0',
269
  "higher_concept_count" integer DEFAULT '0',
270
  "species_count" integer DEFAULT '0',
271
  "occurrence_count" integer DEFAULT '0',
272
  "occurrence_coordinate_count" integer DEFAULT '0',
273
  "created" text/*datetime*/ DEFAULT NULL,
274
  "modified" text/*datetime*/ DEFAULT NULL,
275
  "deleted" text/*datetime*/ DEFAULT NULL,
276
  "iso_country_code" char(2) DEFAULT NULL,
277
  "stated_count_served" integer DEFAULT NULL,
278
  "gbif_approver" varchar(255) DEFAULT NULL,
279
  "lock_description" integer NOT NULL DEFAULT '0',
280
  "lock_iso_country_code" integer NOT NULL DEFAULT '0',
281
  "data_resource_count" integer DEFAULT '0',
282
  PRIMARY KEY ("id"),
283
  /*KEY "IX_data_provider_name" ("name")*/CHECK (true),
284
  /*KEY "IX_data_provider_country" ("iso_country_code")*/CHECK (true)
285
);
286
/*!40101 SET character_set_client = @saved_cs_client */;
287

    
288
--
289
-- Table structure for table "backup_data_resource_nov15_kyle"
290
--
291

    
292
DROP TABLE IF EXISTS "backup_data_resource_nov15_kyle";
293
/*!40101 SET @saved_cs_client     = @@character_set_client */;
294
/*!40101 SET character_set_client = utf8 */;
295
CREATE TABLE "backup_data_resource_nov15_kyle" (
296
  "id" integer NOT NULL,
297
  "data_provider_id" integer NOT NULL,
298
  "name" varchar(255) DEFAULT NULL,
299
  "display_name" varchar(255) DEFAULT NULL,
300
  "description" text,
301
  "rights" text,
302
  "citation" text,
303
  "logo_url" varchar(255) DEFAULT NULL,
304
  "shared_taxonomy" integer DEFAULT '0',
305
  "concept_count" integer DEFAULT '0',
306
  "higher_concept_count" integer DEFAULT '0',
307
  "species_count" integer DEFAULT '0',
308
  "occurrence_count" integer DEFAULT '0',
309
  "occurrence_coordinate_count" integer DEFAULT '0',
310
  "basis_of_record" integer NOT NULL DEFAULT '0',
311
  "created" text/*datetime*/ DEFAULT NULL,
312
  "modified" text/*datetime*/ DEFAULT NULL,
313
  "deleted" text/*datetime*/ DEFAULT NULL,
314
  "citable_agent" varchar(255) DEFAULT NULL,
315
  "root_taxon_rank" integer DEFAULT NULL,
316
  "root_taxon_name" varchar(150) DEFAULT NULL,
317
  "scope_continent_code" char(2) DEFAULT NULL,
318
  "scope_country_code" char(2) DEFAULT NULL,
319
  "provider_record_count" integer DEFAULT NULL,
320
  "taxonomic_priority" integer NOT NULL DEFAULT '100',
321
  "website_url" varchar(255) DEFAULT NULL,
322
  "occurrence_clean_geospatial_count" integer DEFAULT NULL,
323
  "lock_display_name" integer NOT NULL DEFAULT '0',
324
  "lock_citable_agent" integer NOT NULL DEFAULT '0',
325
  "lock_basis_of_record" integer NOT NULL DEFAULT '0',
326
  "override_citation" integer NOT NULL DEFAULT '0',
327
  "gbif_registry_uuid" char(50) DEFAULT NULL,
328
  PRIMARY KEY ("id"),
329
  /*KEY "data_provider_id" ("data_provider_id")*/CHECK (true),
330
  /*KEY "IX_data_resource_name" ("name")*/CHECK (true),
331
  /*KEY "IX_data_resource_display_name" ("display_name")*/CHECK (true),
332
  /*KEY "IX_data_resource_shared_taxonomy" ("shared_taxonomy")*/CHECK (true)
333
);
334
/*!40101 SET character_set_client = @saved_cs_client */;
335

    
336
--
337
-- Table structure for table "bi_relation_tag"
338
--
339

    
340
DROP TABLE IF EXISTS "bi_relation_tag";
341
/*!40101 SET @saved_cs_client     = @@character_set_client */;
342
/*!40101 SET character_set_client = utf8 */;
343
CREATE TABLE "bi_relation_tag" (
344
  "id" integer NOT NULL,
345
  "tag_id" integer DEFAULT NULL,
346
  "to_entity_id" integer DEFAULT NULL,
347
  "from_entity_id" integer DEFAULT NULL,
348
  "count" integer DEFAULT NULL,
349
  "is_system_generated" bit(1) DEFAULT NULL,
350
  PRIMARY KEY ("id"),
351
  /*KEY "tag_id" ("tag_id")*/CHECK (true),
352
  /*KEY "ix_bi_relation_tag_tag_id" ("tag_id")*/CHECK (true),
353
  /*KEY "ix_bi_relation_tag_tag_id_to_entity_id" ("tag_id","to_entity_id")*/CHECK (true),
354
  /*KEY "ix_bi_relation_tag_tag_id_from_entity_id" ("tag_id","from_entity_id")*/CHECK (true)
355
);
356
/*!40101 SET character_set_client = @saved_cs_client */;
357

    
358
--
359
-- Table structure for table "boolean_tag"
360
--
361

    
362
DROP TABLE IF EXISTS "boolean_tag";
363
/*!40101 SET @saved_cs_client     = @@character_set_client */;
364
/*!40101 SET character_set_client = utf8 */;
365
CREATE TABLE "boolean_tag" (
366
  "id" integer NOT NULL,
367
  "tag_id" integer DEFAULT NULL,
368
  "entity_id" integer DEFAULT NULL,
369
  "is_true" integer DEFAULT '0',
370
  "is_system_generated" bit(1) DEFAULT NULL,
371
  PRIMARY KEY ("id"),
372
  /*KEY "tag_id" ("tag_id")*/CHECK (true)
373
);
374
/*!40101 SET character_set_client = @saved_cs_client */;
375

    
376
--
377
-- Table structure for table "catalogue_number"
378
--
379

    
380
DROP TABLE IF EXISTS "catalogue_number";
381
/*!40101 SET @saved_cs_client     = @@character_set_client */;
382
/*!40101 SET character_set_client = utf8 */;
383
CREATE TABLE "catalogue_number" (
384
  "id" integer NOT NULL,
385
  "code" varchar(255) NOT NULL,
386
  PRIMARY KEY ("id"),
387
  /*KEY "ix_cn_catalogue_number" ("code")*/CHECK (true)
388
);
389
/*!40101 SET character_set_client = @saved_cs_client */;
390

    
391
--
392
-- Table structure for table "cell_country"
393
--
394

    
395
DROP TABLE IF EXISTS "cell_country";
396
/*!40101 SET @saved_cs_client     = @@character_set_client */;
397
/*!40101 SET character_set_client = utf8 */;
398
CREATE TABLE "cell_country" (
399
  "cell_id" integer NOT NULL,
400
  "iso_country_code" char(2) NOT NULL,
401
  PRIMARY KEY ("cell_id","iso_country_code"),
402
  /*KEY "IX_cell_ids" ("cell_id")*/CHECK (true),
403
  /*KEY "IX_iso_country_codes" ("iso_country_code")*/CHECK (true)
404
);
405
/*!40101 SET character_set_client = @saved_cs_client */;
406

    
407
--
408
-- Table structure for table "cell_density"
409
--
410

    
411
DROP TABLE IF EXISTS "cell_density";
412
/*!40101 SET @saved_cs_client     = @@character_set_client */;
413
/*!40101 SET character_set_client = utf8 */;
414
CREATE TABLE "cell_density" (
415
  "type" integer NOT NULL,
416
  "entity_id" integer NOT NULL,
417
  "cell_id" integer NOT NULL,
418
  "count" integer DEFAULT NULL,
419
  PRIMARY KEY ("type","entity_id","cell_id")
420
);
421
/*!40101 SET character_set_client = @saved_cs_client */;
422

    
423
--
424
-- Table structure for table "centi_cell_density"
425
--
426

    
427
DROP TABLE IF EXISTS "centi_cell_density";
428
/*!40101 SET @saved_cs_client     = @@character_set_client */;
429
/*!40101 SET character_set_client = utf8 */;
430
CREATE TABLE "centi_cell_density" (
431
  "type" integer NOT NULL,
432
  "entity_id" integer NOT NULL,
433
  "cell_id" integer NOT NULL,
434
  "centi_cell_id" integer NOT NULL,
435
  "count" integer DEFAULT NULL,
436
  PRIMARY KEY ("type","entity_id","cell_id","centi_cell_id")
437
);
438
/*!40101 SET character_set_client = @saved_cs_client */;
439

    
440
--
441
-- Table structure for table "collection_code"
442
--
443

    
444
DROP TABLE IF EXISTS "collection_code";
445
/*!40101 SET @saved_cs_client     = @@character_set_client */;
446
/*!40101 SET character_set_client = utf8 */;
447
CREATE TABLE "collection_code" (
448
  "id" integer NOT NULL,
449
  "code" varchar(255) NOT NULL,
450
  PRIMARY KEY ("id"),
451
  /*KEY "ix_cc_collection_code" ("code")*/CHECK (true)
452
);
453
/*!40101 SET character_set_client = @saved_cs_client */;
454

    
455
--
456
-- Table structure for table "common_name"
457
--
458

    
459
DROP TABLE IF EXISTS "common_name";
460
/*!40101 SET @saved_cs_client     = @@character_set_client */;
461
/*!40101 SET character_set_client = utf8 */;
462
CREATE TABLE "common_name" (
463
  "id" integer NOT NULL,
464
  "taxon_concept_id" integer DEFAULT NULL,
465
  "name" varchar(255) NOT NULL,
466
  "iso_language_code" char(2) DEFAULT NULL,
467
  "language" varchar(255) DEFAULT NULL,
468
  PRIMARY KEY ("id"),
469
  /*KEY "taxon_concept_id" ("taxon_concept_id")*/CHECK (true),
470
  /*KEY "IX_common_name_1" ("name"(50))*/CHECK (true),
471
  /*KEY "IX_common_name_2" ("iso_language_code")*/CHECK (true),
472
  /*KEY "IX_common_name_3" ("language"(100))*/CHECK (true)
473
);
474
/*!40101 SET character_set_client = @saved_cs_client */;
475

    
476
--
477
-- Table structure for table "common_name_orig"
478
--
479

    
480
DROP TABLE IF EXISTS "common_name_orig";
481
/*!40101 SET @saved_cs_client     = @@character_set_client */;
482
/*!40101 SET character_set_client = utf8 */;
483
CREATE TABLE "common_name_orig" (
484
  "id" integer NOT NULL,
485
  "taxon_concept_id" integer DEFAULT NULL,
486
  "name" varchar(255) NOT NULL,
487
  "iso_language_code" char(2) DEFAULT NULL,
488
  "language" varchar(255) DEFAULT NULL,
489
  PRIMARY KEY ("id"),
490
  /*KEY "taxon_concept_id" ("taxon_concept_id")*/CHECK (true),
491
  /*KEY "IX_common_name_1" ("name")*/CHECK (true),
492
  /*KEY "IX_common_name_2" ("iso_language_code")*/CHECK (true),
493
  /*KEY "IX_common_name_3" ("language")*/CHECK (true)
494
);
495
/*!40101 SET character_set_client = @saved_cs_client */;
496

    
497
--
498
-- Table structure for table "country"
499
--
500

    
501
DROP TABLE IF EXISTS "country";
502
/*!40101 SET @saved_cs_client     = @@character_set_client */;
503
/*!40101 SET character_set_client = utf8 */;
504
CREATE TABLE "country" (
505
  "id" integer NOT NULL,
506
  "iso_country_code" char(2) DEFAULT NULL,
507
  "concept_count" integer DEFAULT '0',
508
  "species_count" integer DEFAULT '0',
509
  "occurrence_count" integer DEFAULT '0',
510
  "occurrence_coordinate_count" integer DEFAULT '0',
511
  "continent_code" text CHECK ("continent_code" in ('AF','AS','EU','NA','OC','SA','AN')) DEFAULT NULL,
512
  "region" char(3) DEFAULT NULL,
513
  "min_latitude" float DEFAULT NULL,
514
  "max_latitude" float DEFAULT NULL,
515
  "min_longitude" float DEFAULT NULL,
516
  "max_longitude" float DEFAULT NULL,
517
  PRIMARY KEY ("id"),
518
  /*KEY "IX_country_iso_country_code" ("iso_country_code")*/CHECK (true),
519
  /*KEY "IX_country_continent_code" ("continent_code")*/CHECK (true),
520
  /*KEY "IX_country_region" ("region")*/CHECK (true)
521
);
522
/*!40101 SET character_set_client = @saved_cs_client */;
523

    
524
--
525
-- Table structure for table "country_name"
526
--
527

    
528
DROP TABLE IF EXISTS "country_name";
529
/*!40101 SET @saved_cs_client     = @@character_set_client */;
530
/*!40101 SET character_set_client = utf8 */;
531
CREATE TABLE "country_name" (
532
  "id" integer NOT NULL,
533
  "country_id" integer DEFAULT NULL,
534
  "name" varchar(255) DEFAULT NULL,
535
  "searchable_name" varchar(255) DEFAULT NULL,
536
  "iso_country_code" char(2) DEFAULT NULL,
537
  "locale" char(2) DEFAULT NULL,
538
  PRIMARY KEY ("id"),
539
  /*KEY "country_id" ("country_id")*/CHECK (true),
540
  /*KEY "IX_country_name_name" ("name")*/CHECK (true),
541
  /*KEY "IX_country_name_searchable_name" ("searchable_name")*/CHECK (true),
542
  /*KEY "IX_country_name_iso_country_code" ("iso_country_code")*/CHECK (true),
543
  /*KEY "IX_country_name_locale" ("locale")*/CHECK (true)
544
);
545
/*!40101 SET character_set_client = @saved_cs_client */;
546

    
547
--
548
-- Table structure for table "data_provider"
549
--
550

    
551
DROP TABLE IF EXISTS "data_provider";
552
/*!40101 SET @saved_cs_client     = @@character_set_client */;
553
/*!40101 SET character_set_client = utf8 */;
554
CREATE TABLE "data_provider" (
555
  "id" integer NOT NULL,
556
  "name" varchar(255) DEFAULT NULL,
557
  "description" text,
558
  "address" varchar(255) DEFAULT NULL,
559
  "city" varchar(255) DEFAULT NULL,
560
  "at_latitude" float DEFAULT NULL,
561
  "at_longitude" float DEFAULT NULL,
562
  "website_url" varchar(255) DEFAULT NULL,
563
  "logo_url" varchar(255) DEFAULT NULL,
564
  "email" varchar(255) DEFAULT NULL,
565
  "telephone" varchar(255) DEFAULT NULL,
566
  "uuid" char(50) DEFAULT NULL,
567
  "concept_count" integer DEFAULT '0',
568
  "higher_concept_count" integer DEFAULT '0',
569
  "species_count" integer DEFAULT '0',
570
  "occurrence_count" integer DEFAULT '0',
571
  "occurrence_coordinate_count" integer DEFAULT '0',
572
  "created" text/*datetime*/ DEFAULT NULL,
573
  "modified" text/*datetime*/ DEFAULT NULL,
574
  "deleted" text/*datetime*/ DEFAULT NULL,
575
  "iso_country_code" char(2) DEFAULT NULL,
576
  "stated_count_served" integer DEFAULT NULL,
577
  "gbif_approver" varchar(255) DEFAULT NULL,
578
  "lock_description" integer NOT NULL DEFAULT '0',
579
  "lock_iso_country_code" integer NOT NULL DEFAULT '0',
580
  "data_resource_count" integer DEFAULT '0',
581
  PRIMARY KEY ("id"),
582
  /*KEY "IX_data_provider_name" ("name")*/CHECK (true),
583
  /*KEY "IX_data_provider_country" ("iso_country_code")*/CHECK (true)
584
);
585
/*!40101 SET character_set_client = @saved_cs_client */;
586

    
587
--
588
-- Table structure for table "data_provider_agent"
589
--
590

    
591
DROP TABLE IF EXISTS "data_provider_agent";
592
/*!40101 SET @saved_cs_client     = @@character_set_client */;
593
/*!40101 SET character_set_client = utf8 */;
594
CREATE TABLE "data_provider_agent" (
595
  "id" integer NOT NULL,
596
  "data_provider_id" integer NOT NULL,
597
  "agent_id" integer NOT NULL,
598
  "agent_type" integer NOT NULL,
599
  PRIMARY KEY ("id"),
600
  /*KEY "data_provider_id" ("data_provider_id")*/CHECK (true),
601
  /*KEY "agent_id" ("agent_id")*/CHECK (true)
602
);
603
/*!40101 SET character_set_client = @saved_cs_client */;
604

    
605
--
606
-- Table structure for table "data_resource"
607
--
608

    
609
DROP TABLE IF EXISTS "data_resource";
610
/*!40101 SET @saved_cs_client     = @@character_set_client */;
611
/*!40101 SET character_set_client = utf8 */;
612
CREATE TABLE "data_resource" (
613
  "id" integer NOT NULL,
614
  "data_provider_id" integer NOT NULL,
615
  "name" varchar(255) DEFAULT NULL,
616
  "display_name" varchar(255) DEFAULT NULL,
617
  "description" text,
618
  "rights" text,
619
  "citation" text,
620
  "logo_url" varchar(255) DEFAULT NULL,
621
  "shared_taxonomy" integer DEFAULT '0',
622
  "concept_count" integer DEFAULT '0',
623
  "higher_concept_count" integer DEFAULT '0',
624
  "species_count" integer DEFAULT '0',
625
  "occurrence_count" integer DEFAULT '0',
626
  "occurrence_coordinate_count" integer DEFAULT '0',
627
  "basis_of_record" integer NOT NULL DEFAULT '0',
628
  "created" text/*datetime*/ DEFAULT NULL,
629
  "modified" text/*datetime*/ DEFAULT NULL,
630
  "deleted" text/*datetime*/ DEFAULT NULL,
631
  "citable_agent" varchar(255) DEFAULT NULL,
632
  "root_taxon_rank" integer DEFAULT NULL,
633
  "root_taxon_name" varchar(150) DEFAULT NULL,
634
  "scope_continent_code" char(2) DEFAULT NULL,
635
  "scope_country_code" char(2) DEFAULT NULL,
636
  "provider_record_count" integer DEFAULT NULL,
637
  "taxonomic_priority" integer NOT NULL DEFAULT '100',
638
  "website_url" varchar(255) DEFAULT NULL,
639
  "occurrence_clean_geospatial_count" integer DEFAULT NULL,
640
  "lock_display_name" integer NOT NULL DEFAULT '0',
641
  "lock_citable_agent" integer NOT NULL DEFAULT '0',
642
  "lock_basis_of_record" integer NOT NULL DEFAULT '0',
643
  "override_citation" integer NOT NULL DEFAULT '0',
644
  "gbif_registry_uuid" char(50) DEFAULT NULL,
645
  PRIMARY KEY ("id"),
646
  /*KEY "data_provider_id" ("data_provider_id")*/CHECK (true),
647
  /*KEY "IX_data_resource_name" ("name")*/CHECK (true),
648
  /*KEY "IX_data_resource_display_name" ("display_name")*/CHECK (true),
649
  /*KEY "IX_data_resource_shared_taxonomy" ("shared_taxonomy")*/CHECK (true)
650
);
651
/*!40101 SET character_set_client = @saved_cs_client */;
652

    
653
--
654
-- Table structure for table "data_resource_agent"
655
--
656

    
657
DROP TABLE IF EXISTS "data_resource_agent";
658
/*!40101 SET @saved_cs_client     = @@character_set_client */;
659
/*!40101 SET character_set_client = utf8 */;
660
CREATE TABLE "data_resource_agent" (
661
  "id" integer NOT NULL,
662
  "data_resource_id" integer NOT NULL,
663
  "agent_id" integer NOT NULL,
664
  "agent_type" integer NOT NULL,
665
  PRIMARY KEY ("id"),
666
  /*KEY "data_resource_id" ("data_resource_id")*/CHECK (true),
667
  /*KEY "agent_id" ("agent_id")*/CHECK (true)
668
);
669
/*!40101 SET character_set_client = @saved_cs_client */;
670

    
671
--
672
-- Table structure for table "entity_type"
673
--
674

    
675
DROP TABLE IF EXISTS "entity_type";
676
/*!40101 SET @saved_cs_client     = @@character_set_client */;
677
/*!40101 SET character_set_client = utf8 */;
678
CREATE TABLE "entity_type" (
679
  "id" integer NOT NULL,
680
  "entity_type" varchar(255) DEFAULT NULL,
681
  PRIMARY KEY ("id")
682
);
683
/*!40101 SET character_set_client = @saved_cs_client */;
684

    
685
--
686
-- Table structure for table "gbif_log_message"
687
--
688

    
689
DROP TABLE IF EXISTS "gbif_log_message";
690
/*!40101 SET @saved_cs_client     = @@character_set_client */;
691
/*!40101 SET character_set_client = utf8 */;
692
CREATE TABLE "gbif_log_message" (
693
  "id" integer NOT NULL,
694
  "portal_instance_id" integer DEFAULT NULL,
695
  "log_group_id" integer DEFAULT NULL,
696
  "event_id" integer DEFAULT '0',
697
  "level" integer DEFAULT NULL,
698
  "data_provider_id" integer DEFAULT NULL,
699
  "data_resource_id" integer DEFAULT NULL,
700
  "occurrence_id" integer DEFAULT NULL,
701
  "taxon_concept_id" integer DEFAULT NULL,
702
  "user_id" integer DEFAULT NULL,
703
  "message" text,
704
  "restricted" integer DEFAULT NULL,
705
  "count" integer DEFAULT NULL,
706
  "timestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
707
  PRIMARY KEY ("id"),
708
  /*KEY "log_group_id" ("log_group_id")*/CHECK (true),
709
  /*KEY "portal_instance_id" ("portal_instance_id")*/CHECK (true),
710
  /*KEY "level" ("level")*/CHECK (true),
711
  /*KEY "event_id" ("event_id")*/CHECK (true),
712
  /*KEY "timestamp" ("timestamp")*/CHECK (true),
713
  /*KEY "user_id" ("user_id")*/CHECK (true),
714
  /*KEY "portal_instance_id_2" ("portal_instance_id","log_group_id")*/CHECK (true),
715
  /*KEY "data_resource_id" ("data_resource_id","event_id","timestamp")*/CHECK (true),
716
  /*KEY "data_provider_id" ("data_provider_id","event_id","timestamp")*/CHECK (true),
717
  /*KEY "occurrence_id" ("occurrence_id","event_id","timestamp")*/CHECK (true)
718
);
719
/*!40101 SET character_set_client = @saved_cs_client */;
720

    
721
--
722
-- Table structure for table "gbif_user"
723
--
724

    
725
DROP TABLE IF EXISTS "gbif_user";
726
/*!40101 SET @saved_cs_client     = @@character_set_client */;
727
/*!40101 SET character_set_client = utf8 */;
728
CREATE TABLE "gbif_user" (
729
  "id" integer NOT NULL,
730
  "portal_instance_id" integer NOT NULL,
731
  "name" varchar(255) NOT NULL,
732
  "email" varchar(255) NOT NULL,
733
  "verified" integer NOT NULL DEFAULT '0',
734
  PRIMARY KEY ("id"),
735
  /*KEY "IX_gbif_user_verified" ("verified")*/CHECK (true)
736
);
737
/*!40101 SET character_set_client = @saved_cs_client */;
738

    
739
--
740
-- Table structure for table "geo_mapping"
741
--
742

    
743
DROP TABLE IF EXISTS "geo_mapping";
744
/*!40101 SET @saved_cs_client     = @@character_set_client */;
745
/*!40101 SET character_set_client = utf8 */;
746
CREATE TABLE "geo_mapping" (
747
  "geo_region_id" integer NOT NULL,
748
  "occurrence_id" integer NOT NULL,
749
  PRIMARY KEY ("geo_region_id","occurrence_id")
750
);
751
/*!40101 SET character_set_client = @saved_cs_client */;
752

    
753
--
754
-- Table structure for table "geo_region"
755
--
756

    
757
DROP TABLE IF EXISTS "geo_region";
758
/*!40101 SET @saved_cs_client     = @@character_set_client */;
759
/*!40101 SET character_set_client = utf8 */;
760
CREATE TABLE "geo_region" (
761
  "id" integer NOT NULL DEFAULT '0',
762
  "name" varchar(255) DEFAULT NULL,
763
  "region_type" integer DEFAULT NULL,
764
  "iso_country_code" char(2) DEFAULT NULL,
765
  "concept_count" integer DEFAULT '0',
766
  "species_count" integer DEFAULT '0',
767
  "occurrence_count" integer DEFAULT NULL,
768
  "occurrence_coordinate_count" integer DEFAULT '0',
769
  "min_latitude" float DEFAULT NULL,
770
  "max_latitude" float DEFAULT NULL,
771
  "min_longitude" float DEFAULT NULL,
772
  "max_longitude" float DEFAULT NULL,
773
  PRIMARY KEY ("id"),
774
  /*KEY "ix_geo_region_iso_country_code" ("iso_country_code")*/CHECK (true),
775
  /*KEY "ix_geo_region_name" ("name")*/CHECK (true)
776
);
777
/*!40101 SET character_set_client = @saved_cs_client */;
778

    
779
--
780
-- Table structure for table "geographical_coverage_tag"
781
--
782

    
783
DROP TABLE IF EXISTS "geographical_coverage_tag";
784
/*!40101 SET @saved_cs_client     = @@character_set_client */;
785
/*!40101 SET character_set_client = utf8 */;
786
CREATE TABLE "geographical_coverage_tag" (
787
  "id" integer NOT NULL,
788
  "tag_id" integer DEFAULT NULL,
789
  "entity_id" integer DEFAULT NULL,
790
  "min_longitude" float DEFAULT NULL,
791
  "min_latitude" float DEFAULT NULL,
792
  "max_longitude" float DEFAULT NULL,
793
  "max_latitude" float DEFAULT NULL,
794
  "is_system_generated" bit(1) DEFAULT NULL,
795
  PRIMARY KEY ("id"),
796
  /*KEY "tag_id" ("tag_id")*/CHECK (true)
797
);
798
/*!40101 SET character_set_client = @saved_cs_client */;
799

    
800
--
801
-- Table structure for table "gmba"
802
--
803

    
804
DROP TABLE IF EXISTS "gmba";
805
/*!40101 SET @saved_cs_client     = @@character_set_client */;
806
/*!40101 SET character_set_client = utf8 */;
807
CREATE TABLE "gmba" (
808
  "cellnr" integer DEFAULT NULL,
809
  "latitude" float DEFAULT NULL,
810
  "longitude" float DEFAULT NULL,
811
  "elevation" integer DEFAULT NULL,
812
  "relief" integer DEFAULT NULL,
813
  "continent" integer DEFAULT NULL,
814
  "seadist" integer DEFAULT NULL,
815
  "mtdist" integer DEFAULT NULL,
816
  "vegcode" integer DEFAULT NULL,
817
  "tpcode" integer DEFAULT NULL,
818
  "cell_id" integer DEFAULT NULL,
819
  "tvzcode" integer DEFAULT NULL,
820
  "cell_id2" integer DEFAULT NULL,
821
  /*KEY "relief" ("relief")*/CHECK (true),
822
  /*KEY "cell_id" ("cell_id")*/CHECK (true)
823
);
824
/*!40101 SET character_set_client = @saved_cs_client */;
825

    
826
--
827
-- Table structure for table "identifier_record"
828
--
829

    
830
DROP TABLE IF EXISTS "identifier_record";
831
/*!40101 SET @saved_cs_client     = @@character_set_client */;
832
/*!40101 SET character_set_client = utf8 */;
833
CREATE TABLE "identifier_record" (
834
  "id" integer NOT NULL,
835
  "data_resource_id" integer NOT NULL,
836
  "occurrence_id" integer DEFAULT NULL,
837
  "identifier_type" integer NOT NULL DEFAULT '0',
838
  "identifier" varchar(255) NOT NULL,
839
  PRIMARY KEY ("id"),
840
  /*KEY "ix_identifier_record_occurrence" ("occurrence_id")*/CHECK (true),
841
  /*KEY "id_identifier_record_resource" ("data_resource_id")*/CHECK (true)
842
);
843
/*!40101 SET character_set_client = @saved_cs_client */;
844

    
845
--
846
-- Table structure for table "image_record"
847
--
848

    
849
DROP TABLE IF EXISTS "image_record";
850
/*!40101 SET @saved_cs_client     = @@character_set_client */;
851
/*!40101 SET character_set_client = utf8 */;
852
CREATE TABLE "image_record" (
853
  "id" integer NOT NULL,
854
  "data_resource_id" integer NOT NULL,
855
  "occurrence_id" integer DEFAULT NULL,
856
  "taxon_concept_id" integer DEFAULT NULL,
857
  "raw_image_type" varchar(128) DEFAULT NULL,
858
  "image_type" integer NOT NULL DEFAULT '0',
859
  "url" varchar(255) NOT NULL,
860
  "description" text,
861
  "rights" text,
862
  "html_for_display" text,
863
  PRIMARY KEY ("id"),
864
  /*KEY "ix_image_record_occurrence" ("occurrence_id")*/CHECK (true),
865
  /*KEY "ix_image_record_resource_taxon_concept" ("data_resource_id","taxon_concept_id")*/CHECK (true),
866
  /*KEY "ix_image_record_taxon_concept_id" ("taxon_concept_id")*/CHECK (true)
867
);
868
/*!40101 SET character_set_client = @saved_cs_client */;
869

    
870
--
871
-- Table structure for table "index_data"
872
--
873

    
874
DROP TABLE IF EXISTS "index_data";
875
/*!40101 SET @saved_cs_client     = @@character_set_client */;
876
/*!40101 SET character_set_client = utf8 */;
877
CREATE TABLE "index_data" (
878
  "id" integer NOT NULL,
879
  "resource_access_point_id" integer NOT NULL,
880
  "type" integer DEFAULT NULL,
881
  "lower_value" varchar(255) DEFAULT NULL,
882
  "upper_value" varchar(255) DEFAULT NULL,
883
  "started" text/*datetime*/ DEFAULT NULL,
884
  "finished" text/*datetime*/ DEFAULT NULL,
885
  PRIMARY KEY ("id"),
886
  /*KEY "IX_indexing_data_1" ("resource_access_point_id")*/CHECK (true),
887
  /*KEY "IX_indexing_data_2" ("started")*/CHECK (true)
888
);
889
/*!40101 SET character_set_client = @saved_cs_client */;
890

    
891
--
892
-- Table structure for table "institution_code"
893
--
894

    
895
DROP TABLE IF EXISTS "institution_code";
896
/*!40101 SET @saved_cs_client     = @@character_set_client */;
897
/*!40101 SET character_set_client = utf8 */;
898
CREATE TABLE "institution_code" (
899
  "id" integer NOT NULL,
900
  "code" varchar(255) NOT NULL,
901
  PRIMARY KEY ("id"),
902
  /*KEY "ix_ic_institution_code" ("code")*/CHECK (true)
903
);
904
/*!40101 SET character_set_client = @saved_cs_client */;
905

    
906
--
907
-- Table structure for table "ip_country"
908
--
909

    
910
DROP TABLE IF EXISTS "ip_country";
911
/*!40101 SET @saved_cs_client     = @@character_set_client */;
912
/*!40101 SET character_set_client = utf8 */;
913
CREATE TABLE "ip_country" (
914
  "id" integer NOT NULL,
915
  "start" char(15) NOT NULL,
916
  "end" char(15) NOT NULL,
917
  "start_long" bigint DEFAULT NULL,
918
  "end_long" bigint DEFAULT NULL,
919
  "iso_country_code" char(12) DEFAULT NULL,
920
  PRIMARY KEY ("id"),
921
  /*KEY "IX_ip_country_range" ("start_long","end_long")*/CHECK (true)
922
);
923
/*!40101 SET character_set_client = @saved_cs_client */;
924

    
925
--
926
-- Table structure for table "link_record"
927
--
928

    
929
DROP TABLE IF EXISTS "link_record";
930
/*!40101 SET @saved_cs_client     = @@character_set_client */;
931
/*!40101 SET character_set_client = utf8 */;
932
CREATE TABLE "link_record" (
933
  "id" integer NOT NULL,
934
  "data_resource_id" integer NOT NULL,
935
  "occurrence_id" integer DEFAULT NULL,
936
  "taxon_concept_id" integer DEFAULT NULL,
937
  "raw_link_type" varchar(128) DEFAULT NULL,
938
  "link_type" integer NOT NULL DEFAULT '0',
939
  "url" varchar(255) NOT NULL,
940
  "description" text,
941
  PRIMARY KEY ("id"),
942
  /*KEY "ix_link_record_occurrence" ("occurrence_id")*/CHECK (true),
943
  /*KEY "ix_link_record_taxon_concept" ("taxon_concept_id")*/CHECK (true),
944
  /*KEY "id_link_record_resource" ("data_resource_id")*/CHECK (true)
945
);
946
/*!40101 SET character_set_client = @saved_cs_client */;
947

    
948
--
949
-- Table structure for table "lookup_agent_type"
950
--
951

    
952
DROP TABLE IF EXISTS "lookup_agent_type";
953
/*!40101 SET @saved_cs_client     = @@character_set_client */;
954
/*!40101 SET character_set_client = utf8 */;
955
CREATE TABLE "lookup_agent_type" (
956
  "la_key" integer DEFAULT NULL,
957
  "la_value" varchar(100) DEFAULT NULL
958
);
959
/*!40101 SET character_set_client = @saved_cs_client */;
960

    
961
--
962
-- Table structure for table "lookup_basis_of_record"
963
--
964

    
965
DROP TABLE IF EXISTS "lookup_basis_of_record";
966
/*!40101 SET @saved_cs_client     = @@character_set_client */;
967
/*!40101 SET character_set_client = utf8 */;
968
CREATE TABLE "lookup_basis_of_record" (
969
  "br_key" integer DEFAULT NULL,
970
  "br_value" varchar(100) DEFAULT NULL
971
);
972
/*!40101 SET character_set_client = @saved_cs_client */;
973

    
974
--
975
-- Table structure for table "lookup_cell_density_type"
976
--
977

    
978
DROP TABLE IF EXISTS "lookup_cell_density_type";
979
/*!40101 SET @saved_cs_client     = @@character_set_client */;
980
/*!40101 SET character_set_client = utf8 */;
981
CREATE TABLE "lookup_cell_density_type" (
982
  "cd_key" integer DEFAULT NULL,
983
  "cd_value" varchar(100) DEFAULT NULL
984
);
985
/*!40101 SET character_set_client = @saved_cs_client */;
986

    
987
--
988
-- Table structure for table "lookup_identifier_type"
989
--
990

    
991
DROP TABLE IF EXISTS "lookup_identifier_type";
992
/*!40101 SET @saved_cs_client     = @@character_set_client */;
993
/*!40101 SET character_set_client = utf8 */;
994
CREATE TABLE "lookup_identifier_type" (
995
  "it_key" integer DEFAULT NULL,
996
  "it_value" varchar(100) DEFAULT NULL
997
);
998
/*!40101 SET character_set_client = @saved_cs_client */;
999

    
1000
--
1001
-- Table structure for table "lookup_image_type"
1002
--
1003

    
1004
DROP TABLE IF EXISTS "lookup_image_type";
1005
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1006
/*!40101 SET character_set_client = utf8 */;
1007
CREATE TABLE "lookup_image_type" (
1008
  "im_key" integer DEFAULT NULL,
1009
  "im_value" varchar(100) DEFAULT NULL
1010
);
1011
/*!40101 SET character_set_client = @saved_cs_client */;
1012

    
1013
--
1014
-- Table structure for table "lookup_link_type"
1015
--
1016

    
1017
DROP TABLE IF EXISTS "lookup_link_type";
1018
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1019
/*!40101 SET character_set_client = utf8 */;
1020
CREATE TABLE "lookup_link_type" (
1021
  "li_key" integer DEFAULT NULL,
1022
  "li_value" varchar(100) DEFAULT NULL
1023
);
1024
/*!40101 SET character_set_client = @saved_cs_client */;
1025

    
1026
--
1027
-- Table structure for table "lookup_log_event_type"
1028
--
1029

    
1030
DROP TABLE IF EXISTS "lookup_log_event_type";
1031
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1032
/*!40101 SET character_set_client = utf8 */;
1033
CREATE TABLE "lookup_log_event_type" (
1034
  "le_key" integer DEFAULT NULL,
1035
  "le_value" varchar(100) DEFAULT NULL
1036
);
1037
/*!40101 SET character_set_client = @saved_cs_client */;
1038

    
1039
--
1040
-- Table structure for table "lookup_quad_relation_entity"
1041
--
1042

    
1043
DROP TABLE IF EXISTS "lookup_quad_relation_entity";
1044
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1045
/*!40101 SET character_set_client = utf8 */;
1046
CREATE TABLE "lookup_quad_relation_entity" (
1047
  "qe_attribute" varchar(25) DEFAULT NULL,
1048
  "qe_resolution" varchar(100) DEFAULT NULL
1049
);
1050
/*!40101 SET character_set_client = @saved_cs_client */;
1051

    
1052
--
1053
-- Table structure for table "lookup_relationship_assertion_type"
1054
--
1055

    
1056
DROP TABLE IF EXISTS "lookup_relationship_assertion_type";
1057
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1058
/*!40101 SET character_set_client = utf8 */;
1059
CREATE TABLE "lookup_relationship_assertion_type" (
1060
  "ra_key" integer DEFAULT NULL,
1061
  "ra_value" varchar(100) DEFAULT NULL
1062
);
1063
/*!40101 SET character_set_client = @saved_cs_client */;
1064

    
1065
--
1066
-- Table structure for table "lookup_remote_concept_remote_id"
1067
--
1068

    
1069
DROP TABLE IF EXISTS "lookup_remote_concept_remote_id";
1070
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1071
/*!40101 SET character_set_client = utf8 */;
1072
CREATE TABLE "lookup_remote_concept_remote_id" (
1073
  "rc_key" integer DEFAULT NULL,
1074
  "rc_value" varchar(100) DEFAULT NULL
1075
);
1076
/*!40101 SET character_set_client = @saved_cs_client */;
1077

    
1078
--
1079
-- Table structure for table "namespace_mapping"
1080
--
1081

    
1082
DROP TABLE IF EXISTS "namespace_mapping";
1083
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1084
/*!40101 SET character_set_client = utf8 */;
1085
CREATE TABLE "namespace_mapping" (
1086
  "resource_access_point_id" integer NOT NULL,
1087
  "property_store_namespace_id" integer NOT NULL,
1088
  "priority" integer NOT NULL,
1089
  PRIMARY KEY ("property_store_namespace_id","resource_access_point_id"),
1090
  /*KEY "property_store_namespace_id" ("property_store_namespace_id")*/CHECK (true),
1091
  /*KEY "resource_access_point_id" ("resource_access_point_id")*/CHECK (true)
1092
);
1093
/*!40101 SET character_set_client = @saved_cs_client */;
1094

    
1095
--
1096
-- Table structure for table "network_membership"
1097
--
1098

    
1099
DROP TABLE IF EXISTS "network_membership";
1100
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1101
/*!40101 SET character_set_client = utf8 */;
1102
CREATE TABLE "network_membership" (
1103
  "id" integer NOT NULL,
1104
  "data_resource_id" integer NOT NULL,
1105
  "resource_network_id" integer NOT NULL,
1106
  PRIMARY KEY ("id"),
1107
  /*KEY "data_resource_id" ("data_resource_id")*/CHECK (true),
1108
  /*KEY "resource_network_id" ("resource_network_id")*/CHECK (true),
1109
  /*KEY "IX_network_membership_id" ("id")*/CHECK (true)
1110
);
1111
/*!40101 SET character_set_client = @saved_cs_client */;
1112

    
1113
--
1114
-- Table structure for table "number_tag"
1115
--
1116

    
1117
DROP TABLE IF EXISTS "number_tag";
1118
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1119
/*!40101 SET character_set_client = utf8 */;
1120
CREATE TABLE "number_tag" (
1121
  "id" integer NOT NULL,
1122
  "tag_id" integer DEFAULT NULL,
1123
  "entity_id" integer DEFAULT NULL,
1124
  "value" float DEFAULT NULL,
1125
  "is_system_generated" bit(1) DEFAULT NULL,
1126
  PRIMARY KEY ("id"),
1127
  /*KEY "tag_id" ("tag_id")*/CHECK (true)
1128
);
1129
/*!40101 SET character_set_client = @saved_cs_client */;
1130

    
1131
--
1132
-- Table structure for table "occurrence_record"
1133
--
1134

    
1135
DROP TABLE IF EXISTS "occurrence_record";
1136
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1137
/*!40101 SET character_set_client = utf8 */;
1138
CREATE TABLE "occurrence_record" (
1139
  "id" integer NOT NULL,
1140
  "data_provider_id" integer NOT NULL,
1141
  "data_resource_id" integer NOT NULL,
1142
  "institution_code_id" integer DEFAULT NULL,
1143
  "collection_code_id" integer NOT NULL,
1144
  "catalogue_number_id" integer NOT NULL,
1145
  "taxon_concept_id" integer NOT NULL,
1146
  "taxon_name_id" integer NOT NULL,
1147
  "kingdom_concept_id" integer DEFAULT NULL,
1148
  "phylum_concept_id" integer DEFAULT NULL,
1149
  "class_concept_id" integer DEFAULT NULL,
1150
  "order_concept_id" integer DEFAULT NULL,
1151
  "family_concept_id" integer DEFAULT NULL,
1152
  "genus_concept_id" integer DEFAULT NULL,
1153
  "species_concept_id" integer DEFAULT NULL,
1154
  "nub_concept_id" integer DEFAULT NULL,
1155
  "iso_country_code" char(2) DEFAULT NULL,
1156
  "latitude" float DEFAULT NULL,
1157
  "longitude" float DEFAULT NULL,
1158
  "cell_id" integer DEFAULT NULL,
1159
  "centi_cell_id" integer DEFAULT NULL,
1160
  "mod360_cell_id" integer DEFAULT NULL,
1161
  "year" integer DEFAULT NULL,
1162
  "month" integer DEFAULT NULL,
1163
  "occurrence_date" text/*date*/ DEFAULT NULL,
1164
  "basis_of_record" integer NOT NULL DEFAULT '0',
1165
  "taxonomic_issue" integer NOT NULL DEFAULT '0',
1166
  "geospatial_issue" integer DEFAULT NULL,
1167
  "other_issue" integer NOT NULL DEFAULT '0',
1168
  "deleted" text/*timestamp*/ NULL DEFAULT NULL,
1169
  "altitude_metres" integer DEFAULT NULL,
1170
  "depth_centimetres" integer DEFAULT NULL,
1171
  "modified" text/*timestamp*/ NULL DEFAULT NULL,
1172
  PRIMARY KEY ("id"),
1173
  /*KEY "ix_or_data_provider_id" ("data_provider_id")*/CHECK (true),
1174
  /*KEY "ix_or_data_resource_id" ("data_resource_id")*/CHECK (true),
1175
  /*KEY "ix_or_institution_code" ("institution_code_id")*/CHECK (true),
1176
  /*KEY "ix_or_collection_code" ("collection_code_id")*/CHECK (true),
1177
  /*KEY "ix_or_catalogue_number" ("catalogue_number_id")*/CHECK (true),
1178
  /*KEY "ix_or_taxon_concept_id" ("taxon_concept_id")*/CHECK (true),
1179
  /*KEY "ix_or_taxon_name_id" ("taxon_name_id")*/CHECK (true),
1180
  /*KEY "ix_or_iso_country_code" ("iso_country_code")*/CHECK (true),
1181
  /*KEY "ix_or_occurrence_date" ("occurrence_date")*/CHECK (true),
1182
  /*KEY "ix_or_month" ("month")*/CHECK (true),
1183
  /*KEY "ix_or_year" ("year")*/CHECK (true),
1184
  /*KEY "ix_or_k_cell_mod_cell" ("kingdom_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1185
  /*KEY "ix_or_p_cell_mod_cell" ("phylum_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1186
  /*KEY "ix_or_c_cell_mod_cell" ("class_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1187
  /*KEY "ix_or_o_cell_mod_cell" ("order_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1188
  /*KEY "ix_or_f_cell_mod_cell" ("family_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1189
  /*KEY "ix_or_g_cell_mod_cell" ("genus_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1190
  /*KEY "ix_or_s_cell_mod_cell" ("species_concept_id","cell_id","mod360_cell_id")*/CHECK (true),
1191
  /*KEY "ix_or_cell_mod_cell_nub" ("cell_id","mod360_cell_id","nub_concept_id")*/CHECK (true),
1192
  /*KEY "ix_or_nub_country" ("nub_concept_id","iso_country_code")*/CHECK (true),
1193
  /*KEY "ix_or_altitude_metres" ("altitude_metres")*/CHECK (true),
1194
  /*KEY "ix_or_depth_centimetres" ("depth_centimetres")*/CHECK (true)
1195
);
1196
/*!40101 SET character_set_client = @saved_cs_client */;
1197

    
1198
--
1199
-- Table structure for table "property_store_namespace"
1200
--
1201

    
1202
DROP TABLE IF EXISTS "property_store_namespace";
1203
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1204
/*!40101 SET character_set_client = utf8 */;
1205
CREATE TABLE "property_store_namespace" (
1206
  "id" integer NOT NULL,
1207
  "namespace" varchar(255) DEFAULT NULL,
1208
  PRIMARY KEY ("id")
1209
);
1210
/*!40101 SET character_set_client = @saved_cs_client */;
1211

    
1212
--
1213
-- Table structure for table "quad_relation_tag"
1214
--
1215

    
1216
DROP TABLE IF EXISTS "quad_relation_tag";
1217
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1218
/*!40101 SET character_set_client = utf8 */;
1219
CREATE TABLE "quad_relation_tag" (
1220
  "id" integer NOT NULL,
1221
  "tag_id" integer DEFAULT NULL,
1222
  "entity1_id" integer DEFAULT NULL,
1223
  "entity2_id" integer DEFAULT NULL,
1224
  "entity3_id" integer DEFAULT NULL,
1225
  "entity4_id" integer DEFAULT NULL,
1226
  "count" integer DEFAULT NULL,
1227
  "rollover_id" integer DEFAULT NULL,
1228
  PRIMARY KEY ("id"),
1229
  /*KEY "entity1_id" ("entity1_id","entity2_id")*/CHECK (true)
1230
);
1231
/*!40101 SET character_set_client = @saved_cs_client */;
1232

    
1233
--
1234
-- Table structure for table "rank"
1235
--
1236

    
1237
DROP TABLE IF EXISTS "rank";
1238
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1239
/*!40101 SET character_set_client = utf8 */;
1240
CREATE TABLE "rank" (
1241
  "id" integer NOT NULL,
1242
  "name" char(50) DEFAULT NULL,
1243
  PRIMARY KEY ("id"),
1244
  /*KEY "IX_rank_1" ("name")*/CHECK (true)
1245
);
1246
/*!40101 SET character_set_client = @saved_cs_client */;
1247

    
1248
--
1249
-- Table structure for table "raw_occurrence_record"
1250
--
1251

    
1252
DROP TABLE IF EXISTS "raw_occurrence_record";
1253
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1254
/*!40101 SET character_set_client = utf8 */;
1255
CREATE TABLE "raw_occurrence_record" (
1256
  "id" integer NOT NULL,
1257
  "data_provider_id" integer DEFAULT NULL,
1258
  "data_resource_id" integer DEFAULT NULL,
1259
  "resource_access_point_id" integer DEFAULT NULL,
1260
  "institution_code" varchar(255) DEFAULT NULL,
1261
  "collection_code" varchar(255) DEFAULT NULL,
1262
  "catalogue_number" varchar(255) DEFAULT NULL,
1263
  "scientific_name" varchar(255) DEFAULT NULL,
1264
  "author" varchar(255) DEFAULT NULL,
1265
  "rank" varchar(50) DEFAULT NULL,
1266
  "kingdom" varchar(150) DEFAULT NULL,
1267
  "phylum" varchar(150) DEFAULT NULL,
1268
  "class" varchar(250) DEFAULT NULL,
1269
  "order_rank" varchar(50) DEFAULT NULL,
1270
  "family" varchar(250) DEFAULT NULL,
1271
  "genus" varchar(150) DEFAULT NULL,
1272
  "species" varchar(150) DEFAULT NULL,
1273
  "subspecies" varchar(150) DEFAULT NULL,
1274
  "latitude" varchar(50) DEFAULT NULL,
1275
  "longitude" varchar(50) DEFAULT NULL,
1276
  "lat_long_precision" varchar(50) DEFAULT NULL,
1277
  "max_altitude" varchar(50) DEFAULT NULL,
1278
  "min_altitude" varchar(50) DEFAULT NULL,
1279
  "altitude_precision" varchar(50) DEFAULT NULL,
1280
  "min_depth" varchar(50) DEFAULT NULL,
1281
  "max_depth" varchar(50) DEFAULT NULL,
1282
  "depth_precision" varchar(50) DEFAULT NULL,
1283
  "continent_ocean" varchar(100) DEFAULT NULL,
1284
  "country" varchar(100) DEFAULT NULL,
1285
  "state_province" varchar(100) DEFAULT NULL,
1286
  "county" varchar(100) DEFAULT NULL,
1287
  "collector_name" varchar(255) DEFAULT NULL,
1288
  "locality" text,
1289
  "year" varchar(50) DEFAULT NULL,
1290
  "month" varchar(50) DEFAULT NULL,
1291
  "day" varchar(50) DEFAULT NULL,
1292
  "basis_of_record" varchar(100) DEFAULT NULL,
1293
  "identifier_name" varchar(255) DEFAULT NULL,
1294
  "identification_date" text/*datetime*/ DEFAULT NULL,
1295
  "unit_qualifier" varchar(255) DEFAULT NULL,
1296
  "created" text/*timestamp*/ NULL DEFAULT NULL,
1297
  "modified" text/*timestamp*/ NULL DEFAULT NULL,
1298
  "deleted" text/*timestamp*/ NULL DEFAULT NULL,
1299
  PRIMARY KEY ("id"),
1300
  /*KEY "primarykey" ("id")*/CHECK (true),
1301
  /*KEY "created" ("created","modified")*/CHECK (true),
1302
  /*KEY "resource_access_point_id" ("resource_access_point_id","id")*/CHECK (true),
1303
  /*KEY "data_resource_id" ("data_resource_id","catalogue_number"(50),"collection_code"(10),"institution_code"(10))*/CHECK (true)
1304
);
1305
/*!40101 SET character_set_client = @saved_cs_client */;
1306

    
1307
--
1308
-- Table structure for table "registration_login"
1309
--
1310

    
1311
DROP TABLE IF EXISTS "registration_login";
1312
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1313
/*!40101 SET character_set_client = utf8 */;
1314
CREATE TABLE "registration_login" (
1315
  "id" integer NOT NULL,
1316
  "login_id" varchar(255) DEFAULT NULL,
1317
  "business_key" varchar(255) DEFAULT NULL,
1318
  PRIMARY KEY ("id"),
1319
  /*KEY "IX_registration_login_login_id" ("login_id")*/CHECK (true),
1320
  /*KEY "IX_registration_login_business_key" ("business_key")*/CHECK (true)
1321
);
1322
/*!40101 SET character_set_client = @saved_cs_client */;
1323

    
1324
--
1325
-- Table structure for table "relationship_assertion"
1326
--
1327

    
1328
DROP TABLE IF EXISTS "relationship_assertion";
1329
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1330
/*!40101 SET character_set_client = utf8 */;
1331
CREATE TABLE "relationship_assertion" (
1332
  "from_concept_id" integer NOT NULL,
1333
  "to_concept_id" integer NOT NULL,
1334
  "relationship_type" integer NOT NULL,
1335
  PRIMARY KEY ("from_concept_id","to_concept_id","relationship_type"),
1336
  /*KEY "from_concept_id" ("from_concept_id")*/CHECK (true),
1337
  /*KEY "IX_relationship_assertion_1" ("relationship_type")*/CHECK (true),
1338
  /*KEY "IX_TO_CONCEPT_ID" ("to_concept_id")*/CHECK (true)
1339
);
1340
/*!40101 SET character_set_client = @saved_cs_client */;
1341

    
1342
--
1343
-- Table structure for table "remote_concept"
1344
--
1345

    
1346
DROP TABLE IF EXISTS "remote_concept";
1347
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1348
/*!40101 SET character_set_client = utf8 */;
1349
CREATE TABLE "remote_concept" (
1350
  "id" integer NOT NULL,
1351
  "taxon_concept_id" integer NOT NULL,
1352
  "remote_id" varchar(255) DEFAULT NULL,
1353
  "id_type" integer NOT NULL,
1354
  "modified" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
1355
  PRIMARY KEY ("id"),
1356
  /*KEY "ix_remote_concept_remote_id" ("remote_id")*/CHECK (true),
1357
  /*KEY "ix_remote_concept_tc_id" ("taxon_concept_id")*/CHECK (true)
1358
);
1359
/*!40101 SET character_set_client = @saved_cs_client */;
1360

    
1361
--
1362
-- Table structure for table "resource_access_point"
1363
--
1364

    
1365
DROP TABLE IF EXISTS "resource_access_point";
1366
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1367
/*!40101 SET character_set_client = utf8 */;
1368
CREATE TABLE "resource_access_point" (
1369
  "id" integer NOT NULL,
1370
  "data_provider_id" integer DEFAULT NULL,
1371
  "data_resource_id" integer DEFAULT NULL,
1372
  "url" varchar(255) DEFAULT NULL,
1373
  "remote_id_at_url" varchar(255) DEFAULT NULL,
1374
  "uuid" char(50) DEFAULT NULL,
1375
  "created" text/*datetime*/ DEFAULT NULL,
1376
  "modified" text/*datetime*/ DEFAULT NULL,
1377
  "deleted" text/*datetime*/ DEFAULT NULL,
1378
  "last_harvest_start" text/*datetime*/ DEFAULT NULL,
1379
  "last_extract_start" text/*datetime*/ DEFAULT NULL,
1380
  "supports_date_last_modified" integer NOT NULL DEFAULT '0',
1381
  "interval_metadata_days" integer DEFAULT NULL,
1382
  "interval_harvest_days" integer DEFAULT NULL,
1383
  PRIMARY KEY ("id"),
1384
  /*KEY "data_provider_id" ("data_provider_id")*/CHECK (true),
1385
  /*KEY "ix_rap_dr" ("data_resource_id")*/CHECK (true)
1386
);
1387
/*!40101 SET character_set_client = @saved_cs_client */;
1388

    
1389
--
1390
-- Table structure for table "resource_country"
1391
--
1392

    
1393
DROP TABLE IF EXISTS "resource_country";
1394
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1395
/*!40101 SET character_set_client = utf8 */;
1396
CREATE TABLE "resource_country" (
1397
  "data_resource_id" integer NOT NULL,
1398
  "iso_country_code" char(2) NOT NULL,
1399
  "count" integer DEFAULT NULL,
1400
  "occurrence_coordinate_count" integer DEFAULT '0',
1401
  PRIMARY KEY ("data_resource_id","iso_country_code"),
1402
  /*KEY "IX_data_resource_ids" ("data_resource_id")*/CHECK (true),
1403
  /*KEY "IX_iso_country_codes" ("iso_country_code")*/CHECK (true)
1404
);
1405
/*!40101 SET character_set_client = @saved_cs_client */;
1406

    
1407
--
1408
-- Table structure for table "resource_network"
1409
--
1410

    
1411
DROP TABLE IF EXISTS "resource_network";
1412
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1413
/*!40101 SET character_set_client = utf8 */;
1414
CREATE TABLE "resource_network" (
1415
  "id" integer NOT NULL,
1416
  "name" varchar(255) DEFAULT NULL,
1417
  "code" varchar(50) DEFAULT NULL,
1418
  "description" text,
1419
  "address" varchar(255) DEFAULT NULL,
1420
  "website_url" varchar(255) DEFAULT NULL,
1421
  "logo_url" varchar(255) DEFAULT NULL,
1422
  "email" varchar(255) DEFAULT NULL,
1423
  "telephone" varchar(255) DEFAULT NULL,
1424
  "concept_count" integer DEFAULT '0',
1425
  "species_count" integer DEFAULT '0',
1426
  "occurrence_count" integer DEFAULT '0',
1427
  "occurrence_coordinate_count" integer DEFAULT '0',
1428
  "created" text/*datetime*/ DEFAULT NULL,
1429
  "modified" text/*datetime*/ DEFAULT NULL,
1430
  "deleted" text/*datetime*/ DEFAULT NULL,
1431
  "data_resource_count" integer DEFAULT '0',
1432
  PRIMARY KEY ("id"),
1433
  /*KEY "IX_resource_network_name" ("name")*/CHECK (true)
1434
);
1435
/*!40101 SET character_set_client = @saved_cs_client */;
1436

    
1437
--
1438
-- Table structure for table "resource_rank"
1439
--
1440

    
1441
DROP TABLE IF EXISTS "resource_rank";
1442
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1443
/*!40101 SET character_set_client = utf8 */;
1444
CREATE TABLE "resource_rank" (
1445
  "id" integer NOT NULL,
1446
  "resource_type" integer DEFAULT NULL,
1447
  "entity_id" integer DEFAULT NULL,
1448
  "entity_type" integer DEFAULT NULL,
1449
  "rank" integer DEFAULT NULL,
1450
  PRIMARY KEY ("id"),
1451
  /*KEY "IX_resource_rank_type" ("resource_type")*/CHECK (true),
1452
  /*KEY "IX_resource_rank_entity_id" ("entity_id")*/CHECK (true),
1453
  /*KEY "IX_resource_rank_entity_type" ("entity_type")*/CHECK (true),
1454
  /*KEY "IX_resource_rank_rank" ("rank")*/CHECK (true)
1455
);
1456
/*!40101 SET character_set_client = @saved_cs_client */;
1457

    
1458
--
1459
-- Table structure for table "rollover"
1460
--
1461

    
1462
DROP TABLE IF EXISTS "rollover";
1463
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1464
/*!40101 SET character_set_client = utf8 */;
1465
CREATE TABLE "rollover" (
1466
  "id" integer NOT NULL,
1467
  "rollover_date" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
1468
  PRIMARY KEY ("id")
1469
);
1470
/*!40101 SET character_set_client = @saved_cs_client */;
1471

    
1472
--
1473
-- Table structure for table "stats_country_contribution"
1474
--
1475

    
1476
DROP TABLE IF EXISTS "stats_country_contribution";
1477
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1478
/*!40101 SET character_set_client = utf8 */;
1479
CREATE TABLE "stats_country_contribution" (
1480
  "id" integer NOT NULL,
1481
  "rollover_id" integer NOT NULL,
1482
  "iso_country_code" char(2) DEFAULT NULL,
1483
  "provider_count" integer DEFAULT '0',
1484
  "dataset_count" integer DEFAULT '0',
1485
  "occurrence_count" integer DEFAULT '0',
1486
  "occurrence_georeferenced_count" integer DEFAULT '0',
1487
  "created" text/*datetime*/ DEFAULT NULL,
1488
  PRIMARY KEY ("id")
1489
);
1490
/*!40101 SET character_set_client = @saved_cs_client */;
1491

    
1492
--
1493
-- Table structure for table "stats_participant_contribution"
1494
--
1495

    
1496
DROP TABLE IF EXISTS "stats_participant_contribution";
1497
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1498
/*!40101 SET character_set_client = utf8 */;
1499
CREATE TABLE "stats_participant_contribution" (
1500
  "id" integer NOT NULL,
1501
  "rollover_id" integer NOT NULL,
1502
  "gbif_approver" varchar(255) DEFAULT NULL,
1503
  "provider_count" integer DEFAULT '0',
1504
  "dataset_count" integer DEFAULT '0',
1505
  "occurrence_count" integer DEFAULT '0',
1506
  "occurrence_georeferenced_count" integer DEFAULT '0',
1507
  "created" text/*datetime*/ DEFAULT NULL,
1508
  PRIMARY KEY ("id")
1509
);
1510
/*!40101 SET character_set_client = @saved_cs_client */;
1511

    
1512
--
1513
-- Table structure for table "stats_participant_data_usage"
1514
--
1515

    
1516
DROP TABLE IF EXISTS "stats_participant_data_usage";
1517
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1518
/*!40101 SET character_set_client = utf8 */;
1519
CREATE TABLE "stats_participant_data_usage" (
1520
  "gbif_approver" varchar(150) DEFAULT NULL,
1521
  "month" varchar(50) DEFAULT NULL,
1522
  "year" varchar(50) DEFAULT NULL,
1523
  "search_event_count" integer DEFAULT '0',
1524
  "search_record_count" integer DEFAULT '0',
1525
  "occurrence_detail_page_view" integer DEFAULT '0',
1526
  "download_event_count" integer DEFAULT '0',
1527
  "download_record_count" integer DEFAULT '0'
1528
);
1529
/*!40101 SET character_set_client = @saved_cs_client */;
1530

    
1531
--
1532
-- Table structure for table "string_tag"
1533
--
1534

    
1535
DROP TABLE IF EXISTS "string_tag";
1536
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1537
/*!40101 SET character_set_client = utf8 */;
1538
CREATE TABLE "string_tag" (
1539
  "id" integer NOT NULL,
1540
  "tag_id" integer DEFAULT NULL,
1541
  "entity_id" integer DEFAULT NULL,
1542
  "value" text,
1543
  "is_system_generated" bit(1) DEFAULT NULL,
1544
  PRIMARY KEY ("id"),
1545
  /*KEY "tag_id" ("tag_id")*/CHECK (true)
1546
);
1547
/*!40101 SET character_set_client = @saved_cs_client */;
1548

    
1549
--
1550
-- Table structure for table "tag"
1551
--
1552

    
1553
DROP TABLE IF EXISTS "tag";
1554
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1555
/*!40101 SET character_set_client = utf8 */;
1556
CREATE TABLE "tag" (
1557
  "id" integer NOT NULL,
1558
  "name" char(200) DEFAULT NULL,
1559
  "entity_type" integer DEFAULT NULL,
1560
  "tag_table" char(30) DEFAULT NULL,
1561
  "description" varchar(255) DEFAULT NULL,
1562
  PRIMARY KEY ("id")
1563
);
1564
/*!40101 SET character_set_client = @saved_cs_client */;
1565

    
1566
--
1567
-- Table structure for table "taxon_concept"
1568
--
1569

    
1570
DROP TABLE IF EXISTS "taxon_concept";
1571
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1572
/*!40101 SET character_set_client = utf8 */;
1573
CREATE TABLE "taxon_concept" (
1574
  "id" integer NOT NULL DEFAULT '0',
1575
  "rank" integer NOT NULL,
1576
  "taxon_name_id" integer NOT NULL,
1577
  "data_provider_id" integer NOT NULL,
1578
  "data_resource_id" integer NOT NULL,
1579
  "parent_concept_id" integer DEFAULT NULL,
1580
  "kingdom_concept_id" integer DEFAULT NULL,
1581
  "phylum_concept_id" integer DEFAULT NULL,
1582
  "class_concept_id" integer DEFAULT NULL,
1583
  "order_concept_id" integer DEFAULT NULL,
1584
  "family_concept_id" integer DEFAULT NULL,
1585
  "genus_concept_id" integer DEFAULT NULL,
1586
  "species_concept_id" integer DEFAULT NULL,
1587
  "is_accepted" integer DEFAULT '1',
1588
  "is_nub_concept" integer DEFAULT '0',
1589
  "partner_concept_id" integer DEFAULT NULL,
1590
  "priority" integer NOT NULL DEFAULT '100',
1591
  "is_secondary" integer DEFAULT '0',
1592
  "created" text/*timestamp*/ NULL DEFAULT NULL,
1593
  "modified" text/*timestamp*/ NULL DEFAULT NULL,
1594
  "deleted" text/*timestamp*/ NULL DEFAULT NULL,
1595
  PRIMARY KEY ("id"),
1596
  /*KEY "ix_taxon_concept_dr_rank" ("data_resource_id","rank")*/CHECK (true),
1597
  /*KEY "ix_taxon_concept_partner_dr" ("partner_concept_id","data_resource_id")*/CHECK (true),
1598
  /*KEY "ix_taxon_concept_tn_dr" ("taxon_name_id","data_resource_id")*/CHECK (true),
1599
  /*KEY "ix_taxon_concept_parent" ("parent_concept_id")*/CHECK (true),
1600
  /*KEY "ix_taxon_concept_k" ("kingdom_concept_id")*/CHECK (true),
1601
  /*KEY "ix_taxon_concept_p" ("phylum_concept_id")*/CHECK (true),
1602
  /*KEY "ix_taxon_concept_c" ("class_concept_id")*/CHECK (true),
1603
  /*KEY "ix_taxon_concept_o" ("order_concept_id")*/CHECK (true),
1604
  /*KEY "ix_taxon_concept_f" ("family_concept_id")*/CHECK (true),
1605
  /*KEY "ix_taxon_concept_g" ("genus_concept_id")*/CHECK (true),
1606
  /*KEY "ix_taxon_concept_s" ("species_concept_id")*/CHECK (true),
1607
  /*KEY "ix_taxon_concept_dp" ("data_provider_id")*/CHECK (true),
1608
  /*KEY "ix_taxon_concept_dp_rank" ("data_provider_id","rank")*/CHECK (true)
1609
);
1610
/*!40101 SET character_set_client = @saved_cs_client */;
1611

    
1612
--
1613
-- Table structure for table "taxon_country"
1614
--
1615

    
1616
DROP TABLE IF EXISTS "taxon_country";
1617
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1618
/*!40101 SET character_set_client = utf8 */;
1619
CREATE TABLE "taxon_country" (
1620
  "taxon_concept_id" integer NOT NULL,
1621
  "iso_country_code" char(2) NOT NULL,
1622
  "count" integer DEFAULT NULL,
1623
  PRIMARY KEY ("taxon_concept_id","iso_country_code"),
1624
  /*KEY "IX_taxon_concept_ids" ("taxon_concept_id")*/CHECK (true),
1625
  /*KEY "IX_iso_country_codes" ("iso_country_code")*/CHECK (true)
1626
);
1627
/*!40101 SET character_set_client = @saved_cs_client */;
1628

    
1629
--
1630
-- Table structure for table "taxon_name"
1631
--
1632

    
1633
DROP TABLE IF EXISTS "taxon_name";
1634
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1635
/*!40101 SET character_set_client = utf8 */;
1636
CREATE TABLE "taxon_name" (
1637
  "id" integer NOT NULL,
1638
  "canonical" text,
1639
  "supra_generic" varchar(255) DEFAULT NULL,
1640
  "generic" varchar(255) DEFAULT NULL,
1641
  "infrageneric" varchar(255) DEFAULT NULL,
1642
  "specific_epithet" varchar(255) DEFAULT NULL,
1643
  "infraspecific" varchar(255) DEFAULT NULL,
1644
  "infraspecific_marker" varchar(255) DEFAULT NULL,
1645
  "is_hybrid" integer DEFAULT NULL,
1646
  "rank" integer NOT NULL,
1647
  "author" varchar(255) DEFAULT NULL,
1648
  "searchable_canonical" text,
1649
  PRIMARY KEY ("id"),
1650
  /*KEY "IX_taxon_name_specific_epithet" ("specific_epithet")*/CHECK (true),
1651
  /*KEY "ix_taxon_name_canonical_rank" ("canonical"(50),"rank")*/CHECK (true),
1652
  /*KEY "ix_taxon_name_searchable_canonical_rank" ("searchable_canonical"(50),"rank")*/CHECK (true)
1653
);
1654
/*!40101 SET character_set_client = @saved_cs_client */;
1655

    
1656
--
1657
-- Table structure for table "temporal_coverage_tag"
1658
--
1659

    
1660
DROP TABLE IF EXISTS "temporal_coverage_tag";
1661
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1662
/*!40101 SET character_set_client = utf8 */;
1663
CREATE TABLE "temporal_coverage_tag" (
1664
  "id" integer NOT NULL,
1665
  "tag_id" integer DEFAULT NULL,
1666
  "entity_id" integer DEFAULT NULL,
1667
  "start_date" text/*date*/ NOT NULL,
1668
  "end_date" text/*date*/ DEFAULT NULL,
1669
  "is_system_generated" bit(1) DEFAULT NULL,
1670
  PRIMARY KEY ("id"),
1671
  /*KEY "id" ("id")*/CHECK (true)
1672
);
1673
/*!40101 SET character_set_client = @saved_cs_client */;
1674

    
1675
--
1676
-- Table structure for table "tmp_IMSregions"
1677
--
1678

    
1679
DROP TABLE IF EXISTS "tmp_IMSregions";
1680
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1681
/*!40101 SET character_set_client = utf8 */;
1682
CREATE TABLE "tmp_IMSregions" (
1683
  "gbif_membership" varchar(100) DEFAULT NULL,
1684
  "name_lct" varchar(255) DEFAULT NULL,
1685
  "name_short" varchar(100) DEFAULT NULL,
1686
  "iso2" varchar(2) DEFAULT NULL,
1687
  "gbif_area" varchar(100) DEFAULT NULL
1688
);
1689
/*!40101 SET character_set_client = @saved_cs_client */;
1690

    
1691
--
1692
-- Table structure for table "typification_record"
1693
--
1694

    
1695
DROP TABLE IF EXISTS "typification_record";
1696
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1697
/*!40101 SET character_set_client = utf8 */;
1698
CREATE TABLE "typification_record" (
1699
  "id" integer NOT NULL,
1700
  "data_resource_id" integer NOT NULL,
1701
  "occurrence_id" integer DEFAULT NULL,
1702
  "taxon_name_id" integer DEFAULT NULL,
1703
  "scientific_name" varchar(255) DEFAULT NULL,
1704
  "publication" text,
1705
  "type_status" varchar(255) NOT NULL,
1706
  "notes" text,
1707
  PRIMARY KEY ("id"),
1708
  /*KEY "ix_typification_record_occurrence" ("occurrence_id")*/CHECK (true),
1709
  /*KEY "ix_typification_record_name" ("taxon_name_id")*/CHECK (true),
1710
  /*KEY "ix_typification_record_resource" ("data_resource_id")*/CHECK (true)
1711
);
1712
/*!40101 SET character_set_client = @saved_cs_client */;
1713
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1714

    
1715
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1716
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1717
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1718
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1719
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1720
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1721
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1722

    
1723
-- Dump completed on 2013-03-28 18:36:26
(3-3/11)