Characters dump file

characters

-- phpMyAdmin SQL Dump
-- version 4.6.5.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Creato il: Feb 12, 2020 alle 12:07
-- Versione del server: 5.6.34
-- Versione PHP: 7.1.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `characters`
--

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

--
-- Struttura della tabella `charachter`
--

CREATE TABLE `charachter` (
  `id` int(11) NOT NULL,
  `name` varchar(15) NOT NULL,
  `surname` varchar(15) NOT NULL,
  `age` int(11) NOT NULL,
  `status` enum('MARRIED','SINGLE','WIDOWER','') NOT NULL,
  `gender` enum('MALE','FEMALE','','') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `charachter`
--
ALTER TABLE `charachter`
  ADD PRIMARY KEY (`id`);