creacion y permiso de base de datos del proyecto

Prévia do material em texto

-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: project
CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: project
CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: project
CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: project
-CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: project
CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: project
CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);
-- Name: usuario_email_de9343f9_like; Type: INDEX; Schema: public; Owner: project
CREATE INDEX usuario_email_de9343f9_like ON public.usuario USING btree (email varchar_pattern_ops);
-- Name: usuario_groups_group_id_c67c8651; Type: INDEX; Schema: public; Owner: project
CREATE INDEX usuario_groups_group_id_c67c8651 ON public.usuario_groups USING btree (group_id);
-- Name: usuario_groups_usuario_id_161fc80c; Type: INDEX; Schema: public; Owner: project
CREATE INDEX usuario_groups_usuario_id_161fc80c ON public.usuario_groups USING btree (usuario_id);
-- Name: usuario_user_permissions_permission_id_a8893ce7; Type: INDEX; Schema: public; Owner: project
CREATE INDEX usuario_user_permissions_permission_id_a8893ce7 ON public.usuario_user_permissions USING btree (permission_id);
-- Name: usuario_user_permissions_usuario_id_693d9c50; Type: INDEX; Schema: public; Owner: project
CREATE INDEX usuario_user_permissions_usuario_id_693d9c50 ON public.usuario_user_permissions USING btree (usuario_id);
-- Name: visitante_registrado_por_id_5c877d1a; Type: INDEX; Schema: public; Owner: project
CREATE INDEX visitante_registrado_por_id_5c877d1a ON public.visitante USING btree (registrado_por_id);
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.auth_group_permissions
 ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.auth_group_permissions
 ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.auth_permission
 ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.django_admin_log
 ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_usuario_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.django_admin_log
 ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_usuario_id FOREIGN KEY (user_id) REFERENCES public.usuario(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: portero portero_usuario_id_20cb4801_fk_usuario_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.portero
 ADD CONSTRAINT portero_usuario_id_20cb4801_fk_usuario_id FOREIGN KEY (usuario_id) REFERENCES public.usuario(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: usuario_groups usuario_groups_group_id_c67c8651_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.usuario_groups
 ADD CONSTRAINT usuario_groups_group_id_c67c8651_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: usuario_groups usuario_groups_usuario_id_161fc80c_fk_usuario_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.usuario_groups
 ADD CONSTRAINT usuario_groups_usuario_id_161fc80c_fk_usuario_id FOREIGN KEY (usuario_id) REFERENCES public.usuario(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: usuario_user_permissions usuario_user_permiss_permission_id_a8893ce7_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.usuario_user_permissions
 ADD CONSTRAINT usuario_user_permiss_permission_id_a8893ce7_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: usuario_user_permissions usuario_user_permissions_usuario_id_693d9c50_fk_usuario_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.usuario_user_permissions
 ADD CONSTRAINT usuario_user_permissions_usuario_id_693d9c50_fk_usuario_id FOREIGN KEY (usuario_id) REFERENCES public.usuario(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: visitante visitante_registrado_por_id_5c877d1a_fk_portero_id; Type: FK CONSTRAINT; Schema: public; Owner: project
ALTER TABLE ONLY public.visitante
 ADD CONSTRAINT visitante_registrado_por_id_5c877d1a_fk_portero_id FOREIGN KEY (registrado_por_id) REFERENCES public.portero(id) DEFERRABLE INITIALLY DEFERRED;
-- Name: TABLE usuario_groups; Type: ACL; Schema: public; Owner: project
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.usuario_groups TO postgres;
-- PostgreSQL database dump complete
--
SELECT *
FROM usuario
JOIN Portero ON usuario.id = portero.id
JOIN visitante ON portero.id = visitante.id;