CREATE TABLE `fdtpoc_dec` ( `dec_host` varchar(255) NOT NULL, `dec_dev` varchar(64) NOT NULL, `dec_time` datetime NOT NULL, PRIMARY KEY (`dec_host`,`dec_dev`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtpoc_msg` ( `msg_uid` char(32) NOT NULL, `msg_time` datetime NOT NULL, `msg_dBm` tinyint(4) DEFAULT NULL, `msg_ric` varchar(7) NOT NULL, `msg_sub` varchar(1) NOT NULL, `msg_text` varchar(512) NOT NULL, `msg_visible` tinyint(1) unsigned NOT NULL, `msg_dec` varchar(64) NOT NULL, `msg_host` varchar(255) NOT NULL, PRIMARY KEY (`msg_uid`), KEY `msg_visible` (`msg_visible`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtpoc_srv` ( `srv_host` varchar(255) NOT NULL, `srv_time` datetime NOT NULL, PRIMARY KEY (`srv_host`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsds_radios` ( `radio_host` varchar(255) NOT NULL, `radio_issi` char(8) NOT NULL, `radio_gssi` char(8) NOT NULL, `radio_opta` varchar(24) NOT NULL, `radio_dev` varchar(64) NOT NULL, `radio_dBm` tinyint(4) DEFAULT NULL, `radio_MNI` int(10) unsigned DEFAULT NULL, `radio_LA` smallint(5) unsigned DEFAULT NULL, `radio_reg` tinyint(3) unsigned DEFAULT NULL, `radio_time` datetime NOT NULL, PRIMARY KEY (`radio_host`,`radio_dev`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsds_sds` ( `sds_uid` char(32) NOT NULL, `sds_time` datetime NOT NULL, `sds_aitype` tinyint(3) unsigned NOT NULL, `sds_from` varchar(24) NOT NULL, `sds_fromtype` tinyint(3) unsigned NOT NULL, `sds_to` varchar(24) NOT NULL, `sds_totype` tinyint(3) unsigned NOT NULL, `sds_length` smallint(5) unsigned NOT NULL, `sds_userdata` varchar(512) NOT NULL, `sds_visible` tinyint(1) unsigned NOT NULL, `sds_radio` varchar(64) NOT NULL, `sds_host` varchar(255) NOT NULL, PRIMARY KEY (`sds_uid`), KEY `sds_from` (`sds_from`), KEY `sds_time` (`sds_time`), KEY `sds_aitype` (`sds_aitype`), KEY `sds_visible` (`sds_visible`), FULLTEXT KEY `sds_userdata` (`sds_userdata`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsds_srv` ( `srv_host` varchar(255) NOT NULL, `srv_time` datetime NOT NULL, PRIMARY KEY (`srv_host`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsms_insms` ( `sms_uid` char(32) NOT NULL, `sms_time` datetime NOT NULL, `sms_scts` datetime NOT NULL, `sms_from` varchar(15) NOT NULL, `sms_fromtype` tinyint(3) unsigned NOT NULL, `sms_to` varchar(15) NOT NULL, `sms_totype` tinyint(3) unsigned NOT NULL, `sms_data` varchar(350) NOT NULL, `sms_visible` tinyint(1) unsigned NOT NULL, `sms_mod` varchar(24) NOT NULL, `sms_host` varchar(255) NOT NULL, PRIMARY KEY (`sms_uid`), KEY `sms_visible` (`sms_visible`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsms_mod` ( `mod_host` varchar(255) NOT NULL, `mod_id` varchar(24) NOT NULL, `mod_dev` varchar(64) NOT NULL, `mod_dBm` tinyint(4) DEFAULT NULL, `mod_op` mediumint(8) unsigned DEFAULT NULL, `mod_reg` tinyint(3) unsigned DEFAULT NULL, `mod_time` datetime NOT NULL, PRIMARY KEY (`mod_host`,`mod_dev`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `fdtsms_srv` ( `srv_host` varchar(255) NOT NULL, `srv_time` datetime NOT NULL, PRIMARY KEY (`srv_host`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8