# SQL Manager 2005 Lite for MySQL 3.7.7.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : demo


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `demo`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `demo`;

#
# Structure for the `customer` table : 
#

CREATE TABLE `customer` (
  `custid` varchar(45) NOT NULL default '',
  `custname` varchar(45) default NULL,
  `custcountry` varchar(45) default NULL,
  `productsold` varchar(10) default NULL,
  `saleschannel` varchar(10) default NULL,
  `unitsold` varchar(45) default NULL,
  `datesold` varchar(45) default NULL,
  `city` varchar(20) default NULL,
  PRIMARY KEY  (`custid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

