· 9 years ago · Dec 16, 2016, 11:56 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Nov 21, 2016 alle 12:25
7-- Versione del server: 5.6.20
8-- PHP Version: 5.5.15
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `mydb`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struttura della tabella `responsabili`
27--
28
29CREATE TABLE IF NOT EXISTS `responsabili` (
30`CodResp` int(11) NOT NULL,
31 `Cognome` varchar(40) NOT NULL,
32 `Nome` varchar(40) NOT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
34
35--
36-- Dump dei dati per la tabella `responsabili`
37--
38
39INSERT INTO `responsabili` (`CodResp`, `Cognome`, `Nome`) VALUES
40(1, 'Lerda', 'Ivo'),
41(2, 'Fassa', 'Maria'),
42(3, 'Dutto', 'Luca');
43
44-- --------------------------------------------------------
45
46--
47-- Struttura della tabella `sedea`
48--
49
50CREATE TABLE IF NOT EXISTS `sedea` (
51 `CodOperaio` varchar(5) NOT NULL,
52 `Sesso` varchar(1) NOT NULL,
53 `AssuntoIl` date NOT NULL,
54 `Stipendio` double NOT NULL,
55 `CodR` int(11) NOT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58--
59-- Dump dei dati per la tabella `sedea`
60--
61
62INSERT INTO `sedea` (`CodOperaio`, `Sesso`, `AssuntoIl`, `Stipendio`, `CodR`) VALUES
63('GVDT', 'F', '1999-04-14', 990, 2),
64('MLRB', 'F', '2000-07-05', 980.54, 1),
65('PLAN', 'M', '2001-06-04', 951.78, 2),
66('PLFR', 'F', '2001-05-05', 933.04, 1),
67('UGUG', 'M', '1999-04-03', 980.54, 1),
68('VDLC', 'M', '2000-07-06', 980, 1);
69
70-- --------------------------------------------------------
71
72--
73-- Struttura della tabella `sedeb`
74--
75
76CREATE TABLE IF NOT EXISTS `sedeb` (
77 `CodOperaio` varchar(5) NOT NULL,
78 `Sesso` varchar(1) NOT NULL,
79 `AssuntoIl` date NOT NULL,
80 `Stipendio` double NOT NULL,
81 `CodR` int(11) NOT NULL
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83
84--
85-- Dump dei dati per la tabella `sedeb`
86--
87
88INSERT INTO `sedeb` (`CodOperaio`, `Sesso`, `AssuntoIl`, `Stipendio`, `CodR`) VALUES
89('BCVL', 'M', '2000-05-23', 972.58, 3),
90('DTGM', 'F', '2001-10-15', 972.58, 3),
91('GVDT', 'F', '1999-04-14', 990, 2),
92('MLRB', 'F', '2000-07-05', 980.54, 1),
93('RSMR', 'F', '2001-05-23', 880.78, 2),
94('VDLC', 'M', '2000-07-06', 980, 1);
95
96--
97-- Indexes for dumped tables
98--
99
100--
101-- Indexes for table `responsabili`
102--
103ALTER TABLE `responsabili`
104 ADD PRIMARY KEY (`CodResp`);
105
106--
107-- Indexes for table `sedea`
108--
109ALTER TABLE `sedea`
110 ADD PRIMARY KEY (`CodOperaio`), ADD KEY `FK_SedeA_Responsabili_idx` (`CodR`);
111
112--
113-- Indexes for table `sedeb`
114--
115ALTER TABLE `sedeb`
116 ADD PRIMARY KEY (`CodOperaio`), ADD KEY `FK_SedeB_Responsabili_idx` (`CodR`);
117
118--
119-- AUTO_INCREMENT for dumped tables
120--
121
122--
123-- AUTO_INCREMENT for table `responsabili`
124--
125ALTER TABLE `responsabili`
126MODIFY `CodResp` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
127--
128-- Limiti per le tabelle scaricate
129--
130
131--
132-- Limiti per la tabella `sedea`
133--
134ALTER TABLE `sedea`
135ADD CONSTRAINT `FK_SedeA_Responsabili` FOREIGN KEY (`CodR`) REFERENCES `responsabili` (`CodResp`) ON UPDATE NO ACTION;
136
137--
138-- Limiti per la tabella `sedeb`
139--
140ALTER TABLE `sedeb`
141ADD CONSTRAINT `FK_SedeB_Responsabili` FOREIGN KEY (`CodR`) REFERENCES `responsabili` (`CodResp`) ON UPDATE NO ACTION;
142
143/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
144/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
145/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;