

CREATE DATABASE IF NOT EXISTS Verizon;
USE Verizon;


CREATE TABLE ChangeRequest (
   Title                   varchar(256)     default  null
   AAB_Ticket              varchar(32)     default  null
   VzB_IMAC                varchar(32)     default  null
   RequestorName           varchar(64)     default  null
   RequestorEmail          varchar(32)     default  null
   RequestorPhone          varchar(20)     default  null
   RequestorMobile         varchar(20)     default  null
   SubmitterName           varchar(64)     default  null
   SubmitterEmail          varchar(32)     default  null
   SubmitterPhone          varchar(20)     default  null
   SubmitterMobile         varchar(20)     default  null
   SubmitterHDTicketNo     varchar(32)     default  null
   
   DesiredChangeDate       date
   Region                  varchar(32)     default  null
   SubmitDate              date
   ChangeDescription       text            default  null
   EquipmentDescription    text            default  null
   
   Site1_AAB_TNS_SiteCode  varchar(32)     default  null
   Site1_Country           varchar(32)     default  null
   Site1_ContactPerson     varchar(64)     default  null
   Site1_ContactEmail      varchar(32)     default  null
   S1te1_ContactPhone      varchar(20)     default  null
   S1te1_ContactMobile     varchar(20)     default  null
   Site1_Description       text            default  null
   
   Site2_AAB_TNS_SiteCode  varchar(32)     default  null
   Site2_Country           varchar(32)     default  null
   Site2_ContactPerson     varchar(64)     default  null
   Site2_ContactEmail      varchar(32)     default  null
   S2te1_ContactPhone      varchar(20)     default  null
   S2te1_ContactMobile     varchar(20)     default  null
   Site2_Description       text            default  null
   
   DetailedDescription     text            default  null
) TYPE=InnoDB;


