Menu
▾
▴
[Treebase-guts] SF.net SVN: treebase:[283] trunk/treebase-core/src/main/resources/ TBASE2_POSTGRES_CREATION.sql
|
From: <rv...@us...> - 2009-11-18 18:14:30
|
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.
|
