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);