Project

General

Profile

« Previous | Next » 

Revision 6184

schemas/vegbien.sql: location: Renamed confidentialitystatus->accesslevel, confidentialityreason->accessconditions to match the corresponding fields in source. Note that accessconditions stores more than confidentialityreason did, because it can contain details about the accesslevel in addition to the reason for it.

View differences:

schemas/vegbien.my.sql
796 796
    sourceaccessioncode text,
797 797
    parent_id int(11),
798 798
    authorlocationcode text,
799
    confidentialitystatus text,
800
    confidentialityreason text,
799
    accesslevel text,
800
    accessconditions text,
801 801
    sublocationxposition_m double precision,
802 802
    sublocationyposition_m double precision,
803 803
    authorzone text,
schemas/vegbien.sql
1452 1452
    sourceaccessioncode text,
1453 1453
    parent_id integer,
1454 1454
    authorlocationcode text,
1455
    confidentialitystatus accesslevel,
1456
    confidentialityreason text,
1455
    accesslevel accesslevel,
1456
    accessconditions text,
1457 1457
    sublocationxposition_m double precision,
1458 1458
    sublocationyposition_m double precision,
1459 1459
    authorzone text,

Also available in: Unified diff