merging /branches/cdmlib/SPRINT-Chichorieae1/ to trunk
[cdmlib.git] / cdmlib-persistence / src / test / resources / dbscripts / 001_cdm.ddl
index 2977f07ba12b07093eacc9dba16c8e72f5153a5e..ab04323fdbff6387a43ac4d80514150eff8859f3 100644 (file)
         iso639_2 varchar(3),
         istechnical bit,
         orderindex integer,
-        symmetric bit,
+        symmetrical bit,
         transitive bit,
         defaultcolor varchar(255),
         supportscategoricaldata bit,
         orderindex integer,
         iso639_1 varchar(2),
         iso639_2 varchar(3),
-        symmetric bit,
+        symmetrical bit,
         transitive bit,
         pointapproximation_errorradius integer,
         pointapproximation_latitude double,
         inreference_id integer,
         institution_id integer,
         school_id integer,
+        abbreviatedReference_id integer,
+        fullReference_id integer,
         primary key (id),
         unique (uuid)
     );
         inreference_id integer,
         institution_id integer,
         school_id integer,
+        abbreviatedReference_id integer,
+        fullReference_id integer,
         primary key (id, REV)
     );