Project

General

Profile

« Previous | Next » 

Revision 1054

vegbien.sql: locationevent: Removed VegBank-internal interp_* fields

View differences:

schemas/vegbien.my.sql
1139 1139
    obsenddate timestamp NULL,
1140 1140
    dateentered timestamp NULL ,
1141 1141
    emb_locationevent int(11),
1142
    interp_orig_ci_id int(11),
1143
    interp_orig_cc_id int(11),
1144
    interp_orig_sciname text,
1145
    interp_orig_code text,
1146
    interp_orig_party_id int(11),
1147
    interp_orig_partyname text,
1148
    interp_current_ci_id int(11),
1149
    interp_current_cc_id int(11),
1150
    interp_current_sciname text,
1151
    interp_current_code text,
1152
    interp_current_party_id int(11),
1153
    interp_current_partyname text,
1154
    interp_bestfit_ci_id int(11),
1155
    interp_bestfit_cc_id int(11),
1156
    interp_bestfit_sciname text,
1157
    interp_bestfit_code text,
1158
    interp_bestfit_party_id int(11),
1159
    interp_bestfit_partyname text,
1160 1142
    toptaxon1name text,
1161 1143
    toptaxon2name text,
1162 1144
    toptaxon3name text,
schemas/vegbien.sql
1310 1310
    obsenddate timestamp with time zone,
1311 1311
    dateentered timestamp with time zone DEFAULT now(),
1312 1312
    emb_locationevent integer,
1313
    interp_orig_ci_id integer,
1314
    interp_orig_cc_id integer,
1315
    interp_orig_sciname text,
1316
    interp_orig_code text,
1317
    interp_orig_party_id integer,
1318
    interp_orig_partyname text,
1319
    interp_current_ci_id integer,
1320
    interp_current_cc_id integer,
1321
    interp_current_sciname text,
1322
    interp_current_code text,
1323
    interp_current_party_id integer,
1324
    interp_current_partyname text,
1325
    interp_bestfit_ci_id integer,
1326
    interp_bestfit_cc_id integer,
1327
    interp_bestfit_sciname text,
1328
    interp_bestfit_code text,
1329
    interp_bestfit_party_id integer,
1330
    interp_bestfit_partyname text,
1331 1313
    toptaxon1name text,
1332 1314
    toptaxon2name text,
1333 1315
    toptaxon3name text,

Also available in: Unified diff