Marvin's right, it will create it automatically in any environment its allowed to (usually doing it in development is safe). Its not perfect though (i.e. in 3.4.3 and earlier we don't have annotations for indexes, which we'll add in 3.5).
Cheers, Scott On Mon, Oct 18, 2010 at 3:15 PM, Marvin Addison <[email protected]>wrote: > > 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 > -- 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
