-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.12


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema oncs
--

CREATE DATABASE IF NOT EXISTS oncs;
USE oncs;

--
-- Definition of table `tblAccountHolder`
--

DROP TABLE IF EXISTS `tblAccountHolder`;
CREATE TABLE `tblAccountHolder` (
  `AccHolderId` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(45) default NULL,
  `Address` varchar(45) default NULL,
  `PhoneNumber` varchar(45) default NULL,
  `EmailAddress` varchar(45) default NULL,
  PRIMARY KEY  (`AccHolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `tblAccountHolder`
--

/*!40000 ALTER TABLE `tblAccountHolder` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblAccountHolder` ENABLE KEYS */;


--
-- Definition of table `tblMacAddress`
--

DROP TABLE IF EXISTS `tblMacAddress`;
CREATE TABLE `tblMacAddress` (
  `MacAddress` varchar(17) NOT NULL default '',
  `AccHolderId` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`MacAddress`,`AccHolderId`),
  KEY `idxMacAddress` (`MacAddress`),
  KEY `idxAccHolderId` (`AccHolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblMacAddress`
--

/*!40000 ALTER TABLE `tblMacAddress` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblMacAddress` ENABLE KEYS */;


--
-- Definition of table `tblPayment`
--

DROP TABLE IF EXISTS `tblPayment`;
CREATE TABLE `tblPayment` (
  `AccHolderId` int(10) unsigned NOT NULL default '0',
  `PaymentAmount` decimal(10,0) NOT NULL default '0',
  `DT` datetime NOT NULL default '0000-00-00 00:00:00',
  `PaymentId` int(10) unsigned NOT NULL auto_increment,
  `Reference` text NOT NULL,
  PRIMARY KEY  (`PaymentId`),
  KEY `idxAccHolderId` (`AccHolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblPayment`
--

/*!40000 ALTER TABLE `tblPayment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblPayment` ENABLE KEYS */;


--
-- Definition of table `tblSessionRequest`
--

DROP TABLE IF EXISTS `tblSessionRequest`;
CREATE TABLE `tblSessionRequest` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `MACAddress` varchar(17) NOT NULL default '',
  `IPAddress` varchar(15) NOT NULL default '',
  `SessionStart` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`),
  KEY `idxMACAddress` (`MACAddress`),
  KEY `idxIPAddress` (`IPAddress`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblSessionRequest`
--

/*!40000 ALTER TABLE `tblSessionRequest` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblSessionRequest` ENABLE KEYS */;


--
-- Definition of table `tblUsage`
--

DROP TABLE IF EXISTS `tblUsage`;
CREATE TABLE `tblUsage` (
  `UsageId` int(10) unsigned NOT NULL auto_increment,
  `DT` datetime NOT NULL default '0000-00-00 00:00:00',
  `SessionId` int(10) unsigned NOT NULL default '0',
  `Usage` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`UsageId`),
  KEY `idxSessionId` (`SessionId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblUsage`
--

/*!40000 ALTER TABLE `tblUsage` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblUsage` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;