· 8 years ago · Dec 15, 2017, 08:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.4
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dic 15, 2017 alle 09:23
7-- Versione del server: 5.6.15-log
8-- PHP Version: 5.4.24
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: `iscrizioni_ecdl`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struttura della tabella `candidato`
27--
28
29CREATE TABLE IF NOT EXISTS `candidato` (
30 `NomeC` varchar(15) NOT NULL,
31 `CognomeC` varchar(15) NOT NULL,
32 `CodFisc` varchar(16) NOT NULL,
33 `LuogoN` varchar(15) NOT NULL,
34 `DataN` date NOT NULL,
35 `IdCandidato` int(11) NOT NULL AUTO_INCREMENT,
36 PRIMARY KEY (`IdCandidato`),
37 FULLTEXT KEY `NomeC` (`NomeC`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
39
40-- --------------------------------------------------------
41
42--
43-- Struttura della tabella `esaminatore`
44--
45
46CREATE TABLE IF NOT EXISTS `esaminatore` (
47 `NomeE` varchar(15) NOT NULL,
48 `CognomeE` varchar(15) NOT NULL,
49 `DataNes` date NOT NULL,
50 `CodFiscE` varchar(16) NOT NULL,
51 `IdEsaminatore` int(11) NOT NULL AUTO_INCREMENT,
52 PRIMARY KEY (`IdEsaminatore`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
54
55-- --------------------------------------------------------
56
57--
58-- Struttura della tabella `sessione`
59--
60
61CREATE TABLE IF NOT EXISTS `sessione` (
62 `Data` date NOT NULL,
63 `Ora iniz` time NOT NULL,
64 `Ora fine` time NOT NULL,
65 `CodS` int(11) NOT NULL AUTO_INCREMENT,
66 PRIMARY KEY (`CodS`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
68
69/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
70/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
71/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;