CREATE TABLE TaskStatus (ID int default 0 not null,
TaskID int default 0 not null,
ClientStarted DateTime default "" not null,
ClientFinished DateTime default "" not null,
SentToServer int default 0 not null,
ServerStarted DateTime default "" not null,
ServerFinished DateTime default "" not null);

CREATE TABLE billtasks (id int default 0 not null,
clecID int default 0 not null,
ilecID int default 0 not null,
resale int default 0 not null,
unep int default 0 not null,
taskorder int default 0 not null,
task varchar(100) default '' not null,
descr varchar(255) default '' not null);

insert  into BillTasks values (3,2,1,1,0,1,'AddBSDABResaleUSOCInfo','Add All USOCs');
insert  into BillTasks values (4,2,1,1,0,2,'AddBSDABResaleOCCInfo','Add All Other Charges And Credits');
insert  into BillTasks values (5,2,1,1,0,3,'AddBSDABResaleLocalUsage','Add Local Usage Charges');
insert  into BillTasks values (6,2,1,1,0,4,'AddBSDABResaleItemizedCalls','Add Itemized Calls Charges');
insert  into BillTasks values (7,2,1,1,0,5,'AddBSDABResaleDA','Add Directory Assistance Charges');

CREATE TABLE ilecs (
  id bigint(20) NOT NULL default 0,
  sagrpid bigint(20) NOT NULL default '0',
  abbr varchar(50) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  created datetime NOT NULL default '0000-00-00 00:00:00');

insert  into ilecs values (1, 3, 'BST', 'BELLSOUTH', '0000-00-00 00:00:00');
insert  into ilecs values (2, 7, 'SBC', 'Southwestern Bell', '0000-00-00 00:00:00'); 
insert  into ilecs values (3, 4, 'CTel', 'CenturyTel', '0000-00-00 00:00:00');
insert  into ilecs values (4, 1, 'AllTel', 'AllTel', '0000-00-00 00:00:00');
insert  into ilecs values (5, 13, 'Valor', 'Valor', '0000-00-00 00:00:00');
insert  into ilecs values (6, 2, 'AmTch', 'AmeriTech', '0000-00-00 00:00:00');
insert  into ilecs values (7, 5, 'CinBell', 'Cincinnati Bell', '0000-00-00 00:00:00');
insert  into ilecs values (8, 6, 'Fmrs', 'Farmers', '0000-00-00 00:00:00');
insert  into ilecs values (9, 8, 'Sprint', 'Sprint', '0000-00-00 00:00:00');
insert  into ilecs values (10, 9, 'Vrzn', 'Verizon', '0000-00-00 00:00:00');
insert  into ilecs values (11, 10, 'TT', 'TeleTouch', '0000-00-00 00:00:00');
insert  into ilecs values (12, 11, 'SIT', 'Stay In Touch', '0000-00-00 00:00:00');
insert  into ilecs values (13, 12, 'RR', 'Red River', '0000-00-00 00:00:00');
