-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 17-01-2019 a las 10:54:15
-- Versión del servidor: 10.1.26-MariaDB-0+deb9u1
-- Versión de PHP: 7.0.33-0+deb9u1




--
-- Base de datos: `djangox_3`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `account_emailaddress`
--

CREATE TABLE `account_emailaddress` (
  `id` int(11) NOT NULL,
  `email` varchar(190) NOT NULL,
  `verified` tinyint(1) NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `account_emailaddress`
--

INSERT INTO `account_emailaddress` (`id`, `email`, `verified`, `primary`, `user_id`) VALUES
(1, 'emilianopiantino@gmail.com', 0, 1, 2);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL,
  `name` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `auth_permission`
--

INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
(1, 'Can add log entry', 1, 'add_logentry'),
(2, 'Can change log entry', 1, 'change_logentry'),
(3, 'Can delete log entry', 1, 'delete_logentry'),
(4, 'Can view log entry', 1, 'view_logentry'),
(5, 'Can add permission', 2, 'add_permission'),
(6, 'Can change permission', 2, 'change_permission'),
(7, 'Can delete permission', 2, 'delete_permission'),
(8, 'Can view permission', 2, 'view_permission'),
(9, 'Can add group', 3, 'add_group'),
(10, 'Can change group', 3, 'change_group'),
(11, 'Can delete group', 3, 'delete_group'),
(12, 'Can view group', 3, 'view_group'),
(13, 'Can add content type', 4, 'add_contenttype'),
(14, 'Can change content type', 4, 'change_contenttype'),
(15, 'Can delete content type', 4, 'delete_contenttype'),
(16, 'Can view content type', 4, 'view_contenttype'),
(17, 'Can add session', 5, 'add_session'),
(18, 'Can change session', 5, 'change_session'),
(19, 'Can delete session', 5, 'delete_session'),
(20, 'Can view session', 5, 'view_session'),
(21, 'Can add site', 6, 'add_site'),
(22, 'Can change site', 6, 'change_site'),
(23, 'Can delete site', 6, 'delete_site'),
(24, 'Can view site', 6, 'view_site'),
(25, 'Can add email address', 7, 'add_emailaddress'),
(26, 'Can change email address', 7, 'change_emailaddress'),
(27, 'Can delete email address', 7, 'delete_emailaddress'),
(28, 'Can view email address', 7, 'view_emailaddress'),
(29, 'Can add email confirmation', 8, 'add_emailconfirmation'),
(30, 'Can change email confirmation', 8, 'change_emailconfirmation'),
(31, 'Can delete email confirmation', 8, 'delete_emailconfirmation'),
(32, 'Can view email confirmation', 8, 'view_emailconfirmation'),
(33, 'Can add social account', 9, 'add_socialaccount'),
(34, 'Can change social account', 9, 'change_socialaccount'),
(35, 'Can delete social account', 9, 'delete_socialaccount'),
(36, 'Can view social account', 9, 'view_socialaccount'),
(37, 'Can add social application', 10, 'add_socialapp'),
(38, 'Can change social application', 10, 'change_socialapp'),
(39, 'Can delete social application', 10, 'delete_socialapp'),
(40, 'Can view social application', 10, 'view_socialapp'),
(41, 'Can add social application token', 11, 'add_socialtoken'),
(42, 'Can change social application token', 11, 'change_socialtoken'),
(43, 'Can delete social application token', 11, 'delete_socialtoken'),
(44, 'Can view social application token', 11, 'view_socialtoken'),
(45, 'Can add user', 12, 'add_customuser'),
(46, 'Can change user', 12, 'change_customuser'),
(47, 'Can delete user', 12, 'delete_customuser'),
(48, 'Can view user', 12, 'view_customuser'),
(49, 'Can add pago', 13, 'add_pago'),
(50, 'Can change pago', 13, 'change_pago'),
(51, 'Can delete pago', 13, 'delete_pago'),
(52, 'Can view pago', 13, 'view_pago'),
(53, 'Can add profesional', 14, 'add_profesional'),
(54, 'Can change profesional', 14, 'change_profesional'),
(55, 'Can delete profesional', 14, 'delete_profesional'),
(56, 'Can view profesional', 14, 'view_profesional'),
(57, 'Can add alumno', 15, 'add_alumno'),
(58, 'Can change alumno', 15, 'change_alumno'),
(59, 'Can delete alumno', 15, 'delete_alumno'),
(60, 'Can view alumno', 15, 'view_alumno'),
(61, 'Can add curso', 16, 'add_curso'),
(62, 'Can change curso', 16, 'change_curso'),
(63, 'Can delete curso', 16, 'delete_curso'),
(64, 'Can view curso', 16, 'view_curso'),
(65, 'Can add miembro', 17, 'add_miembro'),
(66, 'Can change miembro', 17, 'change_miembro'),
(67, 'Can delete miembro', 17, 'delete_miembro'),
(68, 'Can view miembro', 17, 'view_miembro'),
(69, 'Can add responsable', 18, 'add_responsable'),
(70, 'Can change responsable', 18, 'change_responsable'),
(71, 'Can delete responsable', 18, 'delete_responsable'),
(72, 'Can view responsable', 18, 'view_responsable');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `chequeras_pago`
--

CREATE TABLE `chequeras_pago` (
  `id_pago` int(11) NOT NULL,
  `periodo` varchar(7) NOT NULL,
  `pesos` decimal(8,2) NOT NULL,
  `pesos_char` varchar(45) NOT NULL,
  `vencimiento_1` date NOT NULL,
  `vencimiento_2` date DEFAULT NULL,
  `cod_pago_mc` varchar(12) NOT NULL,
  `cod_link` varchar(20) NOT NULL,
  `tipo_pago` varchar(1) NOT NULL,
  `cod_barras` varchar(45) NOT NULL,
  `usuario_codigo_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `chequeras_profesional`
--

CREATE TABLE `chequeras_profesional` (
  `codigo_id` int(11) NOT NULL,
  `tipo_doc` varchar(3) DEFAULT NULL,
  `nro_doc` varchar(10) DEFAULT NULL,
  `dom_post` varchar(30) DEFAULT NULL,
  `localidad_post` varchar(30) DEFAULT NULL,
  `cp_post` varchar(10) NOT NULL,
  `matricula` varchar(10) DEFAULT NULL,
  `activo_col` tinyint(1) NOT NULL,
  `activo_seg` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `diplomas_alumno`
--

CREATE TABLE `diplomas_alumno` (
  `id_alumno_id` int(11) NOT NULL,
  `nro_doc` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `diplomas_alumno`
--

INSERT INTO `diplomas_alumno` (`id_alumno_id`, `nro_doc`) VALUES
(2, '37.283.142');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `diplomas_curso`
--

CREATE TABLE `diplomas_curso` (
  `id_curso` int(11) NOT NULL,
  `nombre` varchar(200) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `leyenda_1` varchar(200) DEFAULT NULL,
  `leyenda_2` varchar(200) DEFAULT NULL,
  `leyenda_3` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `diplomas_curso`
--

INSERT INTO `diplomas_curso` (`id_curso`, `nombre`, `anio`, `leyenda_1`, `leyenda_2`, `leyenda_3`) VALUES
(1, 'CURSO DE ACTUALIZACIÓN Y CAPACITACIÓN EN URGENCIAS MÉDICAS', 2018, 'ha participado en caráter de', 'Con 110 (ciento diez) hs. de carga horaria teórica y practica. Evaluación final aprobada.', 'Santa Fe, diciembre de 2018');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `diplomas_miembro`
--

CREATE TABLE `diplomas_miembro` (
  `id` int(11) NOT NULL,
  `date_joined` date NOT NULL,
  `invite_reason` varchar(64) NOT NULL,
  `alumno_id` int(11) NOT NULL,
  `curso_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `diplomas_miembro`
--

INSERT INTO `diplomas_miembro` (`id`, `date_joined`, `invite_reason`, `alumno_id`, `curso_id`) VALUES
(1, '2019-01-16', 'Inscripto', 2, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `diplomas_responsable`
--

CREATE TABLE `diplomas_responsable` (
  `id` int(11) NOT NULL,
  `apellido` varchar(45) NOT NULL,
  `nombre` varchar(45) NOT NULL,
  `nro_doc` varchar(10) NOT NULL,
  `imagen_firma` varchar(100) DEFAULT NULL,
  `cargo` varchar(45) DEFAULT NULL,
  `cargo_2` varchar(45) DEFAULT NULL,
  `cargo_3` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `diplomas_responsable`
--

INSERT INTO `diplomas_responsable` (`id`, `apellido`, `nombre`, `nro_doc`, `imagen_firma`, `cargo`, `cargo_2`, `cargo_3`) VALUES
(1, 'Alico', 'Carlos', '10.863.122', 'static/firmas/firma_alico_usada.png', 'Dr.', 'Presidente Colegio de Médicos', '-1era Circunscripción'),
(2, 'Bedini', 'Julio Cesar', '11.043.556', 'static/firmas/firma_bedini_usada.png', 'Dr.', 'Secretario Colegio de Médicos', '-1era Circunscripción');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `diplomas_responsable_cursos`
--

CREATE TABLE `diplomas_responsable_cursos` (
  `id` int(11) NOT NULL,
  `responsable_id` int(11) NOT NULL,
  `curso_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `diplomas_responsable_cursos`
--

INSERT INTO `diplomas_responsable_cursos` (`id`, `responsable_id`, `curso_id`) VALUES
(1, 1, 1),
(2, 2, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) UNSIGNED NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `django_admin_log`
--

INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES
(1, '2019-01-16 12:11:59.919703', '2', '', 1, '[{\"added\": {}}]', 12, 1),
(2, '2019-01-16 12:12:22.434391', '2', 'emilianopiantino@gmail.com', 2, '[{\"changed\": {\"fields\": [\"first_name\", \"last_name\", \"email\"]}}]', 12, 1),
(3, '2019-01-16 12:13:03.556922', '1', 'emilianopiantino@gmail.com (emilianopiantino@gmail.com)', 1, '[{\"added\": {}}]', 7, 1),
(4, '2019-01-16 12:19:28.511314', '1', 'CURSO DE ACTUALIZACIÓN Y CAPACITACIÓN EN URGENCIAS MÉDICAS', 1, '[{\"added\": {}}]', 16, 1),
(5, '2019-01-16 12:20:00.370133', '2', '37283142', 1, '[{\"added\": {}}]', 15, 1),
(6, '2019-01-16 12:20:45.763069', '1', 'Miembro object (1)', 1, '[{\"added\": {}}]', 17, 1),
(7, '2019-01-16 17:30:42.998475', '2', 'Piantino Emiliano Juan Antonio', 2, '[{\"changed\": {\"fields\": [\"first_name\"]}}]', 12, 1),
(8, '2019-01-17 12:50:47.488181', '1', 'Responsable object (1)', 1, '[{\"added\": {}}]', 18, 1),
(9, '2019-01-17 12:52:51.821963', '2', 'Responsable object (2)', 1, '[{\"added\": {}}]', 18, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `django_content_type`
--

INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES
(7, 'account', 'emailaddress'),
(8, 'account', 'emailconfirmation'),
(1, 'admin', 'logentry'),
(3, 'auth', 'group'),
(2, 'auth', 'permission'),
(13, 'chequeras', 'pago'),
(14, 'chequeras', 'profesional'),
(4, 'contenttypes', 'contenttype'),
(15, 'diplomas', 'alumno'),
(16, 'diplomas', 'curso'),
(17, 'diplomas', 'miembro'),
(18, 'diplomas', 'responsable'),
(5, 'sessions', 'session'),
(6, 'sites', 'site'),
(9, 'socialaccount', 'socialaccount'),
(10, 'socialaccount', 'socialapp'),
(11, 'socialaccount', 'socialtoken'),
(12, 'users', 'customuser');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `django_migrations`
--

INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES
(1, 'contenttypes', '0001_initial', '2019-01-16 12:01:10.757541'),
(2, 'contenttypes', '0002_remove_content_type_name', '2019-01-16 12:01:11.393127'),
(3, 'auth', '0001_initial', '2019-01-16 12:01:13.945005'),
(4, 'auth', '0002_alter_permission_name_max_length', '2019-01-16 12:01:14.496440'),
(5, 'auth', '0003_alter_user_email_max_length', '2019-01-16 12:01:14.527674'),
(6, 'auth', '0004_alter_user_username_opts', '2019-01-16 12:01:14.567549'),
(7, 'auth', '0005_alter_user_last_login_null', '2019-01-16 12:01:14.602101'),
(8, 'auth', '0006_require_contenttypes_0002', '2019-01-16 12:01:14.631365'),
(9, 'auth', '0007_alter_validators_add_error_messages', '2019-01-16 12:01:14.669203'),
(10, 'auth', '0008_alter_user_username_max_length', '2019-01-16 12:01:14.710384'),
(11, 'auth', '0009_alter_user_last_name_max_length', '2019-01-16 12:01:14.751750'),
(12, 'users', '0001_initial', '2019-01-16 12:01:17.802020'),
(13, 'account', '0001_initial', '2019-01-16 12:01:19.306930'),
(14, 'account', '0002_email_max_length', '2019-01-16 12:01:19.884943'),
(15, 'admin', '0001_initial', '2019-01-16 12:01:21.256080'),
(16, 'admin', '0002_logentry_remove_auto_add', '2019-01-16 12:01:21.289818'),
(17, 'admin', '0003_logentry_add_action_flag_choices', '2019-01-16 12:01:21.336559'),
(18, 'chequeras', '0001_initial', '2019-01-16 12:01:23.137901'),
(19, 'diplomas', '0001_initial', '2019-01-16 12:01:26.911102'),
(20, 'sessions', '0001_initial', '2019-01-16 12:01:27.330510'),
(21, 'sites', '0001_initial', '2019-01-16 12:01:27.581495'),
(22, 'sites', '0002_alter_domain_unique', '2019-01-16 12:01:27.740244'),
(23, 'socialaccount', '0001_initial', '2019-01-16 12:01:32.013080'),
(24, 'socialaccount', '0002_token_max_lengths', '2019-01-16 12:01:33.444761'),
(25, 'socialaccount', '0003_extra_data_default_dict', '2019-01-16 12:01:33.490640'),
(26, 'diplomas', '0002_responsable_cargo_3', '2019-01-17 12:48:13.191553');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `django_site`
--

CREATE TABLE `django_site` (
  `id` int(11) NOT NULL,
  `domain` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `django_site`
--

INSERT INTO `django_site` (`id`, `domain`, `name`) VALUES
(1, 'example.com', 'example.com');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `socialaccount_socialaccount`
--

CREATE TABLE `socialaccount_socialaccount` (
  `id` int(11) NOT NULL,
  `provider` varchar(30) NOT NULL,
  `uid` varchar(191) NOT NULL,
  `last_login` datetime(6) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `extra_data` longtext NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `socialaccount_socialapp_sites`
--

CREATE TABLE `socialaccount_socialapp_sites` (
  `id` int(11) NOT NULL,
  `socialapp_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_customuser_groups`
--

CREATE TABLE `users_customuser_groups` (
  `id` int(11) NOT NULL,
  `customuser_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_customuser_user_permissions`
--

CREATE TABLE `users_customuser_user_permissions` (
  `id` int(11) NOT NULL,
  `customuser_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `account_emailaddress`
--
ALTER TABLE `account_emailaddress`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `account_emailaddress_user_id_2c513194_fk_users_customuser_id` (`user_id`);

--
-- Indices de la tabla `auth_group`
--
ALTER TABLE `auth_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indices de la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  ADD KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`);

--
-- Indices de la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`);

--
-- Indices de la tabla `chequeras_pago`
--
ALTER TABLE `chequeras_pago`
  ADD PRIMARY KEY (`id_pago`),
  ADD KEY `chequeras_pago_usuario_codigo_id_971b70bb_fk_chequeras` (`usuario_codigo_id`);

--
-- Indices de la tabla `chequeras_profesional`
--
ALTER TABLE `chequeras_profesional`
  ADD PRIMARY KEY (`codigo_id`);

--
-- Indices de la tabla `diplomas_alumno`
--
ALTER TABLE `diplomas_alumno`
  ADD PRIMARY KEY (`id_alumno_id`);

--
-- Indices de la tabla `diplomas_curso`
--
ALTER TABLE `diplomas_curso`
  ADD PRIMARY KEY (`id_curso`);

--
-- Indices de la tabla `diplomas_miembro`
--
ALTER TABLE `diplomas_miembro`
  ADD PRIMARY KEY (`id`),
  ADD KEY `diplomas_miembro_alumno_id_3535743a_fk_diplomas_` (`alumno_id`),
  ADD KEY `diplomas_miembro_curso_id_f43200e4_fk_diplomas_curso_id_curso` (`curso_id`);

--
-- Indices de la tabla `diplomas_responsable`
--
ALTER TABLE `diplomas_responsable`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `diplomas_responsable_cursos`
--
ALTER TABLE `diplomas_responsable_cursos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `diplomas_responsable_cur_responsable_id_curso_id_7908e868_uniq` (`responsable_id`,`curso_id`),
  ADD KEY `diplomas_responsable_curso_id_71d4441c_fk_diplomas_` (`curso_id`);

--
-- Indices de la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  ADD KEY `django_admin_log_user_id_c564eba6_fk_users_customuser_id` (`user_id`);

--
-- Indices de la tabla `django_content_type`
--
ALTER TABLE `django_content_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`);

--
-- Indices de la tabla `django_migrations`
--
ALTER TABLE `django_migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `django_site`
--
ALTER TABLE `django_site`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `django_site_domain_a2e37b91_uniq` (`domain`);

--
-- Indices de la tabla `socialaccount_socialaccount`
--
ALTER TABLE `socialaccount_socialaccount`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `socialaccount_socialaccount_provider_uid_fc810c6e_uniq` (`provider`,`uid`),
  ADD KEY `socialaccount_social_user_id_8146e70c_fk_users_cus` (`user_id`);

--
-- Indices de la tabla `socialaccount_socialapp_sites`
--
ALTER TABLE `socialaccount_socialapp_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `socialaccount_socialapp_sites_socialapp_id_site_id_71a9a768_uniq` (`socialapp_id`,`site_id`),
  ADD KEY `socialaccount_socialapp_sites_site_id_2579dee5_fk_django_site_id` (`site_id`);

--
-- Indices de la tabla `users_customuser_groups`
--
ALTER TABLE `users_customuser_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_customuser_groups_customuser_id_group_id_76b619e3_uniq` (`customuser_id`,`group_id`),
  ADD KEY `users_customuser_groups_group_id_01390b14_fk_auth_group_id` (`group_id`);

--
-- Indices de la tabla `users_customuser_user_permissions`
--
ALTER TABLE `users_customuser_user_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_customuser_user_pe_customuser_id_permission_7a7debf6_uniq` (`customuser_id`,`permission_id`),
  ADD KEY `users_customuser_use_permission_id_baaa2f74_fk_auth_perm` (`permission_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `account_emailaddress`
--
ALTER TABLE `account_emailaddress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `auth_group`
--
ALTER TABLE `auth_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- AUTO_INCREMENT de la tabla `diplomas_miembro`
--
ALTER TABLE `diplomas_miembro`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `diplomas_responsable`
--
ALTER TABLE `diplomas_responsable`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `diplomas_responsable_cursos`
--
ALTER TABLE `diplomas_responsable_cursos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT de la tabla `django_content_type`
--
ALTER TABLE `django_content_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT de la tabla `django_migrations`
--
ALTER TABLE `django_migrations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT de la tabla `django_site`
--
ALTER TABLE `django_site`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `socialaccount_socialaccount`
--
ALTER TABLE `socialaccount_socialaccount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `socialaccount_socialapp_sites`
--
ALTER TABLE `socialaccount_socialapp_sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `users_customuser_groups`
--
ALTER TABLE `users_customuser_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `users_customuser_user_permissions`
--
ALTER TABLE `users_customuser_user_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `account_emailaddress`
--
ALTER TABLE `account_emailaddress`
  ADD CONSTRAINT `account_emailaddress_user_id_2c513194_fk_users_customuser_id` FOREIGN KEY (`user_id`) REFERENCES `users_customuser` (`id`);

--
-- Filtros para la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);

--
-- Filtros para la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);

--
-- Filtros para la tabla `chequeras_pago`
--
ALTER TABLE `chequeras_pago`
  ADD CONSTRAINT `chequeras_pago_usuario_codigo_id_971b70bb_fk_chequeras` FOREIGN KEY (`usuario_codigo_id`) REFERENCES `chequeras_profesional` (`codigo_id`);

--
-- Filtros para la tabla `chequeras_profesional`
--
ALTER TABLE `chequeras_profesional`
  ADD CONSTRAINT `chequeras_profesional_codigo_id_9ffe248e_fk_users_customuser_id` FOREIGN KEY (`codigo_id`) REFERENCES `users_customuser` (`id`);

--
-- Filtros para la tabla `diplomas_alumno`
--
ALTER TABLE `diplomas_alumno`
  ADD CONSTRAINT `diplomas_alumno_id_alumno_id_2d9878df_fk_users_customuser_id` FOREIGN KEY (`id_alumno_id`) REFERENCES `users_customuser` (`id`);

--
-- Filtros para la tabla `diplomas_miembro`
--
ALTER TABLE `diplomas_miembro`
  ADD CONSTRAINT `diplomas_miembro_alumno_id_3535743a_fk_diplomas_` FOREIGN KEY (`alumno_id`) REFERENCES `diplomas_alumno` (`id_alumno_id`),
  ADD CONSTRAINT `diplomas_miembro_curso_id_f43200e4_fk_diplomas_curso_id_curso` FOREIGN KEY (`curso_id`) REFERENCES `diplomas_curso` (`id_curso`);

--
-- Filtros para la tabla `diplomas_responsable_cursos`
--
ALTER TABLE `diplomas_responsable_cursos`
  ADD CONSTRAINT `diplomas_responsable_curso_id_71d4441c_fk_diplomas_` FOREIGN KEY (`curso_id`) REFERENCES `diplomas_curso` (`id_curso`),
  ADD CONSTRAINT `diplomas_responsable_responsable_id_058a45bf_fk_diplomas_` FOREIGN KEY (`responsable_id`) REFERENCES `diplomas_responsable` (`id`);

--
-- Filtros para la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_users_customuser_id` FOREIGN KEY (`user_id`) REFERENCES `users_customuser` (`id`);

--
-- Filtros para la tabla `socialaccount_socialaccount`
--
ALTER TABLE `socialaccount_socialaccount`
  ADD CONSTRAINT `socialaccount_social_user_id_8146e70c_fk_users_cus` FOREIGN KEY (`user_id`) REFERENCES `users_customuser` (`id`);

--
-- Filtros para la tabla `socialaccount_socialapp_sites`
--
ALTER TABLE `socialaccount_socialapp_sites`
  ADD CONSTRAINT `socialaccount_social_socialapp_id_97fb6e7d_fk_socialacc` FOREIGN KEY (`socialapp_id`) REFERENCES `socialaccount_socialapp` (`id`),
  ADD CONSTRAINT `socialaccount_socialapp_sites_site_id_2579dee5_fk_django_site_id` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`);

--
-- Filtros para la tabla `users_customuser_groups`
--
ALTER TABLE `users_customuser_groups`
  ADD CONSTRAINT `users_customuser_gro_customuser_id_958147bf_fk_users_cus` FOREIGN KEY (`customuser_id`) REFERENCES `users_customuser` (`id`),
  ADD CONSTRAINT `users_customuser_groups_group_id_01390b14_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);

--
-- Filtros para la tabla `users_customuser_user_permissions`
--
ALTER TABLE `users_customuser_user_permissions`
  ADD CONSTRAINT `users_customuser_use_customuser_id_5771478b_fk_users_cus` FOREIGN KEY (`customuser_id`) REFERENCES `users_customuser` (`id`),
  ADD CONSTRAINT `users_customuser_use_permission_id_baaa2f74_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);

