#
# Table structure for table 'client'
#
CREATE TABLE client (
  client_id int(11) DEFAULT '0' NOT NULL,
  societe varchar(30),
  password varchar(20),
  hm int(11),
  acces int(11),
  PRIMARY KEY (client_id)
);

#
# Table structure for table 'incoming_calls'
#
CREATE TABLE incoming_calls (
  service_id char(16) DEFAULT '' NOT NULL,
  start int(11) DEFAULT '0' NOT NULL,
  length int(11),
  caller_id1 char(128),
  caller_id2 char(128),
  route_id int(11),
  comment char(32),
  KEY start (start,service_id),
  KEY service_id (service_id)
);

#
# Table structure for table 'outgoing_calls'
#
CREATE TABLE outgoing_calls (
  service_id char(16),
  start int(11) DEFAULT '0' NOT NULL,
  length int(11) DEFAULT '0' NOT NULL,
  origin char(128),
  destination char(128),
  comment char(32)
);

#
# Table structure for table 'outgoing_calls_requests'
#
CREATE TABLE outgoing_calls_requests (
  request_id int(11) DEFAULT '0' NOT NULL auto_increment,
  service_id char(16) DEFAULT '' NOT NULL,
  start int(11),
  origin char(128),
  destination char(128) DEFAULT '' NOT NULL,
  comment char(32),
  PRIMARY KEY (request_id)
);

#
# Table structure for table 'routes'
#
CREATE TABLE routes (
  route_id int(11) DEFAULT '0' NOT NULL auto_increment,
  address char(128) DEFAULT '' NOT NULL,
  route char(128) DEFAULT '' NOT NULL,
  active tinyint(1) DEFAULT '0' NOT NULL,
  start int(11),
  end int(11),
  stats tinyint(1) DEFAULT '0' NOT NULL,
  comment char(128),
  PRIMARY KEY (route_id)
);

#
# Table structure for table 'section_stats'
#
CREATE TABLE section_stats (
  service_id char(16) DEFAULT '' NOT NULL,
  start int(11) DEFAULT '0' NOT NULL,
  length int(11) DEFAULT '0' NOT NULL,
  section char(32) DEFAULT '' NOT NULL
);

#
# Table structure for table 'services'
#
CREATE TABLE services (
  service_id char(16) DEFAULT '' NOT NULL,
  pickup tinyint(1) DEFAULT '0' NOT NULL,
  start_script char(128),
  script char(128),
  end_script char(128),
  comment char(128),
  dir0 char(128),
  dir1 char(128),
  dir2 char(128),
  dir3 char(128),
  data0 char(128),
  data1 char(128),
  data2 char(128),
  data3 char(128),
  data4 char(128),
  data5 char(128),
  data6 char(128),
  data7 char(128),
  data8 char(128),
  data9 char(128),
  client_id int(11),
  PRIMARY KEY (service_id)
);