6Ee0qqbv

1CREATE TABLE IF NOT EXISTS serviceticket
2(
3  id                      VARCHAR(255) NOT NULL
4    CONSTRAINT serviceticket_pkey
5    PRIMARY KEY,
6  number_of_times_used    INTEGER,
7  creation_time           BIGINT,
8  expiration_policy       OID          NOT NULL,
9  last_time_used          BIGINT,
10  previous_last_time_used BIGINT,
11  from_new_login          BOOLEAN      NOT NULL,
12  ticket_already_granted  BOOLEAN      NOT NULL,
13  service                 OID          NOT NULL,
14  ticketgrantingticket_id VARCHAR(255)
15);
16
17CREATE TABLE IF NOT EXISTS ticketgrantingticket
18(
19  id                         VARCHAR(255) NOT NULL
20    CONSTRAINT ticketgrantingticket_pkey
21    PRIMARY KEY,
22  number_of_times_used       INTEGER,
23  creation_time              BIGINT,
24  expiration_policy          OID          NOT NULL,
25  last_time_used             BIGINT,
26  previous_last_time_used    BIGINT,
27  authentication             OID          NOT NULL,
28  expired                    BOOLEAN      NOT NULL,
29  services_granted_access_to OID          NOT NULL,
30  ticketgrantingticket_id    VARCHAR(255)
31    CONSTRAINT fkb4c4cdde32a2c0e5
32    REFERENCES ticketgrantingticket
33);