data base create in drupal 7

CREATE TABLE IF NOT EXISTS  `fleet_overview` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `data` LONGTEXT COMMENT  'Data',
 `position` INT( 11 ) DEFAULT NULL ,
 `status` INT( 11 ) DEFAULT 1,
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9


CREATE TABLE IF NOT EXISTS  `fleet_virtual` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid`INT(11) NOT NULL,
 `virtualimage` LONGTEXT COMMENT  'virtualimage',
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9


CREATE TABLE IF NOT EXISTS  `fleet_middle_slider` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid`INT(11) NOT NULL,
 `middleimage` INT(11) NOT NULL COMMENT  'middleimage',
 `accomodations` LONGTEXT COMMENT  'accomodations',
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9



CREATE TABLE IF NOT EXISTS  `fleet_gallery` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid` INT( 11 ) NOT NULL ,
 `galleryType` VARCHAR( 256 ) ,
 `galleryData` VARCHAR( 256 ) ,
 `position` INT( 11 ) NULL ,
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9