1CREATE TABLE users (
2	fname text not null,
3	lname text not null,
4	username text,
5	userid serial,
6	PRIMARY KEY(lname, fname)
7	) ;
8
9CREATE INDEX users_username_idx ON users(username);
10CREATE INDEX users_fname_idx ON users(fname);
11CREATE INDEX users_lname_idx ON users(lname);
12CREATE INDEX users_userid_idx ON users(userid);
13
14
15CREATE TABLE taxonomy (
16	id serial primary key,
17	name text unique
18	) ;
19
20CREATE TABLE entry (
21	accession text not null primary key,
22	eid serial unique,
23	txid int2 not null references taxonomy(id)
24	) ;
25
26CREATE TABLE sequences (
27	eid int4 not null references entry(eid),
28	pid serial primary key,
29	product text not null,
30	sequence text not null,
31	multipart bool default 'false'
32	) ;
33CREATE INDEX sequences_product_idx ON sequences(product) ;
34
35CREATE TABLE xsequences (
36	pid int4 not null references sequences(pid),
37	sequence text not null
38	) ;
39CREATE INDEX xsequences_pid_idx ON xsequences(pid) ;
40