[Treebase-guts] SF.net SVN: treebase:[283] trunk/treebase-core/src/main/resources/ TBASE2_POSTGRES_CREATION.sql

[<rv...@us...>]

Revision: 283
          http://treebase.svn.sourceforge.net/treebase/?rev=283&view=rev
Author:   rvos
Date:     2009-11-18 18:14:19 +0000 (Wed, 18 Nov 2009)

Log Message:
-----------
Added postgres sequences for autoincrementing id columns

Modified Paths:
--------------
    trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql

Modified: trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql
===================================================================
--- trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql	2009-11-18 17:51:00 UTC (rev 282)
+++ trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql	2009-11-18 18:14:19 UTC (rev 283)
@@ -1732,6 +1732,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE algorithm OWNER TO postgres;
+CREATE SEQUENCE algorithm_id_sequence;
+ALTER TABLE algorithm ALTER COLUMN algorithm_id SET DEFAULT nextval('algorithm_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 4519;
 
 -- CREATE TABLE JRUAN.ANALYSIS ( 
 -- 	ANALYSIS_ID   	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -1755,6 +1758,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE analysis OWNER TO postgres;
+CREATE SEQUENCE analysis_id_sequence;
+ALTER TABLE analysis ALTER COLUMN analysis_id SET DEFAULT nextval('analysis_id_sequence');
+--  alter sequence analysis_id_sequence restart with 4512;
 
 -- CREATE TABLE JRUAN.ANALYSISSTEP ( 
 -- 	ANALYSISSTEP_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -1784,6 +1790,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE analysisstep OWNER TO postgres;
+CREATE SEQUENCE analysisstep_id_sequence;
+ALTER TABLE analysisstep ALTER COLUMN analysisstep_id SET DEFAULT nextval('analysisstep_id_sequence');
+-- alter sequence analysisstep_id_sequence restart with 4517;
 
 -- CREATE TABLE JRUAN.ANALYZEDDATA ( 
 -- 	TYPE           	CHARACTER(1) NOT NULL,
@@ -1811,6 +1820,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE analyzeddata OWNER TO postgres;
+CREATE SEQUENCE analyzeddata_id_sequence;
+ALTER TABLE analyzeddata ALTER COLUMN analyzeddata_id SET DEFAULT nextval('analyzeddata_id_sequence');
+-- alter sequence analyzeddata_id_sequence restart with 10417;
 
 -- CREATE TABLE JRUAN.ANCESTRALSTATE ( 
 -- 	TYPE                	CHARACTER(1) NOT NULL,
@@ -1834,6 +1846,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE ancestralstate OWNER TO postgres;
+CREATE SEQUENCE ancestralstate_id_sequence;
+ALTER TABLE ancestralstate ALTER COLUMN ancestralstate_id SET DEFAULT nextval('ancestralstate_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.ANCSTATESET ( 
 -- 	ANCSTATESET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -1851,6 +1866,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE ancstateset OWNER TO postgres;
+CREATE SEQUENCE ancstateset_id_sequence;
+ALTER TABLE ancstateset ALTER COLUMN ancstateset_id SET DEFAULT nextval('ancstateset_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.CHARGROUP_COLRANGE ( 
 -- 	CHARGROUP_ID  	BIGINT NOT NULL,
@@ -1881,6 +1899,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE chargroup OWNER TO postgres;
+CREATE SEQUENCE chargroup_id_sequence;
+ALTER TABLE chargroup ALTER COLUMN chargroup_id SET DEFAULT nextval('chargroup_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 913;
 
 -- CREATE TABLE JRUAN.CHARPARTITION ( 
 -- 	CHARPARTITION_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -1898,6 +1919,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE charpartition OWNER TO postgres;
+CREATE SEQUENCE charpartition_id_sequence;
+ALTER TABLE charpartition ALTER COLUMN charpartition_id SET DEFAULT nextval('charpartition_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 303;
 
 -- CREATE TABLE JRUAN.CHARSET_COLRANGE ( 
 -- 	CHARSET_ID    	BIGINT NOT NULL,
@@ -1930,6 +1954,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE charset OWNER TO postgres;
+CREATE SEQUENCE charset_id_sequence;
+ALTER TABLE charset ALTER COLUMN charset_id SET DEFAULT nextval('charset_id_sequence');
+-- alter sequence ancestralstate_id_sequence restart with 6190;
 
 -- CREATE TABLE JRUAN.CHARWEIGHT_COLRANGE ( 
 -- 	CHARWEIGHT_ID 	BIGINT NOT NULL,
@@ -1964,6 +1991,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE charweight OWNER TO postgres;
+CREATE SEQUENCE charweight_id_sequence;
+ALTER TABLE charweight ALTER COLUMN charweight_id SET DEFAULT nextval('charweight_id_sequence');
+-- alter sequence charweight_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.CHARWEIGHTSET ( 
 -- 	CHARWEIGHTSET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -1981,6 +2011,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE charweightset OWNER TO postgres;
+CREATE SEQUENCE charweightset_id_sequence;
+ALTER TABLE charweightset ALTER COLUMN charweightset_id SET DEFAULT nextval('charweightset_id_sequence');
+-- alter sequence charweightset_id_sequence restart with 113;
 
 -- CREATE TABLE JRUAN.CITATION_AUTHOR ( 
 -- 	CITATION_ID      	BIGINT NOT NULL,
@@ -2062,6 +2095,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE citation OWNER TO postgres;
+CREATE SEQUENCE citation_id_sequence;
+ALTER TABLE citation ALTER COLUMN citation_id SET DEFAULT nextval('citation_id_sequence');
+-- alter sequence citation_id_sequence restart with 2045;
 
 -- CREATE TABLE JRUAN.CITATIONSTATUS ( 
 -- 	CITATIONSTATUS_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2077,6 +2113,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE citationstatus OWNER TO postgres;
+CREATE SEQUENCE citationstatus_id_sequence;
+ALTER TABLE citationstatus ALTER COLUMN citationstatus_id SET DEFAULT nextval('citationstatus_id_sequence');
+-- alter sequence citationstatus_id_sequence restart with 6;
 
 -- CREATE TABLE JRUAN.CODERECORD_COLRANGE ( 
 -- 	GENETICCODERECORD_ID	BIGINT NOT NULL,
@@ -2159,6 +2198,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE codonpositionset OWNER TO postgres;
+CREATE SEQUENCE codonpositionset_id_sequence;
+ALTER TABLE codonpositionset ALTER COLUMN codonpositionset_id SET DEFAULT nextval('codonpositionset_id_sequence');
+-- alter sequence codonpositionset_id_sequence restart with 4320;
 
 -- CREATE TABLE JRUAN.COLUMNRANGE ( 
 -- 	COLUMNRANGE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2178,6 +2220,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE columnrange OWNER TO postgres;
+CREATE SEQUENCE columnrange_id_sequence;
+ALTER TABLE columnrange ALTER COLUMN columnrange_id SET DEFAULT nextval('columnrange_id_sequence');
+-- alter sequence columnrange_id_sequence restart with 255320;
 
 -- CREATE TABLE JRUAN.COMPOUND_ELEMENT ( 
 -- 	COMPOUND_ID	BIGINT NOT NULL,
@@ -2223,6 +2268,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE cstreenode OWNER TO postgres;
+CREATE SEQUENCE cstreenode_id_sequence;
+ALTER TABLE cstreenode ALTER COLUMN cstreenode_id SET DEFAULT nextval('cstreenode_id_sequence');
+-- alter sequence cstreenode_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.DISCRETECHARSTATE ( 
 -- 	DISCRETECHARSTATE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2248,6 +2296,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE discretecharstate OWNER TO postgres;
+CREATE SEQUENCE discretecharstate_id_sequence;
+ALTER TABLE discretecharstate ALTER COLUMN discretecharstate_id SET DEFAULT nextval('discretecharstate_id_sequence');
+-- alter sequence discretecharstate_id_sequence restart with 169616;
 
 -- CREATE TABLE JRUAN.DISTANCEMATRIXELEMENT ( 
 -- 	DISTANCEMATRIXELEMENT_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2269,6 +2320,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE distancematrixelement OWNER TO postgres;
+CREATE SEQUENCE distancematrixelement_id_sequence;
+ALTER TABLE distancematrixelement ALTER COLUMN distancematrixelement_id SET DEFAULT nextval('distancematrixelement_id_sequence');
+-- alter sequence distancematrixelement_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.EXPLAIN_ARGUMENT ( 
 -- 	EXPLAIN_REQUESTER  	VARCHAR(128) NOT NULL,
@@ -2463,6 +2517,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE gapmode OWNER TO postgres;
+CREATE SEQUENCE gapmode_id_sequence;
+ALTER TABLE gapmode ALTER COLUMN gapmode_id SET DEFAULT nextval('gapmode_id_sequence');
+-- alter sequence gapmode_id_sequence restart with 3;
 
 -- CREATE TABLE JRUAN.GENETICCODE ( 
 -- 	GENETICCODE_ID 	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2488,6 +2545,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE geneticcode OWNER TO postgres;
+CREATE SEQUENCE geneticcode_id_sequence;
+ALTER TABLE geneticcode ALTER COLUMN geneticcode_id SET DEFAULT nextval('geneticcode_id_sequence');
+-- alter sequence geneticcode_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.GENETICCODERECORD ( 
 -- 	GENETICCODERECORD_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2505,6 +2565,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE geneticcoderecord OWNER TO postgres;
+CREATE SEQUENCE geneticcoderecord_id_sequence;
+ALTER TABLE geneticcoderecord ALTER COLUMN geneticcoderecord_id SET DEFAULT nextval('geneticcoderecord_id_sequence');
+-- alter sequence geneticcoderecord_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.GENETICCODESET ( 
 -- 	GENETICCODESET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2524,8 +2587,10 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE geneticcodeset OWNER TO postgres;
+CREATE SEQUENCE geneticcodeset_id_sequence;
+ALTER TABLE geneticcodeset ALTER COLUMN geneticcodeset_id SET DEFAULT nextval('geneticcodeset_id_sequence');
+-- alter sequence geneticcodeset_id_sequence restart with 1;
 
-
 -- CREATE TABLE JRUAN.GEOSPOT ( 
 -- 	GEOSPOT_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
 -- 	VERSION   	INTEGER,
@@ -2548,6 +2613,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE geospot OWNER TO postgres;
+CREATE SEQUENCE geospot_id_sequence;
+ALTER TABLE geospot ALTER COLUMN geospot_id SET DEFAULT nextval('geospot_id_sequence');
+-- alter sequence geospot_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.HELP ( 
 -- 	HELP_ID 	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2565,6 +2633,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE help OWNER TO postgres;
+CREATE SEQUENCE help_id_sequence;
+ALTER TABLE help ALTER COLUMN help_id SET DEFAULT nextval('help_id_sequence');
+-- alter sequence help_id_sequence restart with 38;
 
 -- CREATE TABLE JRUAN.ITEMDEFINITION ( 
 -- 	ITEMDEFINITION_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2580,6 +2651,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE itemdefinition OWNER TO postgres;
+CREATE SEQUENCE itemdefinition_id_sequence;
+ALTER TABLE itemdefinition ALTER COLUMN itemdefinition_id SET DEFAULT nextval('itemdefinition_id_sequence');
+-- alter sequence itemdefinition_id_sequence restart with 9;
 
 -- CREATE TABLE JRUAN.ITEMVALUE ( 
 -- 	ITEMVALUE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2597,6 +2671,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE itemvalue OWNER TO postgres;
+CREATE SEQUENCE itemvalue_id_sequence;
+ALTER TABLE itemvalue ALTER COLUMN itemvalue_id SET DEFAULT nextval('itemvalue_id_sequence');
+-- alter sequence itemvalue_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.LEFTCHANGESET_CHARSTATE ( 
 -- 	STATECHANGESET_ID   	BIGINT NOT NULL,
@@ -2685,6 +2762,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrix OWNER TO postgres;
+CREATE SEQUENCE matrix_id_sequence;
+ALTER TABLE matrix ALTER COLUMN matrix_id SET DEFAULT nextval('matrix_id_sequence');
+-- alter sequence matrix_id_sequence restart with 3786;
 
 -- CREATE TABLE JRUAN.MATRIXCOLUMN_ITEMDEFINITION ( 
 -- 	MATRIXCOLUMN_ID  	BIGINT NOT NULL,
@@ -2719,6 +2799,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrixcolumn OWNER TO postgres;
+CREATE SEQUENCE matrixcolumn_id_sequence;
+ALTER TABLE matrixcolumn ALTER COLUMN matrixcolumn_id SET DEFAULT nextval('matrixcolumn_id_sequence');
+-- alter sequence matrixcolumn_id_sequence restart with 5681073;
 
 -- CREATE TABLE JRUAN.MATRIXDATATYPE ( 
 -- 	MATRIXDATATYPE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2736,6 +2819,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrixdatatype OWNER TO postgres;
+CREATE SEQUENCE matrixdatatype_id_sequence;
+ALTER TABLE matrixdatatype ALTER COLUMN matrixdatatype_id SET DEFAULT nextval('matrixdatatype_id_sequence');
+-- alter sequence matrixdatatype_id_sequence restart with 8;
 
 -- CREATE TABLE JRUAN.MATRIXELEMENT ( 
 -- 	TYPE                	CHARACTER(1) NOT NULL,
@@ -2769,6 +2855,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrixelement OWNER TO postgres;
+CREATE SEQUENCE matrixelement_id_sequence;
+ALTER TABLE matrixelement ALTER COLUMN matrixelement_id SET DEFAULT nextval('matrixelement_id_sequence');
+-- alter sequence matrixelement_id_sequence restart with 304732573;
 
 -- CREATE TABLE JRUAN.MATRIXKIND ( 
 -- 	MATRIXKIND_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2784,6 +2873,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrixkind OWNER TO postgres;
+CREATE SEQUENCE matrixkind_id_sequence;
+ALTER TABLE matrixkind ALTER COLUMN matrixkind_id SET DEFAULT nextval('matrixkind_id_sequence');
+-- alter sequence matrixkind_id_sequence restart with 12;
 
 -- CREATE TABLE JRUAN.MATRIXROW ( 
 -- 	MATRIXROW_ID 	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2805,6 +2897,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE matrixrow OWNER TO postgres;
+CREATE SEQUENCE matrixrow_id_sequence;
+ALTER TABLE matrixrow ALTER COLUMN matrixrow_id SET DEFAULT nextval('matrixrow_id_sequence');
+-- alter sequence matrixrow_id_sequence restart with 181845;
 
 -- CREATE TABLE JRUAN.NODEATTRIBUTE ( 
 -- 	NODEATTRIBUTE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2818,6 +2913,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE nodeattribute OWNER TO postgres;
+CREATE SEQUENCE nodeattribute_id_sequence;
+ALTER TABLE nodeattribute ALTER COLUMN nodeattribute_id SET DEFAULT nextval('nodeattribute_id_sequence');
+-- alter sequence nodeattribute_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.PERSON ( 
 -- 	PERSON_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2843,6 +2941,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE person OWNER TO postgres;
+CREATE SEQUENCE person_id_sequence;
+ALTER TABLE person ALTER COLUMN person_id SET DEFAULT nextval('person_id_sequence');
+-- alter sequence person_id_sequence restart with 4326;
 
 -- CREATE TABLE JRUAN.PHYLOCHAR ( 
 -- 	TYPE        	CHARACTER(1) NOT NULL,
@@ -2864,6 +2965,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE phylochar OWNER TO postgres;
+CREATE SEQUENCE phylochar_id_sequence;
+ALTER TABLE phylochar ALTER COLUMN phylochar_id SET DEFAULT nextval('phylochar_id_sequence');
+-- alter sequence phylochar_id_sequence restart with 32758;
 
 -- CREATE TABLE JRUAN.PHYLOTREE ( 
 -- 	PHYLOTREE_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2909,6 +3013,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE phylotree OWNER TO postgres;
+CREATE SEQUENCE phylotree_id_sequence;
+ALTER TABLE phylotree ALTER COLUMN phylotree_id SET DEFAULT nextval('phylotree_id_sequence');
+-- alter sequence phylotree_id_sequence restart with 5614;
 
 -- CREATE TABLE JRUAN.PHYLOTREENODE ( 
 -- 	PHYLOTREENODE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2944,6 +3051,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE phylotreenode OWNER TO postgres;
+CREATE SEQUENCE phylotreenode_id_sequence;
+ALTER TABLE phylotreenode ALTER COLUMN phylotreenode_id SET DEFAULT nextval('phylotreenode_id_sequence');
+-- alter sequence phylotreenode_id_sequence restart with 430424;
 
 -- CREATE TABLE JRUAN.POLYTCOUNT ( 
 -- 	POLYTCOUNT_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -2959,6 +3069,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE polytcount OWNER TO postgres;
+CREATE SEQUENCE polytcount_id_sequence;
+ALTER TABLE polytcount ALTER COLUMN polytcount_id SET DEFAULT nextval('polytcount_id_sequence');
+-- alter sequence polytcount_id_sequence restart with 3;
 
 -- CREATE TABLE JRUAN.RIGHTCHANGESET_CHARSTATE ( 
 -- 	STATECHANGESET_ID   	BIGINT NOT NULL,
@@ -3023,6 +3136,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE rowsegment OWNER TO postgres;
+CREATE SEQUENCE rowsegment_id_sequence;
+ALTER TABLE rowsegment ALTER COLUMN rowsegment_id SET DEFAULT nextval('rowsegment_id_sequence');
+-- alter sequence rowsegment_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.SOFTWARE ( 
 -- 	SOFTWARE_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3044,6 +3160,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE software OWNER TO postgres;
+CREATE SEQUENCE software_id_sequence;
+ALTER TABLE software ALTER COLUMN software_id SET DEFAULT nextval('software_id_sequence');
+-- alter sequence software_id_sequence restart with 4499;
 
 -- CREATE TABLE JRUAN.SPECIMENLABEL ( 
 -- 	SPECIMENLABEL_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3069,6 +3188,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE specimenlabel OWNER TO postgres;
+CREATE SEQUENCE specimenlabel_id_sequence;
+ALTER TABLE specimenlabel ALTER COLUMN specimenlabel_id SET DEFAULT nextval('specimenlabel_id_sequence');
+-- alter sequence specimenlabel_id_sequence restart with 4499;
 
 -- CREATE TABLE JRUAN.STATECHANGESET ( 
 -- 	STATECHANGESET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3086,6 +3208,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE statechangeset OWNER TO postgres;
+CREATE SEQUENCE statechangeset_id_sequence;
+ALTER TABLE statechangeset ALTER COLUMN statechangeset_id SET DEFAULT nextval('statechangeset_id_sequence');
+-- alter sequence statechangeset_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.STATEFORMAT ( 
 -- 	STATEFORMAT_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3101,6 +3226,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE stateformat OWNER TO postgres;
+CREATE SEQUENCE stateformat_id_sequence;
+ALTER TABLE stateformat ALTER COLUMN stateformat_id SET DEFAULT nextval('stateformat_id_sequence');
+-- alter sequence stateformat_id_sequence restart with 5;
 
 -- CREATE TABLE JRUAN.STATEMODIFIER ( 
 -- 	STATEMODIFIER_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3124,6 +3252,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE statemodifier OWNER TO postgres;
+CREATE SEQUENCE statemodifier_id_sequence;
+ALTER TABLE statemodifier ALTER COLUMN statemodifier_id SET DEFAULT nextval('statemodifier_id_sequence');
+-- alter sequence statemodifier_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.STATESET ( 
 -- 	STATESET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3141,6 +3272,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE stateset OWNER TO postgres;
+CREATE SEQUENCE stateset_id_sequence;
+ALTER TABLE stateset ALTER COLUMN stateset_id SET DEFAULT nextval('stateset_id_sequence');
+-- alter sequence stateset_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.STEPMATRIXELEMENT ( 
 -- 	DISCRETECHARSTATE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3208,6 +3342,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE study OWNER TO postgres;
+CREATE SEQUENCE study_id_sequence;
+ALTER TABLE study ALTER COLUMN study_id SET DEFAULT nextval('study_id_sequence');
+-- alter sequence study_id_sequence restart with 2067;
 
 -- CREATE TABLE JRUAN.STUDYSTATUS ( 
 -- 	STUDYSTATUS_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3223,6 +3360,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE studystatus OWNER TO postgres;
+CREATE SEQUENCE studystatus_id_sequence;
+ALTER TABLE studystatus ALTER COLUMN studystatus_id SET DEFAULT nextval('studystatus_id_sequence');
+-- alter sequence studystatus_id_sequence restart with 4;
 
 -- CREATE TABLE JRUAN.SUB_MATRIX ( 
 -- 	SUBMISSION_ID	BIGINT NOT NULL,
@@ -3289,6 +3429,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE submission OWNER TO postgres;
+CREATE SEQUENCE submission_id_sequence;
+ALTER TABLE submission ALTER COLUMN submission_id SET DEFAULT nextval('submission_id_sequence');
+-- alter sequence submission_id_sequence restart with 2059;
 
 -- CREATE TABLE JRUAN.TAXON ( 
 -- 	TAXON_ID      	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3314,6 +3457,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxon OWNER TO postgres;
+CREATE SEQUENCE taxon_id_sequence;
+ALTER TABLE taxon ALTER COLUMN taxon_id SET DEFAULT nextval('taxon_id_sequence');
+-- alter sequence taxon_id_sequence restart with 424700;
 
 -- CREATE TABLE JRUAN.TAXONAUTHORITY ( 
 -- 	TAXONAUTHORITY_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3333,6 +3479,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonauthority OWNER TO postgres;
+CREATE SEQUENCE taxonauthority_id_sequence;
+ALTER TABLE taxonauthority ALTER COLUMN taxonauthority_id SET DEFAULT nextval('taxonauthority_id_sequence');
+-- alter sequence taxonauthority_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TAXONLABEL ( 
 -- 	TAXONLABEL_ID  	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3354,6 +3503,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonlabel OWNER TO postgres;
+CREATE SEQUENCE taxonlabel_id_sequence;
+ALTER TABLE taxonlabel ALTER COLUMN taxonlabel_id SET DEFAULT nextval('taxonlabel_id_sequence');
+-- alter sequence taxonlabel_id_sequence restart with 231762;
 
 -- CREATE TABLE JRUAN.TAXONLABELGROUP ( 
 -- 	TAXONLABELGROUP_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3371,6 +3523,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonlabelgroup OWNER TO postgres;
+CREATE SEQUENCE taxonlabelgroup_id_sequence;
+ALTER TABLE taxonlabelgroup ALTER COLUMN taxonlabelgroup_id SET DEFAULT nextval('taxonlabelgroup_id_sequence');
+-- alter sequence taxonlabelgroup_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TAXONLABELPARTITION ( 
 -- 	TAXONLABELPARTITION_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3386,6 +3541,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonlabelpartition OWNER TO postgres;
+CREATE SEQUENCE taxonlabelpartition_id_sequence;
+ALTER TABLE taxonlabelpartition ALTER COLUMN taxonlabelpartition_id SET DEFAULT nextval('taxonlabelpartition_id_sequence');
+-- alter sequence taxonlabelpartition_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TAXONLABELROUP_TAXONLABEL ( 
 -- 	TAXONLABELGROUP_ID	BIGINT NOT NULL,
@@ -3433,6 +3591,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonlabelset OWNER TO postgres;
+CREATE SEQUENCE taxonlabelset_id_sequence;
+ALTER TABLE taxonlabelset ALTER COLUMN taxonlabelset_id SET DEFAULT nextval('taxonlabelset_id_sequence');
+-- alter sequence taxonlabelset_id_sequence restart with 13124;
 
 -- CREATE TABLE JRUAN.TAXONLINK ( 
 -- 	LINKTYPE         	CHARACTER(1) NOT NULL,
@@ -3454,6 +3615,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonlink OWNER TO postgres;
+CREATE SEQUENCE taxonlink_id_sequence;
+ALTER TABLE taxonlink ALTER COLUMN taxonlink_id SET DEFAULT nextval('taxonlink_id_sequence');
+-- alter sequence taxonlink_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TAXONSET_TAXON ( 
 -- 	TAXONSET_ID	BIGINT NOT NULL,
@@ -3484,6 +3648,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonset OWNER TO postgres;
+CREATE SEQUENCE taxonset_id_sequence;
+ALTER TABLE taxonset ALTER COLUMN taxonset_id SET DEFAULT nextval('taxonset_id_sequence');
+-- alter sequence taxonset_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TAXONVARIANT ( 
 -- 	TAXONVARIANT_ID 	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3509,6 +3676,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE taxonvariant OWNER TO postgres;
+CREATE SEQUENCE taxonvariant_id_sequence;
+ALTER TABLE taxonvariant ALTER COLUMN taxonvariant_id SET DEFAULT nextval('taxonvariant_id_sequence');
+-- alter sequence taxonvariant_id_sequence restart with 564260;
 
 -- CREATE TABLE JRUAN.TREEATTRIBUTE ( 
 -- 	TREEATTRIBUTE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3522,6 +3692,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treeattribute OWNER TO postgres;
+CREATE SEQUENCE treeattribute_id_sequence;
+ALTER TABLE treeattribute ALTER COLUMN treeattribute_id SET DEFAULT nextval('treeattribute_id_sequence');
+-- alter sequence treeattribute_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TREEBLOCK ( 
 -- 	TREEBLOCK_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3539,6 +3712,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treeblock OWNER TO postgres;
+CREATE SEQUENCE treeblock_id_sequence;
+ALTER TABLE treeblock ALTER COLUMN treeblock_id SET DEFAULT nextval('treeblock_id_sequence');
+-- alter sequence treeblock_id_sequence restart with 9028;
 
 -- CREATE TABLE JRUAN.TREEGROUP_PHYLOTREE ( 
 -- 	TREEGROUP_ID	BIGINT NOT NULL,
@@ -3569,6 +3745,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treegroup OWNER TO postgres;
+CREATE SEQUENCE treegroup_id_sequence;
+ALTER TABLE treegroup ALTER COLUMN treegroup_id SET DEFAULT nextval('treegroup_id_sequence');
+-- alter sequence treegroup_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TREEKIND ( 
 -- 	TREEKIND_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3584,6 +3763,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treekind OWNER TO postgres;
+CREATE SEQUENCE treekind_id_sequence;
+ALTER TABLE treekind ALTER COLUMN treekind_id SET DEFAULT nextval('treekind_id_sequence');
+-- alter sequence treekind_id_sequence restart with 7;
 
 -- CREATE TABLE JRUAN.TREENODEEDGE ( 
 -- 	TREENODEEDGE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3601,6 +3783,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treenodeedge OWNER TO postgres;
+CREATE SEQUENCE treenodeedge_id_sequence;
+ALTER TABLE treenodeedge ALTER COLUMN treenodeedge_id SET DEFAULT nextval('treenodeedge_id_sequence');
+-- alter sequence treenodeedge_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TREEPARTITION ( 
 -- 	TREEPARTITION_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3616,6 +3801,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treepartition OWNER TO postgres;
+CREATE SEQUENCE treepartition_id_sequence;
+ALTER TABLE treepartition ALTER COLUMN treepartition_id SET DEFAULT nextval('treepartition_id_sequence');
+-- alter sequence treepartition_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TREEQUALITY ( 
 -- 	TREEQUALITY_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3631,6 +3819,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treequality OWNER TO postgres;
+CREATE SEQUENCE treequality_id_sequence;
+ALTER TABLE treequality ALTER COLUMN treequality_id SET DEFAULT nextval('treequality_id_sequence');
+-- alter sequence treequality_id_sequence restart with 5;
 
 -- CREATE TABLE JRUAN.TREESET_PHYLOTREE ( 
 -- 	TREESET_ID  	BIGINT NOT NULL,
@@ -3661,6 +3852,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treeset OWNER TO postgres;
+CREATE SEQUENCE treeset_id_sequence;
+ALTER TABLE treeset ALTER COLUMN treeset_id SET DEFAULT nextval('treeset_id_sequence');
+-- alter sequence treeset_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.TREETYPE ( 
 -- 	TREETYPE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3676,6 +3870,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE treetype OWNER TO postgres;
+CREATE SEQUENCE treetype_id_sequence;
+ALTER TABLE treetype ALTER COLUMN treetype_id SET DEFAULT nextval('treetype_id_sequence');
+-- alter sequence treetype_id_sequence restart with 4;
 
 -- CREATE TABLE JRUAN.TYPESET ( 
 -- 	TYPESET_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3693,6 +3890,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE typeset OWNER TO postgres;
+CREATE SEQUENCE typeset_id_sequence;
+ALTER TABLE typeset ALTER COLUMN typeset_id SET DEFAULT nextval('typeset_id_sequence');
+-- alter sequence typeset_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.USER ( 
 -- 	USER_ID    	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3714,6 +3914,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE "user" OWNER TO postgres;
+CREATE SEQUENCE user_id_sequence;
+ALTER TABLE "user" ALTER COLUMN user_id SET DEFAULT nextval('user_id_sequence');
+-- alter sequence user_id_sequence restart with 12;
 
 -- CREATE TABLE JRUAN.USERROLE ( 
 -- 	USERROLE_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3729,6 +3932,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE userrole OWNER TO postgres;
+CREATE SEQUENCE userrole_id_sequence;
+ALTER TABLE "userrole" ALTER COLUMN userrole_id SET DEFAULT nextval('userrole_id_sequence');
+-- alter sequence userrole_id_sequence restart with 4;
 
 -- CREATE TABLE JRUAN.USERTYPE ( 
 -- 	TYPE       	CHARACTER(1) NOT NULL,
@@ -3746,6 +3952,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE usertype OWNER TO postgres;
+CREATE SEQUENCE usertype_id_sequence;
+ALTER TABLE usertype ALTER COLUMN usertype_id SET DEFAULT nextval('usertype_id_sequence');
+-- alter sequence usertype_id_sequence restart with 4;
 
 -- CREATE TABLE JRUAN.USERTYPERECORD ( 
 -- 	USERTYPERECORD_ID	BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
@@ -3763,6 +3972,9 @@
 )
 WITH (OIDS=FALSE);
 ALTER TABLE usertyperecord OWNER TO postgres;
+CREATE SEQUENCE usertyperecord_id_sequence;
+ALTER TABLE usertyperecord ALTER COLUMN usertyperecord_id SET DEFAULT nextval('usertyperecord_id_sequence');
+-- alter sequence usertyperecord_id_sequence restart with 1;
 
 -- CREATE TABLE JRUAN.USERTYPERRD_COLRANGE ( 
 -- 	USERTYPERECORD_ID	BIGINT NOT NULL,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.