CREATE TABLE IF NOT EXISTS `alarm_tbl_aktuell` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `S_1_STAT` varchar(255),
  `S_1_BATT` varchar(255), 
  `S_2_STAT` varchar(255),
  `S_2_BATT` varchar(255),
  `S_3_STAT` varchar(255),
  `S_3_BATT` varchar(255),
  `S_4_STAT` varchar(255),
  `S_4_BATT` varchar(255),
  `S_5_STAT` varchar(255),
  `S_5_BATT` varchar(255),
  `S_6_STAT` varchar(255),
  `S_6_BATT` varchar(255),
  `S_7_STAT` varchar(255),
  `S_7_BATT` varchar(255),
  `S_8_STAT` varchar(255),
  `S_8_BATT` varchar(255),
  `DATE` varchar(255),
  `TIME` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `alarm_tbl_aktuell` (`id`, `S_1_STAT`, `S_1_BATT`, `S_2_STAT`, `S_2_BATT`, `S_3_STAT`, `S_3_BATT`, `S_4_STAT`, `S_4_BATT`, `S_5_STAT`, `S_5_BATT`, `S_6_STAT`, `S_6_BATT`, `S_7_STAT`, `S_7_BATT`, `S_8_STAT`, `S_8_BATT` ) VALUES
('0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');

ALTER TABLE `alarm_tbl_aktuell`;
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `alarm_fensterstatus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `F_1_STATUS` varchar(255),
  `F_2_STATUS` varchar(255),
  `F_3_STATUS` varchar(255),
  `F_4_STATUS` varchar(255),
  `F_5_STATUS` varchar(255),
  `F_6_STATUS` varchar(255),
  `F_7_STATUS` varchar(255),
  `F_8_STATUS` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `alarm_fensterstatus` (`id`, `F_1_STATUS`, `F_2_STATUS`, `F_3_STATUS` , `F_4_STATUS` , `F_5_STATUS` , `F_6_STATUS` , `F_7_STATUS` , `F_8_STATUS`) VALUES
('0','0','0','0','0','0','0','0' ,'0');
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `alarm_batterie` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DATE` varchar(255),
  `TIME` varchar(255),
  `Sensor` varchar(255),
  `Batteriestatus` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
************************************************************************************************************************ 

DROP TABLE IF EXISTS `alarm_on_off`;
CREATE TABLE `alarm_on_off` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `S_1_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_2_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_3_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_4_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_5_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_6_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_7_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_8_ALARM` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `alarm_on_off` (`id`, `S_1_ALARM`, `S_2_ALARM`, `S_3_ALARM`, `S_4_ALARM`, `S_5_ALARM`, `S_6_ALARM`, `S_7_ALARM`, `S_8_ALARM`,`DATE`, `TIME`) VALUES
(1,	'1',	'1',	'1',	'1',	'1',	'1',	'1', '1',	'',	'');
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `alarm_alarmstatus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ALARM_STATUS` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `alarm_alarmstatus` (`id`, `ALARM_STATUS`) VALUES
('0','0');
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `camera_on_off` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `PRE` varchar(255),
  `CAMERA_1_STAT` varchar(255),
  `CAMERA_2_STAT` varchar(255),
  `END` varchar(255),  
  `DATE` varchar(255),
  `TIME` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `camera_on_off` (`id`, `PRE`,`CAMERA_1_STAT`, `CAMERA_2_STAT`, `END` ) VALUES
('0','0','0' ,'0' ,'0');

ALTER TABLE `camera_on_off`;
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `alarm_email` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Datum` DATE,
  `Zeit` varchar(255),
  `Sensor` varchar(255),
  `Email_an` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `alarm_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DATE` DATE,
  `TIME` varchar(255),
  `Sensor` varchar(255),
  `Batteriestatus` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
************************************************************************************************************************ 

CREATE TABLE IF NOT EXISTS `test_hex` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DATE` varchar(255),
  `TIME` varchar(255),
  `byte_1` varchar(255),
  `byte_2` varchar(255),
  `byte_3` varchar(255),
  `byte_4` varchar(255),
  `byte_5` varchar(255),
  `byte_6` varchar(255),
  `byte_7` varchar(255),
  `byte_8` varchar(255),
  `byte_9` varchar(255),
  `byte_10` varchar(255),
  `byte_11` varchar(255),
  `byte_12` varchar(255),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `test_hex` (`id`, `DATE`,`TIME`, `byte_1`, `byte_2`,`byte_3`, `byte_4`, `byte_5`, `byte_6`, `byte_7`, `byte_8`, `byte_9`, `byte_10`, `byte_11`, `byte_12` ) VALUES
('0','0','0' ,'0' ,'0' ,'0' ,'0' ,'0','0','0','0','0','0','0','0');

ALTER TABLE `test_hex`;
************************************************************************************************************************