-ALTER TABLE "Allele" ADD
- CONSTRAINT "pk_Allele" PRIMARY KEY
- (
- "allele_id"
- )
-;
-
-ALTER TABLE "AlleleFlagCode" ADD
- CONSTRAINT "pk_AlleleFlagCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "AlleleMotif" ADD
- CONSTRAINT "pk_AlleleMotif" PRIMARY KEY
- (
- "allele_id",
- "motif_order"
- )
-;
-
-ALTER TABLE "AllocIds" ADD
- CONSTRAINT "pk_AllocIds" PRIMARY KEY
- (
- "name"
- )
-;
-
-ALTER TABLE "Author" ADD
- CONSTRAINT "pk_Author" PRIMARY KEY
- (
- "pub_id",
- "position"
- )
-;
-
-
-
-ALTER TABLE "CpGCode" ADD
- CONSTRAINT "pk_CpGCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-
-
-ALTER TABLE "GenomeBuildInfo" ADD
- CONSTRAINT "DF__GenomeBui__inser__15E52B55" DEFAULT (getdate()) FOR "insert_time",
- CONSTRAINT "DF__GenomeBui__is_ma__18C19800" DEFAULT (1) FOR "is_major",
- CONSTRAINT "DF__GenomeBui__ncbi___23FE4082" DEFAULT (0) FOR "ncbi_genome_tax_id"
-;
-
-ALTER TABLE "GtyAllele" ADD
- CONSTRAINT "pk_GtyAllele" PRIMARY KEY
- (
- "gty_id",
- "rev_flag",
- "chr_num"
- )
-;
-
-ALTER TABLE "IUPACna" ADD
- CONSTRAINT "pk_IUPACna" PRIMARY KEY
- (
- "allele"
- )
-;
-
-ALTER TABLE "LoadHistory" ADD
- CONSTRAINT "pk_LoadHistory" PRIMARY KEY
- (
- "build_id"
- )
-;
-
-ALTER TABLE "LocTypeCode" ADD
- CONSTRAINT "DF__LocTypeCo__creat__75CD617E" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_LocTypeCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "MapLinkCode" ADD
- CONSTRAINT "pk_MapLinkCode" PRIMARY KEY
- (
- "which_code",
- "code"
- )
-;
-
-ALTER TABLE "Method" ADD
- CONSTRAINT "pk_Method_mid" PRIMARY KEY
- (
- "method_id"
- )
-;
-
-ALTER TABLE "MethodClass" ADD
- CONSTRAINT "pk_MethodClass" PRIMARY KEY
- (
- "meth_class_id"
- )
-;
-
-ALTER TABLE "MethodLine" ADD
- CONSTRAINT "pk_MethodLine" PRIMARY KEY
- (
- "method_id",
- "line_num"
- )
-;
-
-ALTER TABLE "Moltype" ADD
- CONSTRAINT "pk_Moltype" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "Motif" ADD
- CONSTRAINT "pk_Motif" PRIMARY KEY
- (
- "motif_id"
- )
-;
-
-ALTER TABLE "ObsGenotype" ADD
- CONSTRAINT "pk_ObsGenotype" PRIMARY KEY
- (
- "gty_id"
- )
-;
-
-ALTER TABLE "ObsVariation" ADD
- CONSTRAINT "DF__ObsVariat__creat__3BB5CE82" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "DF__ObsVariat__last___3CA9F2BB" DEFAULT (getdate()) FOR "last_updated_time",
- CONSTRAINT "pk_ObsVariation" PRIMARY KEY
- (
- "var_id"
- )
-;
-
-ALTER TABLE "OrgDbStatus" ADD
- CONSTRAINT "pk_org_db_status" PRIMARY KEY
- (
- "database_name"
- )
-;
-
-ALTER TABLE "OrganismTax" ADD
- CONSTRAINT "pk_organism" PRIMARY KEY
- (
- "tax_id"
- )
-;
-
-ALTER TABLE "PopClass" ADD
- CONSTRAINT "pk_PopClass" PRIMARY KEY
- (
- "pop_id",
- "pop_class_id"
- )
-;
-
-ALTER TABLE "PopClassCode" ADD
- CONSTRAINT "PK__PopClassCode__270595B6" PRIMARY KEY
- (
- "pop_class_id"
- )
-;
-
-ALTER TABLE "Publication" ADD
- CONSTRAINT "pk_Publication" PRIMARY KEY
- (
- "pub_id"
- )
-;
-
-ALTER TABLE "SNPGlossary" ADD
- CONSTRAINT "DF__SNPGlossa__last___4050666D" DEFAULT (getdate()) FOR "last_updated",
- CONSTRAINT "pk_SNPGlossary" PRIMARY KEY
- (
- "term"
- )
-;
-
-ALTER TABLE "SNP_tax_id" ADD
- CONSTRAINT "DF__SNP_tax_i__statu__31583BA0" DEFAULT ('C') FOR "status",
- CONSTRAINT "pk_SNP_tax_id" PRIMARY KEY
- (
- "snp_id"
- )
-;
-
-ALTER TABLE "SnpChrCode" ADD
- CONSTRAINT "pk_SnpChrCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpClassCode" ADD
- CONSTRAINT "pk_SnpClassCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpFunctionCode" ADD
- CONSTRAINT "pk_SnpFunctionCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpValidationCode" ADD
- CONSTRAINT "pk_SnpValidationCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "StrandCode" ADD
- CONSTRAINT "pk_StrandCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-
-
-ALTER TABLE "Submitter" ADD
- CONSTRAINT "DF_Submitter_create_time" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_Submitter" PRIMARY KEY
- (
- "handle"
- )
-;
-
-ALTER TABLE "TemplateType" ADD
- CONSTRAINT "pk_TemplateType" PRIMARY KEY
- (
- "temp_type_id"
- )
-;
-
-ALTER TABLE "UniGty" ADD
- CONSTRAINT "pk_UniGty" PRIMARY KEY
- (
- "unigty_id"
- )
-;
-
-ALTER TABLE "UniVariAllele" ADD
- CONSTRAINT "pk_UniVariAllele" PRIMARY KEY
- (
- "univar_id",
- "allele_id"
- )
-;
-
-ALTER TABLE "UniVariation" ADD
- CONSTRAINT "pk_UniVariation" PRIMARY KEY
- (
- "univar_id"
- )
-;
-
-ALTER TABLE "UniVariationSrcCode" ADD
- CONSTRAINT "pk_UniVariationSrcCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "VariAllele" ADD
- CONSTRAINT "pk_VariAllele" PRIMARY KEY
- (
- "var_id",
- "allele_id"
- )
-;
-
-ALTER TABLE "db_DataDictionaryNew" ADD
- CONSTRAINT "DF__db_DataDi__updat__5BB889C0" DEFAULT (getdate()) FOR "update_time"
-;
-
-ALTER TABLE "db_ftp_table_list" ADD
- CONSTRAINT "DF__db_ftp_ta__creat__27F9B9EF" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_db_ftp_table_list" PRIMARY KEY
- (
- "table_name"
- )
-;
-
-
-ALTER TABLE "dn_Allele_rev" ADD
- CONSTRAINT "pk_dn_Allele_rev" PRIMARY KEY
- (
- "allele_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_Motif_rev" ADD
- CONSTRAINT "pk_dn_Motif_rev" PRIMARY KEY
- (
- "motif_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_UniGty_allele" ADD
- CONSTRAINT "pk_dn_UniGty_allele" PRIMARY KEY
- (
- "unigty_id",
- "chr_num"
- )
-;
-
-ALTER TABLE "dn_UniGty_rev" ADD
- CONSTRAINT "pk_dn_Gty_rev" PRIMARY KEY
- (
- "unigty_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_UniVariation_rev" ADD
- CONSTRAINT "pk_dn_UniVariation_rev" PRIMARY KEY
- (
- "univar_id",
- "rev_flag"
- )
-;
-
-
-
-ALTER TABLE "dn_summary" ADD
- CONSTRAINT "DF__dn_summar__creat__383A4359" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "DF__dn_summar__last___392E6792" DEFAULT (getdate()) FOR "last_updated_time",
- PRIMARY KEY
- (
- "tax_id",
- "build_id",
- "type"
- )
-;
-
+ALTER TABLE Allele ADD \r
+ CONSTRAINT pk_Allele PRIMARY KEY \r
+ (\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE AlleleFlagCode ADD \r
+ CONSTRAINT pk_AlleleFlagCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE AlleleMotif ADD \r
+ CONSTRAINT pk_AlleleMotif PRIMARY KEY \r
+ (\r
+ allele_id,\r
+ motif_order\r
+ )\r
+;\r
+\r
+ALTER TABLE AllocIds ADD \r
+ CONSTRAINT pk_AllocIds PRIMARY KEY\r
+ (\r
+ name\r
+ )\r
+;\r
+\r
+ALTER TABLE Author ADD \r
+ CONSTRAINT pk_Author PRIMARY KEY\r
+ (\r
+ pub_id,\r
+ position\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE CpGCode ADD \r
+ CONSTRAINT pk_CpGCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+\r
+\r
+-- ALTER TABLE GenomeBuildInfo ADD \r
+-- CONSTRAINT DF__GenomeBui__inser__15E52B55 DEFAULT (getdate()) FOR insert_time,\r
+-- CONSTRAINT DF__GenomeBui__is_ma__18C19800 DEFAULT (1) FOR is_major,\r
+-- CONSTRAINT DF__GenomeBui__ncbi___23FE4082 DEFAULT (0) FOR ncbi_genome_tax_id\r
+-- ;\r
+\r
+ALTER TABLE GtyAllele ADD \r
+ CONSTRAINT pk_GtyAllele PRIMARY KEY \r
+ (\r
+ gty_id,\r
+ rev_flag,\r
+ chr_num\r
+ )\r
+;\r
+\r
+ALTER TABLE IUPACna ADD \r
+ CONSTRAINT pk_IUPACna PRIMARY KEY \r
+ (\r
+ allele\r
+ )\r
+;\r
+\r
+ALTER TABLE LoadHistory ADD \r
+ CONSTRAINT pk_LoadHistory PRIMARY KEY\r
+ (\r
+ build_id\r
+ )\r
+;\r
+\r
+ALTER TABLE LocTypeCode ADD \r
+-- CONSTRAINT DF__LocTypeCo__creat__75CD617E DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_LocTypeCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE MapLinkCode ADD \r
+ CONSTRAINT pk_MapLinkCode PRIMARY KEY \r
+ (\r
+ which_code,\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE Method ADD \r
+ CONSTRAINT pk_Method_mid PRIMARY KEY \r
+ (\r
+ method_id\r
+ )\r
+;\r
+\r
+ALTER TABLE MethodClass ADD \r
+ CONSTRAINT pk_MethodClass PRIMARY KEY \r
+ (\r
+ meth_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE MethodLine ADD \r
+ CONSTRAINT pk_MethodLine PRIMARY KEY\r
+ (\r
+ method_id,\r
+ line_num\r
+ )\r
+;\r
+\r
+ALTER TABLE Moltype ADD \r
+ CONSTRAINT pk_Moltype PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE Motif ADD \r
+ CONSTRAINT pk_Motif PRIMARY KEY \r
+ (\r
+ motif_id\r
+ )\r
+;\r
+\r
+ALTER TABLE ObsGenotype ADD \r
+ CONSTRAINT pk_ObsGenotype PRIMARY KEY \r
+ (\r
+ gty_id\r
+ )\r
+;\r
+\r
+ALTER TABLE ObsVariation ADD \r
+-- CONSTRAINT DF__ObsVariat__creat__3BB5CE82 DEFAULT (getdate()) FOR create_time,\r
+-- CONSTRAINT DF__ObsVariat__last___3CA9F2BB DEFAULT (getdate()) FOR last_updated_time,\r
+ CONSTRAINT pk_ObsVariation PRIMARY KEY \r
+ (\r
+ var_id\r
+ )\r
+;\r
+\r
+ALTER TABLE OrgDbStatus ADD \r
+ CONSTRAINT pk_org_db_status PRIMARY KEY \r
+ (\r
+ database_name\r
+ )\r
+;\r
+\r
+ALTER TABLE OrganismTax ADD \r
+ CONSTRAINT pk_organism PRIMARY KEY\r
+ (\r
+ tax_id\r
+ )\r
+;\r
+\r
+ALTER TABLE PopClass ADD \r
+ CONSTRAINT pk_PopClass PRIMARY KEY \r
+ (\r
+ pop_id,\r
+ pop_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE PopClassCode ADD \r
+ CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY \r
+ (\r
+ pop_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE Publication ADD \r
+ CONSTRAINT pk_Publication PRIMARY KEY\r
+ (\r
+ pub_id\r
+ )\r
+;\r
+\r
+ALTER TABLE SNPGlossary ADD \r
+-- CONSTRAINT DF__SNPGlossa__last___4050666D DEFAULT (getdate()) FOR last_updated,\r
+ CONSTRAINT pk_SNPGlossary PRIMARY KEY \r
+ (\r
+ term\r
+ )\r
+;\r
+\r
+ALTER TABLE SNP_tax_id ADD \r
+-- CONSTRAINT DF__SNP_tax_i__statu__31583BA0 DEFAULT ('C') FOR status,\r
+ CONSTRAINT pk_SNP_tax_id PRIMARY KEY \r
+ (\r
+ snp_id\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpChrCode ADD \r
+ CONSTRAINT pk_SnpChrCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpClassCode ADD \r
+ CONSTRAINT pk_SnpClassCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpFunctionCode ADD \r
+ CONSTRAINT pk_SnpFunctionCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpValidationCode ADD \r
+ CONSTRAINT pk_SnpValidationCode PRIMARY KEY\r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE StrandCode ADD \r
+ CONSTRAINT pk_StrandCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE Submitter ADD \r
+-- CONSTRAINT DF_Submitter_create_time DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_Submitter PRIMARY KEY\r
+ (\r
+ handle\r
+ )\r
+;\r
+\r
+ALTER TABLE TemplateType ADD \r
+ CONSTRAINT pk_TemplateType PRIMARY KEY \r
+ (\r
+ temp_type_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniGty ADD \r
+ CONSTRAINT pk_UniGty PRIMARY KEY \r
+ (\r
+ unigty_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariAllele ADD \r
+ CONSTRAINT pk_UniVariAllele PRIMARY KEY \r
+ (\r
+ univar_id,\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariation ADD \r
+ CONSTRAINT pk_UniVariation PRIMARY KEY \r
+ (\r
+ univar_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariationSrcCode ADD \r
+ CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE VariAllele ADD \r
+ CONSTRAINT pk_VariAllele PRIMARY KEY \r
+ (\r
+ var_id,\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE db_ftp_table_list ADD \r
+-- CONSTRAINT DF__db_ftp_ta__creat__27F9B9EF DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_db_ftp_table_list PRIMARY KEY \r
+ (\r
+ table_name\r
+ )\r
+;\r
+\r
+-- ALTER TABLE db_map_table_name ADD \r
+-- CONSTRAINT DF__db_map_ta__inNon__206E7217 DEFAULT ('N') FOR inNonHuman\r
+-- ;\r
+\r
+ALTER TABLE dn_Allele_rev ADD \r
+ CONSTRAINT pk_dn_Allele_rev PRIMARY KEY \r
+ (\r
+ allele_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_Motif_rev ADD \r
+ CONSTRAINT pk_dn_Motif_rev PRIMARY KEY \r
+ (\r
+ motif_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniGty_allele ADD \r
+ CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY \r
+ (\r
+ unigty_id,\r
+ chr_num\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniGty_rev ADD \r
+ CONSTRAINT pk_dn_Gty_rev PRIMARY KEY \r
+ (\r
+ unigty_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniVariation_rev ADD \r
+ CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY \r
+ (\r
+ univar_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE dn_summary ADD \r
+-- CONSTRAINT DF__dn_summar__creat__383A4359 DEFAULT (getdate()) FOR create_time,\r
+-- CONSTRAINT DF__dn_summar__last___392E6792 DEFAULT (getdate()) FOR last_updated_time,\r
+ PRIMARY KEY \r
+ (\r
+ tax_id,\r
+ build_id,\r
+ type\r
+ )\r
+;\r
+\r