add human 9606 schema

[dbsnp.git] / schema / human_9606_schema / dbSNP_sup_table_postgresql.sql

diff --git a/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql b/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql
new file mode 100644 (file)
index 0000000..8ef0491
--- /dev/null
+++ b/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql
@@ -0,0 +1,106 @@
+CREATE TABLE SubSNPAcc_p1_human (
+       subsnp_id int NOT NULL ,
+       acc_type_ind char (1) NOT NULL ,
+       acc_part varchar (16) NOT NULL ,
+       acc_ver int NULL 
+)
+;
+
+CREATE TABLE SubSNPAcc_p2_human (
+       subsnp_id int NOT NULL ,
+       acc_type_ind char (1) NOT NULL ,
+       acc_part varchar (16) NOT NULL ,
+       acc_ver int NULL 
+)
+;
+
+CREATE TABLE SubSNPAcc_p3_human (
+       subsnp_id int NOT NULL ,
+       acc_type_ind char (1) NOT NULL ,
+       acc_part varchar (16) NOT NULL ,
+       acc_ver int NULL 
+)
+;
+
+CREATE TABLE SubSNPCommLine_p1_human (
+       subsnp_id int NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPCommLine_p2_human (
+       subsnp_id int NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPCommLine_p3_human (
+       subsnp_id int NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq3_p1_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq3_p2_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq3_p3_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq5_p1_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq5_p2_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE SubSNPSeq5_p3_human (
+       subsnp_id int NOT NULL ,
+       type smallint NOT NULL ,
+       line_num smallint NOT NULL ,
+       line varchar (255) NOT NULL 
+)
+;
+
+CREATE TABLE dn_table_rowcount (
+       tabname varchar (64) NOT NULL ,
+       row_cnt int NOT NULL ,
+       build_id int NOT NULL ,
+       update_time TIMESTAMP NOT NULL ,
+       rows_in_spaceused int NULL ,
+       reserved_KB_spaceused int NULL ,
+       data_KB_spaceused int NULL ,
+       index_size_KB_spaceused int NULL ,
+       unused_KB_spaceused int NULL 
+)
+;
+