schema.txt

#
# Database schema for use with the "Phone Bill" sample
# of the Big Faceless Report Generator. The phone numbers
# are all random numbers, so best not try calling them.
#
# http://big.faceless.org/products/report
#
#


# Table structure for table 'account'
#
DROP TABLE IF EXISTS account;

CREATE TABLE account
(
  accno    int(11) not null primary key,
  name     varchar(50) not null,
  address  varchar(255) not null
);

# Dumping data for table 'account'
#
INSERT INTO account VALUES (12345678,'John Tester','21 Test Street\nTestville\nTestland');


# Table structure for table 'charges'
#
DROP TABLE IF EXISTS charges;

CREATE TABLE charges
(
  type       int(11) not null primary key,
  name       varchar(30) not null,
  persecond  float not null
);

# Dumping data for table 'charges'
#
INSERT INTO charges VALUES (1,'Local',0.01);
INSERT INTO charges VALUES (2,'Mobile',0.08);
INSERT INTO charges VALUES (3,'Germany',0.12);
INSERT INTO charges VALUES (4,'New Zealand',0.17);
INSERT INTO charges VALUES (5,'Australia',0.17);


# Table structure for table 'calls'
#
DROP TABLE IF EXISTS calls;

CREATE TABLE calls
(
  accno        int(11) not null,
  date         datetime not null,
  callee       varchar(20) not null,
  seconds      int(11) not null,
  chargetype   int(11) not null,
  PRIMARY KEY  (accno,date)
);

