-- MySQL dump 9.11
--
-- Host: localhost    Database: NUS
-- ------------------------------------------------------
-- Server version	4.0.25-log

--
-- Table structure for table `AccountsArchiveDocType`
--

SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE AccountsArchiveDocType (
  ID int(10) unsigned NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  DocType varchar(50) default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `AccountsArchiveTypes`
--

CREATE TABLE AccountsArchiveTypes (
  ID smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Description varchar(100) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `AccountsPDFs`
--

CREATE TABLE AccountsPDFs (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  TypeID smallint(5) unsigned NOT NULL default '0',
  CompanyID int(10) unsigned NOT NULL default '0',
  ArticleDate date NOT NULL default '0000-00-00',
  InvoiceNo mediumint(8) unsigned NOT NULL default '0',
  ReferenceCode varchar(50) NOT NULL default '',
  PRIMARY KEY  (ID),
  UNIQUE KEY IDX_InvoiceNo_ArticleDate (ArticleDate,InvoiceNo)
) TYPE=InnoDB;

--
-- Table structure for table `AccountsPaidInvoices`
--

CREATE TABLE AccountsPaidInvoices (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  PDFID int(10) unsigned NOT NULL default '0',
  InvoiceID int(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `AgeBillingNotes`
--

CREATE TABLE AgeBillingNotes (
  DanPK int(11) NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  FileNo int(11) default NULL,
  SubNo smallint(6) default NULL,
  BillingID smallint(6) default NULL,
  NoteDate datetime default NULL,
  AgedNote text,
  Author smallint(6) default NULL,
  ActionDate datetime default NULL,
  Completed tinyint(4) default NULL,
  PRIMARY KEY  (DanPK)
) TYPE=InnoDB;

--
-- Table structure for table `AllStaff`
--

CREATE TABLE AllStaff (
  MyStamp timestamp(14) NOT NULL,
  GroupNo tinyint(3) unsigned default '0',
  Initials char(3) default '',
  FirstName varchar(20) default '',
  LastName varchar(20) default '',
  Active tinyint(1) default '0',
  ID smallint(5) unsigned NOT NULL default '0',
  TelPhoneNo varchar(50) default '',
  Assistant smallint(5) unsigned default '0',
  Management tinyint(1) default '0',
  Password varchar(20) default '',
  StartDate date default NULL,
  TerminationDate date default NULL,
  AlterID char(1) default '',
  ExtNo smallint(5) unsigned default '0',
  TimeSheet tinyint(1) default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `AnalystFollowUps`
--

CREATE TABLE AnalystFollowUps (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  AnalystID smallint(5) unsigned NOT NULL default '0',
  ClientID mediumint(8) unsigned NOT NULL default '0',
  FollowUp date NOT NULL default '0000-00-00',
  Note tinytext NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM MAX_ROWS=1000;

--
-- Table structure for table `AnalystTaskTypes`
--

CREATE TABLE AnalystTaskTypes (
  ID int(11) NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Task varchar(50) default NULL,
  Prod char(1) default NULL,
  Priority smallint(6) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `AnalystTasks`
--

CREATE TABLE AnalystTasks (
  TaskNo int(11) NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo smallint(6) default NULL,
  Prod char(1) default NULL,
  Type smallint(6) default NULL,
  RequestDate datetime default NULL,
  AnalystID int(11) default NULL,
  RequestedBy int(11) default NULL,
  CompleteDate datetime default NULL,
  TaskPriority smallint(6) default NULL,
  PRIMARY KEY  (TaskNo)
) TYPE=InnoDB;

--
-- Table structure for table `AnnualTargetType`
--

CREATE TABLE AnnualTargetType (
  TargetTypeID int(10) unsigned NOT NULL auto_increment,
  TargetType varchar(30) NOT NULL default '',
  PRIMARY KEY  (TargetTypeID)
) TYPE=MyISAM;

--
-- Table structure for table `AnnualTargets`
--

CREATE TABLE AnnualTargets (
  TargetID int(10) unsigned NOT NULL auto_increment,
  TargetYear smallint(4) NOT NULL default '0',
  TargetProduct smallint(6) NOT NULL default '0',
  TargetAmount double NOT NULL default '0',
  PRIMARY KEY  (TargetID),
  UNIQUE KEY Yearly (TargetYear,TargetProduct)
) TYPE=MyISAM;

--
-- Table structure for table `BillFormats`
--

CREATE TABLE BillFormats (
  ID smallint(5) unsigned NOT NULL auto_increment,
  BillName varchar(50) NOT NULL default '',
  BillFormat varchar(50) NOT NULL default '',
  Disk tinyint(1) NOT NULL default '0',
  Email tinyint(1) NOT NULL default '0',
  Download tinyint(1) NOT NULL default '0',
  Comments tinytext NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `BillTypes`
--

CREATE TABLE BillTypes (
  BillType varchar(20) NOT NULL default '',
  BillFate varchar(100) NOT NULL default '',
  Description varchar(100) NOT NULL default '',
  PRIMARY KEY  (BillType)
) TYPE=MyISAM;

--
-- Table structure for table `Billing_BillCollection`
--

CREATE TABLE Billing_BillCollection (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SavingsNo mediumint(8) unsigned NOT NULL default '0',
  InvoiceNo int(10) unsigned NOT NULL default '0',
  TAP_ID int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_InvoiceNo (InvoiceNo)
) TYPE=MyISAM;

--
-- Table structure for table `Billing_ServiceRates`
--

CREATE TABLE Billing_ServiceRates (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Service_FK mediumint(8) unsigned NOT NULL default '0',
  Commencement date NOT NULL default '0000-00-00',
  Rate double NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `Billing_ServiceSavings`
--

CREATE TABLE Billing_ServiceSavings (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SavingsNo mediumint(8) unsigned NOT NULL default '0',
  Line varchar(30) NOT NULL default '',
  BillingLineType mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_SavingsNo (SavingsNo),
  KEY IDX_Line (Line)
) TYPE=MyISAM;

--
-- Table structure for table `Billing_ServiceTypes`
--

CREATE TABLE Billing_ServiceTypes (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SupplierID smallint(5) unsigned NOT NULL default '0',
  ServiceDescription varchar(100) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `Billing_SupplierSavings`
--

CREATE TABLE Billing_SupplierSavings (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SavingsNo int(10) unsigned NOT NULL default '0',
  LocID mediumint(5) unsigned NOT NULL default '0',
  SupplierID smallint(5) unsigned NOT NULL default '0',
  Sav_Loc double NOT NULL default '0',
  Weight_Loc double NOT NULL default '0',
  Sav_Nat double NOT NULL default '0',
  Weight_Nat double NOT NULL default '0',
  Sav_Int double NOT NULL default '0',
  Weight_Int double NOT NULL default '0',
  Sav_Mob double NOT NULL default '0',
  Weight_Mob double NOT NULL default '0',
  Sav_Inb double NOT NULL default '0',
  Weight_Inb double NOT NULL default '0',
  Sav_Dat double NOT NULL default '0',
  Weight_Dat double NOT NULL default '0',
  Sav_Serv double NOT NULL default '0',
  Weight_Serv double NOT NULL default '0',
  Active tinyint(4) default '0',
  PRIMARY KEY  (ID),
  KEY IDX_LocID (LocID),
  KEY IDX_Active (Active),
  KEY IDX_SavingsNo (SavingsNo)
) TYPE=MyISAM;

--
-- Table structure for table `BillsReceived`
--

CREATE TABLE BillsReceived (
  BatchNo mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  DateAnalysed date default NULL,
  ClientID int(10) unsigned default '0',
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo smallint(5) unsigned NOT NULL default '0',
  DateReceived date NOT NULL default '0000-00-00',
  Prod char(1) NOT NULL default '',
  PostedDate date default NULL,
  Original varchar(20) NOT NULL default '',
  DateReturned date default NULL,
  Fate tinyint(3) unsigned default '0',
  PostingPriority tinyint(3) unsigned default '7',
  Poster smallint(5) unsigned default NULL,
  DateTaken date default NULL,
  PRIMARY KEY  (BatchNo),
  KEY FileNo_SubNo (FileNo,SubNo),
  KEY IDX_ClientID (ClientID),
  KEY IDX_Poster_and_PostedDate (PostedDate,Poster),
  KEY IDX_Poster (Poster)
) TYPE=InnoDB;

--
-- Table structure for table `BillsReceivedFlags`
--

CREATE TABLE BillsReceivedFlags (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo smallint(5) unsigned NOT NULL default '0',
  Prod char(1) NOT NULL default '',
  AccMan smallint(5) unsigned NOT NULL default '0',
  Analyst smallint(5) unsigned NOT NULL default '0',
  Billing smallint(5) unsigned NOT NULL default '0',
  AccManNote varchar(255) default '',
  AnalystNote varchar(255) default '',
  BillingNote varchar(255) default '',
  PRIMARY KEY  (ID),
  KEY FileNo_SubNo (FileNo,SubNo)
) TYPE=MyISAM;

--
-- Table structure for table `BillsReceivedNotices`
--

CREATE TABLE BillsReceivedNotices (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Recipient varchar(100) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  Subject varchar(100) NOT NULL default '',
  Body tinytext NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `BusinessTypes`
--

CREATE TABLE BusinessTypes (
  MySQLStamp timestamp(14) NOT NULL,
  BusTypeID mediumint(8) unsigned NOT NULL auto_increment,
  BusinessType varchar(50) NOT NULL default '',
  Examples varchar(120) default NULL,
  WSale_Manuf enum('W','M') default NULL,
  PRIMARY KEY  (BusTypeID)
) TYPE=MyISAM;

--
-- Table structure for table `CallCap_to_CallCategory_IDs`
--

CREATE TABLE CallCap_to_CallCategory_IDs (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `CallCap_to_CallCategory_Items`
--

CREATE TABLE CallCap_to_CallCategory_Items (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  CallCap_to_CallCategory_FK int(11) NOT NULL default '0',
  CapID int(11) NOT NULL default '0',
  CatID smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_CapID (CapID),
  KEY IDX_CatID (CatID),
  KEY IDX_CallCap_to_CallCategory_FK (CallCap_to_CallCategory_FK)
) TYPE=MyISAM COMMENT='Links Call Caps to Call Categories';

--
-- Table structure for table `CallCaps`
--

CREATE TABLE CallCaps (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Block_1 smallint(5) unsigned NOT NULL default '60',
  Factor decimal(10,4) unsigned default NULL,
  Block_2 smallint(5) unsigned NOT NULL default '60',
  Minimum decimal(10,4) unsigned default NULL,
  Cap decimal(10,4) unsigned default NULL,
  Free decimal(10,4) default NULL,
  PRIMARY KEY  (ID),
  UNIQUE KEY IDX_DuplicateBlocker (Block_1,Factor,Block_2,Minimum,Cap,Free)
) TYPE=MyISAM;

--
-- Table structure for table `CallCategory`
--

CREATE TABLE CallCategory (
  CatID smallint(20) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  CatCode int(11) default '0',
  CatType varchar(50) default '',
  CatDescription varchar(100) default '',
  CatPeriod varchar(15) default '',
  CatGroup tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (CatID)
) TYPE=MyISAM COMMENT='Used in conjunction with CallCap table';

--
-- Table structure for table `CallCategoryGroups`
--

CREATE TABLE CallCategoryGroups (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SimpleGroup varchar(50) default NULL,
  GroupDescription varchar(100) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `Cheques`
--

CREATE TABLE Cheques (
  DanPK int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  DateReceived datetime default NULL,
  Company char(70) default NULL,
  FileNo int(11) default NULL,
  SubNo tinyint(4) default NULL,
  Amount decimal(15,4) default NULL,
  PRIMARY KEY  (DanPK)
) TYPE=MyISAM;

--
-- Table structure for table `ConsultantBulletinBoard`
--

CREATE TABLE ConsultantBulletinBoard (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  NoteDate date NOT NULL default '0000-00-00',
  Note text NOT NULL,
  Author smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (DanPK)
) TYPE=MyISAM;

--
-- Table structure for table `Contracts`
--

CREATE TABLE Contracts (
  ContractID int(10) unsigned NOT NULL auto_increment,
  myStamp timestamp(14) NOT NULL,
  LocID int(10) unsigned NOT NULL default '0',
  Prod char(1) NOT NULL default 'T',
  ExpiryDate date default NULL,
  ConsultantNoteDate date default NULL,
  ConsultantNote varchar(254) NOT NULL default '',
  ManagementNoteDate date default NULL,
  ManagementNote varchar(254) NOT NULL default '',
  PRIMARY KEY  (ContractID),
  KEY IDX_LocID (LocID),
  KEY IDX_Prod (Prod)
) TYPE=MyISAM;

--
-- Table structure for table `Correspondence`
--

CREATE TABLE Correspondence (
  ID int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  DocTypeID smallint(5) unsigned NOT NULL default '0',
  CompanyID mediumint(8) unsigned NOT NULL default '0',
  Contact varchar(50) NOT NULL default '',
  ArticleDate date NOT NULL default '0000-00-00',
  Description varchar(100) NOT NULL default '',
  NUSStaffID smallint(5) unsigned NOT NULL default '0',
  SentReceived enum('S','R') NOT NULL default 'S',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `CorrespondenceSummaries`
--

CREATE TABLE CorrespondenceSummaries (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  CorrospondenceTypeID smallint(5) unsigned NOT NULL default '0',
  Summary varchar(50) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `CorrespondenceTypes`
--

CREATE TABLE CorrespondenceTypes (
  ID smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Description varchar(100) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `Creditors`
--

CREATE TABLE Creditors (
  ID smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Creditor varchar(100) NOT NULL default '',
  Address varchar(100) NOT NULL default '',
  Suburb varchar(50) NOT NULL default '',
  State tinyint(3) unsigned NOT NULL default '0',
  Postcode smallint(5) unsigned NOT NULL default '0',
  PhoneNo varchar(20) NOT NULL default '',
  FaxNo varchar(20) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `EAAcctNos`
--

CREATE TABLE EAAcctNos (
  Loc_FK mediumint(8) unsigned NOT NULL default '0',
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  AccountNo varchar(20) NOT NULL default '',
  EAAType char(1) NOT NULL default '',
  EAADate date NOT NULL default '0000-00-00',
  EAARetailer smallint(5) unsigned default '0',
  EAATSTariff smallint(5) unsigned NOT NULL default '0',
  EAATSKwh mediumint(8) unsigned NOT NULL default '0',
  EAATSDays smallint(5) unsigned NOT NULL default '0',
  LastOne tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_LastOne (LastOne),
  KEY IDX_LocFK (Loc_FK),
  CONSTRAINT `Locations_FK` FOREIGN KEY (`Loc_FK`) REFERENCES `EALocations` (`ID`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `EALocations`
--

CREATE TABLE EALocations (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  ClientID mediumint(8) unsigned NOT NULL default '0',
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo tinyint(3) unsigned NOT NULL default '0',
  LocNo tinyint(3) unsigned NOT NULL default '0',
  Prod char(1) default 'E',
  EALCoy varchar(75) default NULL,
  EALStreet varchar(45) default NULL,
  EALSuburb varchar(25) default NULL,
  EALState char(3) default NULL,
  EALPCode smallint(5) unsigned NOT NULL default '0',
  EALNetworkID smallint(5) unsigned NOT NULL default '0',
  EALContract tinyint(4) NOT NULL default '0',
  EALVolts char(1) default NULL,
  DateSetUp date default NULL,
  LastReview date default NULL,
  ProjectedAnnualKHW int(11) default NULL,
  NMI varchar(50) default NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB;

--
-- Table structure for table `EAMeterReadings`
--

CREATE TABLE EAMeterReadings (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  Meter_FK mediumint(8) unsigned NOT NULL default '0',
  EAMDate date NOT NULL default '0000-00-00',
  EAMStart double default NULL,
  EAMEnd double default NULL,
  PRIMARY KEY  (ID),
  KEY IDX_Meter_FK (Meter_FK),
  CONSTRAINT `Meter_FK` FOREIGN KEY (`Meter_FK`) REFERENCES `EAMeters` (`ID`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `EAMeters`
--

CREATE TABLE EAMeters (
  Loc_FK mediumint(8) unsigned NOT NULL default '0',
  ID mediumint(8) unsigned NOT NULL auto_increment,
  NMI varchar(50) default NULL,
  EAMConstant double default '0',
  EAMDate date default NULL,
  EAMTariff varchar(20) default NULL,
  PRIMARY KEY  (ID),
  KEY Loc_FK (Loc_FK),
  CONSTRAINT `Loc_FK` FOREIGN KEY (`Loc_FK`) REFERENCES `EALocations` (`ID`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `EANPostCodes`
--

CREATE TABLE EANPostCodes (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  EANPostCode smallint(5) unsigned NOT NULL default '0',
  EANOperator smallint(5) unsigned NOT NULL default '0',
  EANShared tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `EAPosting`
--

CREATE TABLE EAPosting (
  Account_FK mediumint(8) unsigned NOT NULL default '0',
  Loc_FK mediumint(8) unsigned NOT NULL default '0',
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  BatchNo mediumint(8) unsigned NOT NULL default '0',
  EAPDate date NOT NULL default '0000-00-00',
  EAPDays smallint(5) unsigned NOT NULL default '0',
  EAPKWHpk double unsigned NOT NULL default '0',
  EAPKWHshl double unsigned NOT NULL default '0',
  EAPKWHopk double unsigned NOT NULL default '0',
  EAPKWHcont double unsigned NOT NULL default '0',
  EAPKWHtotal double unsigned NOT NULL default '0',
  PeakCAP double unsigned NOT NULL default '0',
  EAPTariff smallint(5) unsigned NOT NULL default '0',
  EAPNKWHpk double unsigned NOT NULL default '0',
  EAPNKWHshl double unsigned NOT NULL default '0',
  EAPNKWHopk double unsigned NOT NULL default '0',
  EAPNKWHcont double unsigned NOT NULL default '0',
  EAPNKWHtotal double unsigned NOT NULL default '0',
  ShoulderCAP double unsigned NOT NULL default '0',
  OPeakCAP double unsigned NOT NULL default '0',
  PeakMD smallint(5) unsigned NOT NULL default '0',
  ShoulderMD smallint(5) unsigned NOT NULL default '0',
  OPeakMD smallint(5) unsigned NOT NULL default '0',
  TLossFact double NOT NULL default '0',
  DLossFact double NOT NULL default '0',
  PowerFactor double unsigned NOT NULL default '0',
  NetworkCharge double NOT NULL default '0',
  MeterCharge double NOT NULL default '0',
  OtherCharge double NOT NULL default '0',
  Adjustments double NOT NULL default '0',
  EAPTotal double NOT NULL default '0',
  LastOne tinyint(4) default '0',
  PRIMARY KEY  (ID),
  KEY IDX_LastOne (LastOne),
  KEY IDX_Account_FK (Account_FK),
  KEY IDX_LocFK (Loc_FK),
  CONSTRAINT `Account_FK` FOREIGN KEY (`Account_FK`) REFERENCES `EAAcctNos` (`ID`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `EATariffNames`
--

CREATE TABLE EATariffNames (
  EATariffID smallint(5) unsigned NOT NULL auto_increment,
  EATSupplier smallint(5) unsigned NOT NULL default '0',
  EATariffName varchar(60) default NULL,
  EATariffDate date default NULL,
  EATariffType char(1) default NULL,
  PRIMARY KEY  (EATariffID)
) TYPE=MyISAM;

--
-- Table structure for table `ExchangeCodeCityStates`
--

CREATE TABLE ExchangeCodeCityStates (
  DanPK tinyint(3) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Name varchar(10) NOT NULL default '',
  PRIMARY KEY  (DanPK)
) TYPE=MyISAM;

--
-- Table structure for table `ExchangeCodeLocations`
--

CREATE TABLE ExchangeCodeLocations (
  DanPK smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Name varchar(50) NOT NULL default '',
  PRIMARY KEY  (DanPK),
  KEY IDX_Name (Name)
) TYPE=MyISAM;

--
-- Table structure for table `ExchangeCodes`
--

CREATE TABLE ExchangeCodes (
  Line mediumint(8) unsigned NOT NULL default '0',
  LocationID smallint(5) unsigned NOT NULL default '0',
  CityStateID tinyint(3) unsigned NOT NULL default '0',
  RSLPOP tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (Line),
  KEY IDX_LocationID (LocationID)
) TYPE=MyISAM;

--
-- Table structure for table `Fates`
--

CREATE TABLE Fates (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  Description varchar(20) NOT NULL default '',
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `FollowUps`
--

CREATE TABLE FollowUps (
  ID mediumint(11) NOT NULL auto_increment,
  ClientID int(10) unsigned NOT NULL default '0',
  FileNo mediumint(11) NOT NULL default '0',
  SubNo smallint(6) NOT NULL default '0',
  FollowUp datetime default NULL,
  Phoned tinyint(4) default '0',
  Faxed tinyint(4) default '0',
  Written tinyint(4) default '0',
  Visited tinyint(4) default '0',
  Reviewed tinyint(4) default '0',
  Email tinyint(4) default '0',
  ReSet tinyint(4) default '0',
  Memo longtext,
  MemoDate datetime default NULL,
  AccMan smallint(6) NOT NULL default '0',
  FutureFollowUpLegitimate tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_FollowUp (FollowUp),
  KEY IDX_ClientID (ClientID)
) TYPE=InnoDB;

--
-- Table structure for table `FrameRelayLocations`
--

CREATE TABLE FrameRelayLocations (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  TLP_FK mediumint(8) unsigned NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  AEndAddress varchar(75) default NULL,
  BEndAddress varchar(75) default NULL,
  PRIMARY KEY  (DanPK)
) TYPE=MyISAM;

--
-- Table structure for table `Freight`
--

CREATE TABLE Freight (
  DanPK int(11) NOT NULL default '0',
  Location varchar(50) default NULL,
  State char(3) default NULL,
  Petrol decimal(15,4) default NULL,
  Diesel decimal(15,4) default NULL,
  Postcode smallint(11) default NULL,
  MetroCountry enum('M','C') default NULL,
  MyStamp timestamp(14) NOT NULL,
  Zone tinyint(4) NOT NULL default '0',
  ACCC150 tinyint(4) NOT NULL default '0',
  FuelSalesGrant decimal(15,4) NOT NULL default '0.0000',
  PRIMARY KEY  (DanPK)
) TYPE=MyISAM;

--
-- Table structure for table `Groups`
--

CREATE TABLE Groups (
  GroupID tinyint(3) unsigned NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  Description varchar(40) NOT NULL default '',
  PRIMARY KEY  (GroupID)
) TYPE=MyISAM;

--
-- Table structure for table `InitialAnalysis`
--

CREATE TABLE InitialAnalysis (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  FileNo int(11) NOT NULL default '0',
  SubNo smallint(6) NOT NULL default '0',
  Prod char(1) NOT NULL default '',
  ReceivedProdDept datetime default NULL,
  AssignedAcctMgr datetime default NULL,
  PostedDate datetime default NULL,
  ReceivedRateDept datetime default NULL,
  AnalysisDate datetime default NULL,
  AssignedGroup datetime default NULL,
  InitialReportDate datetime default NULL,
  Note char(100) default NULL,
  PRIMARY KEY  (DanPK),
  UNIQUE KEY FileSubProd (FileNo,SubNo,Prod)
) TYPE=MyISAM;

--
-- Table structure for table `LineHuntLines`
--

CREATE TABLE LineHuntLines (
  ID mediumint(9) NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Line varchar(10) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY IDX_Line (Line)
) TYPE=MyISAM;

--
-- Table structure for table `LubePosting`
--

CREATE TABLE LubePosting (
  ID int(11) NOT NULL auto_increment,
  FileNo int(11) default NULL,
  SubNo smallint(6) default NULL,
  LocNo smallint(6) default NULL,
  MyDate datetime default NULL,
  InvoiceNo char(25) default NULL,
  Location char(30) default NULL,
  Product char(50) default NULL,
  PackSize decimal(15,4) default NULL,
  UnitMeasure char(20) default NULL,
  PackNo decimal(15,4) default NULL,
  PackPrice decimal(15,4) default NULL,
  Tax decimal(15,4) default NULL,
  Total decimal(15,4) default NULL,
  BatchNo int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `MiscContacts`
--

CREATE TABLE MiscContacts (
  MiscContactID int(10) NOT NULL auto_increment,
  ContactTimestamp timestamp(14) NOT NULL,
  Product char(1) NOT NULL default '',
  Company varchar(80) default '',
  Name varchar(50) default '',
  Title varchar(50) default '',
  Phone int(11) unsigned default '0',
  Fax int(11) unsigned default '0',
  Mobile int(11) unsigned default '0',
  Email varchar(50) default '',
  Location varchar(100) default '',
  WebSite varchar(50) default '',
  PRIMARY KEY  (MiscContactID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileBlocks`
--

CREATE TABLE MobileBlocks (
  BlockID tinyint(2) NOT NULL default '0',
  BlockTimestamp timestamp(14) NOT NULL,
  BlockDesc varchar(15) NOT NULL default '',
  PRIMARY KEY  (BlockID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileCalls`
--

CREATE TABLE MobileCalls (
  CallsID int(20) unsigned NOT NULL auto_increment,
  CallsTimestamp timestamp(14) NOT NULL,
  CallsPlanNo int(20) NOT NULL default '0',
  CallsOptionNo int(20) NOT NULL default '0',
  CallType tinyint(4) NOT NULL default '1',
  CallDay tinyint(2) NOT NULL default '1',
  CallPeriod tinyint(2) NOT NULL default '1',
  CallCapBlock tinyint(2) NOT NULL default '0',
  CallCapDay tinyint(3) unsigned NOT NULL default '0',
  CallCapMins int(4) NOT NULL default '0',
  CallCapRate double NOT NULL default '0',
  CallCap$ double NOT NULL default '0',
  CallCapPeriod tinyint(1) NOT NULL default '0',
  CallBalBlock tinyint(2) NOT NULL default '3',
  CallFF double NOT NULL default '0',
  CallPeak double NOT NULL default '0',
  CallOPeak double NOT NULL default '0',
  PRIMARY KEY  (CallsID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileCalls_BAK`
--

CREATE TABLE MobileCalls_BAK (
  CallsID int(20) unsigned NOT NULL auto_increment,
  CallsTimestamp timestamp(14) NOT NULL,
  CallsPlanNo int(20) NOT NULL default '0',
  CallsOptionNo int(20) NOT NULL default '0',
  CallType tinyint(4) NOT NULL default '1',
  CallDay tinyint(2) NOT NULL default '1',
  CallPeriod tinyint(2) NOT NULL default '1',
  CallCapBlock tinyint(2) NOT NULL default '0',
  CallCapMins tinyint(4) NOT NULL default '0',
  CallCapRate double NOT NULL default '0',
  CallCap$ double NOT NULL default '0',
  CallCapPeriod tinyint(1) NOT NULL default '0',
  CallBalBlock tinyint(2) NOT NULL default '3',
  CallFF double NOT NULL default '0',
  CallPeak double NOT NULL default '0',
  CallOPeak double NOT NULL default '0',
  PRIMARY KEY  (CallsID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileDays`
--

CREATE TABLE MobileDays (
  DaysID tinyint(2) NOT NULL default '1',
  DaysTimestamp timestamp(14) NOT NULL,
  DaysDesc varchar(25) NOT NULL default '',
  PRIMARY KEY  (DaysID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileGroup`
--

CREATE TABLE MobileGroup (
  MobileGroupID int(11) NOT NULL auto_increment,
  MobGroupTimestamp timestamp(14) NOT NULL,
  GroupName varchar(80) NOT NULL default '',
  GroupAccess double NOT NULL default '0',
  GroupCap double NOT NULL default '0',
  GroupPhones smallint(6) NOT NULL default '0',
  GroupPlanID int(11) NOT NULL default '0',
  PRIMARY KEY  (MobileGroupID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileHwareOption`
--

CREATE TABLE MobileHwareOption (
  HwareID int(11) NOT NULL auto_increment,
  PlanNo int(11) NOT NULL default '0',
  OptionNo tinyint(3) unsigned NOT NULL default '0',
  PhoneID int(11) NOT NULL default '0',
  UpFront float NOT NULL default '0',
  ContractTerm int(11) NOT NULL default '0',
  PRIMARY KEY  (HwareID)
) TYPE=MyISAM;

--
-- Table structure for table `MobileOptions`
--

CREATE TABLE MobileOptions (
  OptionID int(20) unsigned NOT NULL auto_increment,
  OptionTimestamp timestamp(14) NOT NULL,
  OptionNo tinyint(4) NOT NULL default '0',
  OptionName varchar(50) NOT NULL default '',
  PlanID int(11) NOT NULL default '0',
  PlanBonus double NOT NULL default '0',
  PlanShare tinyint(1) NOT NULL default '0',
  PlanMates tinyint(2) NOT NULL default '0',
  PlanOwnFixed tinyint(2) NOT NULL default '0',
  PlanOwnMobiles tinyint(1) NOT NULL default '0',
  PlanSMS double NOT NULL default '0',
  PlanSMSIncl tinyint(1) NOT NULL default '0',
  PlanSMSFree int(11) NOT NULL default '0',
  PlanMMS double NOT NULL default '0',
  PlanMMSIncl tinyint(1) NOT NULL default '0',
  PlanMMSFree int(11) NOT NULL default '0',
  PlanVMS double NOT NULL default '0',
  PlanVMSIncl tinyint(1) NOT NULL default '0',
  PlanVMSFree int(11) NOT NULL default '0',
  PlanMEMO double NOT NULL default '0',
  PlanMEMOIncl tinyint(1) NOT NULL default '0',
  PlanMEMOFree int(11) NOT NULL default '0',
  PRIMARY KEY  (OptionID)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePeriods`
--

CREATE TABLE MobilePeriods (
  PeriodID tinyint(2) NOT NULL default '0',
  PeriodTimestamp timestamp(14) NOT NULL,
  PeriodDesc varchar(15) NOT NULL default '',
  PRIMARY KEY  (PeriodID)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePhoneXref`
--

CREATE TABLE MobilePhoneXref (
  MobileXREFID int(11) NOT NULL auto_increment,
  MobileXrefTimestamp timestamp(14) NOT NULL,
  PlanID int(11) NOT NULL default '0',
  OptionID int(11) NOT NULL default '0',
  PhoneID int(11) NOT NULL default '0',
  PRIMARY KEY  (MobileXREFID)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePhones`
--

CREATE TABLE MobilePhones (
  MobilePhoneID int(11) NOT NULL auto_increment,
  MobilePhoneTimestamp timestamp(14) NOT NULL,
  MobileMake varchar(100) NOT NULL default '',
  MobileModel varchar(100) NOT NULL default '',
  MobileFeatures mediumtext NOT NULL,
  PRIMARY KEY  (MobilePhoneID)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePlanCapExclusions`
--

CREATE TABLE MobilePlanCapExclusions (
  MobExclID int(11) NOT NULL default '0',
  MobExclTimestamp timestamp(14) NOT NULL,
  MobExclDesc varchar(25) NOT NULL default '',
  PRIMARY KEY  (MobExclID)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePlanSelections`
--

CREATE TABLE MobilePlanSelections (
  PlanNo int(11) NOT NULL default '0',
  TimeStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (PlanNo)
) TYPE=MyISAM;

--
-- Table structure for table `MobilePlans`
--

CREATE TABLE MobilePlans (
  PlanID int(20) unsigned NOT NULL auto_increment,
  PlanTimestamp timestamp(14) NOT NULL,
  PlanName varchar(100) NOT NULL default '',
  PlanProvider int(3) NOT NULL default '0',
  PlanAccess double NOT NULL default '0',
  PlanAllowance double NOT NULL default '0',
  PlanCap double NOT NULL default '0',
  PlanCapLimit double NOT NULL default '0',
  PlanCapExclusions int(2) NOT NULL default '0',
  PlanCapMiscExclusions int(11) NOT NULL default '0',
  PlanAvailable int(11) NOT NULL default '0',
  GroupAccess double NOT NULL default '0',
  GroupCap double NOT NULL default '0',
  GroupPhones int(1) NOT NULL default '0',
  PRIMARY KEY  (PlanID)
) TYPE=InnoDB;

--
-- Table structure for table `MobilePlans_Lock`
--

CREATE TABLE MobilePlans_Lock (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  UserID smallint(5) unsigned NOT NULL default '0',
  LockDateTime datetime NOT NULL default '0000-00-00 00:00:00',
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB COMMENT='Locks the MobilePlans table';

--
-- Table structure for table `MobilePlans_StateSave`
--

CREATE TABLE MobilePlans_StateSave (
  PlanID int(11) NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  PlanAvailable tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (PlanID)
) TYPE=InnoDB;

--
-- Table structure for table `MobileTypes`
--

CREATE TABLE MobileTypes (
  TypeID tinyint(2) NOT NULL default '0',
  TypeTimestamp timestamp(14) NOT NULL,
  TypeDesc varchar(25) NOT NULL default '',
  PRIMARY KEY  (TypeID)
) TYPE=MyISAM;

--
-- Table structure for table `NonTollingLines`
--

CREATE TABLE NonTollingLines (
  ClientID int(11) NOT NULL default '0',
  AccountNo varchar(20) NOT NULL default '',
  Supplier varchar(50) NOT NULL default '',
  Line varchar(50) NOT NULL default '',
  Required tinyint(4) default '1',
  AnnualService double default '0',
  Actioned date default NULL,
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (Line)
) TYPE=MyISAM;

--
-- Table structure for table `NonTollingLinesActions`
--

CREATE TABLE NonTollingLinesActions (
  ID smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Action varchar(50) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `NonTollingLinesNotes`
--

CREATE TABLE NonTollingLinesNotes (
  ClientID mediumint(8) unsigned NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  ActionDate date default NULL,
  Action smallint(6) NOT NULL default '0',
  Note tinytext NOT NULL,
  PRIMARY KEY  (ClientID)
) TYPE=MyISAM;

--
-- Table structure for table `PhoneTypes`
--

CREATE TABLE PhoneTypes (
  ID int(11) NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  PhoneType varchar(25) default NULL,
  SitRepID tinyint(1) default NULL,
  LocalID tinyint(1) default '0',
  NoLen smallint(2) default '0',
  SitRepDesc varchar(25) default NULL,
  TollingLine tinyint(1) default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `PostCodes`
--

CREATE TABLE PostCodes (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  Pcode smallint(5) unsigned NOT NULL default '0',
  Location varchar(100) default NULL,
  State char(3) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `PostingAllocation`
--

CREATE TABLE PostingAllocation (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Poster smallint(5) unsigned NOT NULL default '0',
  Energy smallint(5) unsigned NOT NULL default '0',
  Gas smallint(5) unsigned NOT NULL default '0',
  Fuel smallint(5) unsigned NOT NULL default '0',
  Telecom smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `RecoLocations`
--

CREATE TABLE RecoLocations (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  RecoNo mediumint(8) unsigned NOT NULL default '0',
  LocID mediumint(8) unsigned NOT NULL default '0',
  BillsIn tinyint(4) default '0',
  PRIMARY KEY  (ID),
  KEY IDX_LocID (LocID)
) TYPE=MyISAM;

--
-- Table structure for table `SiteLines`
--

CREATE TABLE SiteLines (
  DanPK int(10) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo smallint(5) unsigned NOT NULL default '0',
  AccountNo varchar(20) NOT NULL default '',
  ProviderID smallint(5) unsigned NOT NULL default '0',
  Line varchar(20) NOT NULL default '',
  LineType varchar(5) default '',
  SiteNo smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (DanPK),
  KEY IDX_FileSub (FileNo,SubNo),
  KEY IDX_AccountNo (AccountNo)
) TYPE=InnoDB;

--
-- Table structure for table `States`
--

CREATE TABLE States (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  State char(3) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `SupplierLineTypes`
--

CREATE TABLE SupplierLineTypes (
  ID mediumint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  SupplierID smallint(5) unsigned NOT NULL default '0',
  LineTypeID smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `TLocations`
--

CREATE TABLE TLocations (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  ClientID int(10) unsigned default '0',
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo tinyint(3) unsigned NOT NULL default '0',
  LocNo tinyint(3) unsigned NOT NULL default '0',
  Prod char(1) NOT NULL default 'T',
  Fixed tinyint(4) default '0',
  Mobile tinyint(4) default '0',
  Internet tinyint(4) default '0',
  ProviderID smallint(5) unsigned default '0',
  AccountNo varchar(20) NOT NULL default '',
  Data mediumint(8) unsigned default '0',
  Active tinyint(1) NOT NULL default '1',
  DateSetUp date default NULL,
  DateAnalysed date default NULL,
  ProjectedAnnual double NOT NULL default '0',
  ProjectedAnnual_Fixed double NOT NULL default '0',
  ProjectedAnnual_Mobile double NOT NULL default '0',
  PRIMARY KEY  (DanPK),
  UNIQUE KEY IDX_AccountNo (AccountNo),
  KEY IDX_ClientID (ClientID),
  KEY IDX_FileNo_SubNo (FileNo,SubNo)
) TYPE=InnoDB;

--
-- Table structure for table `TelecomAccountPosting`
--

CREATE TABLE TelecomAccountPosting (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  LocID mediumint(8) unsigned NOT NULL default '0',
  TimeStamp timestamp(14) NOT NULL,
  BatchNo mediumint(8) unsigned NOT NULL default '0',
  AccountNo varchar(20) NOT NULL default '',
  InvDate date NOT NULL default '0000-00-00',
  ServiceFrom date default NULL,
  ServiceTo date default NULL,
  Service double default '0',
  OtherCharges double default '0',
  GroupPlanDiscounts double default '0',
  MobileVolumeDiscounts double default '0',
  TotalBill double default '0',
  GST double default '0',
  GSTRemoved tinyint(1) NOT NULL default '0',
  Selector tinyint(1) unsigned NOT NULL default '0',
  Incomplete tinyint(4) NOT NULL default '0',
  LastThree tinyint(1) NOT NULL default '0',
  LastOne tinyint(1) default '0',
  PRIMARY KEY  (DanPK),
  KEY IDX_AccountNo (AccountNo),
  KEY IDX_LocID (LocID),
  KEY IDX_LastThree (LastThree),
  KEY IDX_LastOne (LastOne),
  KEY IDX_BatchNo (BatchNo),
  CONSTRAINT `0_21` FOREIGN KEY (`LocID`) REFERENCES `TLocations` (`DanPK`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `TelecomLinePosting`
--

CREATE TABLE TelecomLinePosting (
  DanPK mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  TelecomLinePostingID mediumint(9) unsigned NOT NULL default '0',
  Line varchar(30) NOT NULL default '',
  LineType smallint(5) unsigned default '0',
  AnsweringPoints varchar(255) default NULL,
  Plan varchar(20) default '',
  PlanAdjust double default '0',
  Service double NOT NULL default '0',
  Local double NOT NULL default '0',
  LocalNo mediumint(5) unsigned NOT NULL default '0',
  National double NOT NULL default '0',
  NationalNo mediumint(5) unsigned NOT NULL default '0',
  International double NOT NULL default '0',
  InternationalNo mediumint(5) unsigned NOT NULL default '0',
  Mobile double NOT NULL default '0',
  MobileNo mediumint(5) unsigned NOT NULL default '0',
  Data double NOT NULL default '0',
  DataNo mediumint(5) unsigned NOT NULL default '0',
  AEnd text,
  BEnd mediumint(8) unsigned default '0',
  OtherCalls double NOT NULL default '0',
  OtherCharges double NOT NULL default '0',
  Discount double default '0',
  PRIMARY KEY  (DanPK),
  KEY IDX_Plan (Plan),
  KEY IDX_TelecomLinePostingID (TelecomLinePostingID),
  KEY IDX_Line (Line),
  KEY IDX_LineType (LineType),
  KEY IDX_Line_LineType (Line,LineType),
  CONSTRAINT `0_17` FOREIGN KEY (`TelecomLinePostingID`) REFERENCES `TelecomAccountPosting` (`DanPK`) ON DELETE CASCADE
) TYPE=InnoDB;

--
-- Table structure for table `TestItems`
--

CREATE TABLE TestItems (
  ItemNo smallint(5) unsigned NOT NULL default '0',
  Quantity int(10) unsigned NOT NULL default '0',
  Commodity smallint(5) unsigned NOT NULL default '0',
  Rate double NOT NULL default '0',
  Unit smallint(5) unsigned NOT NULL default '0',
  Charge double NOT NULL default '0',
  ID mediumint(8) unsigned NOT NULL auto_increment,
  TestNameID mediumint(8) unsigned NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `TestName`
--

CREATE TABLE TestName (
  TestID smallint(5) unsigned NOT NULL auto_increment,
  TestName varchar(50) NOT NULL default '',
  TestDate date NOT NULL default '0000-00-00',
  Seconds int(10) unsigned NOT NULL default '0',
  Selector tinyint(1) NOT NULL default '0',
  MyStamp timestamp(14) NOT NULL,
  PRIMARY KEY  (TestID)
) TYPE=MyISAM;

--
-- Table structure for table `Title_Integration`
--

CREATE TABLE Title_Integration (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  TitleTxt varchar(100) NOT NULL default '',
  TitleID smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `Titles`
--

CREATE TABLE Titles (
  ID smallint(5) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  Title varchar(50) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `_cached_LinesNotTolling`
--

CREATE TABLE _cached_LinesNotTolling (
  ID mediumint(8) unsigned NOT NULL auto_increment,
  MyStamp timestamp(14) NOT NULL,
  ClientID int(10) unsigned NOT NULL default '0',
  FileNo mediumint(8) unsigned NOT NULL default '0',
  SubNo smallint(5) unsigned NOT NULL default '0',
  LocID mediumint(10) unsigned NOT NULL default '0',
  AccountNo varchar(50) NOT NULL default '',
  Supplier smallint(5) unsigned default NULL,
  Line varchar(50) NOT NULL default '',
  PhoneType varchar(50) default NULL,
  CityState varchar(20) NOT NULL default '',
  Exchange varchar(50) NOT NULL default '',
  AnnualService double NOT NULL default '0',
  MaxOfInvDate date default NULL,
  LastServiceAmount double NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_LocID (LocID),
  KEY IDX_Line (Line)
) TYPE=MyISAM;

--
-- Table structure for table `tmp_25_Email`
--

CREATE TABLE tmp_25_Email (
  ID tinyint(3) unsigned NOT NULL auto_increment,
  Subject varchar(100) default NULL,
  Body text,
  Sender varchar(100) default NULL,
  Recipients text,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table `tmp_LatestFollowUps`
--

CREATE TABLE tmp_LatestFollowUps (
  ID bigint(20) default NULL,
  ClientID int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

SET FOREIGN_KEY_CHECKS = 1;