CREATE DATABASE IF NOT EXISTS  datatypes;
USE datatypes;

CREATE TABLE IF NOT EXISTS Data_Types
(
   `ID`               bigint   NOT NULL auto_increment PRIMARY KEY,
   `Date`      		 date NULL,
   `DateTime`       datetime NULL,   
   `Time`       		 time NULL,      
   `Timestamp`      TIMESTAMP NULL,
   
   `Tinyint`       tinyint  NOT NULL default '0',
      
   `SmallInt`      smallint default '',
   `SmallInt_NULL`      smallint NULL,
   `SmallInt_UNSIGNED`      smallint UNSIGNED default '' ,
   `SmallInt_UNSIGNED_NULL`      smallint UNSIGNED NULL,
   
   `MediumInt`     mediumint default '',   
   `MediumInt_NULL`     mediumint NULL,
   `MediumInt_UNSIGNED`     mediumint UNSIGNED  default '',   
   `MediumInt_UNSIGNED_NULL`     mediumint UNSIGNED NULL,  
   
   `Int`     int default '',   
   `Int_NULL`    int NULL,
   `Int_UNSIGNED`   int UNSIGNED  default '',   
   `Int_UNSIGNED_NULL`   int UNSIGNED NULL,  
   
   `BigInt`     bigint default '',   
   `BigInt_NULL`    bigint NULL,
   `BigInt_UNSIGNED`   bigint UNSIGNED  default '',   
   `BigInt_UNSIGNED_NULL`   bigint UNSIGNED NULL,  
   
   `Double`    double default '',   
   `Double_Null`  double NULL,
   `Double_UNSIGNED`  double UNSIGNED  default '',   
   `Double_UNSIGNED_NULL` double UNSIGNED NULL,  
   
   `Float`    Float default '',   
   `Float_Null`  Float NULL,
   `Float_UNSIGNED`  Float UNSIGNED  default '',   
   `Float_UNSIGNED_NULL` Float UNSIGNED NULL,  
   
   `Decimal`    Decimal default '',   
   `Decimal_Null` Decimal NULL,
   `Decimal_UNSIGNED` Decimal UNSIGNED  default '',   
   `Decimal_UNSIGNED_NULL` Decimal UNSIGNED NULL, 
    
   `Enum` Enum('small', 'medium', 'large') NULL Default NULL,
   `Set` Set ('set_small', 'set_medium', 'set_large')


   
)TYPE=MyISAM;