1
timestamp: 2008-11-30T11:06:07.078000
3
id INTEGER PRIMARY KEY AUTOINCREMENT,
8
timestamp: 2008-11-30T11:06:07.203000
9
CREATE TABLE gis_webmapcontext(
10
id INTEGER PRIMARY KEY AUTOINCREMENT,
11
user REFERENCES user(id) ON DELETE CASCADE
14
timestamp: 2008-11-30T11:06:07.343000
15
CREATE TABLE gis_feature(
16
id INTEGER PRIMARY KEY AUTOINCREMENT,
18
feature_class CHAR(32),
23
timestamp: 2008-11-30T11:09:34.046000
24
CREATE TABLE gis_feature_metadata(
25
id INTEGER PRIMARY KEY AUTOINCREMENT,
27
description CHAR(256),
28
author REFERENCES user(id) ON DELETE CASCADE,
29
timestamp_event TIMESTAMP,
30
timestamp_added TIMESTAMP
33
timestamp: 2008-11-30T11:09:34.250000
34
CREATE TABLE gis_feature_class(
35
id INTEGER PRIMARY KEY AUTOINCREMENT,
39
timestamp: 2008-11-30T11:41:44.625000
40
CREATE TABLE gis_projection(
41
id INTEGER PRIMARY KEY AUTOINCREMENT,
45
timestamp: 2008-11-30T11:41:44.812000
46
CREATE TABLE gis_style(
47
id INTEGER PRIMARY KEY AUTOINCREMENT,
51
timestamp: 2008-11-30T11:41:44.968000
52
CREATE TABLE gis_layer(
53
id INTEGER PRIMARY KEY AUTOINCREMENT,
57
timestamp: 2008-11-30T11:41:45.109000
58
CREATE TABLE gis_layer_wms(
59
id INTEGER PRIMARY KEY AUTOINCREMENT,
63
timestamp: 2008-11-30T11:52:17.046000
65
id INTEGER PRIMARY KEY AUTOINCREMENT,
67
description CHAR(256),
71
timestamp: 2008-11-30T11:52:17.234000
72
ALTER TABLE gis_layer ADD type CHAR(32);
74
timestamp: 2008-11-30T11:52:17.390000
75
ALTER TABLE gis_layer_wms ADD url CHAR(32);
77
timestamp: 2008-11-30T12:33:13.671000
78
ALTER TABLE gis_feature ADD lon CHAR(32);
80
timestamp: 2008-11-30T12:33:13.781000
81
ALTER TABLE gis_feature ADD lat CHAR(32);
83
timestamp: 2008-11-30T15:05:08.781000
84
CREATE TABLE gis_option(
85
id INTEGER PRIMARY KEY AUTOINCREMENT,
87
description CHAR(256),
91
timestamp: 2008-11-30T17:09:05.750000
92
CREATE TABLE gis_feature_group(
93
id INTEGER PRIMARY KEY AUTOINCREMENT,
95
author REFERENCES user(id) ON DELETE CASCADE
98
timestamp: 2008-11-30T17:09:05.890000
99
ALTER TABLE gis_layer ADD enabled CHAR(32);
101
timestamp: 2008-11-30T17:09:06.046000
102
CREATE TABLE gis_layer_internal(
103
id INTEGER PRIMARY KEY AUTOINCREMENT,
107
timestamp: 2008-11-30T17:12:13.671000
108
CREATE TABLE gis_layer_internal(
109
id INTEGER PRIMARY KEY AUTOINCREMENT,
110
name REFERENCES gis_layer(id) ON DELETE CASCADE,
113
timestamp: 2008-11-30T17:23:29.843000
114
CREATE TABLE gis_layer_internal(
115
id INTEGER PRIMARY KEY AUTOINCREMENT,
116
name REFERENCES gis_layer(id) ON DELETE CASCADE,
117
group REFERENCES gis_feature_group(id) ON DELETE CASCADE
119
timestamp: 2008-11-30T17:24:07.750000
120
CREATE TABLE gis_layer_internal(
121
id INTEGER PRIMARY KEY AUTOINCREMENT,
122
name REFERENCES gis_layer(id) ON DELETE CASCADE,
123
feature_group REFERENCES gis_feature_group(id) ON DELETE CASCADE
126
timestamp: 2008-11-30T17:24:07.906000
127
CREATE TABLE gis_layer_google(
128
id INTEGER PRIMARY KEY AUTOINCREMENT,
129
name REFERENCES gis_layer(id) ON DELETE CASCADE,
134
timestamp: 2008-11-30T17:24:08.046000
135
ALTER TABLE gis_layer_wms ADD visible CHAR(32);
137
timestamp: 2008-11-30T17:24:08.187000
138
CREATE TABLE gis_key(
139
id INTEGER PRIMARY KEY AUTOINCREMENT,
144
timestamp: 2008-11-30T17:24:08.359000
145
ALTER TABLE gis_projection ADD epsg CHAR(32);
147
timestamp: 2008-11-30T18:23:49.796000
148
CREATE TABLE t2_person(
149
id INTEGER PRIMARY KEY AUTOINCREMENT,
152
registration_key CHAR(64),
154
created_by_ip CHAR(32),
158
timestamp: 2008-11-30T18:23:49.968000
159
CREATE TABLE t2_group(
160
id INTEGER PRIMARY KEY AUTOINCREMENT,
163
created_on TIMESTAMP,
165
created_signature CHAR(32)
168
timestamp: 2008-11-30T18:23:50.156000
169
CREATE TABLE t2_membership(
170
id INTEGER PRIMARY KEY AUTOINCREMENT,
171
person_id REFERENCES t2_person(id) ON DELETE CASCADE,
172
group_id REFERENCES t2_group(id) ON DELETE CASCADE,
173
membership_type CHAR(32),
175
created_on TIMESTAMP,
177
created_signature CHAR(32)
180
timestamp: 2008-11-30T18:23:50.296000
181
CREATE TABLE t2_access(
182
id INTEGER PRIMARY KEY AUTOINCREMENT,
183
group_id REFERENCES t2_group(id) ON DELETE CASCADE,
186
access_type CHAR(32),
187
created_on TIMESTAMP,
189
created_signature CHAR(32)
192
timestamp: 2008-11-30T18:23:50.484000
193
CREATE TABLE t2_attachment(
194
id INTEGER PRIMARY KEY AUTOINCREMENT,
197
created_on TIMESTAMP,
199
created_signature CHAR(32),
208
timestamp: 2008-11-30T18:23:50.718000
209
CREATE TABLE t2_comment(
210
id INTEGER PRIMARY KEY AUTOINCREMENT,
213
parent_record INTEGER,
215
created_signature CHAR(32),
216
created_on TIMESTAMP,
221
timestamp: 2008-11-30T18:23:50.890000
222
CREATE TABLE t2_review(
223
id INTEGER PRIMARY KEY AUTOINCREMENT,
228
created_signature CHAR(32),
229
created_on TIMESTAMP,
234
timestamp: 2008-11-30T18:40:30.359000
235
ALTER TABLE gis_layer ADD description CHAR(256);
237
timestamp: 2008-11-30T20:37:11.671000
238
CREATE TABLE gis_map(
239
id INTEGER PRIMARY KEY AUTOINCREMENT,
243
timestamp: 2008-11-30T20:46:50.687000
244
CREATE TABLE gis_marker(
245
id INTEGER PRIMARY KEY AUTOINCREMENT,
250
timestamp: 2008-11-30T21:53:06.390000
251
CREATE TABLE gis_layer_base(
252
id INTEGER PRIMARY KEY AUTOINCREMENT,
253
name REFERENCES gis_layer(id) ON DELETE CASCADE,
257
timestamp: 2008-11-30T21:53:06.578000
258
CREATE TABLE gis_layer_overlay(
259
id INTEGER PRIMARY KEY AUTOINCREMENT,
260
name REFERENCES gis_layer(id) ON DELETE CASCADE,
264
timestamp: 2008-12-01T18:46:51.203000
265
ALTER TABLE module ADD name_nice CHAR(32);
267
timestamp: 2008-12-01T19:16:47.687000
268
CREATE TABLE gis_menu_option(
269
id INTEGER PRIMARY KEY AUTOINCREMENT,
271
description CHAR(256),
275
timestamp: 2008-12-01T19:23:25.250000
276
ALTER TABLE gis_menu_option ADD priority CHAR(32);
278
timestamp: 2008-12-01T19:26:26
279
ALTER TABLE module ADD menu_priority INTEGER;
281
timestamp: 2008-12-01T21:37:30.015000
282
CREATE TABLE cr_menu_option(
283
id INTEGER PRIMARY KEY AUTOINCREMENT,
285
description CHAR(256),
290
timestamp: 2008-12-01T21:37:30.203000
291
CREATE TABLE dvr_menu_option(
292
id INTEGER PRIMARY KEY AUTOINCREMENT,
294
description CHAR(256),
299
timestamp: 2008-12-01T21:37:30.375000
300
CREATE TABLE ims_menu_option(
301
id INTEGER PRIMARY KEY AUTOINCREMENT,
303
description CHAR(256),
308
timestamp: 2008-12-01T21:37:30.593000
309
CREATE TABLE mpr_menu_option(
310
id INTEGER PRIMARY KEY AUTOINCREMENT,
312
description CHAR(256),
317
timestamp: 2008-12-01T21:37:30.859000
318
CREATE TABLE or_menu_option(
319
id INTEGER PRIMARY KEY AUTOINCREMENT,
321
description CHAR(256),
326
timestamp: 2008-12-01T21:37:31.015000
327
CREATE TABLE rms_menu_option(
328
id INTEGER PRIMARY KEY AUTOINCREMENT,
330
description CHAR(256),
335
timestamp: 2008-12-01T21:37:31.218000
336
CREATE TABLE vol_menu_option(
337
id INTEGER PRIMARY KEY AUTOINCREMENT,
339
description CHAR(256),
344
timestamp: 2008-12-01T22:32:21.484000
345
ALTER TABLE gis_layer_overlay ADD visible CHAR(1);
347
timestamp: 2008-12-01T22:32:21.609000
348
CREATE TABLE gis_layer_base_wms(
349
id INTEGER PRIMARY KEY AUTOINCREMENT,
350
name REFERENCES gis_layer(id) ON DELETE CASCADE,
354
timestamp: 2008-12-01T22:32:21.750000
355
CREATE TABLE gis_layer_overlay_wms(
356
id INTEGER PRIMARY KEY AUTOINCREMENT,
357
name REFERENCES gis_layer(id) ON DELETE CASCADE,
361
timestamp: 2008-12-01T22:54:15.953000
362
ALTER TABLE gis_layer_google ADD key REFERENCES gis_key(id) ON DELETE CASCADE;
364
timestamp: 2008-12-02T10:49:24.765000
365
ALTER TABLE gis_layer_base ADD layer_id REFERENCES gis_layer(id) ON DELETE CASCADE;
367
timestamp: 2008-12-02T15:00:36.562000
368
ALTER TABLE gis_layer ADD feature_group REFERENCES gis_feature_group(id) ON DELETE CASCADE;
370
timestamp: 2008-12-02T15:00:36.718000
371
ALTER TABLE gis_layer ADD visible CHAR(1);
373
timestamp: 2008-12-02T15:00:36.890000
374
ALTER TABLE gis_layer ADD url CHAR(32);
376
timestamp: 2008-12-02T15:00:37.031000
377
ALTER TABLE gis_layer ADD subtype CHAR(32);
379
timestamp: 2008-12-02T15:00:37.140000
380
ALTER TABLE gis_layer ADD base CHAR(1);
382
timestamp: 2008-12-02T15:00:37.265000
383
ALTER TABLE gis_layer ADD key REFERENCES gis_key(id) ON DELETE CASCADE;
385
timestamp: 2008-12-02T15:40:36.562000
386
ALTER TABLE gis_layer ADD feature_group_id REFERENCES gis_feature_group(id) ON DELETE CASCADE;
388
timestamp: 2008-12-02T21:34:41.546000
389
ALTER TABLE gis_key ADD description CHAR(256);
391
timestamp: 2008-12-02T22:15:43.156000
392
ALTER TABLE gis_feature ADD modified_on TIMESTAMP;
394
timestamp: 2008-12-02T22:15:43.343000
395
ALTER TABLE gis_feature_metadata ADD modified_by REFERENCES t2_person(id) ON DELETE CASCADE;
397
timestamp: 2008-12-02T22:15:43.515000
398
ALTER TABLE gis_feature_metadata ADD event_time TIMESTAMP;
400
timestamp: 2008-12-02T22:15:43.640000
401
ALTER TABLE gis_feature_metadata ADD created_on TIMESTAMP;
403
timestamp: 2008-12-02T22:15:43.796000
404
ALTER TABLE gis_feature_metadata ADD modified_on TIMESTAMP;
406
timestamp: 2008-12-02T22:15:43.968000
407
ALTER TABLE gis_feature_class ADD modified_on TIMESTAMP;
409
timestamp: 2008-12-02T22:15:44.140000
410
ALTER TABLE gis_feature_group ADD modified_on TIMESTAMP;
412
timestamp: 2008-12-02T22:15:44.312000
413
ALTER TABLE gis_key ADD displays CHAR(32);
415
timestamp: 2008-12-02T22:15:44.453000
416
ALTER TABLE gis_key ADD modified_on TIMESTAMP;
418
timestamp: 2008-12-02T22:15:44.625000
419
ALTER TABLE gis_layer ADD modified_on TIMESTAMP;
421
timestamp: 2008-12-02T22:15:44.781000
422
ALTER TABLE gis_projection ADD modified_on TIMESTAMP;
424
timestamp: 2008-12-02T22:15:44.906000
425
ALTER TABLE gis_marker ADD modified_on TIMESTAMP;
427
timestamp: 2008-12-02T22:15:45.093000
428
ALTER TABLE gis_map ADD modified_on TIMESTAMP;
430
timestamp: 2008-12-02T22:15:45.234000
431
ALTER TABLE gis_style ADD modified_on TIMESTAMP;
433
timestamp: 2008-12-02T22:15:45.375000
434
ALTER TABLE gis_webmapcontext ADD modified_on TIMESTAMP;
436
timestamp: 2008-12-03T07:34:08
438
id INTEGER PRIMARY KEY AUTOINCREMENT,
443
timestamp: 2008-12-03T23:21:01.578000
444
CREATE TABLE home_menu_option(
445
id INTEGER PRIMARY KEY AUTOINCREMENT,
447
description CHAR(256),
452
timestamp: 2008-12-05T18:36:57.875000
453
CREATE TABLE gis_default(
454
id INTEGER PRIMARY KEY AUTOINCREMENT,
456
description CHAR(256),
460
timestamp: 2008-12-05T18:41:11.812000
461
ALTER TABLE gis_feature_class ADD marker CHAR(32);
463
timestamp: 2008-12-05T18:41:11.984000
464
ALTER TABLE gis_layer ADD projection CHAR(32);
466
timestamp: 2008-12-05T21:14:43.515000
467
ALTER TABLE gis_layer ADD priority INTEGER;
469
timestamp: 2008-12-05T22:44:13.234000
470
ALTER TABLE gis_default ADD projection REFERENCES gis_projection(id) ON DELETE CASCADE;
472
timestamp: 2008-12-06T11:47:28.656000
473
CREATE TABLE field_option(
474
id INTEGER PRIMARY KEY AUTOINCREMENT,
476
option_code CHAR(20),
477
option_description CHAR(50)
480
timestamp: 2008-12-06T11:47:28.843000
481
CREATE TABLE contact(
482
id INTEGER PRIMARY KEY AUTOINCREMENT,
484
description CHAR(256)
487
timestamp: 2008-12-06T11:47:29.109000
488
CREATE TABLE cr_shelter(
489
id INTEGER PRIMARY KEY AUTOINCREMENT,
491
description CHAR(256),
495
contact REFERENCES contact(id) ON DELETE CASCADE,
496
location REFERENCES gis_feature(id) ON DELETE CASCADE
499
timestamp: 2008-12-06T12:15:48.937000
500
CREATE TABLE or_organisation(
501
id INTEGER PRIMARY KEY AUTOINCREMENT,
503
description CHAR(256),
505
contact REFERENCES contact(id) ON DELETE CASCADE
508
timestamp: 2008-12-06T13:26:42.500000
509
ALTER TABLE t2_person ADD modified_by INTEGER;
511
timestamp: 2008-12-06T13:26:42.656000
512
ALTER TABLE t2_person ADD created_by INTEGER;
514
timestamp: 2008-12-06T13:26:42.765000
515
ALTER TABLE t2_person ADD created_signature CHAR(32);
517
timestamp: 2008-12-06T13:26:42.875000
518
ALTER TABLE t2_person ADD modified_on TIMESTAMP;
520
timestamp: 2008-12-06T13:26:43.046000
521
ALTER TABLE t2_person ADD modified_signature CHAR(32);
523
timestamp: 2008-12-06T13:26:43.156000
524
ALTER TABLE t2_group ADD modified_by INTEGER;
526
timestamp: 2008-12-06T13:26:43.265000
527
ALTER TABLE t2_group ADD created_by_ip CHAR(32);
529
timestamp: 2008-12-06T13:26:43.375000
530
ALTER TABLE t2_group ADD modified_on TIMESTAMP;
532
timestamp: 2008-12-06T13:26:43.484000
533
ALTER TABLE t2_group ADD modified_signature CHAR(32);
535
timestamp: 2008-12-06T13:26:43.640000
536
ALTER TABLE t2_membership ADD modified_by INTEGER;
538
timestamp: 2008-12-06T13:26:43.765000
539
ALTER TABLE t2_membership ADD created_by_ip CHAR(32);
541
timestamp: 2008-12-06T13:26:43.906000
542
ALTER TABLE t2_membership ADD modified_on TIMESTAMP;
544
timestamp: 2008-12-06T13:26:44.125000
545
ALTER TABLE t2_membership ADD modified_signature CHAR(32);
547
timestamp: 2008-12-06T13:26:44.250000
548
ALTER TABLE t2_access ADD modified_by INTEGER;
550
timestamp: 2008-12-06T13:26:44.390000
551
ALTER TABLE t2_access ADD created_by_ip CHAR(32);
553
timestamp: 2008-12-06T13:26:44.500000
554
ALTER TABLE t2_access ADD modified_on TIMESTAMP;
556
timestamp: 2008-12-06T13:26:44.656000
557
ALTER TABLE t2_access ADD modified_signature CHAR(32);
559
timestamp: 2008-12-06T13:26:44.796000
560
ALTER TABLE t2_attachment ADD modified_by INTEGER;
562
timestamp: 2008-12-06T13:26:44.921000
563
ALTER TABLE t2_attachment ADD created_by_ip CHAR(32);
565
timestamp: 2008-12-06T13:26:45.171000
566
ALTER TABLE t2_attachment ADD modified_on TIMESTAMP;
568
timestamp: 2008-12-06T13:26:45.296000
569
ALTER TABLE t2_attachment ADD modified_signature CHAR(32);
571
timestamp: 2008-12-06T13:26:45.468000
572
ALTER TABLE t2_comment ADD modified_by INTEGER;
574
timestamp: 2008-12-06T13:26:45.656000
575
ALTER TABLE t2_comment ADD created_by_ip CHAR(32);
577
timestamp: 2008-12-06T13:26:45.781000
578
ALTER TABLE t2_comment ADD modified_on TIMESTAMP;
580
timestamp: 2008-12-06T13:26:45.921000
581
ALTER TABLE t2_comment ADD modified_signature CHAR(32);
583
timestamp: 2008-12-06T13:26:46.109000
584
ALTER TABLE t2_review ADD modified_by INTEGER;
586
timestamp: 2008-12-06T13:26:46.296000
587
ALTER TABLE t2_review ADD created_by_ip CHAR(32);
589
timestamp: 2008-12-06T13:26:46.421000
590
ALTER TABLE t2_review ADD modified_on TIMESTAMP;
592
timestamp: 2008-12-06T13:26:46.593000
593
ALTER TABLE t2_review ADD modified_signature CHAR(32);
595
timestamp: 2008-12-06T13:26:46.734000
596
CREATE TABLE t2_wiki(
597
id INTEGER PRIMARY KEY AUTOINCREMENT,
602
created_signature CHAR(32),
603
created_by_ip CHAR(32),
605
created_on TIMESTAMP,
606
modified_signature CHAR(32),
608
modified_on TIMESTAMP
611
timestamp: 2008-12-06T18:25:59.125000
612
CREATE TABLE default(
613
id INTEGER PRIMARY KEY AUTOINCREMENT,
615
description CHAR(256),
618
timestamp: 2008-12-06T18:27:37.921000
619
CREATE TABLE system_default(
620
id INTEGER PRIMARY KEY AUTOINCREMENT,
622
description CHAR(256),
626
timestamp: 2008-12-06T18:31:15.656000
627
CREATE TABLE system_config(
628
id INTEGER PRIMARY KEY AUTOINCREMENT,
630
description CHAR(256),
634
timestamp: 2008-12-06T18:31:15.828000
635
CREATE TABLE gis_config(
636
id INTEGER PRIMARY KEY AUTOINCREMENT,
638
description CHAR(256),
642
timestamp: 2008-12-07T01:39:43.921000
644
id INTEGER PRIMARY KEY AUTOINCREMENT,
646
family_name CHAR(32),
650
timestamp: 2008-12-07T01:40:37.140000
651
CREATE TABLE person_contact(
652
id INTEGER PRIMARY KEY AUTOINCREMENT,
653
person REFERENCES person(id) ON DELETE CASCADE,
654
opt_contact_type CHAR(32),
655
contact_value CHAR(32)
658
timestamp: 2008-12-07T01:47:58.359000
659
CREATE TABLE person_identity(
660
id INTEGER PRIMARY KEY AUTOINCREMENT,
661
person REFERENCES person(id) ON DELETE CASCADE,
662
opt_id_type CHAR(32),
666
timestamp: 2008-12-07T01:47:58.578000
667
ALTER TABLE gis_feature_metadata ADD feature REFERENCES gis_feature(id) ON DELETE CASCADE;
669
timestamp: 2008-12-07T01:47:58.796000
670
CREATE TABLE gis_layer_shapefile(
671
id INTEGER PRIMARY KEY AUTOINCREMENT,
672
modified_on TIMESTAMP,
673
layer REFERENCES gis_layer(id) ON DELETE CASCADE
676
timestamp: 2008-12-07T01:47:58.984000
677
ALTER TABLE gis_layer_wms ADD modified_on TIMESTAMP;
679
timestamp: 2008-12-07T01:47:59.109000
680
ALTER TABLE gis_layer_wms ADD layer REFERENCES gis_layer(id) ON DELETE CASCADE;
682
timestamp: 2008-12-07T01:47:59.343000
683
ALTER TABLE gis_layer_wms ADD type CHAR(32);
685
timestamp: 2008-12-07T01:47:59.531000
686
ALTER TABLE cr_shelter ADD modified_on TIMESTAMP;
688
timestamp: 2008-12-07T01:48:41.875000
689
ALTER TABLE or_organisation ADD modified_on TIMESTAMP;
691
timestamp: 2008-12-07T02:03:41.890000
692
ALTER TABLE gis_layer_google ADD modified_on TIMESTAMP;
694
timestamp: 2008-12-07T02:03:42.015000
695
ALTER TABLE gis_layer_google ADD layer REFERENCES gis_layer(id) ON DELETE CASCADE;
697
timestamp: 2008-12-07T02:04:37
698
CREATE TABLE gis_layer_features(
699
id INTEGER PRIMARY KEY AUTOINCREMENT,
700
modified_on TIMESTAMP,
701
layer REFERENCES gis_layer(id) ON DELETE CASCADE,
702
feature_group REFERENCES gis_feature_group(id) ON DELETE CASCADE
705
timestamp: 2008-12-07T02:04:37.234000
706
CREATE TABLE gis_layer_openstreetmap(
707
id INTEGER PRIMARY KEY AUTOINCREMENT,
708
modified_on TIMESTAMP,
709
layer REFERENCES gis_layer(id) ON DELETE CASCADE,
713
timestamp: 2008-12-07T02:04:37.375000
714
ALTER TABLE gis_layer_shapefile ADD projection REFERENCES gis_projection(id) ON DELETE CASCADE;
716
timestamp: 2008-12-07T02:04:37.500000
717
CREATE TABLE gis_layer_wms_base(
718
id INTEGER PRIMARY KEY AUTOINCREMENT,
719
modified_on TIMESTAMP,
720
layer REFERENCES gis_layer(id) ON DELETE CASCADE,
722
projection REFERENCES gis_projection(id) ON DELETE CASCADE
725
timestamp: 2008-12-07T02:04:37.656000
726
CREATE TABLE gis_layer_wms_overlay(
727
id INTEGER PRIMARY KEY AUTOINCREMENT,
728
modified_on TIMESTAMP,
729
layer REFERENCES gis_layer(id) ON DELETE CASCADE,
731
projection REFERENCES gis_projection(id) ON DELETE CASCADE,
735
timestamp: 2008-12-07T09:32:46.593000
736
ALTER TABLE t2_wiki ADD name CHAR(32);
738
timestamp: 2008-12-07T09:32:46.843000
739
CREATE TABLE person_details(
740
id INTEGER PRIMARY KEY AUTOINCREMENT,
741
person REFERENCES person(id) ON DELETE CASCADE,
742
next_kin REFERENCES person(id) ON DELETE CASCADE,
744
opt_age_group CHAR(32),
746
opt_country CHAR(32),
748
opt_religion CHAR(32),
749
opt_marital_status CHAR(32),
754
timestamp: 2008-12-07T12:46:40.046000
755
ALTER TABLE gis_projection ADD units CHAR(32);
757
timestamp: 2008-12-07T12:46:40.218000
758
ALTER TABLE gis_projection ADD maxResolution CHAR(32);
760
timestamp: 2008-12-07T12:46:40.437000
761
ALTER TABLE gis_projection ADD maxExtent CHAR(32);
763
timestamp: 2008-12-07T13:00:45.500000
764
ALTER TABLE gis_marker ADD size CHAR(32);
766
timestamp: 2008-12-07T13:00:45.703000
767
CREATE TABLE gis_layer_georss(
768
id INTEGER PRIMARY KEY AUTOINCREMENT,
769
modified_on TIMESTAMP,
770
layer REFERENCES gis_layer(id) ON DELETE CASCADE,
772
icon REFERENCES gis_marker(id) ON DELETE CASCADE,
773
projection REFERENCES gis_projection(id) ON DELETE CASCADE,
777
timestamp: 2008-12-07T13:00:45.906000
778
ALTER TABLE gis_layer_wms ADD layers CHAR(32);
780
timestamp: 2008-12-09T11:56:59.171000
781
ALTER TABLE person ADD modified_on TIMESTAMP;
783
timestamp: 2008-12-09T11:56:59.359000
784
ALTER TABLE person_contact ADD modified_on TIMESTAMP;
786
timestamp: 2008-12-09T11:56:59.500000
787
ALTER TABLE person_identity ADD modified_on TIMESTAMP;
789
timestamp: 2008-12-09T11:56:59.671000
790
ALTER TABLE person_details ADD modified_on TIMESTAMP;
792
timestamp: 2008-12-09T11:56:59.796000
793
CREATE TABLE person_status(
794
id INTEGER PRIMARY KEY AUTOINCREMENT,
795
modified_on TIMESTAMP,
796
person REFERENCES person(id) ON DELETE CASCADE,
797
isReliefWorker CHAR(1),
803
timestamp: 2008-12-09T11:56:59.953000
804
CREATE TABLE person_physical(
805
id INTEGER PRIMARY KEY AUTOINCREMENT,
806
modified_on TIMESTAMP,
807
person REFERENCES person(id) ON DELETE CASCADE,
810
opt_blood_type CHAR(32),
811
opt_eye_color CHAR(32),
812
opt_skin_color CHAR(32),
813
opt_hair_color CHAR(32),
818
timestamp: 2008-12-09T11:57:00.093000
819
CREATE TABLE person_missing(
820
id INTEGER PRIMARY KEY AUTOINCREMENT,
821
modified_on TIMESTAMP,
822
person REFERENCES person(id) ON DELETE CASCADE,
824
last_clothing CHAR(32),
828
timestamp: 2008-12-09T11:57:00.281000
829
CREATE TABLE person_deceased(
830
id INTEGER PRIMARY KEY AUTOINCREMENT,
831
modified_on TIMESTAMP,
832
person REFERENCES person(id) ON DELETE CASCADE,
835
place_of_death CHAR(32),
839
timestamp: 2008-12-09T11:57:00.437000
840
CREATE TABLE person_report(
841
id INTEGER PRIMARY KEY AUTOINCREMENT,
842
modified_on TIMESTAMP,
843
person REFERENCES person(id) ON DELETE CASCADE,
844
reporter REFERENCES person(id) ON DELETE CASCADE,
848
timestamp: 2008-12-09T11:57:00.578000
849
CREATE TABLE person_group(
850
id INTEGER PRIMARY KEY AUTOINCREMENT,
851
modified_on TIMESTAMP,
852
opt_group_type CHAR(32)
855
timestamp: 2008-12-09T11:57:00.703000
856
CREATE TABLE person_group_details(
857
id INTEGER PRIMARY KEY AUTOINCREMENT,
858
modified_on TIMESTAMP,
859
group REFERENCES person_group(id) ON DELETE CASCADE,
860
head REFERENCES person(id) ON DELETE CASCADE,
861
no_of_adult_males INTEGER,
862
no_of_adult_females INTEGER,
863
no_of_children INTEGER,
864
no_displaced INTEGER,
867
no_rehabilitated INTEGER,
869
description CHAR(256)
871
timestamp: 2008-12-09T16:02:59.250000
872
CREATE TABLE person_group_details(
873
id INTEGER PRIMARY KEY AUTOINCREMENT,
874
modified_on TIMESTAMP,
875
group REFERENCES person_group(id) ON DELETE CASCADE,
876
head REFERENCES person(id) ON DELETE CASCADE,
877
no_of_adult_males INTEGER,
878
no_of_adult_females INTEGER,
879
no_of_children INTEGER,
880
no_displaced INTEGER,
883
no_rehabilitated INTEGER,
885
description CHAR(256)
887
timestamp: 2008-12-09T16:08:42.437000
888
ALTER TABLE or_organisation ADD archived CHAR(1);
890
timestamp: 2008-12-09T16:08:42.578000
891
ALTER TABLE or_organisation ADD opt_org_type CHAR(32);
893
timestamp: 2008-12-09T16:08:42.765000
894
ALTER TABLE or_organisation ADD manpower CHAR(32);
896
timestamp: 2008-12-09T16:08:42.906000
897
ALTER TABLE or_organisation ADD privacy INTEGER;
899
timestamp: 2008-12-09T16:08:43.015000
900
ALTER TABLE or_organisation ADD equipment CHAR(32);
902
timestamp: 2008-12-09T16:08:43.156000
903
ALTER TABLE or_organisation ADD registration CHAR(32);
905
timestamp: 2008-12-09T19:52:02.515000
906
CREATE TABLE gis_layer_type(
907
id INTEGER PRIMARY KEY AUTOINCREMENT,
909
description CHAR(256)
912
timestamp: 2008-12-09T20:10:18.140000
913
CREATE TABLE person_group_details(
914
id INTEGER PRIMARY KEY AUTOINCREMENT,
915
modified_on TIMESTAMP,
916
group REFERENCES person_group(id) ON DELETE CASCADE,
917
head REFERENCES person(id) ON DELETE CASCADE,
918
no_of_adult_males INTEGER,
919
no_of_adult_females INTEGER,
920
no_of_children INTEGER,
921
no_displaced INTEGER,
924
no_rehabilitated INTEGER,
926
description CHAR(256)
928
timestamp: 2008-12-09T20:11:01.593000
929
CREATE TABLE person_group_details(
930
id INTEGER PRIMARY KEY AUTOINCREMENT,
931
modified_on TIMESTAMP,
932
person_group REFERENCES person_group(id) ON DELETE CASCADE,
933
head REFERENCES person(id) ON DELETE CASCADE,
934
no_of_adult_males INTEGER,
935
no_of_adult_females INTEGER,
936
no_of_children INTEGER,
937
no_displaced INTEGER,
940
no_rehabilitated INTEGER,
942
description CHAR(256)
945
timestamp: 2008-12-09T20:11:35.234000
946
CREATE TABLE person_to_group(
947
id INTEGER PRIMARY KEY AUTOINCREMENT,
948
modified_on TIMESTAMP,
949
person REFERENCES person(id) ON DELETE CASCADE,
950
person_group REFERENCES person_group(id) ON DELETE CASCADE