Project

General

Profile

« Previous | Next » 

Revision 3213

schemas/vegbien.sql: commdetermination: Made commconcept_id NOT NULL because it doesn't make sense to have a commdetermination on nothing. Note that the commname field in commdetermination is not used for making determinations (and may need to be removed to avoid confusion); commname.commname is used instead.

View differences:

schemas/vegbien.my.sql
340 340
CREATE TABLE commdetermination (
341 341
    commdetermination_id int(11) NOT NULL,
342 342
    commclass_id int(11) NOT NULL,
343
    commconcept_id int(11),
343
    commconcept_id int(11) NOT NULL,
344 344
    commcode text,
345 345
    commname text,
346 346
    classfit text,
schemas/vegbien.sql
582 582
CREATE TABLE commdetermination (
583 583
    commdetermination_id integer NOT NULL,
584 584
    commclass_id integer NOT NULL,
585
    commconcept_id integer,
585
    commconcept_id integer NOT NULL,
586 586
    commcode text,
587 587
    commname text,
588 588
    classfit text,

Also available in: Unified diff