Progetto Farmacia di William Ferrari V D Sql - Alter Table da aggiungere alla fine dello script
-- phpMyAdmin SQL Dump -- version 4.1.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 22, 2017 alle 16:40 -- Versione del server: 5.1.71-community-log -- PHP Version: 5.3.10 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 utf8 */; -- -- Database: `my_ferrariwilliam` -- -- -------------------------------------------------------- -- -- Struttura della tabella `ditta` -- CREATE TABLE IF NOT EXISTS `ditta` ( `IDDitta` varchar(20) NOT NULL, `NomeDitta` varchar(20) DEFAULT NULL, PRIMARY KEY (`IDDitta`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dump dei dati per la tabella `ditta` -- INSERT INTO `ditta` (`IDDitta`, `NomeDitta`) VALUES ('140', 'FOURINIER PHARMA S.P'), ('168...