dll.createIndexesAndForeignKeys.sql Maven / Gradle / Ivy

Go to download
alter table addresses add constraint FK34207BA28DE7C415 foreign key (federalstate_id) references federalstates;
alter table addresses add constraint FK34207BA2905CFE01 foreign key (zipcode_id) references zipcodes;
alter table blacklisted_contacts add constraint FKA1253AB66B955CF9 foreign key (blacklisted_id) references users;
alter table blacklisted_contacts add constraint FKA1253AB6A09C615E foreign key (user_data_id) references user_data;
alter table event_locations add constraint FKCF58CBF92275A772 foreign key (event_location_id) references addresses;
alter table event_locations add constraint FKCF58CBF9A66D97A5 foreign key (event_id) references events;
alter table event_locations add constraint FKCF58CBF954300003 foreign key (appointment_id) references appointments;
alter table event_locations add constraint FKCF58CBF9B9B74960 foreign key (contactperson_id) references users;
alter table event_messages add constraint FKAB620D51C43C0A33 foreign key (event_location_id) references event_locations;
alter table event_messages add constraint FKAB620D51442255DC foreign key (message_id) references messages;
alter table event_ratings add constraint FK518F61D1A66D97A5 foreign key (event_id) references events;
alter table event_ratings add constraint FK518F61D1B117ECD foreign key (rater) references users;
alter table event_topics add constraint FK409D2269A66D97A5 foreign key (event_id) references events;
alter table event_topics add constraint FK409D2269DF34FEDE foreign key (topic_id) references topics;
alter table events add constraint FKB307E11962075049 foreign key (categories_id) references categories;
alter table federalstates add constraint FK1A5486DFA5FA3D28 foreign key (country_id) references countries;
alter table message_attachments add constraint FK64E05778442255DC foreign key (message_id) references messages;
alter table message_attachments add constraint FK64E05778E812C08D foreign key (resource_id) references resources;
alter table message_recipients add constraint FKF83BACB28940B5B5 foreign key (recipient_email) references contactmethods;
alter table message_recipients add constraint FKF83BACB24FFB4C3C foreign key (recipient_id) references users;
alter table message_recipients add constraint FKF83BACB2442255DC foreign key (message_id) references messages;
alter table messages add constraint FKE475014CCE9D4970 foreign key (sender) references users;
alter table messages add constraint FKE475014C33EFD8D1 foreign key (sender_email) references contactmethods;
alter table messages add constraint FKE475014C6D93BE33 foreign key (parent) references messages;
alter table offered_event_locations add constraint FK56D7CBB599597015 foreign key (event_location_data_id) references event_location_data;
alter table offered_event_locations add constraint FK56D7CBB57FAE0964 foreign key (provider_id) references users;
alter table offered_event_locations add constraint FK56D7CBB5FBD81D4A foreign key (user_id) references users;
alter table offered_event_locations add constraint FK56D7CBB565A3C1EC foreign key (user_address_id) references addresses;
alter table profile_federalstates add constraint FKC66646C98DE7C415 foreign key (federalstate_id) references federalstates;
alter table profile_federalstates add constraint FKC66646C9FBD81D4A foreign key (user_id) references users;
alter table profile_topics add constraint FKD90ECC7AFBD81D4A foreign key (user_id) references users;
alter table profile_topics add constraint FKD90ECC7ADF34FEDE foreign key (topic_id) references topics;
alter table rating_descriptions add constraint FKAF90FB592AAF514 foreign key (event_ratings_id) references event_ratings;
alter table recommendations add constraint FK9357B7DAFBD81D4A foreign key (user_id) references users;
alter table recommendations add constraint FK9357B7DAC77E60BA foreign key (recommended_id) references users;
alter table relation_permissions add constraint FK634032C17FAE0964 foreign key (provider_id) references users;
alter table relation_permissions add constraint FK634032C1625E9B8D foreign key (subscriber_id) references users;
alter table reset_passwords add constraint FK35B79A48FBD81D4A foreign key (user_id) references users;
alter table robinsons add constraint FKAAF79CBE7597B3 foreign key (robinson_user_id) references users;
alter table role_permissions add constraint FKEAD9D23B5682C574 foreign key (role_id) references roles;
alter table role_permissions add constraint FKEAD9D23B70D24902 foreign key (permission_id) references permissions;
alter table rule_violations add constraint FK99170D11EEC9B5D1 foreign key (detector_user_id) references users;
alter table rule_violations add constraint FK99170D113F55EB31 foreign key (violator_user_id) references users;
alter table topics add constraint FKCC42D92493AACD83 foreign key (parent_id) references topics;
alter table user_addresses add constraint FK9188602EA09C615E foreign key (user_data_id) references user_data;
alter table user_addresses add constraint FK9188602ED634EE8A foreign key (addresses_id) references addresses;
alter table user_contactmethods add constraint FKA59F56868708F8A7 foreign key (contactmethods_id) references contactmethods;
alter table user_contactmethods add constraint FKA59F5686A09C615E foreign key (user_data_id) references user_data;
alter table user_contacts add constraint FKE130BA47A09C615E foreign key (user_data_id) references user_data;
alter table user_contacts add constraint FKE130BA475C8835C9 foreign key (user_contact_id) references users;
alter table user_contacts_allowed_contactmethods add constraint FKE8DCB001A785DACC foreign key (user_contactmethod_id) references contactmethods;
alter table user_contacts_allowed_contactmethods add constraint FKE8DCB0015C8835C9 foreign key (user_contact_id) references users;
alter table user_credits add constraint FK983F4C26FBD81D4A foreign key (user_id) references users;
alter table user_data add constraint FK1435639E77FEE755 foreign key (primary_address_id) references addresses;
alter table user_relation_permissions add constraint FKDBE83EB570D24902 foreign key (permission_id) references permissions;
alter table user_relation_permissions add constraint FKDBE83EB51DB40057 foreign key (user_relation_permission_id) references relation_permissions;
alter table user_resources add constraint FKE734A2B1A09C615E foreign key (user_data_id) references user_data;
alter table user_resources add constraint FKE734A2B187A1FB16 foreign key (resources_id) references resources;
alter table user_roles add constraint FK734299495682C574 foreign key (role_id) references roles;
alter table user_roles add constraint FK73429949FBD81D4A foreign key (user_id) references users;
alter table userevents add constraint FK7DB388A4A66D97A5 foreign key (event_id) references events;
alter table userevents add constraint FK7DB388A4FBD81D4A foreign key (user_id) references users;
alter table users add constraint FK6A68E083DCC3A0 foreign key (user_data) references user_data;
alter table zipcodes add constraint FKF88385A5A5FA3D28 foreign key (country_id) references countries;
create sequence hibernate_sequence;