> Where can I find the DB schema for the tables created by a JpaTicket
> Registry?
Note that by default Hibernate creates the schema provided the JDBC
user has sufficient privileges to create/alter schema objects. The
dump of the JPA part of our PostgreSQL schema follows:
CREATE TABLE registeredserviceimpl (
id bigint NOT NULL,
allowedtoproxy boolean NOT NULL,
anonymousaccess boolean NOT NULL,
description character varying(255),
enabled boolean NOT NULL,
evaluation_order integer NOT NULL,
ignoreattributes boolean NOT NULL,
name character varying(255),
serviceid character varying(255),
ssoenabled boolean NOT NULL,
theme character varying(255)
);
CREATE TABLE rs_attributes (
registeredserviceimpl_id bigint NOT NULL,
a_name character varying(255) NOT NULL,
a_id integer NOT NULL
);
CREATE TABLE serviceticket (
id character varying(255) NOT NULL,
number_of_times_used integer,
creation_time bigint,
expiration_policy oid NOT NULL,
last_time_used bigint,
previous_last_time_used bigint,
from_new_login boolean NOT NULL,
ticket_already_granted boolean NOT NULL,
service oid NOT NULL,
ticketgrantingticket_id character varying(255)
);
CREATE TABLE ticketgrantingticket (
id character varying(255) NOT NULL,
number_of_times_used integer,
creation_time bigint,
expiration_policy oid NOT NULL,
last_time_used bigint,
previous_last_time_used bigint,
authentication oid NOT NULL,
expired boolean NOT NULL,
services_granted_access_to oid NOT NULL,
ticketgrantingticket_id character varying(255)
);
ALTER TABLE ONLY registeredserviceimpl
ADD CONSTRAINT registeredserviceimpl_pkey PRIMARY KEY (id);
ALTER TABLE ONLY rs_attributes
ADD CONSTRAINT rs_attributes_pkey PRIMARY KEY
(registeredserviceimpl_id, a_id);
ALTER TABLE ONLY serviceticket
ADD CONSTRAINT serviceticket_pkey PRIMARY KEY (id);
ALTER TABLE ONLY ticketgrantingticket
ADD CONSTRAINT ticketgrantingticket_pkey PRIMARY KEY (id);
ALTER TABLE ONLY rs_attributes
ADD CONSTRAINT fk4322e15f0c8d661 FOREIGN KEY (registeredserviceimpl_id)
REFERENCES registeredserviceimpl(id);
ALTER TABLE ONLY serviceticket
ADD CONSTRAINT fk7645ade132a2c0e5 FOREIGN KEY (ticketgrantingticket_id)
REFERENCES ticketgrantingticket(id);
ALTER TABLE ONLY ticketgrantingticket
ADD CONSTRAINT fkb4c4cdde32a2c0e5 FOREIGN KEY (ticketgrantingticket_id)
REFERENCES ticketgrantingticket(id);
CREATE INDEX i_st_tgt_id ON serviceticket USING btree (ticketgrantingticket_id);
CREATE INDEX i_tgt_tgt_id ON ticketgrantingticket USING btree
(ticketgrantingticket_id);
Hope that helps,
M
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
