-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]
-GO
-
-
-ALTER TABLE [GtyAllele] ADD
- CONSTRAINT [pk_GtyAllele] PRIMARY KEY CLUSTERED
- (
- [gty_id],
- [rev_flag],
- [chr_num]
- )
+ALTER TABLE [GtyAllele] ADD CONSTRAINT [pk_GtyAllele] PRIMARY KEY CLUSTERED ([gty_id] ASC,[rev_flag] ASC,[chr_num] ASC)\r