create_zcs_database.sql

create_zcs_database.sql

CREATE DATABASE IF NOT EXISTS `zcs_production`;
USE `zcs_production`;

DROP TABLE IF EXISTS `zcs_counters`;
CREATE TABLE `zcs_counters` (
  `id` int(255) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `call_switch` varchar(255) DEFAULT NULL,
  `date_and_hour` datetime DEFAULT NULL,
  `input` int(255) DEFAULT NULL,
  `output` int(255) DEFAULT NULL,
  `home_records` int(255) DEFAULT NULL,
  `roam_records` int(255) DEFAULT NULL,
  `icom_records` int(255) DEFAULT NULL,
  `ntua_records` int(255) DEFAULT NULL,
  `gate_in_drop` int(255) DEFAULT NULL,
  `gate_out_drop` int(255) DEFAULT NULL,
  `sip_in_drop` int(255) DEFAULT NULL,
  `sip_out_drop` int(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;