# Dumping data for table 'calls'
#
INSERT INTO calls VALUES (12345678,'2001-09-07 10:10:00','7391228',20,1);
INSERT INTO calls VALUES (12345678,'2001-09-07 18:31:00','07092 872256',55,2);
INSERT INTO calls VALUES (12345678,'2001-09-08 05:13:00','5882994',45,1);
INSERT INTO calls VALUES (12345678,'2001-09-09 01:34:00','+49 1 7755539',145,3);
INSERT INTO calls VALUES (12345678,'2001-09-09 03:40:00','5714543',30,1);
INSERT INTO calls VALUES (12345678,'2001-09-09 18:32:00','+64 4 4473439',160,4);
INSERT INTO calls VALUES (12345678,'2001-09-10 13:29:00','+64 4 4164573',50,4);
INSERT INTO calls VALUES (12345678,'2001-09-11 04:23:00','6116135',160,1);
INSERT INTO calls VALUES (12345678,'2001-09-11 07:35:00','+49 1 8394678',90,3);
INSERT INTO calls VALUES (12345678,'2001-09-11 22:36:00','+49 1 8135090',25,3);
INSERT INTO calls VALUES (12345678,'2001-09-12 11:58:00','9474497',80,1);
INSERT INTO calls VALUES (12345678,'2001-09-13 06:54:00','+49 1 9143114',55,3);
INSERT INTO calls VALUES (12345678,'2001-09-13 15:05:00','07771 790326',55,2);
INSERT INTO calls VALUES (12345678,'2001-09-14 10:51:00','07092 513723',125,2);
INSERT INTO calls VALUES (12345678,'2001-09-14 18:41:00','6393857',105,1);
INSERT INTO calls VALUES (12345678,'2001-09-15 04:58:00','3150902',160,1);
INSERT INTO calls VALUES (12345678,'2001-09-15 16:15:00','9832865',70,1);
INSERT INTO calls VALUES (12345678,'2001-09-16 08:25:00','5248614',65,1);
INSERT INTO calls VALUES (12345678,'2001-09-16 09:16:00','07771 944645',130,2);
INSERT INTO calls VALUES (12345678,'2001-09-17 01:11:00','+64 4 5001559',140,4);
INSERT INTO calls VALUES (12345678,'2001-09-17 08:20:00','7286736',115,1);
INSERT INTO calls VALUES (12345678,'2001-09-17 15:55:00','9277289',140,1);
INSERT INTO calls VALUES (12345678,'2001-09-17 20:59:00','+49 1 8207041',25,3);
INSERT INTO calls VALUES (12345678,'2001-09-18 18:15:00','07092 433947',140,2);
INSERT INTO calls VALUES (12345678,'2001-09-19 05:26:00','3517051',40,1);
INSERT INTO calls VALUES (12345678,'2001-09-19 12:28:00','+64 4 4885611',25,4);
INSERT INTO calls VALUES (12345678,'2001-09-20 06:41:00','07771 649980',65,2);
INSERT INTO calls VALUES (12345678,'2001-09-20 08:44:00','+49 1 3751255',65,3);
INSERT INTO calls VALUES (12345678,'2001-09-20 11:41:00','6932697',90,1);
INSERT INTO calls VALUES (12345678,'2001-09-20 13:07:00','+61 2 53578467',100,5);
INSERT INTO calls VALUES (12345678,'2001-09-20 13:16:00','3683238',40,1);
INSERT INTO calls VALUES (12345678,'2001-09-20 23:40:00','8784498',130,1);
INSERT INTO calls VALUES (12345678,'2001-09-21 14:29:00','8347740',50,1);
INSERT INTO calls VALUES (12345678,'2001-09-22 12:31:00','07771 667340',85,2);
INSERT INTO calls VALUES (12345678,'2001-09-23 01:57:00','5767478',105,1);
INSERT INTO calls VALUES (12345678,'2001-09-23 10:45:00','07771 350891',45,2);
INSERT INTO calls VALUES (12345678,'2001-09-24 02:49:00','8091627',105,1);
INSERT INTO calls VALUES (12345678,'2001-09-24 19:14:00','6811222',25,1);
INSERT INTO calls VALUES (12345678,'2001-09-24 22:53:00','+61 2 58860163',40,5);
INSERT INTO calls VALUES (12345678,'2001-09-25 15:50:00','5053500',155,1);
INSERT INTO calls VALUES (12345678,'2001-09-25 19:20:00','8352256',40,1);
INSERT INTO calls VALUES (12345678,'2001-09-25 21:07:00','07092 731561',70,2);
INSERT INTO calls VALUES (12345678,'2001-09-26 07:19:00','+49 1 4186966',105,3);
INSERT INTO calls VALUES (12345678,'2001-09-26 16:29:00','+61 2 55303343',145,5);
INSERT INTO calls VALUES (12345678,'2001-09-26 20:51:00','6872979',35,1);
INSERT INTO calls VALUES (12345678,'2001-09-27 03:08:00','07771 846048',40,2);
INSERT INTO calls VALUES (12345678,'2001-09-27 08:48:00','+64 4 6682848',20,4);
INSERT INTO calls VALUES (12345678,'2001-09-27 14:23:00','8689565',75,1);
INSERT INTO calls VALUES (12345678,'2001-09-28 04:09:00','8874643',65,1);
INSERT INTO calls VALUES (12345678,'2001-09-29 02:14:00','9453474',90,1);
INSERT INTO calls VALUES (12345678,'2001-09-29 12:49:00','5900162',95,1);
INSERT INTO calls VALUES (12345678,'2001-09-29 18:27:00','+61 2 55756113',90,5);
INSERT INTO calls VALUES (12345678,'2001-09-30 00:01:00','07771 582376',40,2);
INSERT INTO calls VALUES (12345678,'2001-09-30 21:57:00','07092 669437',95,2);
INSERT INTO calls VALUES (12345678,'2001-10-01 01:16:00','5729671',105,1);
INSERT INTO calls VALUES (12345678,'2001-10-01 19:38:00','3936912',65,1);
INSERT INTO calls VALUES (12345678,'2001-10-02 01:33:00','07092 441792',85,2);
INSERT INTO calls VALUES (12345678,'2001-10-02 08:28:00','07092 561694',115,2);
INSERT INTO calls VALUES (12345678,'2001-10-03 01:11:00','+64 4 6180591',105,4);
INSERT INTO calls VALUES (12345678,'2001-10-03 05:53:00','7727006',85,1);
INSERT INTO calls VALUES (12345678,'2001-10-03 07:18:00','07771 890948',30,2);
INSERT INTO calls VALUES (12345678,'2001-10-03 22:22:00','9172766',100,1);
INSERT INTO calls VALUES (12345678,'2001-10-04 17:33:00','6215751',50,1);
INSERT INTO calls VALUES (12345678,'2001-10-05 12:49:00','+61 2 53181281',35,5);
INSERT INTO calls VALUES (12345678,'2001-10-06 04:20:00','8638710',55,1);
INSERT INTO calls VALUES (12345678,'2001-10-06 07:39:00','3765724',130,1);
INSERT INTO calls VALUES (12345678,'2001-10-06 12:07:00','3387962',165,1);
INSERT INTO calls VALUES (12345678,'2001-10-06 12:52:00','+61 2 53424347',165,5);
INSERT INTO calls VALUES (12345678,'2001-10-06 16:16:00','07771 339739',140,2);
INSERT INTO calls VALUES (12345678,'2001-10-07 01:42:00','+64 4 7195694',165,4);
INSERT INTO calls VALUES (12345678,'2001-10-07 12:33:00','+49 1 9773679',160,3);
INSERT INTO calls VALUES (12345678,'2001-10-08 08:39:00','3605188',80,1);
INSERT INTO calls VALUES (12345678,'2001-10-09 05:13:00','9994113',20,1);
INSERT INTO calls VALUES (12345678,'2001-10-09 12:28:00','+49 1 6920059',100,3);
INSERT INTO calls VALUES (12345678,'2001-10-10 04:22:00','7450076',140,1);
INSERT INTO calls VALUES (12345678,'2001-10-10 06:47:00','+64 4 3480171',105,4);
INSERT INTO calls VALUES (12345678,'2001-10-10 22:25:00','9142118',140,1);
INSERT INTO calls VALUES (12345678,'2001-10-11 04:25:00','+61 2 53691606',140,5);
INSERT INTO calls VALUES (12345678,'2001-10-11 20:25:00','+61 2 56511591',165,5);
INSERT INTO calls VALUES (12345678,'2001-10-12 06:17:00','5558002',90,1);
INSERT INTO calls VALUES (12345678,'2001-10-12 09:04:00','3541066',65,1);
INSERT INTO calls VALUES (12345678,'2001-10-13 02:50:00','6381434',95,1);
INSERT INTO calls VALUES (12345678,'2001-10-13 07:03:00','6372071',115,1);
INSERT INTO calls VALUES (12345678,'2001-10-13 08:09:00','+64 4 3490229',115,4);
INSERT INTO calls VALUES (12345678,'2001-10-14 03:33:00','9773603',150,1);
INSERT INTO calls VALUES (12345678,'2001-10-14 14:50:00','+49 1 7545454',70,3);
INSERT INTO calls VALUES (12345678,'2001-10-15 01:31:00','5848586',120,1);
INSERT INTO calls VALUES (12345678,'2001-10-15 11:35:00','5140880',115,1);
INSERT INTO calls VALUES (12345678,'2001-10-16 01:22:00','4387930',140,1);
INSERT INTO calls VALUES (12345678,'2001-10-16 21:14:00','07092 604307',75,2);
INSERT INTO calls VALUES (12345678,'2001-10-17 16:37:00','6273014',145,1);
INSERT INTO calls VALUES (12345678,'2001-10-17 21:07:00','+61 2 53518840',165,5);
INSERT INTO calls VALUES (12345678,'2001-10-18 09:43:00','7287431',100,1);
INSERT INTO calls VALUES (12345678,'2001-10-19 07:43:00','07771 476663',30,2);
INSERT INTO calls VALUES (12345678,'2001-10-19 10:50:00','9627491',145,1);
INSERT INTO calls VALUES (12345678,'2001-10-19 10:54:00','6506541',90,1);
INSERT INTO calls VALUES (12345678,'2001-10-19 23:45:00','+64 4 4298476',30,4);
INSERT INTO calls VALUES (12345678,'2001-10-20 17:51:00','4290301',105,1);
INSERT INTO calls VALUES (12345678,'2001-10-21 06:42:00','8449829',45,1);
INSERT INTO calls VALUES (12345678,'2001-10-21 19:07:00','7068587',45,1);