Menu
▾
▴
[Treebase-guts] SF.net SVN: treebase:[69] trunk/treebase-core/src/main/resources/ TBASE2_POSTGRES_CREATION.sql
|
From: <rv...@us...> - 2009-06-19 02:22:16
|
Revision: 69
http://treebase.svn.sourceforge.net/treebase/?rev=69&view=rev
Author: rvos
Date: 2009-06-19 02:22:14 +0000 (Fri, 19 Jun 2009)
Log Message:
-----------
Adding postgres TBASE2 creation script
Added Paths:
-----------
trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql
Added: trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql
===================================================================
--- trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql (rev 0)
+++ trunk/treebase-core/src/main/resources/TBASE2_POSTGRES_CREATION.sql 2009-06-19 02:22:14 UTC (rev 69)
@@ -0,0 +1,6545 @@
+/*
+--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,
+ algorithm_id bigint NOT NULL,
+ "version" integer,
+ description character varying(2000),
+ propertyname character varying(255),
+ propertyvalue character varying(255),
+ usertype_id bigint,
+ gapmode_id bigint,
+ polytcount_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE algorithm OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ "name" character varying(255),
+ notes character varying(2000),
+ validated smallint,
+ study_id bigint,
+ analysis_order integer
+)
+WITH (OIDS=FALSE);
+ALTER TABLE analysis OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ commands character varying(2000),
+ "name" character varying(255),
+ notes character varying(2000),
+ algorithm_id bigint,
+ analysis_id bigint,
+ software_id bigint,
+ step_order integer,
+ tb_analysisid character varying(34)
+)
+WITH (OIDS=FALSE);
+ALTER TABLE analysisstep OWNER TO postgres;
+
+-- 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,
+ analyzeddata_id bigint NOT NULL,
+ "version" integer,
+ "input" smallint,
+ notes character varying(2000),
+ treelength integer,
+ analysisstep_id bigint NOT NULL,
+ matrix_id bigint,
+ phylotree_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE analyzeddata OWNER TO postgres;
+
+-- 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,
+ ancestralstate_id bigint NOT NULL,
+ "version" integer,
+ title character varying(255),
+ ancvalue character varying(255),
+ discretecharstate_id bigint,
+ ancstateset_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE ancestralstate OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ title character varying(255),
+ matrix_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE ancstateset OWNER TO postgres;
+
+-- 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,
+ columnrange_id bigint NOT NULL
+)
+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,
+ "version" integer,
+ title character varying(255),
+ charpartition_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE chargroup OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ title character varying(255),
+ matrix_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE charpartition OWNER TO postgres;
+
+-- 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,
+ columnrange_id bigint NOT NULL
+)
+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,
+ charset_id bigint NOT NULL,
+ "version" integer,
+ title character varying(255),
+ matrix_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE charset OWNER TO postgres;
+
+-- 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,
+ columnrange_id bigint NOT NULL
+)
+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,
+ charweight_id bigint NOT NULL,
+ "version" integer,
+ weight integer,
+ realweight double precision,
+ charweightset_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE charweight OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ title character varying(255),
+ matrix_id bigint
+)
+WITH (OIDS=FALSE);
+ALTER TABLE charweightset OWNER TO postgres;
+
+-- 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,
+ authors_person_id bigint NOT NULL,
+ author_order integer NOT NULL
+)
+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,
+ editors_person_id bigint NOT NULL,
+ editor_order integer NOT NULL
+)
+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,
+ citation_id bigint NOT NULL,
+ "version" integer,
+ pmid character varying(255),
+ url character varying(255),
+ abstract character varying(10000),
+ doi character varying(255),
+ keywords character varying(255),
+ pages character varying(255),
+ publishyear integer,
+ published smallint,
+ title character varying(500),
+ issue character varying(255),
+ journal character varying(255),
+ volume character varying(255),
+ isbn character varying(255),
+ booktitle character varying(255),
+ city character varying(255),
+ publisher character varying(255),
+ citationstatus_id bigint,
+ tb_studyid character varying(30)
+)
+WITH (OIDS=FALSE);
+ALTER TABLE citation OWNER TO postgres;
+
+-- 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,
+ "version" integer,
+ description character varying(50)
+)
+WITH (OIDS=FALSE);
+ALTER TABLE citationstatus OWNER TO postgres;
+
+-- CREATE TABLE JRUAN.CODERECORD_COLRANGE (
+-- GENETICCODERECORD_ID BIGINT NOT NULL,
+-- COLUMNRANGE_ID BIGINT NOT NULL
+-- )
+-- GO
+CREATE TABLE coderecord_colrange
+(
+ geneticcoderecord_id bigint NOT NULL,
+ columnrange_id ...
[truncated message content] |
