-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_insert_time] DEFAULT (GETDATE()) FOR [insert_time]
-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_is_major] DEFAULT ((1)) FOR [is_major]
-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_ncbi_genome_tax_id] DEFAULT ((0)) FOR [ncbi_genome_tax_id]
+ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [PK_GenomeBuildInfo] PRIMARY KEY CLUSTERED ([snp_build_id] ASC,[tax_id] ASC,[is_major] ASC)\r
+GO
ALTER TABLE [GtyAllele] ADD CONSTRAINT [pk_GtyAllele] PRIMARY KEY CLUSTERED ([gty_id] ASC,[rev_flag] ASC,[chr_num] ASC)\r
GO
ALTER TABLE CpGCode ADD CONSTRAINT pk_CpGCode PRIMARY KEY (code);
-ALTER TABLE GenomeBuildInfo ALTER COLUMN insert_time SET DEFAULT NOW();
-ALTER TABLE GenomeBuildInfo ALTER COLUMN is_major SET DEFAULT (1);
-ALTER TABLE GenomeBuildInfo ALTER COLUMN ncbi_genome_tax_id SET DEFAULT (0);
+ALTER TABLE GenomeBuildInfo ADD CONSTRAINT PK_GneomeBuildInfo PRIMARY KEY (snp_build_id,tax_id,is_major);
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);
[top_level_class] [char](5) NOT NULL ,
[is_coding] [tinyint] NOT NULL ,
[is_exon] [bit] NULL ,
-[var_prop_loc_code] [int] NULL ,
-[var_prop_effect_code] [int] NULL
+[var_prop_effect_code] [int] NULL ,
+[var_prop_gene_loc_code] [int] NULL ,
+[SO_id] [varchar](32) NULL
)\r
GO
CREATE TABLE [SubSNPDelComm]
(
[comment_id] [smallint] NOT NULL ,
-[comment] [varchar](255) NOT NULL ,
+[comment] [varchar](400) NULL ,
[create_time] [smalldatetime] NULL
)\r
GO
top_level_class char(5) NOT NULL ,
is_coding smallint NOT NULL ,
is_exon bit NULL ,
-var_prop_loc_code int NULL ,
-var_prop_effect_code int NULL
+var_prop_effect_code int NULL ,
+var_prop_gene_loc_code int NULL ,
+SO_id varchar(32) NULL
);
CREATE TABLE SnpValidationCode
(
CREATE TABLE SubSNPDelComm
(
comment_id smallint NOT NULL ,
-comment varchar(255) NOT NULL ,
+comment varchar(400) NOT NULL ,
create_time TIMESTAMP NULL
);
CREATE TABLE SubSNPSeqTypeCode