film_actor-03-11

-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Creato il: Nov 03, 2019 alle 22:41
-- Versione del server: 10.4.8-MariaDB
-- Versione PHP: 7.3.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `chiabre`
--

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

--
-- Struttura della tabella `film_actor`
--

CREATE TABLE `film_actor` (
  `actor_id` smallint(5) UNSIGNED NOT NULL,
  `film_id` smallint(5) UNSIGNED NOT NULL,
  `role` varchar(50) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `film_actor`
--

INSERT INTO `film_actor` (`actor_id`, `film_id`, `role`, `last_update`) VALUES
(1, 2, 'Regan MacNeil', '2019-10-30 04:39:02'),
(1, 5, 'Regan MacNeil', '2019-10-30 05:27:00'),
(2, 2, 'Chris MacNeil', '2019-10-30 04:39:47'),
(3, 2, 'Father Lankester Merrin', '2019-10-30 04:42:02'),
(3, 4, 'Josiah Kane', '2019-10-30 07:10:38'),
(3, 5, 'Father Lankester Merrin', '2019-10-30 05:27:15'),
(4, 2, 'Father/Dr. Damien Karras, S.J.', '2019-10-30 04:41:20'),
(5, 2, 'Father Joseph Dyer', '2019-10-30 04:43:08'),
(6, 2, 'Lieutenant William F. Kinderman', '2019-10-30 04:43:53'),
(7, 2, 'The face of the demon Papuzu', '2019-10-30 04:45:30'),
(8, 2, 'The voice of the demon Papuzu', '2019-10-30 04:46:16'),
(9, 2, 'Papuzu', '2019-10-30 04:54:22'),
(10, 1, 'Bruce Wayne / Batman', '2019-10-30 06:43:06'),
(11, 1, 'Jack Napier / the Joker', '2019-10-30 06:42:04'),
(12, 1, 'Vicki Vale', '2019-10-30 06:42:29'),
(13, 1, 'Alexander Knox', '2019-10-30 06:43:32'),
(14, 1, 'Harvey Dent', '2019-10-30 06:43:56'),
(15, 1, 'Alfred', '2019-10-30 06:44:21'),
(16, 1, 'Carl Grissom', '2019-10-30 06:44:49'),
(17, 1, 'Commissioner Gordon', '2019-10-30 06:45:19'),
(18, 1, 'Alicia', '2019-10-30 06:45:39'),
(19, 1, 'Mayor Borg', '2019-10-30 06:46:04'),
(20, 3, 'Rick Deckard', '2019-10-30 06:56:26'),
(21, 3, 'Roy Batty', '2019-10-30 06:56:47'),
(22, 3, 'Rachel', '2019-10-30 06:57:01'),
(23, 3, 'Pris', '2019-10-30 06:57:16'),
(24, 3, 'Zhora Salome', '2019-10-30 06:57:39'),
(25, 3, 'Gaff', '2019-10-30 06:57:55'),
(26, 3, 'Eldon Tyrell', '2019-10-30 06:58:38'),
(27, 3, 'J,F, Sebastian', '2019-10-30 06:59:04'),
(28, 3, 'Dave Holden', '2019-10-30 06:59:30'),
(29, 3, 'Leon Kowalski', '2019-10-30 07:00:04'),
(30, 4, 'Solomon Kane', '2019-10-30 07:04:48'),
(31, 4, 'Meredith Crowthorn', '2019-10-30 07:05:40'),
(32, 4, 'Father Michael', '2019-10-30 07:06:18'),
(33, 4, 'William Crowthorn', '2019-10-30 07:06:46'),
(34, 4, 'the Devil Reaper', '2019-10-30 07:07:57'),
(35, 4, 'Katherine Crowthorn', '2019-10-30 07:08:28'),
(36, 4, 'Malachi', '2019-10-30 07:08:56'),
(37, 4, 'Marcus Kane', '2019-10-30 07:09:16'),
(38, 4, 'Henry Telford', '2019-10-30 07:09:48'),
(41, 5, 'Father Philip Lamont', '2019-10-30 05:28:21'),
(42, 5, 'Dr. Gene Tuskin', '2019-10-30 05:28:56'),
(43, 2, 'Sharon Spencer', '2019-10-30 04:55:12'),
(43, 5, 'Sharon Spencer', '2019-10-30 05:29:20'),
(44, 5, 'The Cardinal', '2019-10-30 05:29:46'),
(45, 5, 'Sandra Phalor', '2019-10-30 05:30:22'),
(46, 5, 'Edwards', '2019-10-30 05:31:24'),
(47, 5, 'Kokumo', '2019-10-30 05:30:59'),
(48, 5, 'Liz', '2019-10-30 05:31:42'),
(49, 2, 'Burke Dennings', '2019-10-30 04:55:49'),
(50, 2, 'Tom, President Georgetown University', '2019-10-30 04:56:45'),
(51, 2, 'Dr. Barringer', '2019-10-30 04:57:16'),
(52, 2, 'Dr.Taney', '2019-10-30 04:57:42'),
(53, 2, 'Dr.Samuel Klein', '2019-10-30 04:58:07'),
(54, 2, 'Karl, house servant', '2019-10-30 04:58:46'),
(55, 2, 'The psycanalist', '2019-10-30 04:59:22'),
(56, 5, 'Mrs. Phalor', '2019-10-30 05:33:04'),
(57, 5, 'Abbot', '2019-10-30 05:33:04'),
(58, 5, 'The voice of the demon Papuzu', '2019-10-30 05:33:32'),
(59, 1, 'Bob the Goon', '2019-10-30 06:46:53'),
(60, 1, 'Lt. Eckhardt', '2019-10-30 06:48:02'),
(61, 1, 'Ricorso', '2019-10-30 06:48:02'),
(62, 1, 'Nic', '2019-10-30 06:49:17'),
(63, 1, 'Becky', '2019-10-30 06:49:17'),
(64, 1, 'Young Jack Napier', '2019-10-30 06:50:22'),
(65, 1, 'Young Bruce Wayne', '2019-10-30 06:50:22'),
(66, 1, 'Thomas Wayne', '2019-10-30 06:51:11'),
(67, 1, 'Martha Wayne', '2019-10-30 06:51:11');

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `film_actor`
--
ALTER TABLE `film_actor`
  ADD PRIMARY KEY (`actor_id`,`film_id`),
  ADD KEY `idx_fk_film_id` (`film_id`);

--
-- Limiti per le tabelle scaricate
--

--
-- Limiti per la tabella `film_actor`
--
ALTER TABLE `film_actor`
  ADD CONSTRAINT `fk_film_actor_actor` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_film_actor_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;