1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
/*
* $Id: PubStruct.scr,v 6.2 1998/06/05 17:59:55 kimelman Exp $
* ===========================================================================
*
* PUBLIC DOMAIN NOTICE
* National Center for Biotechnology Information (NCBI)
*
* This software/database is a "United States Government Work" under the
* terms of the United States Copyright Act. It was written as part of
* the author's official duties as a United States Government employee and
* thus cannot be copyrighted. This software/database is freely available
* to the public for use. The National Library of Medicine and the U.S.
* Government do not place any restriction on its use or reproduction.
* We would, however, appreciate having the NCBI and the author cited in
* any work or product based on this material
*
* Although all reasonable efforts have been taken to ensure the accuracy
* and reliability of the software and data, the NLM and the U.S.
* Government do not and cannot warrant the performance or results that
* may be obtained by using this software or data. The NLM and the U.S.
* Government disclaim all warranties, express or implied, including
* warranties of performance, merchantability or fitness for any particular
* purpose.
*
* ===========================================================================
*
* Author: Michael Kimelman
*
* PubStruct schema definition
*
* Modifications:
*
* $Log: PubStruct.scr,v $
* Revision 6.2 1998/06/05 17:59:55 kimelman
* help tags changed
*
*
*/
use PubStruct
go
PRINT "create acc"
go
/*
* TABLE acc : ticketing
*/
create table acc (
kind tinyint primary key,
ticket int NOT NULL
)
go
insert into acc values(1,1)
go
/*
* TABLE Struct : main PubStruct storage
*/
PRINT "create Struct"
go
create table Struct (
acc int NOT NULL primary key, /* technical accession number */
mmdb_id int NOT NULL,
state int NOT NULL, /* important thing */
/* value -- legend
0 alive and ready for public retrieval
>0 intermediate states on "assembling line".
if we update some structure(BLOB) we suppress previous version
instead of removing it.
*/
date datetime NOT NULL, /* date of arriving in this state */
suppressed tinyint NOT NULL, /* >0 - if suppressed by newly arrived data */
confidential tinyint NOT NULL,
blob image NULL
)
go
CREATE INDEX mmdb_PubStruct ON Struct(mmdb_id,state)
go
grant select on Struct to public
go
grant update(blob) on Struct to public
go
/*
* TABLE pdb : pdb to mmdb translation.
*/
PRINT "create pdb"
go
create table pdb (
mmdb_id int NOT NULL PRIMARY KEY,
pdb_id char(4) NOT NULL,
)
go
CREATE INDEX pdb_PubStruct ON pdb(pdb_id)
go
grant select on pdb to public
go
|
