68 lines
1.5 KiB
SQL
68 lines
1.5 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 4.6.5.2
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost
|
|
-- Creato il: Mag 25, 2017 alle 08:47
|
|
-- Versione del server: 10.1.22-MariaDB
|
|
-- Versione PHP: 7.1.5
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
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: `sondaggio`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struttura della tabella `abbonati`
|
|
--
|
|
|
|
CREATE TABLE `abbonati` (
|
|
`Codice` int(5) NOT NULL,
|
|
`voto` int(1) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Dump dei dati per la tabella `abbonati`
|
|
--
|
|
|
|
INSERT INTO `abbonati` (`Codice`, `voto`) VALUES
|
|
(100, 1),
|
|
(200, 0),
|
|
(300, 0),
|
|
(400, 0);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struttura della tabella `riviste`
|
|
--
|
|
|
|
CREATE TABLE `riviste` (
|
|
`nome` varchar(50) NOT NULL,
|
|
`preferenze` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Dump dei dati per la tabella `riviste`
|
|
--
|
|
|
|
INSERT INTO `riviste` (`nome`, `preferenze`) VALUES
|
|
('Altroconsumo', 1),
|
|
('Quattroruote', 0),
|
|
('Topolino', 0),
|
|
('Marrazzo', 0);
|
|
|
|
/*!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 */;
|