3 * Plain old SQL for setting up the tables for Odin web services.
6 /* The various tools assume that the database is appropriate configured with
7 * the SERIALIZABLE isolation level.
12 drop table odin_shorturl
;
13 drop table odin_shorturl_seq
;
15 create table odin_shorturl_seq (seq
int);
16 insert into odin_shorturl_seq (seq
) values (10000);
18 create table odin_shorturl
19 (tag
varchar(16) primary key,
20 stamp
timestamp not null default current_timestamp,
21 owner varchar(64) not null,
23 create index odin_shorturl_by_owner
on odin_shorturl (owner);