|
From: <rv...@us...> - 2009-11-30 10:25:30
|
Revision: 330
http://treebase.svn.sourceforge.net/treebase/?rev=330&view=rev
Author: rvos
Date: 2009-11-30 10:25:20 +0000 (Mon, 30 Nov 2009)
Log Message:
-----------
Recalculated sequence restart values
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-25 17:15:46 UTC (rev 329)
+++ trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql 2009-11-30 10:25:20 UTC (rev 330)
@@ -1,1723 +1,3 @@
-/*
---Script generated by Aqua Data Studio 6.5.12 on Jun-12-2009 12:30:24 AM
---Database: TBASE2
---Schema: JRUAN
---Objects: TABLE
-*/
--- ALTER TABLE JRUAN.USERTYPERRD_COLRANGE
--- DROP CONSTRAINT FK405805DDC009330E
--- GO
--- ALTER TABLE JRUAN.USERTYPERRD_COLRANGE
--- DROP CONSTRAINT FK405805DD79A523E6
--- GO
--- ALTER TABLE JRUAN.USERTYPERECORD
--- DROP CONSTRAINT FK136AF61692E6A38E
--- GO
--- ALTER TABLE JRUAN.USERTYPERECORD
--- DROP CONSTRAINT FK136AF6164D737E46
--- GO
--- ALTER TABLE JRUAN.USER
--- DROP CONSTRAINT FK27E3CBF59DD12
--- GO
--- ALTER TABLE JRUAN.USER
--- DROP CONSTRAINT FK27E3CBE3910672
--- GO
--- ALTER TABLE JRUAN.TYPESET
--- DROP CONSTRAINT FKF7F2B6C8A414944F
--- GO
--- ALTER TABLE JRUAN.TREESET_PHYLOTREE
--- DROP CONSTRAINT FK31FC19A7EC59B1E3
--- GO
--- ALTER TABLE JRUAN.TREESET_PHYLOTREE
--- DROP CONSTRAINT FK31FC19A7B710CB23
--- GO
--- ALTER TABLE JRUAN.TREENODEEDGE
--- DROP CONSTRAINT FK7767285D27FD0589
--- GO
--- ALTER TABLE JRUAN.TREENODEEDGE
--- DROP CONSTRAINT FK7767285D1851763B
--- GO
--- ALTER TABLE JRUAN.TREEGROUP
--- DROP CONSTRAINT FKA870258180CBD223
--- GO
--- ALTER TABLE JRUAN.TREEGROUP_PHYLOTREE
--- DROP CONSTRAINT FKFB7D704B710CB23
--- GO
--- ALTER TABLE JRUAN.TREEGROUP_PHYLOTREE
--- DROP CONSTRAINT FKFB7D7045E56A83
--- GO
--- ALTER TABLE JRUAN.TREEBLOCK
--- DROP CONSTRAINT FKA826F38FE310471D
--- GO
--- ALTER TABLE JRUAN.TAXONVARIANT
--- DROP CONSTRAINT FKEE3D127B1DE2FCDD
--- GO
--- ALTER TABLE JRUAN.TAXONSET_TAXON
--- DROP CONSTRAINT FKC656C9031DE2FCDD
--- GO
--- ALTER TABLE JRUAN.TAXONSET_TAXON
--- DROP CONSTRAINT FKC656C90313C28457
--- GO
--- ALTER TABLE JRUAN.TAXONLINK
--- DROP CONSTRAINT FKC102D9A43BF5F2F7
--- GO
--- ALTER TABLE JRUAN.TAXONLINK
--- DROP CONSTRAINT FKC102D9A41DE2FCDD
--- GO
--- ALTER TABLE JRUAN.TAXONLABELSET
--- DROP CONSTRAINT FK28D3A5983C572C3C
--- GO
--- ALTER TABLE JRUAN.TAXONLABELSET_TAXONLABEL
--- DROP CONSTRAINT FK2EB54B71E310471D
--- GO
--- ALTER TABLE JRUAN.TAXONLABELSET_TAXONLABEL
--- DROP CONSTRAINT FK2EB54B7163AB9FD7
--- GO
--- ALTER TABLE JRUAN.TAXONLABELROUP_TAXONLABEL
--- DROP CONSTRAINT FK4B1D0BC763AB9FD7
--- GO
--- ALTER TABLE JRUAN.TAXONLABELROUP_TAXONLABEL
--- DROP CONSTRAINT FK4B1D0BC7294B993D
--- GO
--- ALTER TABLE JRUAN.TAXONLABELGROUP
--- DROP CONSTRAINT FK4AE2663513A813DD
--- GO
--- ALTER TABLE JRUAN.TAXONLABEL
--- DROP CONSTRAINT FK5F548A6A3C572C3C
--- GO
--- ALTER TABLE JRUAN.TAXONLABEL
--- DROP CONSTRAINT FK5F548A6A3C1B6F7
--- GO
--- ALTER TABLE JRUAN.SUBMISSION
--- DROP CONSTRAINT FKA120274CBEF300B2
--- GO
--- ALTER TABLE JRUAN.SUBMISSION
--- DROP CONSTRAINT FKA120274C3C572C3C
--- GO
--- ALTER TABLE JRUAN.SUB_TREEBLOCK
--- DROP CONSTRAINT FK94D50830BFD107C3
--- GO
--- ALTER TABLE JRUAN.SUB_TREEBLOCK
--- DROP CONSTRAINT FK94D508308DFE4858
--- GO
--- ALTER TABLE JRUAN.SUB_TAXONLABEL
--- DROP CONSTRAINT FK86909E98DFE4858
--- GO
--- ALTER TABLE JRUAN.SUB_TAXONLABEL
--- DROP CONSTRAINT FK86909E963AB9FD7
--- GO
--- ALTER TABLE JRUAN.SUB_MATRIX
--- DROP CONSTRAINT FK5F26A2C08DFE4858
--- GO
--- ALTER TABLE JRUAN.SUB_MATRIX
--- DROP CONSTRAINT FK5F26A2C055961AEE
--- GO
--- ALTER TABLE JRUAN.STUDY
--- DROP CONSTRAINT FK4B915A9BEF300B2
--- GO
--- ALTER TABLE JRUAN.STUDY
--- DROP CONSTRAINT FK4B915A98E1E4DF8
--- GO
--- ALTER TABLE JRUAN.STUDY
--- DROP CONSTRAINT FK4B915A9255A519C
--- GO
--- ALTER TABLE JRUAN.STUDY_NEXUSFILE
--- DROP CONSTRAINT FK47FC1EE53C572C3C
--- GO
--- ALTER TABLE JRUAN.STEPMATRIXELEMENT
--- DROP CONSTRAINT FK891100AF9E8198E
--- GO
--- ALTER TABLE JRUAN.STEPMATRIXELEMENT
--- DROP CONSTRAINT FK891100AF6E979EE7
--- GO
--- ALTER TABLE JRUAN.STEPMATRIXELEMENT
--- DROP CONSTRAINT FK891100AF6E972A88
--- GO
--- ALTER TABLE JRUAN.STATESET
--- DROP CONSTRAINT FK7D38523150CBAB47
--- GO
--- ALTER TABLE JRUAN.STATEMODIFIER
--- DROP CONSTRAINT FKD157BE48F4803CE6
--- GO
--- ALTER TABLE JRUAN.STATEMODIFIER
--- DROP CONSTRAINT FKD157BE48BED40086
--- GO
--- ALTER TABLE JRUAN.STATEMODIFIER
--- DROP CONSTRAINT FKD157BE48459091E5
--- GO
--- ALTER TABLE JRUAN.SPECIMENLABEL
--- DROP CONSTRAINT FK1E8F38CCA2039B9D
--- GO
--- ALTER TABLE JRUAN.ROWSEGMENT
--- DROP CONSTRAINT FKEE9AE819E7B3CDA6
--- GO
--- ALTER TABLE JRUAN.ROWSEGMENT
--- DROP CONSTRAINT FKEE9AE81963AB9FD7
--- GO
--- ALTER TABLE JRUAN.RIGHTCHANGESET_CHARSTATE
--- DROP CONSTRAINT FKC8AFC9F2F4803CE6
--- GO
--- ALTER TABLE JRUAN.RIGHTCHANGESET_CHARSTATE
--- DROP CONSTRAINT FKC8AFC9F275763EAE
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA79944B710CB23
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA7994463AB9FD7
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA799445BCC767D
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA79944434FDCCB
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA799443C348165
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT FK3EA79944271A5763
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442FE2812F1
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442F5AEA931
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442F3D1CF03
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442EA08B443
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442BFD107C3
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E442A3015CE3
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT FK76F2E4423C572C3C
--- GO
--- ALTER TABLE JRUAN.MATRIXROW
--- DROP CONSTRAINT FKE4688E59A414944F
--- GO
--- ALTER TABLE JRUAN.MATRIXROW
--- DROP CONSTRAINT FKE4688E5963AB9FD7
--- GO
--- ALTER TABLE JRUAN.MATRIXELEMENT
--- DROP CONSTRAINT FK90AE93FBF4803CE6
--- GO
--- ALTER TABLE JRUAN.MATRIXELEMENT
--- DROP CONSTRAINT FK90AE93FBE7B3CDA6
--- GO
--- ALTER TABLE JRUAN.MATRIXELEMENT
--- DROP CONSTRAINT FK90AE93FB8B2E884E
--- GO
--- ALTER TABLE JRUAN.MATRIXELEMENT
--- DROP CONSTRAINT FK90AE93FB405A7CEE
--- GO
--- ALTER TABLE JRUAN.MATRIXDATATYPE
--- DROP CONSTRAINT FKF054C4A5F5DECA46
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN
--- DROP CONSTRAINT FK9B0BE57F5DECA46
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN
--- DROP CONSTRAINT FK9B0BE57BED40086
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN
--- DROP CONSTRAINT FK9B0BE57A414944F
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN_ITEMDEFINITION
--- DROP CONSTRAINT FKB556F8E8B2E884E
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN_ITEMDEFINITION
--- DROP CONSTRAINT FKB556F8E405A7CEE
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC1E9B425A6
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC1E310471D
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC191BD3C8E
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC1684F6406
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC14D737E46
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC14CE484AE
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC1491DB20E
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC145534A9C
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT FK87208BC13C572C3C
--- GO
--- ALTER TABLE JRUAN.MATRIX_ITEMDEFINITION
--- DROP CONSTRAINT FK5717E0E4AC5C19DD
--- GO
--- ALTER TABLE JRUAN.MATRIX_ITEMDEFINITION
--- DROP CONSTRAINT FK5717E0E4405A7CEE
--- GO
--- ALTER TABLE JRUAN.LEFTCHANGESET_CHARSTATE
--- DROP CONSTRAINT FKC8877207F4803CE6
--- GO
--- ALTER TABLE JRUAN.LEFTCHANGESET_CHARSTATE
--- DROP CONSTRAINT FKC887720775763EAE
--- GO
--- ALTER TABLE JRUAN.ITEMVALUE
--- DROP CONSTRAINT FK27B41A1E459091E5
--- GO
--- ALTER TABLE JRUAN.GENETICCODESET
--- DROP CONSTRAINT FK6A12F7DCA414944F
--- GO
--- ALTER TABLE JRUAN.GENETICCODERECORD
--- DROP CONSTRAINT FK237932B782D8ECCE
--- GO
--- ALTER TABLE JRUAN.GENETICCODERECORD
--- DROP CONSTRAINT FK237932B76CB73FC6
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_STREAM
--- DROP CONSTRAINT SQL050919121811070
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_STATEMENT
--- DROP CONSTRAINT SQL050919121810950
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_PREDICATE
--- DROP CONSTRAINT SQL050919121811040
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_OPERATOR
--- DROP CONSTRAINT SQL050919121810970
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_OBJECT
--- DROP CONSTRAINT SQL050919121811000
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_ARGUMENT
--- DROP CONSTRAINT SQL050919121811060
--- GO
--- ALTER TABLE JRUAN.DISTANCEMATRIXELEMENT
--- DROP CONSTRAINT FK92D3DDE6C1429863
--- GO
--- ALTER TABLE JRUAN.DISTANCEMATRIXELEMENT
--- DROP CONSTRAINT FK92D3DDE64B8EF343
--- GO
--- ALTER TABLE JRUAN.DISTANCEMATRIXELEMENT
--- DROP CONSTRAINT FK92D3DDE61F08BAE7
--- GO
--- ALTER TABLE JRUAN.DISCRETECHARSTATE
--- DROP CONSTRAINT FK2EEF2802FE41A723
--- GO
--- ALTER TABLE JRUAN.DISCRETECHARSTATE
--- DROP CONSTRAINT FK2EEF2802C7BEAAFE
--- GO
--- ALTER TABLE JRUAN.DISCRETECHARSTATE
--- DROP CONSTRAINT FK2EEF2802163C67CE
--- GO
--- ALTER TABLE JRUAN.CSTREENODE
--- DROP CONSTRAINT FK82B9AB10F572A92
--- GO
--- ALTER TABLE JRUAN.CSTREENODE
--- DROP CONSTRAINT FK82B9AB10F4803CE6
--- GO
--- ALTER TABLE JRUAN.CSTREENODE
--- DROP CONSTRAINT FK82B9AB10C6999FCE
--- GO
--- ALTER TABLE JRUAN.CONTANCSTATE_VALUE
--- DROP CONSTRAINT FKA84B8C3FD450D2BD
--- GO
--- ALTER TABLE JRUAN.COMPOUND_ELEMENT
--- DROP CONSTRAINT FK311830485F4F7CEB
--- GO
--- ALTER TABLE JRUAN.COMPOUND_ELEMENT
--- DROP CONSTRAINT FK31183048459091E5
--- GO
--- ALTER TABLE JRUAN.CODONPOSITIONSET
--- DROP CONSTRAINT FK4E501CC2A414944F
--- GO
--- ALTER TABLE JRUAN.CODONNONCODING_COLRANGE
--- DROP CONSTRAINT FK307897FC79A523E6
--- GO
--- ALTER TABLE JRUAN.CODONNONCODING_COLRANGE
--- DROP CONSTRAINT FK307897FC491DB20E
--- GO
--- ALTER TABLE JRUAN.CODONCHAR3_COLRANGE
--- DROP CONSTRAINT FKC2EDB73679A523E6
--- GO
--- ALTER TABLE JRUAN.CODONCHAR3_COLRANGE
--- DROP CONSTRAINT FKC2EDB736491DB20E
--- GO
--- ALTER TABLE JRUAN.CODONCHAR2_COLRANGE
--- DROP CONSTRAINT FKCEA4461779A523E6
--- GO
--- ALTER TABLE JRUAN.CODONCHAR2_COLRANGE
--- DROP CONSTRAINT FKCEA44617491DB20E
--- GO
--- ALTER TABLE JRUAN.CODONCHAR1_COLRANGE
--- DROP CONSTRAINT FKDA5AD4F879A523E6
--- GO
--- ALTER TABLE JRUAN.CODONCHAR1_COLRANGE
--- DROP CONSTRAINT FKDA5AD4F8491DB20E
--- GO
--- ALTER TABLE JRUAN.CODERECORD_COLRANGE
--- DROP CONSTRAINT FKA3E6C61EDC51C546
--- GO
--- ALTER TABLE JRUAN.CODERECORD_COLRANGE
--- DROP CONSTRAINT FKA3E6C61E79A523E6
--- GO
--- ALTER TABLE JRUAN.CITATION
--- DROP CONSTRAINT FKD8A7FAE74C983658
--- GO
--- ALTER TABLE JRUAN.CITATION_EDITOR
--- DROP CONSTRAINT FK2A8955C5EC93F501
--- GO
--- ALTER TABLE JRUAN.CITATION_EDITOR
--- DROP CONSTRAINT FK2A8955C568F6F619
--- GO
--- ALTER TABLE JRUAN.CITATION_AUTHOR
--- DROP CONSTRAINT FK24AA55E38E1E4DF8
--- GO
--- ALTER TABLE JRUAN.CITATION_AUTHOR
--- DROP CONSTRAINT FK24AA55E36707573B
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHTSET
--- DROP CONSTRAINT FK99B8AC34A414944F
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHT
--- DROP CONSTRAINT FK8CC7694EE9B425A6
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHT_COLRANGE
--- DROP CONSTRAINT FK54CA674EF9A75EE
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHT_COLRANGE
--- DROP CONSTRAINT FK54CA674E79A523E6
--- GO
--- ALTER TABLE JRUAN.CHARSET
--- DROP CONSTRAINT FK56D8ED2CA414944F
--- GO
--- ALTER TABLE JRUAN.CHARSET_COLRANGE
--- DROP CONSTRAINT FK2CBD9079A523E6
--- GO
--- ALTER TABLE JRUAN.CHARSET_COLRANGE
--- DROP CONSTRAINT FK2CBD90416D5B50
--- GO
--- ALTER TABLE JRUAN.CHARPARTITION
--- DROP CONSTRAINT FKDEA9F834A414944F
--- GO
--- ALTER TABLE JRUAN.CHARGROUP
--- DROP CONSTRAINT FK3AF18C91AA11DC6
--- GO
--- ALTER TABLE JRUAN.CHARGROUP_COLRANGE
--- DROP CONSTRAINT FKB2D8C293971FFFA6
--- GO
--- ALTER TABLE JRUAN.CHARGROUP_COLRANGE
--- DROP CONSTRAINT FKB2D8C29379A523E6
--- GO
--- ALTER TABLE JRUAN.ANCSTATESET
--- DROP CONSTRAINT FK879339E7A414944F
--- GO
--- ALTER TABLE JRUAN.ANCESTRALSTATE
--- DROP CONSTRAINT FK3FA14284F4803CE6
--- GO
--- ALTER TABLE JRUAN.ANCESTRALSTATE
--- DROP CONSTRAINT FK3FA14284684F6406
--- GO
--- ALTER TABLE JRUAN.ANALYZEDDATA
--- DROP CONSTRAINT FK8C961842B710CB23
--- GO
--- ALTER TABLE JRUAN.ANALYZEDDATA
--- DROP CONSTRAINT FK8C96184255961AEE
--- GO
--- ALTER TABLE JRUAN.ANALYZEDDATA
--- DROP CONSTRAINT FK8C9618424BA97F78
--- GO
--- ALTER TABLE JRUAN.ANALYSISSTEP
--- DROP CONSTRAINT FK21F853A8D1884DD8
--- GO
--- ALTER TABLE JRUAN.ANALYSISSTEP
--- DROP CONSTRAINT FK21F853A865EDD5F8
--- GO
--- ALTER TABLE JRUAN.ANALYSISSTEP
--- DROP CONSTRAINT FK21F853A848A2817C
--- GO
--- ALTER TABLE JRUAN.ANALYSIS
--- DROP CONSTRAINT FKF19622DC3C572C3C
--- GO
--- ALTER TABLE JRUAN.ALGORITHM
--- DROP CONSTRAINT FKB388C44FC6E814E6
--- GO
--- ALTER TABLE JRUAN.ALGORITHM
--- DROP CONSTRAINT FKB388C44F9698D32E
--- GO
--- ALTER TABLE JRUAN.ALGORITHM
--- DROP CONSTRAINT FKB388C44F92E6A38E
--- GO
--- ALTER TABLE JRUAN.USERTYPERRD_COLRANGE
--- DROP CONSTRAINT SQL081219134227270
--- GO
--- ALTER TABLE JRUAN.USER
--- DROP CONSTRAINT SQL081219134226851
--- GO
--- ALTER TABLE JRUAN.SUBMISSION
--- DROP CONSTRAINT SQL081219134223811
--- GO
--- ALTER TABLE JRUAN.SUB_TREEBLOCK
--- DROP CONSTRAINT SQL081219134224130
--- GO
--- ALTER TABLE JRUAN.SUB_TAXONLABEL
--- DROP CONSTRAINT SQL081219134224030
--- GO
--- ALTER TABLE JRUAN.SUB_MATRIX
--- DROP CONSTRAINT SQL081219134223920
--- GO
--- ALTER TABLE JRUAN.COMPOUND_ELEMENT
--- DROP CONSTRAINT SQL081219134219010
--- GO
--- ALTER TABLE JRUAN.CODONNONCODING_COLRANGE
--- DROP CONSTRAINT SQL081219134220010
--- GO
--- ALTER TABLE JRUAN.CODONCHAR3_COLRANGE
--- DROP CONSTRAINT SQL081219134219910
--- GO
--- ALTER TABLE JRUAN.CODONCHAR2_COLRANGE
--- DROP CONSTRAINT SQL081219134219810
--- GO
--- ALTER TABLE JRUAN.CODONCHAR1_COLRANGE
--- DROP CONSTRAINT SQL081219134219710
--- GO
--- ALTER TABLE JRUAN.CODERECORD_COLRANGE
--- DROP CONSTRAINT SQL081219134219610
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHT_COLRANGE
--- DROP CONSTRAINT SQL081219134219510
--- GO
--- ALTER TABLE JRUAN.CHARSET_COLRANGE
--- DROP CONSTRAINT SQL081219134219400
--- GO
--- ALTER TABLE JRUAN.CHARGROUP_COLRANGE
--- DROP CONSTRAINT SQL081219134219300
--- GO
--- ALTER TABLE JRUAN.USERTYPERECORD
--- DROP CONSTRAINT SQL081219134227170
--- GO
--- ALTER TABLE JRUAN.USERTYPE
--- DROP CONSTRAINT SQL081219134227060
--- GO
--- ALTER TABLE JRUAN.USERROLE
--- DROP CONSTRAINT SQL081219134226960
--- GO
--- ALTER TABLE JRUAN.USER
--- DROP CONSTRAINT SQL081219134226850
--- GO
--- ALTER TABLE JRUAN.TYPESET
--- DROP CONSTRAINT SQL081219134226550
--- GO
--- ALTER TABLE JRUAN.TREETYPE
--- DROP CONSTRAINT SQL081219134226440
--- GO
--- ALTER TABLE JRUAN.TREESET
--- DROP CONSTRAINT SQL081219134226240
--- GO
--- ALTER TABLE JRUAN.TREESET_PHYLOTREE
--- DROP CONSTRAINT SQL081219134226340
--- GO
--- ALTER TABLE JRUAN.TREEQUALITY
--- DROP CONSTRAINT SQL081219134226140
--- GO
--- ALTER TABLE JRUAN.TREEPARTITION
--- DROP CONSTRAINT SQL081219134226040
--- GO
--- ALTER TABLE JRUAN.TREENODEEDGE
--- DROP CONSTRAINT SQL081219134225930
--- GO
--- ALTER TABLE JRUAN.TREEKIND
--- DROP CONSTRAINT SQL081219134225820
--- GO
--- ALTER TABLE JRUAN.TREEGROUP
--- DROP CONSTRAINT SQL081219134225620
--- GO
--- ALTER TABLE JRUAN.TREEGROUP_PHYLOTREE
--- DROP CONSTRAINT SQL081219134225720
--- GO
--- ALTER TABLE JRUAN.TREEBLOCK
--- DROP CONSTRAINT SQL081219134225510
--- GO
--- ALTER TABLE JRUAN.TREEATTRIBUTE
--- DROP CONSTRAINT SQL081219134225410
--- GO
--- ALTER TABLE JRUAN.TAXONVARIANT
--- DROP CONSTRAINT SQL081219134225250
--- GO
--- ALTER TABLE JRUAN.TAXONSET
--- DROP CONSTRAINT SQL081219134225050
--- GO
--- ALTER TABLE JRUAN.TAXONSET_TAXON
--- DROP CONSTRAINT SQL081219134225150
--- GO
--- ALTER TABLE JRUAN.TAXONLINK
--- DROP CONSTRAINT SQL081219134224950
--- GO
--- ALTER TABLE JRUAN.TAXONLABELSET
--- DROP CONSTRAINT SQL081219134226650
--- GO
--- ALTER TABLE JRUAN.TAXONLABELSET_TAXONLABEL
--- DROP CONSTRAINT SQL081219134226750
--- GO
--- ALTER TABLE JRUAN.TAXONLABELPARTITION
--- DROP CONSTRAINT SQL081219134224760
--- GO
--- ALTER TABLE JRUAN.TAXONLABELGROUP
--- DROP CONSTRAINT SQL081219134224650
--- GO
--- ALTER TABLE JRUAN.TAXONLABEL
--- DROP CONSTRAINT SQL081219134224550
--- GO
--- ALTER TABLE JRUAN.TAXONAUTHORITY
--- DROP CONSTRAINT SQL081219134224450
--- GO
--- ALTER TABLE JRUAN.TAXON
--- DROP CONSTRAINT SQL081219134224350
--- GO
--- ALTER TABLE JRUAN.SUBMISSION
--- DROP CONSTRAINT SQL081219134223810
--- GO
--- ALTER TABLE JRUAN.SUB_TREEBLOCK
--- DROP CONSTRAINT SQL081219134224120
--- GO
--- ALTER TABLE JRUAN.SUB_TAXONLABEL
--- DROP CONSTRAINT SQL081219134224020
--- GO
--- ALTER TABLE JRUAN.SUB_MATRIX
--- DROP CONSTRAINT SQL081219134223910
--- GO
--- ALTER TABLE JRUAN.STUDYSTATUS
--- DROP CONSTRAINT SQL081219134223710
--- GO
--- ALTER TABLE JRUAN.STUDY
--- DROP CONSTRAINT SQL081219134223600
--- GO
--- ALTER TABLE JRUAN.STUDY_NEXUSFILE
--- DROP CONSTRAINT SQL081219134224240
--- GO
--- ALTER TABLE JRUAN.STEPMATRIXELEMENT
--- DROP CONSTRAINT SQL081219134223500
--- GO
--- ALTER TABLE JRUAN.STATESET
--- DROP CONSTRAINT SQL081219134223390
--- GO
--- ALTER TABLE JRUAN.STATEMODIFIER
--- DROP CONSTRAINT SQL081219134223290
--- GO
--- ALTER TABLE JRUAN.STATEFORMAT
--- DROP CONSTRAINT SQL081219134223190
--- GO
--- ALTER TABLE JRUAN.STATECHANGESET
--- DROP CONSTRAINT SQL081219134223070
--- GO
--- ALTER TABLE JRUAN.SPECIMENLABEL
--- DROP CONSTRAINT SQL080428163906480
--- GO
--- ALTER TABLE JRUAN.SOFTWARE
--- DROP CONSTRAINT SQL081219134222960
--- GO
--- ALTER TABLE JRUAN.ROWSEGMENT
--- DROP CONSTRAINT SQL081219134222850
--- GO
--- ALTER TABLE JRUAN.POLYTCOUNT
--- DROP CONSTRAINT SQL081219134222660
--- GO
--- ALTER TABLE JRUAN.PHYLOTREENODE
--- DROP CONSTRAINT SQL081219134222560
--- GO
--- ALTER TABLE JRUAN.PHYLOTREE
--- DROP CONSTRAINT SQL081219134222440
--- GO
--- ALTER TABLE JRUAN.PHYLOCHAR
--- DROP CONSTRAINT SQL081219134222330
--- GO
--- ALTER TABLE JRUAN.PERSON
--- DROP CONSTRAINT SQL081219134222230
--- GO
--- ALTER TABLE JRUAN.NODEATTRIBUTE
--- DROP CONSTRAINT SQL081219134222120
--- GO
--- ALTER TABLE JRUAN.MATRIXROW
--- DROP CONSTRAINT SQL081219134221900
--- GO
--- ALTER TABLE JRUAN.MATRIXKIND
--- DROP CONSTRAINT SQL081219134221790
--- GO
--- ALTER TABLE JRUAN.MATRIXELEMENT
--- DROP CONSTRAINT SQL081219134221690
--- GO
--- ALTER TABLE JRUAN.MATRIXDATATYPE
--- DROP CONSTRAINT SQL081219134221580
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN
--- DROP CONSTRAINT SQL081219134221370
--- GO
--- ALTER TABLE JRUAN.MATRIXCOLUMN_ITEMDEFINITION
--- DROP CONSTRAINT SQL081219134221470
--- GO
--- ALTER TABLE JRUAN.MATRIX
--- DROP CONSTRAINT SQL081219134221270
--- GO
--- ALTER TABLE JRUAN.MATRIX_ITEMDEFINITION
--- DROP CONSTRAINT SQL081219134222010
--- GO
--- ALTER TABLE JRUAN.ITEMVALUE
--- DROP CONSTRAINT SQL081219134221080
--- GO
--- ALTER TABLE JRUAN.ITEMDEFINITION
--- DROP CONSTRAINT SQL081219134220970
--- GO
--- ALTER TABLE JRUAN.HELP
--- DROP CONSTRAINT SQL081219134220860
--- GO
--- ALTER TABLE JRUAN.GEOSPOT
--- DROP CONSTRAINT SQL080428163906080
--- GO
--- ALTER TABLE JRUAN.GENETICCODESET
--- DROP CONSTRAINT SQL081219134220550
--- GO
--- ALTER TABLE JRUAN.GENETICCODERECORD
--- DROP CONSTRAINT SQL081219134220760
--- GO
--- ALTER TABLE JRUAN.GENETICCODE
--- DROP CONSTRAINT SQL081219134220650
--- GO
--- ALTER TABLE JRUAN.GAPMODE
--- DROP CONSTRAINT SQL081219134220440
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_STATEMENT
--- DROP CONSTRAINT SQL050919121810940
--- GO
--- ALTER TABLE JRUAN.EXPLAIN_INSTANCE
--- DROP CONSTRAINT SQL050919121810910
--- GO
--- ALTER TABLE JRUAN.DISTANCEMATRIXELEMENT
--- DROP CONSTRAINT SQL081219134220330
--- GO
--- ALTER TABLE JRUAN.DISCRETECHARSTATE
--- DROP CONSTRAINT SQL081219134220230
--- GO
--- ALTER TABLE JRUAN.CSTREENODE
--- DROP CONSTRAINT SQL081219134219200
--- GO
--- ALTER TABLE JRUAN.COMPOUND_ELEMENT
--- DROP CONSTRAINT SQL081219134219000
--- GO
--- ALTER TABLE JRUAN.COLUMNRANGE
--- DROP CONSTRAINT SQL081219134218890
--- GO
--- ALTER TABLE JRUAN.CODONPOSITIONSET
--- DROP CONSTRAINT SQL081219134220130
--- GO
--- ALTER TABLE JRUAN.CITATIONSTATUS
--- DROP CONSTRAINT SQL081219134218570
--- GO
--- ALTER TABLE JRUAN.CITATION
--- DROP CONSTRAINT SQL081219134218470
--- GO
--- ALTER TABLE JRUAN.CITATION_EDITOR
--- DROP CONSTRAINT SQL081219134218780
--- GO
--- ALTER TABLE JRUAN.CITATION_AUTHOR
--- DROP CONSTRAINT SQL081219134218670
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHTSET
--- DROP CONSTRAINT SQL081219134218310
--- GO
--- ALTER TABLE JRUAN.CHARWEIGHT
--- DROP CONSTRAINT SQL081219134218200
--- GO
--- ALTER TABLE JRUAN.CHARSET
--- DROP CONSTRAINT SQL081219134218100
--- GO
--- ALTER TABLE JRUAN.CHARPARTITION
--- DROP CONSTRAINT SQL081219134217990
--- GO
--- ALTER TABLE JRUAN.CHARGROUP
--- DROP CONSTRAINT SQL081219134217890
--- GO
--- ALTER TABLE JRUAN.ANCSTATESET
--- DROP CONSTRAINT SQL081219134217770
--- GO
--- ALTER TABLE JRUAN.ANCESTRALSTATE
--- DROP CONSTRAINT SQL081219134217670
--- GO
--- ALTER TABLE JRUAN.ANALYZEDDATA
--- DROP CONSTRAINT SQL081219134217570
--- GO
--- ALTER TABLE JRUAN.ANALYSISSTEP
--- DROP CONSTRAINT SQL081219134217470
--- GO
--- ALTER TABLE JRUAN.ANALYSIS
--- DROP CONSTRAINT SQL081219134217310
--- GO
--- ALTER TABLE JRUAN.ALGORITHM
--- DROP CONSTRAINT SQL081219134217210
--- GO
-/*
-ALTER TABLE USERTYPERRD_COLRANGE
- DROP CONSTRAINT FK405805DDC009330E;
-ALTER TABLE USERTYPERRD_COLRANGE
- DROP CONSTRAINT FK405805DD79A523E6;
-ALTER TABLE USERTYPERECORD
- DROP CONSTRAINT FK136AF61692E6A38E;
-ALTER TABLE USERTYPERECORD
- DROP CONSTRAINT FK136AF6164D737E46;
-ALTER TABLE "user"
- DROP CONSTRAINT FK27E3CBF59DD12;
-ALTER TABLE "user"
- DROP CONSTRAINT FK27E3CBE3910672;
-ALTER TABLE TYPESET
- DROP CONSTRAINT FKF7F2B6C8A414944F;
-ALTER TABLE TREESET_PHYLOTREE
- DROP CONSTRAINT FK31FC19A7EC59B1E3;
-ALTER TABLE TREESET_PHYLOTREE
- DROP CONSTRAINT FK31FC19A7B710CB23;
-ALTER TABLE TREENODEEDGE
- DROP CONSTRAINT FK7767285D27FD0589;
-ALTER TABLE TREENODEEDGE
- DROP CONSTRAINT FK7767285D1851763B;
-ALTER TABLE TREEGROUP
- DROP CONSTRAINT FKA870258180CBD223;
-ALTER TABLE TREEGROUP_PHYLOTREE
- DROP CONSTRAINT FKFB7D704B710CB23;
-ALTER TABLE TREEGROUP_PHYLOTREE
- DROP CONSTRAINT FKFB7D7045E56A83;
-ALTER TABLE TREEBLOCK
- DROP CONSTRAINT FKA826F38FE310471D;
-ALTER TABLE TAXONVARIANT
- DROP CONSTRAINT FKEE3D127B1DE2FCDD;
-ALTER TABLE TAXONSET_TAXON
- DROP CONSTRAINT FKC656C9031DE2FCDD;
-ALTER TABLE TAXONSET_TAXON
- DROP CONSTRAINT FKC656C90313C28457;
-ALTER TABLE TAXONLINK
- DROP CONSTRAINT FKC102D9A43BF5F2F7;
-ALTER TABLE TAXONLINK
- DROP CONSTRAINT FKC102D9A41DE2FCDD;
-ALTER TABLE TAXONLABELSET
- DROP CONSTRAINT FK28D3A5983C572C3C;
-ALTER TABLE TAXONLABELSET_TAXONLABEL
- DROP CONSTRAINT FK2EB54B71E310471D;
-ALTER TABLE TAXONLABELSET_TAXONLABEL
- DROP CONSTRAINT FK2EB54B7163AB9FD7;
-ALTER TABLE TAXONLABELROUP_TAXONLABEL
- DROP CONSTRAINT FK4B1D0BC763AB9FD7;
-ALTER TABLE TAXONLABELROUP_TAXONLABEL
- DROP CONSTRAINT FK4B1D0BC7294B993D;
-ALTER TABLE TAXONLABELGROUP
- DROP CONSTRAINT FK4AE2663513A813DD;
-ALTER TABLE TAXONLABEL
- DROP CONSTRAINT FK5F548A6A3C572C3C;
-ALTER TABLE TAXONLABEL
- DROP CONSTRAINT FK5F548A6A3C1B6F7;
-ALTER TABLE SUBMISSION
- DROP CONSTRAINT FKA120274CBEF300B2;
-ALTER TABLE SUBMISSION
- DROP CONSTRAINT FKA120274C3C572C3C;
-ALTER TABLE SUB_TREEBLOCK
- DROP CONSTRAINT FK94D50830BFD107C3;
-ALTER TABLE SUB_TREEBLOCK
- DROP CONSTRAINT FK94D508308DFE4858;
-ALTER TABLE SUB_TAXONLABEL
- DROP CONSTRAINT FK86909E98DFE4858;
-ALTER TABLE SUB_TAXONLABEL
- DROP CONSTRAINT FK86909E963AB9FD7;
-ALTER TABLE SUB_MATRIX
- DROP CONSTRAINT FK5F26A2C08DFE4858;
-ALTER TABLE SUB_MATRIX
- DROP CONSTRAINT FK5F26A2C055961AEE;
-ALTER TABLE STUDY
- DROP CONSTRAINT FK4B915A9BEF300B2;
-ALTER TABLE STUDY
- DROP CONSTRAINT FK4B915A98E1E4DF8;
-ALTER TABLE STUDY
- DROP CONSTRAINT FK4B915A9255A519C;
-ALTER TABLE STUDY_NEXUSFILE
- DROP CONSTRAINT FK47FC1EE53C572C3C;
-ALTER TABLE STEPMATRIXELEMENT
- DROP CONSTRAINT FK891100AF9E8198E;
-ALTER TABLE STEPMATRIXELEMENT
- DROP CONSTRAINT FK891100AF6E979EE7;
-ALTER TABLE STEPMATRIXELEMENT
- DROP CONSTRAINT FK891100AF6E972A88;
-ALTER TABLE STATESET
- DROP CONSTRAINT FK7D38523150CBAB47;
-ALTER TABLE STATEMODIFIER
- DROP CONSTRAINT FKD157BE48F4803CE6;
-ALTER TABLE STATEMODIFIER
- DROP CONSTRAINT FKD157BE48BED40086;
-ALTER TABLE STATEMODIFIER
- DROP CONSTRAINT FKD157BE48459091E5;
-ALTER TABLE SPECIMENLABEL
- DROP CONSTRAINT FK1E8F38CCA2039B9D;
-ALTER TABLE ROWSEGMENT
- DROP CONSTRAINT FKEE9AE819E7B3CDA6;
-ALTER TABLE ROWSEGMENT
- DROP CONSTRAINT FKEE9AE81963AB9FD7;
-ALTER TABLE RIGHTCHANGESET_CHARSTATE
- DROP CONSTRAINT FKC8AFC9F2F4803CE6;
-ALTER TABLE RIGHTCHANGESET_CHARSTATE
- DROP CONSTRAINT FKC8AFC9F275763EAE;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA79944B710CB23;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA7994463AB9FD7;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA799445BCC767D;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA79944434FDCCB;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA799443C348165;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT FK3EA79944271A5763;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442FE2812F1;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442F5AEA931;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442F3D1CF03;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442EA08B443;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442BFD107C3;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E442A3015CE3;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT FK76F2E4423C572C3C;
-ALTER TABLE MATRIXROW
- DROP CONSTRAINT FKE4688E59A414944F;
-ALTER TABLE MATRIXROW
- DROP CONSTRAINT FKE4688E5963AB9FD7;
-ALTER TABLE MATRIXELEMENT
- DROP CONSTRAINT FK90AE93FBF4803CE6;
-ALTER TABLE MATRIXELEMENT
- DROP CONSTRAINT FK90AE93FBE7B3CDA6;
-ALTER TABLE MATRIXELEMENT
- DROP CONSTRAINT FK90AE93FB8B2E884E;
-ALTER TABLE MATRIXELEMENT
- DROP CONSTRAINT FK90AE93FB405A7CEE;
-ALTER TABLE MATRIXDATATYPE
- DROP CONSTRAINT FKF054C4A5F5DECA46;
-ALTER TABLE MATRIXCOLUMN
- DROP CONSTRAINT FK9B0BE57F5DECA46;
-ALTER TABLE MATRIXCOLUMN
- DROP CONSTRAINT FK9B0BE57BED40086;
-ALTER TABLE MATRIXCOLUMN
- DROP CONSTRAINT FK9B0BE57A414944F;
-ALTER TABLE MATRIXCOLUMN_ITEMDEFINITION
- DROP CONSTRAINT FKB556F8E8B2E884E;
-ALTER TABLE MATRIXCOLUMN_ITEMDEFINITION
- DROP CONSTRAINT FKB556F8E405A7CEE;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC1E9B425A6;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC1E310471D;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC191BD3C8E;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC1684F6406;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC14D737E46;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC14CE484AE;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC1491DB20E;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC145534A9C;
-ALTER TABLE MATRIX
- DROP CONSTRAINT FK87208BC13C572C3C;
-ALTER TABLE MATRIX_ITEMDEFINITION
- DROP CONSTRAINT FK5717E0E4AC5C19DD;
-ALTER TABLE MATRIX_ITEMDEFINITION
- DROP CONSTRAINT FK5717E0E4405A7CEE;
-ALTER TABLE LEFTCHANGESET_CHARSTATE
- DROP CONSTRAINT FKC8877207F4803CE6;
-ALTER TABLE LEFTCHANGESET_CHARSTATE
- DROP CONSTRAINT FKC887720775763EAE;
-ALTER TABLE ITEMVALUE
- DROP CONSTRAINT FK27B41A1E459091E5;
-ALTER TABLE GENETICCODESET
- DROP CONSTRAINT FK6A12F7DCA414944F;
-ALTER TABLE GENETICCODERECORD
- DROP CONSTRAINT FK237932B782D8ECCE;
-ALTER TABLE GENETICCODERECORD
- DROP CONSTRAINT FK237932B76CB73FC6;
---ALTER TABLE EXPLAIN_STREAM
--- DROP CONSTRAINT SQL050919121811070;
---ALTER TABLE EXPLAIN_STATEMENT
--- DROP CONSTRAINT SQL050919121810950;
---ALTER TABLE EXPLAIN_PREDICATE
--- DROP CONSTRAINT SQL050919121811040;
---ALTER TABLE EXPLAIN_OPERATOR
--- DROP CONSTRAINT SQL050919121810970;
---ALTER TABLE EXPLAIN_OBJECT
--- DROP CONSTRAINT SQL050919121811000;
---ALTER TABLE EXPLAIN_ARGUMENT
--- DROP CONSTRAINT SQL050919121811060;
-ALTER TABLE DISTANCEMATRIXELEMENT
- DROP CONSTRAINT FK92D3DDE6C1429863;
-ALTER TABLE DISTANCEMATRIXELEMENT
- DROP CONSTRAINT FK92D3DDE64B8EF343;
-ALTER TABLE DISTANCEMATRIXELEMENT
- DROP CONSTRAINT FK92D3DDE61F08BAE7;
-ALTER TABLE DISCRETECHARSTATE
- DROP CONSTRAINT FK2EEF2802FE41A723;
-ALTER TABLE DISCRETECHARSTATE
- DROP CONSTRAINT FK2EEF2802C7BEAAFE;
-ALTER TABLE DISCRETECHARSTATE
- DROP CONSTRAINT FK2EEF2802163C67CE;
-ALTER TABLE CSTREENODE
- DROP CONSTRAINT FK82B9AB10F572A92;
-ALTER TABLE CSTREENODE
- DROP CONSTRAINT FK82B9AB10F4803CE6;
-ALTER TABLE CSTREENODE
- DROP CONSTRAINT FK82B9AB10C6999FCE;
-ALTER TABLE CONTANCSTATE_VALUE
- DROP CONSTRAINT FKA84B8C3FD450D2BD;
-ALTER TABLE COMPOUND_ELEMENT
- DROP CONSTRAINT FK311830485F4F7CEB;
-ALTER TABLE COMPOUND_ELEMENT
- DROP CONSTRAINT FK31183048459091E5;
-ALTER TABLE CODONPOSITIONSET
- DROP CONSTRAINT FK4E501CC2A414944F;
-ALTER TABLE CODONNONCODING_COLRANGE
- DROP CONSTRAINT FK307897FC79A523E6;
-ALTER TABLE CODONNONCODING_COLRANGE
- DROP CONSTRAINT FK307897FC491DB20E;
-ALTER TABLE CODONCHAR3_COLRANGE
- DROP CONSTRAINT FKC2EDB73679A523E6;
-ALTER TABLE CODONCHAR3_COLRANGE
- DROP CONSTRAINT FKC2EDB736491DB20E;
-ALTER TABLE CODONCHAR2_COLRANGE
- DROP CONSTRAINT FKCEA4461779A523E6;
-ALTER TABLE CODONCHAR2_COLRANGE
- DROP CONSTRAINT FKCEA44617491DB20E;
-ALTER TABLE CODONCHAR1_COLRANGE
- DROP CONSTRAINT FKDA5AD4F879A523E6;
-ALTER TABLE CODONCHAR1_COLRANGE
- DROP CONSTRAINT FKDA5AD4F8491DB20E;
-ALTER TABLE CODERECORD_COLRANGE
- DROP CONSTRAINT FKA3E6C61EDC51C546;
-ALTER TABLE CODERECORD_COLRANGE
- DROP CONSTRAINT FKA3E6C61E79A523E6;
-ALTER TABLE CITATION
- DROP CONSTRAINT FKD8A7FAE74C983658;
-ALTER TABLE CITATION_EDITOR
- DROP CONSTRAINT FK2A8955C5EC93F501;
-ALTER TABLE CITATION_EDITOR
- DROP CONSTRAINT FK2A8955C568F6F619;
-ALTER TABLE CITATION_AUTHOR
- DROP CONSTRAINT FK24AA55E38E1E4DF8;
-ALTER TABLE CITATION_AUTHOR
- DROP CONSTRAINT FK24AA55E36707573B;
-ALTER TABLE CHARWEIGHTSET
- DROP CONSTRAINT FK99B8AC34A414944F;
-ALTER TABLE CHARWEIGHT
- DROP CONSTRAINT FK8CC7694EE9B425A6;
-ALTER TABLE CHARWEIGHT_COLRANGE
- DROP CONSTRAINT FK54CA674EF9A75EE;
-ALTER TABLE CHARWEIGHT_COLRANGE
- DROP CONSTRAINT FK54CA674E79A523E6;
-ALTER TABLE CHARSET
- DROP CONSTRAINT FK56D8ED2CA414944F;
-ALTER TABLE CHARSET_COLRANGE
- DROP CONSTRAINT FK2CBD9079A523E6;
-ALTER TABLE CHARSET_COLRANGE
- DROP CONSTRAINT FK2CBD90416D5B50;
-ALTER TABLE CHARPARTITION
- DROP CONSTRAINT FKDEA9F834A414944F;
-ALTER TABLE CHARGROUP
- DROP CONSTRAINT FK3AF18C91AA11DC6;
-ALTER TABLE CHARGROUP_COLRANGE
- DROP CONSTRAINT FKB2D8C293971FFFA6;
-ALTER TABLE CHARGROUP_COLRANGE
- DROP CONSTRAINT FKB2D8C29379A523E6;
-ALTER TABLE ANCSTATESET
- DROP CONSTRAINT FK879339E7A414944F;
-ALTER TABLE ANCESTRALSTATE
- DROP CONSTRAINT FK3FA14284F4803CE6;
-ALTER TABLE ANCESTRALSTATE
- DROP CONSTRAINT FK3FA14284684F6406;
-ALTER TABLE ANALYZEDDATA
- DROP CONSTRAINT FK8C961842B710CB23;
-ALTER TABLE ANALYZEDDATA
- DROP CONSTRAINT FK8C96184255961AEE;
-ALTER TABLE ANALYZEDDATA
- DROP CONSTRAINT FK8C9618424BA97F78;
-ALTER TABLE ANALYSISSTEP
- DROP CONSTRAINT FK21F853A8D1884DD8;
-ALTER TABLE ANALYSISSTEP
- DROP CONSTRAINT FK21F853A865EDD5F8;
-ALTER TABLE ANALYSISSTEP
- DROP CONSTRAINT FK21F853A848A2817C;
-ALTER TABLE ANALYSIS
- DROP CONSTRAINT FKF19622DC3C572C3C;
-ALTER TABLE ALGORITHM
- DROP CONSTRAINT FKB388C44FC6E814E6;
-ALTER TABLE ALGORITHM
- DROP CONSTRAINT FKB388C44F9698D32E;
-ALTER TABLE ALGORITHM
- DROP CONSTRAINT FKB388C44F92E6A38E;
-ALTER TABLE USERTYPERRD_COLRANGE
- DROP CONSTRAINT SQL081219134227270;
-ALTER TABLE "user"
- DROP CONSTRAINT SQL081219134226851;
-ALTER TABLE SUBMISSION
- DROP CONSTRAINT SQL081219134223811;
-ALTER TABLE SUB_TREEBLOCK
- DROP CONSTRAINT SQL081219134224130;
-ALTER TABLE SUB_TAXONLABEL
- DROP CONSTRAINT SQL081219134224030;
-ALTER TABLE SUB_MATRIX
- DROP CONSTRAINT SQL081219134223920;
-ALTER TABLE COMPOUND_ELEMENT
- DROP CONSTRAINT SQL081219134219010;
-ALTER TABLE CODONNONCODING_COLRANGE
- DROP CONSTRAINT SQL081219134220010;
-ALTER TABLE CODONCHAR3_COLRANGE
- DROP CONSTRAINT SQL081219134219910;
-ALTER TABLE CODONCHAR2_COLRANGE
- DROP CONSTRAINT SQL081219134219810;
-ALTER TABLE CODONCHAR1_COLRANGE
- DROP CONSTRAINT SQL081219134219710;
-ALTER TABLE CODERECORD_COLRANGE
- DROP CONSTRAINT SQL081219134219610;
-ALTER TABLE CHARWEIGHT_COLRANGE
- DROP CONSTRAINT SQL081219134219510;
-ALTER TABLE CHARSET_COLRANGE
- DROP CONSTRAINT SQL081219134219400;
-ALTER TABLE CHARGROUP_COLRANGE
- DROP CONSTRAINT SQL081219134219300;
-ALTER TABLE USERTYPERECORD
- DROP CONSTRAINT SQL081219134227170;
-ALTER TABLE USERTYPE
- DROP CONSTRAINT SQL081219134227060;
-ALTER TABLE USERROLE
- DROP CONSTRAINT SQL081219134226960;
-ALTER TABLE "user"
- DROP CONSTRAINT SQL081219134226850;
-ALTER TABLE TYPESET
- DROP CONSTRAINT SQL081219134226550;
-ALTER TABLE TREETYPE
- DROP CONSTRAINT SQL081219134226440;
-ALTER TABLE TREESET
- DROP CONSTRAINT SQL081219134226240;
-ALTER TABLE TREESET_PHYLOTREE
- DROP CONSTRAINT SQL081219134226340;
-ALTER TABLE TREEQUALITY
- DROP CONSTRAINT SQL081219134226140;
-ALTER TABLE TREEPARTITION
- DROP CONSTRAINT SQL081219134226040;
-ALTER TABLE TREENODEEDGE
- DROP CONSTRAINT SQL081219134225930;
-ALTER TABLE TREEKIND
- DROP CONSTRAINT SQL081219134225820;
-ALTER TABLE TREEGROUP
- DROP CONSTRAINT SQL081219134225620;
-ALTER TABLE TREEGROUP_PHYLOTREE
- DROP CONSTRAINT SQL081219134225720;
-ALTER TABLE TREEBLOCK
- DROP CONSTRAINT SQL081219134225510;
-ALTER TABLE TREEATTRIBUTE
- DROP CONSTRAINT SQL081219134225410;
-ALTER TABLE TAXONVARIANT
- DROP CONSTRAINT SQL081219134225250;
-ALTER TABLE TAXONSET
- DROP CONSTRAINT SQL081219134225050;
-ALTER TABLE TAXONSET_TAXON
- DROP CONSTRAINT SQL081219134225150;
-ALTER TABLE TAXONLINK
- DROP CONSTRAINT SQL081219134224950;
-ALTER TABLE TAXONLABELSET
- DROP CONSTRAINT SQL081219134226650;
-ALTER TABLE TAXONLABELSET_TAXONLABEL
- DROP CONSTRAINT SQL081219134226750;
-ALTER TABLE TAXONLABELPARTITION
- DROP CONSTRAINT SQL081219134224760;
-ALTER TABLE TAXONLABELGROUP
- DROP CONSTRAINT SQL081219134224650;
-ALTER TABLE TAXONLABEL
- DROP CONSTRAINT SQL081219134224550;
-ALTER TABLE TAXONAUTHORITY
- DROP CONSTRAINT SQL081219134224450;
-ALTER TABLE TAXON
- DROP CONSTRAINT SQL081219134224350;
-ALTER TABLE SUBMISSION
- DROP CONSTRAINT SQL081219134223810;
-ALTER TABLE SUB_TREEBLOCK
- DROP CONSTRAINT SQL081219134224120;
-ALTER TABLE SUB_TAXONLABEL
- DROP CONSTRAINT SQL081219134224020;
-ALTER TABLE SUB_MATRIX
- DROP CONSTRAINT SQL081219134223910;
-ALTER TABLE STUDYSTATUS
- DROP CONSTRAINT SQL081219134223710;
-ALTER TABLE STUDY
- DROP CONSTRAINT SQL081219134223600;
-ALTER TABLE STUDY_NEXUSFILE
- DROP CONSTRAINT SQL081219134224240;
-ALTER TABLE STEPMATRIXELEMENT
- DROP CONSTRAINT SQL081219134223500;
-ALTER TABLE STATESET
- DROP CONSTRAINT SQL081219134223390;
-ALTER TABLE STATEMODIFIER
- DROP CONSTRAINT SQL081219134223290;
-ALTER TABLE STATEFORMAT
- DROP CONSTRAINT SQL081219134223190;
-ALTER TABLE STATECHANGESET
- DROP CONSTRAINT SQL081219134223070;
-ALTER TABLE SPECIMENLABEL
- DROP CONSTRAINT SQL080428163906480;
-ALTER TABLE SOFTWARE
- DROP CONSTRAINT SQL081219134222960;
-ALTER TABLE ROWSEGMENT
- DROP CONSTRAINT SQL081219134222850;
-ALTER TABLE POLYTCOUNT
- DROP CONSTRAINT SQL081219134222660;
-ALTER TABLE PHYLOTREENODE
- DROP CONSTRAINT SQL081219134222560;
-ALTER TABLE PHYLOTREE
- DROP CONSTRAINT SQL081219134222440;
-ALTER TABLE PHYLOCHAR
- DROP CONSTRAINT SQL081219134222330;
-ALTER TABLE PERSON
- DROP CONSTRAINT SQL081219134222230;
-ALTER TABLE NODEATTRIBUTE
- DROP CONSTRAINT SQL081219134222120;
-ALTER TABLE MATRIXROW
- DROP CONSTRAINT SQL081219134221900;
-ALTER TABLE MATRIXKIND
- DROP CONSTRAINT SQL081219134221790;
-ALTER TABLE MATRIXELEMENT
- DROP CONSTRAINT SQL081219134221690;
-ALTER TABLE MATRIXDATATYPE
- DROP CONSTRAINT SQL081219134221580;
-ALTER TABLE MATRIXCOLUMN
- DROP CONSTRAINT SQL081219134221370;
-ALTER TABLE MATRIXCOLUMN_ITEMDEFINITION
- DROP CONSTRAINT SQL081219134221470;
-ALTER TABLE MATRIX
- DROP CONSTRAINT SQL081219134221270;
-ALTER TABLE MATRIX_ITEMDEFINITION
- DROP CONSTRAINT SQL081219134222010;
-ALTER TABLE ITEMVALUE
- DROP CONSTRAINT SQL081219134221080;
-ALTER TABLE ITEMDEFINITION
- DROP CONSTRAINT SQL081219134220970;
-ALTER TABLE HELP
- DROP CONSTRAINT SQL081219134220860;
-ALTER TABLE GEOSPOT
- DROP CONSTRAINT SQL080428163906080;
-ALTER TABLE GENETICCODESET
- DROP CONSTRAINT SQL081219134220550;
-ALTER TABLE GENETICCODERECORD
- DROP CONSTRAINT SQL081219134220760;
-ALTER TABLE GENETICCODE
- DROP CONSTRAINT SQL081219134220650;
-ALTER TABLE GAPMODE
- DROP CONSTRAINT SQL081219134220440;
---ALTER TABLE EXPLAIN_STATEMENT
--- DROP CONSTRAINT SQL050919121810940;
---ALTER TABLE EXPLAIN_INSTANCE
--- DROP CONSTRAINT SQL050919121810910;
-ALTER TABLE DISTANCEMATRIXELEMENT
- DROP CONSTRAINT SQL081219134220330;
-ALTER TABLE DISCRETECHARSTATE
- DROP CONSTRAINT SQL081219134220230;
-ALTER TABLE CSTREENODE
- DROP CONSTRAINT SQL081219134219200;
-ALTER TABLE COMPOUND_ELEMENT
- DROP CONSTRAINT SQL081219134219000;
-ALTER TABLE COLUMNRANGE
- DROP CONSTRAINT SQL081219134218890;
-ALTER TABLE CODONPOSITIONSET
- DROP CONSTRAINT SQL081219134220130;
-ALTER TABLE CITATIONSTATUS
- DROP CONSTRAINT SQL081219134218570;
-ALTER TABLE CITATION
- DROP CONSTRAINT SQL081219134218470;
-ALTER TABLE CITATION_EDITOR
- DROP CONSTRAINT SQL081219134218780;
-ALTER TABLE CITATION_AUTHOR
- DROP CONSTRAINT SQL081219134218670;
-ALTER TABLE CHARWEIGHTSET
- DROP CONSTRAINT SQL081219134218310;
-ALTER TABLE CHARWEIGHT
- DROP CONSTRAINT SQL081219134218200;
-ALTER TABLE CHARSET
- DROP CONSTRAINT SQL081219134218100;
-ALTER TABLE CHARPARTITION
- DROP CONSTRAINT SQL081219134217990;
-ALTER TABLE CHARGROUP
- DROP CONSTRAINT SQL081219134217890;
-ALTER TABLE ANCSTATESET
- DROP CONSTRAINT SQL081219134217770;
-ALTER TABLE ANCESTRALSTATE
- DROP CONSTRAINT SQL081219134217670;
-ALTER TABLE ANALYZEDDATA
- DROP CONSTRAINT SQL081219134217570;
-ALTER TABLE ANALYSISSTEP
- DROP CONSTRAINT SQL081219134217470;
-ALTER TABLE ANALYSIS
- DROP CONSTRAINT SQL081219134217310;
-ALTER TABLE ALGORITHM
- DROP CONSTRAINT SQL081219134217210;
-*/
--- DROP INDEX JRUAN.TVARI_NBID_IDX
--- GO
--- DROP INDEX JRUAN.TVARI_TAXON_IDX
--- GO
--- DROP INDEX JRUAN.TVARI_FNAME_IDX
--- GO
--- DROP INDEX JRUAN.TLABEL_STUDY_IDX
--- GO
--- DROP INDEX JRUAN.TAXON_NAME_IDX
--- GO
--- DROP INDEX JRUAN.STUDY_NAME_IDX
--- GO
--- DROP INDEX JRUAN.SPECIM_INST_IDX
--- GO
--- DROP INDEX JRUAN.TNODE_TREE_IDX
--- GO
--- DROP INDEX JRUAN.TNODE_TAXLABEL_IDX
--- GO
--- DROP INDEX JRUAN.PERSON_EMAIL_IDX
--- GO
--- DROP INDEX JRUAN.PERSON_LNAME_IDX
--- GO
--- DROP INDEX JRUAN.ROW_M_IDX
--- GO
--- DROP INDEX JRUAN.ELEMENT_COL_IDX
--- GO
--- DROP INDEX JRUAN.ELEMENT_ROW_IDX
--- GO
--- DROP INDEX JRUAN.COLUMN_M_IDX
--- GO
-/*
-DROP INDEX TVARI_NBID_IDX;
-DROP INDEX TVARI_TAXON_IDX;
-DROP INDEX TVARI_FNAME_IDX;
-DROP INDEX TLABEL_STUDY_IDX;
-DROP INDEX TAXON_NAME_IDX;
-DROP INDEX STUDY_NAME_IDX;
-DROP INDEX SPECIM_INST_IDX;
-DROP INDEX TNODE_TREE_IDX;
-DROP INDEX TNODE_TAXLABEL_IDX;
-DROP INDEX PERSON_EMAIL_IDX;
-DROP INDEX PERSON_LNAME_IDX;
-DROP INDEX ROW_M_IDX;
-DROP INDEX ELEMENT_COL_IDX;
-DROP INDEX ELEMENT_ROW_IDX;
-DROP INDEX COLUMN_M_IDX;
-*/
--- DROP TABLE JRUAN.USERTYPERRD_COLRANGE
--- GO
--- DROP TABLE JRUAN.USERTYPERECORD
--- GO
--- DROP TABLE JRUAN.USERTYPE
--- GO
--- DROP TABLE JRUAN.USERROLE
--- GO
--- DROP TABLE JRUAN.USER
--- GO
--- DROP TABLE JRUAN.TYPESET
--- GO
--- DROP TABLE JRUAN.TREETYPE
--- GO
--- DROP TABLE JRUAN.TREESET
--- GO
--- DROP TABLE JRUAN.TREESET_PHYLOTREE
--- GO
--- DROP TABLE JRUAN.TREEQUALITY
--- GO
--- DROP TABLE JRUAN.TREEPARTITION
--- GO
--- DROP TABLE JRUAN.TREENODEEDGE
--- GO
--- DROP TABLE JRUAN.TREEKIND
--- GO
--- DROP TABLE JRUAN.TREEGROUP
--- GO
--- DROP TABLE JRUAN.TREEGROUP_PHYLOTREE
--- GO
--- DROP TABLE JRUAN.TREEBLOCK
--- GO
--- DROP TABLE JRUAN.TREEATTRIBUTE
--- GO
--- DROP TABLE JRUAN.TAXONVARIANT
--- GO
--- DROP TABLE JRUAN.TAXONSET
--- GO
--- DROP TABLE JRUAN.TAXONSET_TAXON
--- GO
--- DROP TABLE JRUAN.TAXONLINK
--- GO
--- DROP TABLE JRUAN.TAXONLABELSET
--- GO
--- DROP TABLE JRUAN.TAXONLABELSET_TAXONLABEL
--- GO
--- DROP TABLE JRUAN.TAXONLABELROUP_TAXONLABEL
--- GO
--- DROP TABLE JRUAN.TAXONLABELPARTITION
--- GO
--- DROP TABLE JRUAN.TAXONLABELGROUP
--- GO
--- DROP TABLE JRUAN.TAXONLABEL
--- GO
--- DROP TABLE JRUAN.TAXONAUTHORITY
--- GO
--- DROP TABLE JRUAN.TAXON
--- GO
--- DROP TABLE JRUAN.SUBMISSION
--- GO
--- DROP TABLE JRUAN.SUB_TREEBLOCK
--- GO
--- DROP TABLE JRUAN.SUB_TAXONLABEL
--- GO
--- DROP TABLE JRUAN.SUB_MATRIX
--- GO
--- DROP TABLE JRUAN.STUDYSTATUS
--- GO
--- DROP TABLE JRUAN.STUDY
--- GO
--- DROP TABLE JRUAN.STUDY_NEXUSFILE
--- GO
--- DROP TABLE JRUAN.STEPMATRIXELEMENT
--- GO
--- DROP TABLE JRUAN.STATESET
--- GO
--- DROP TABLE JRUAN.STATEMODIFIER
--- GO
--- DROP TABLE JRUAN.STATEFORMAT
--- GO
--- DROP TABLE JRUAN.STATECHANGESET
--- GO
--- DROP TABLE JRUAN.SPECIMENLABEL
--- GO
--- DROP TABLE JRUAN.SOFTWARE
--- GO
--- DROP TABLE JRUAN.ROWSEGMENT
--- GO
--- DROP TABLE JRUAN.RIGHTCHANGESET_CHARSTATE
--- GO
--- DROP TABLE JRUAN.POLYTCOUNT
--- GO
--- DROP TABLE JRUAN.PHYLOTREENODE
--- GO
--- DROP TABLE JRUAN.PHYLOTREE
--- GO
--- DROP TABLE JRUAN.PHYLOCHAR
--- GO
--- DROP TABLE JRUAN.PERSON
--- GO
--- DROP TABLE JRUAN.NODEATTRIBUTE
--- GO
--- DROP TABLE JRUAN.MATRIXROW
--- GO
--- DROP TABLE JRUAN.MATRIXKIND
--- GO
--- DROP TABLE JRUAN.MATRIXELEMENT
--- GO
--- DROP TABLE JRUAN.MATRIXDATATYPE
--- GO
--- DROP TABLE JRUAN.MATRIXCOLUMN
--- GO
--- DROP TABLE JRUAN.MATRIXCOLUMN_ITEMDEFINITION
--- GO
--- DROP TABLE JRUAN.MATRIX
--- GO
--- DROP TABLE JRUAN.MATRIX_ITEMDEFINITION
--- GO
--- DROP TABLE JRUAN.LEFTCHANGESET_CHARSTATE
--- GO
--- DROP TABLE JRUAN.ITEMVALUE
--- GO
--- DROP TABLE JRUAN.ITEMDEFINITION
--- GO
--- DROP TABLE JRUAN.HELP
--- GO
--- DROP TABLE JRUAN.GEOSPOT
--- GO
--- DROP TABLE JRUAN.GENETICCODESET
--- GO
--- DROP TABLE JRUAN.GENETICCODERECORD
--- GO
--- DROP TABLE JRUAN.GENETICCODE
--- GO
--- DROP TABLE JRUAN.GAPMODE
--- GO
--- DROP TABLE JRUAN.EXPLAIN_STREAM
--- GO
--- DROP TABLE JRUAN.EXPLAIN_STATEMENT
--- GO
--- DROP TABLE JRUAN.EXPLAIN_PREDICATE
--- GO
--- DROP TABLE JRUAN.EXPLAIN_OPERATOR
--- GO
--- DROP TABLE JRUAN.EXPLAIN_OBJECT
--- GO
--- DROP TABLE JRUAN.EXPLAIN_INSTANCE
--- GO
--- DROP TABLE JRUAN.EXPLAIN_ARGUMENT
--- GO
--- DROP TABLE JRUAN.DISTANCEMATRIXELEMENT
--- GO
--- DROP TABLE JRUAN.DISCRETECHARSTATE
--- GO
--- DROP TABLE JRUAN.CSTREENODE
--- GO
--- DROP TABLE JRUAN.CONTANCSTATE_VALUE
--- GO
--- DROP TABLE JRUAN.COMPOUND_ELEMENT
--- GO
--- DROP TABLE JRUAN.COLUMNRANGE
--- GO
--- DROP TABLE JRUAN.CODONPOSITIONSET
--- GO
--- DROP TABLE JRUAN.CODONNONCODING_COLRANGE
--- GO
--- DROP TABLE JRUAN.CODONCHAR3_COLRANGE
--- GO
--- DROP TABLE JRUAN.CODONCHAR2_COLRANGE
--- GO
--- DROP TABLE JRUAN.CODONCHAR1_COLRANGE
--- GO
--- DROP TABLE JRUAN.CODERECORD_COLRANGE
--- GO
--- DROP TABLE JRUAN.CITATIONSTATUS
--- GO
--- DROP TABLE JRUAN.CITATION
--- GO
--- DROP TABLE JRUAN.CITATION_EDITOR
--- GO
--- DROP TABLE JRUAN.CITATION_AUTHOR
--- GO
--- DROP TABLE JRUAN.CHARWEIGHTSET
--- GO
--- DROP TABLE JRUAN.CHARWEIGHT
--- GO
--- DROP TABLE JRUAN.CHARWEIGHT_COLRANGE
--- GO
--- DROP TABLE JRUAN.CHARSET
--- GO
--- DROP TABLE JRUAN.CHARSET_COLRANGE
--- GO
--- DROP TABLE JRUAN.CHARPARTITION
--- GO
--- DROP TABLE JRUAN.CHARGROUP
--- GO
--- DROP TABLE JRUAN.CHARGROUP_COLRANGE
--- GO
--- DROP TABLE JRUAN.ANCSTATESET
--- GO
--- DROP TABLE JRUAN.ANCESTRALSTATE
--- GO
--- DROP TABLE JRUAN.ANALYZEDDATA
--- GO
--- DROP TABLE JRUAN.ANALYSISSTEP
--- GO
--- DROP TABLE JRUAN.ANALYSIS
--- GO
--- DROP TABLE JRUAN.ALGORITHM
--- GO
--- DROP TABLE JRUAN.ADVISE_WORKLOAD
--- GO
--- DROP TABLE JRUAN.ADVISE_INDEX
--- GO
-/*
-DROP TABLE USERTYPERRD_COLRANGE;
-DROP TABLE USERTYPERECORD;
-DROP TABLE USERTYPE;
-DROP TABLE USERROLE;
-DROP TABLE "user";
-DROP TABLE TYPESET;
-DROP TABLE TREETYPE;
-DROP TABLE TREESET;
-DROP TABLE TREESET_PHYLOTREE;
-DROP TABLE TREEQUALITY;
-DROP TABLE TREEPARTITION;
-DROP TABLE TREENODEEDGE;
-DROP TABLE TREEKIND;
-DROP TABLE TREEGROUP;
-DROP TABLE TREEGROUP_PHYLOTREE;
-DROP TABLE TREEBLOCK;
-DROP TABLE TREEATTRIBUTE;
-DROP TABLE TAXONVARIANT;
-DROP TABLE TAXONSET;
-DROP TABLE TAXONSET_TAXON;
-DROP TABLE TAXONLINK;
-DROP TABLE TAXONLABELSET;
-DROP TABLE TAXONLABELSET_TAXONLABEL;
-DROP TABLE TAXONLABELROUP_TAXONLABEL;
-DROP TABLE TAXONLABELPARTITION;
-DROP TABLE TAXONLABELGROUP;
-DROP TABLE TAXONLABEL;
-DROP TABLE TAXONAUTHORITY;
-DROP TABLE TAXON;
-DROP TABLE SUBMISSION;
-DROP TABLE SUB_TREEBLOCK;
-DROP TABLE SUB_TAXONLABEL;
-DROP TABLE SUB_MATRIX;
-DROP TABLE STUDYSTATUS;
-DROP TABLE STUDY;
-DROP TABLE STUDY_NEXUSFILE;
-DROP TABLE STEPMATRIXELEMENT;
-DROP TABLE STATESET;
-DROP TABLE STATEMODIFIER;
-DROP TABLE STATEFORMAT;
-DROP TABLE STATECHANGESET;
-DROP TABLE SPECIMENLABEL;
-DROP TABLE SOFTWARE;
-DROP TABLE ROWSEGMENT;
-DROP TABLE RIGHTCHANGESET_CHARSTATE;
-DROP TABLE POLYTCOUNT;
-DROP TABLE PHYLOTREENODE;
-DROP TABLE PHYLOTREE;
-DROP TABLE PHYLOCHAR;
-DROP TABLE PERSON;
-DROP TABLE NODEATTRIBUTE;
-DROP TABLE MATRIXROW;
-DROP TABLE MATRIXKIND;
-DROP TABLE MATRIXELEMENT;
-DROP TABLE MATRIXDATATYPE;
-DROP TABLE MATRIXCOLUMN;
-DROP TABLE MATRIXCOLUMN_ITEMDEFINITION;
-DROP TABLE MATRIX;
-DROP TABLE MATRIX_ITEMDEFINITION;
-DROP TABLE LEFTCHANGESET_CHARSTATE;
-DROP TABLE ITEMVALUE;
-DROP TABLE ITEMDEFINITION;
-DROP TABLE HELP;
-DROP TABLE GEOSPOT;
-DROP TABLE GENETICCODESET;
-DROP TABLE GENETICCODERECORD;
-DROP TABLE GENETICCODE;
-DROP TABLE GAPMODE;
---DROP TABLE EXPLAIN_STREAM;
---DROP TABLE EXPLAIN_STATEMENT;
---DROP TABLE EXPLAIN_PREDICATE;
---DROP TABLE EXPLAIN_OPERATOR;
---DROP TABLE EXPLAIN_OBJECT;
---DROP TABLE EXPLAIN_INSTANCE;
---DROP TABLE EXPLAIN_ARGUMENT;
-DROP TABLE DISTANCEMATRIXELEMENT;
-DROP TABLE DISCRETECHARSTATE;
-DROP TABLE CSTREENODE;
-DROP TABLE CONTANCSTATE_VALUE;
-DROP TABLE COMPOUND_ELEMENT;
-DROP TABLE COLUMNRANGE;
-DROP TABLE CODONPOSITIONSET;
-DROP TABLE CODONNONCODING_COLRANGE;
-DROP TABLE CODONCHAR3_COLRANGE;
-DROP TABLE CODONCHAR2_COLRANGE;
-DROP TABLE CODONCHAR1_COLRANGE;
-DROP TABLE CODERECORD_COLRANGE;
-DROP TABLE CITATIONSTATUS;
-DROP TABLE CITATION;
-DROP TABLE CITATION_EDITOR;
-DROP TABLE CITATION_AUTHOR;
-DROP TABLE CHARWEIGHTSET;
-DROP TABLE CHARWEIGHT;
-DROP TABLE CHARWEIGHT_COLRANGE;
-DROP TABLE CHARSET;
-DROP TABLE CHARSET_COLRANGE;
-DROP TABLE CHARPARTITION;
-DROP TABLE CHARGROUP;
-DROP TABLE CHARGROUP_COLRANGE;
-DROP TABLE ANCSTATESET;
-DROP TABLE ANCESTRALSTATE;
-DROP TABLE ANALYZEDDATA;
-DROP TABLE ANALYSISSTEP;
-DROP TABLE ANALYSIS;
-DROP TABLE ALGORITHM;
---DROP TABLE ADVISE_WORKLOAD;
---DROP TABLE ADVISE_INDEX;
-*/
--- CREATE TABLE JRUAN.ADVISE_INDEX (
--- EXPLAIN_REQUESTER VARCHAR(128) NOT NULL DEFAULT '',
--- EXPLAIN_TIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,
--- SOURCE_NAME VARCHAR(128) NOT NULL DEFAULT '',
--- SOURCE_SCHEMA VARCHAR(128) NOT NULL DEFAULT '',
--- SOURCE_VERSION VARCHAR(64) NOT NULL DEFAULT '',
--- EXPLAIN_LEVEL CHARACTER(1) NOT NULL DEFAULT '',
--- STMTNO INTEGER NOT NULL DEFAULT 0,
--- SECTNO INTEGER NOT NULL DEFAULT 0,
--- QUERYNO INTEGER NOT NULL DEFAULT 0,
--- QUERYTAG CHARACTER(20) NOT NULL DEFAULT '',
--- NAME VARCHAR(128) NOT NULL,
--- CREATOR VARCHAR(128) NOT NULL DEFAULT '',
--- TBNAME VARCHAR(128) NOT NULL,
--- TBCREATOR VARCHAR(128) NOT NULL DEFAULT '',
--- COLNAMES CLOB(2097152) NOT NULL,
--- UNIQUERULE CHARACTER(1) NOT NULL DEFAULT '',
--- COLCOUNT SMALLINT NOT NULL DEFAULT 0,
--- IID SMALLINT NOT NULL DEFAULT 0,
--- NLEAF INTEGER NOT NULL DEFAULT 0,
--- NLEVELS SMALLINT NOT NULL DEFAULT 0,
--- FIRSTKEYCARD BIGINT NOT NULL DEFAULT 0,
--- FULLKEYCARD BIGINT NOT NULL DEFAULT 0,
--- CLUSTERRATIO SMALLINT NOT NULL DEFAULT 0,
--- CLUSTERFACTOR DOUBLE NOT NULL DEFAULT 0,
--- USERDEFINED SMALLINT NOT NULL DEFAULT 0,
--- SYSTEM_REQUIRED SMALLINT NOT NULL DEFAULT 0,
--- CREATE_TIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,
--- STATS_TIME TIMESTAMP DEFAULT CURRENT TIMESTAMP,
--- PAGE_FETCH_PAIRS VARCHAR(254) NOT NULL DEFAULT '',
--- REMARKS VARCHAR(254) DEFAULT '',
--- DEFINER VARCHAR(128) NOT NULL DEFAULT '',
--- CONVERTED CHARACTER(1) NOT NULL DEFAULT '',
--- SEQUENTIAL_PAGES INTEGER NOT NULL DEFAULT 0,
--- DENSITY INTEGER NOT NULL DEFAULT 0,
--- FIRST2KEYCARD BIGINT NOT NULL DEFAULT 0,
--- FIRST3KEYCARD BIGINT NOT NULL DEFAULT 0,
--- FIRST4KEYCARD BIGINT NOT NULL DEFAULT 0,
--- PCTFREE SMALLINT NOT NULL DEFAULT -1,
--- UNIQUE_COLCOUNT SMALLINT NOT NULL DEFAULT -1,
--- MINPCTUSED SMALLINT NOT NULL DEFAULT 0,
--- REVERSE_SCANS CHARACTER(1) NOT NULL DEFAULT 'N',
--- USE_INDEX CHARACTER(1),
--- CREATION_TEXT CLOB(2097152) NOT NULL DEFAULT '',
--- PACKED_DESC BLOB(1048576)
--- )
--- GO
--- CREATE TABLE JRUAN.ADVISE_WORKLOAD (
--- WORKLOAD_NAME CHARACTER(128) NOT NULL DEFAULT 'WK0',
--- STATEMENT_NO INTEGER NOT NULL DEFAULT 1,
--- STATEMENT_TEXT CLOB(2097152) NOT NULL,
--- STATEMENT_TAG VARCHAR(256) NOT NULL DEFAULT '',
--- FREQUENCY INTEGER NOT NULL DEFAULT 1,
--- IMPORTANCE DOUBLE NOT NULL DEFAULT 1,
--- WEIGHT DOUBLE NOT NULL DEFAULT 1,
--- COST_BEFORE DOUBLE,
--- COST_AFTER DOUBLE,
--- COMPILABLE CHARACTER(17)
--- )
--- GO
--- CREATE TABLE JRUAN.ALGORITHM (
--- TYPE CHARACTER(1) NOT NULL,
--- ALGORITHM_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- DESCRIPTION VARCHAR(2000),
--- PROPERTYNAME VARCHAR(255),
--- PROPERTYVALUE VARCHAR(255),
--- USERTYPE_ID BIGINT,
--- GAPMODE_ID BIGINT,
--- POLYTCOUNT_ID BIGINT
--- )
--- GO
CREATE TABLE algorithm
(
"type" character(1) NOT NULL,
@@ -1734,18 +14,8 @@
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;
+-- alter sequence ancestralstate_id_sequence restart with 4885;
--- CREATE TABLE JRUAN.ANALYSIS (
--- ANALYSIS_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- NAME VARCHAR(255),
--- NOTES VARCHAR(2000),
--- VALIDATED SMALLINT,
--- STUDY_ID BIGINT,
--- ANALYSIS_ORDER INTEGER
--- )
--- GO
CREATE TABLE analysis
(
analysis_id bigint NOT NULL,
@@ -1760,21 +30,8 @@
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;
+-- alter sequence analysis_id_sequence restart with 4887;
--- CREATE TABLE JRUAN.ANALYSISSTEP (
--- ANALYSISSTEP_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- COMMANDS VARCHAR(2000),
--- NAME VARCHAR(255),
--- NOTES VARCHAR(2000),
--- ALGORITHM_ID BIGINT,
--- ANALYSIS_ID BIGINT,
--- SOFTWARE_ID BIGINT,
--- STEP_ORDER INTEGER,
--- TB_ANALYSISID VARCHAR(34)
--- )
--- GO
CREATE TABLE analysisstep
(
analysisstep_id bigint NOT NULL,
@@ -1792,20 +49,8 @@
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;
+-- alter sequence analysisstep_id_sequence restart with 4883;
--- CREATE TABLE JRUAN.ANALYZEDDATA (
--- TYPE CHARACTER(1) NOT NULL,
--- ANALYZEDDATA_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- INPUT SMALLINT,
--- NOTES VARCHAR(2000),
--- TREELENGTH INTEGER,
--- ANALYSISSTEP_ID BIGINT NOT NULL,
--- MATRIX_ID BIGINT,
--- PHYLOTREE_ID BIGINT
--- )
--- GO
CREATE TABLE analyzeddata
(
"type" character(1) NOT NULL,
@@ -1822,18 +67,8 @@
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;
+-- alter sequence analyzeddata_id_sequence restart with 11063;
--- CREATE TABLE JRUAN.ANCESTRALSTATE (
--- TYPE CHARACTER(1) NOT NULL,
--- ANCESTRALSTATE_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- ANCVALUE VARCHAR(255),
--- DISCRETECHARSTATE_ID BIGINT,
--- ANCSTATESET_ID BIGINT
--- )
--- GO
CREATE TABLE ancestralstate
(
"type" character(1) NOT NULL,
@@ -1850,13 +85,6 @@
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,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- MATRIX_ID BIGINT
--- )
--- GO
CREATE TABLE ancstateset
(
ancstateset_id bigint NOT NULL,
@@ -1870,11 +98,6 @@
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,
--- COLUMNRANGE_ID BIGINT NOT NULL
--- )
--- GO
CREATE TABLE chargroup_colrange
(
chargroup_id bigint NOT NULL,
@@ -1883,13 +106,6 @@
WITH (OIDS=FALSE);
ALTER TABLE chargroup_colrange OWNER TO postgres;
--- CREATE TABLE JRUAN.CHARGROUP (
--- CHARGROUP_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- CHARPARTITION_ID BIGINT
--- )
--- GO
CREATE TABLE chargroup
(
chargroup_id bigint NOT NULL,
@@ -1901,15 +117,8 @@
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;
+-- alter sequence ancestralstate_id_sequence restart with 1011;
--- CREATE TABLE JRUAN.CHARPARTITION (
--- CHARPARTITION_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- MATRIX_ID BIGINT
--- )
--- GO
CREATE TABLE charpartition
(
charpartition_id bigint NOT NULL,
@@ -1921,13 +130,8 @@
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;
+-- alter sequence charpartition_id_sequence restart with 429;
--- CREATE TABLE JRUAN.CHARSET_COLRANGE (
--- CHARSET_ID BIGINT NOT NULL,
--- COLUMNRANGE_ID BIGINT NOT NULL
--- )
--- GO
CREATE TABLE charset_colrange
(
charset_id bigint NOT NULL,
@@ -1936,14 +140,6 @@
WITH (OIDS=FALSE);
ALTER TABLE charset_colrange OWNER TO postgres;
--- CREATE TABLE JRUAN.CHARSET (
--- TYPE CHARACTER(1) NOT NULL,
--- CHARSET_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- MATRIX_ID BIGINT
--- )
--- GO
CREATE TABLE charset
(
"type" character(1) NOT NULL,
@@ -1956,13 +152,8 @@
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;
+-- alter sequence ancestralstate_id_sequence restart with 6335;
--- CREATE TABLE JRUAN.CHARWEIGHT_COLRANGE (
--- CHARWEIGHT_ID BIGINT NOT NULL,
--- COLUMNRANGE_ID BIGINT NOT NULL
--- )
--- GO
CREATE TABLE charweight_colrange
(
charweight_id bigint NOT NULL,
@@ -1971,15 +162,6 @@
WITH (OIDS=FALSE);
ALTER TABLE charweight_colrange OWNER TO postgres;
--- CREATE TABLE JRUAN.CHARWEIGHT (
--- TYPE CHARACTER(1) NOT NULL,
--- CHARWEIGHT_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- WEIGHT INTEGER,
--- REALWEIGHT DOUBLE,
--- CHARWEIGHTSET_ID BIGINT
--- )
--- GO
CREATE TABLE charweight
(
"type" character(1) NOT NULL,
@@ -1995,13 +177,6 @@
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,
--- VERSION INTEGER,
--- TITLE VARCHAR(255),
--- MATRIX_ID BIGINT
--- )
--- GO
CREATE TABLE charweightset
(
charweightset_id bigint NOT NULL,
@@ -2013,14 +188,8 @@
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;
+-- alter sequence charweightset_id_sequence restart with 208;
--- CREATE TABLE JRUAN.CITATION_AUTHOR (
--- CITATION_ID BIGINT NOT NULL,
--- AUTHORS_PERSON_ID BIGINT NOT NULL,
--- AUTHOR_ORDER INTEGER NOT NULL
--- )
--- GO
CREATE TABLE citation_author
(
citation_id bigint NOT NULL,
@@ -2030,12 +199,6 @@
WITH (OIDS=FALSE);
ALTER TABLE citation_author OWNER TO postgres;
--- CREATE TABLE JRUAN.CITATION_EDITOR (
--- CITATION_ID BIGINT NOT NULL,
--- EDITORS_PERSON_ID BIGINT NOT NULL,
--- EDITOR_ORDER INTEGER NOT NULL
--- )
--- GO
CREATE TABLE citation_editor
(
citation_id bigint NOT NULL,
@@ -2045,30 +208,6 @@
WITH (OIDS=FALSE);
ALTER TABLE citation_editor OWNER TO postgres;
--- CREATE TABLE JRUAN.CITATION (
--- TYPE CHARACTER(1) NOT NULL,
--- CITATION_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- PMID VARCHAR(255),
--- URL VARCHAR(255),
--- ABSTRACT VARCHAR(10000),
--- DOI VARCHAR(255),
--- KEYWORDS VARCHAR(255),
--- PAGES VARCHAR(255),
--- PUBLISHYEAR INTEGER,
--- PUBLISHED SMALLINT,
--- TITLE VARCHAR(500),
--- ISSUE VARCHAR(255),
--- JOURNAL VARCHAR(255),
--- VOLUME VARCHAR(255),
--- ISBN VARCHAR(255),
--- BOOKTITLE VARCHAR(255),
--- CITY VARCHAR(255),
--- PUBLISHER VARCHAR(255),
--- CITATIONSTATUS_ID BIGINT,
--- TB_STUDYID VARCHAR(30)
--- )
--- GO
CREATE TABLE citation
(
"type" character(1) NOT NULL,
@@ -2097,14 +236,8 @@
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;
+-- alter sequence citation_id_sequence restart with 18422;
--- CREATE TABLE JRUAN.CITATIONSTATUS (
--- CITATIONSTATUS_ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
--- VERSION INTEGER,
--- DESCRIPTION VARCHAR(50)
--- )
--- GO
CREATE TABLE citationstatus
(
citationstatus_id bigint NOT NULL,
@@ -2117,11 +250,6 @@
ALTER TABL...
[truncated message content] |