-- MySQL dump 10.11
--
-- Host: localhost    Database: ib_dev
-- ------------------------------------------------------
-- Server version	5.0.37-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tblAccountActivity`
--

DROP TABLE IF EXISTS `tblAccountActivity`;
CREATE TABLE `tblAccountActivity` (
  `UserModified` char(16) default NULL,
  `DateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ActivityNo` int(11) NOT NULL auto_increment,
  `UserID` int(11) NOT NULL default '0',
  `ComponentID` char(20) NOT NULL default '',
  `Description` char(255) default NULL,
  `Credit` decimal(10,2) default '0.00',
  `Debit` decimal(10,2) default '0.00',
  `eDate` date default '0000-00-00',
  `Source` tinyint(4) default NULL,
  `CheckNo` char(10) default NULL,
  `Taxed` enum('0','-1') NOT NULL default '0',
  `Tax` enum('0','-1') NOT NULL default '0',
  `Invoiced` enum('0','-1') default '0',
  `InvoiceNo` int(11) default NULL,
  PRIMARY KEY  (`ActivityNo`),
  KEY `tax` (`Tax`),
  KEY `UserID` (`UserID`),
  KEY `ComponentID` (`ComponentID`),
  KEY `InvoiceNo` (`InvoiceNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;

--
-- Table structure for table `tblCustomer`
--

DROP TABLE IF EXISTS `tblCustomer`;
CREATE TABLE `tblCustomer` (
  `UserModified` varchar(15) default NULL,
  `DateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `CustomerID` int(11) NOT NULL auto_increment,
  `CompanyName` varchar(100) default NULL,
  `ContactFirstName` varchar(50) default NULL,
  `ContactLastName` varchar(50) default NULL,
  `BillAddress1` varchar(50) default NULL,
  `BillAddress2` varchar(50) default NULL,
  `BillCity` varchar(30) default NULL,
  `Dealer` tinyint(4) default NULL,
  `BillRegion` varchar(30) default NULL,
  `BillPostalCode` varchar(50) default NULL,
  `BillCountry` varchar(30) default NULL,
  `MobilPhone` varchar(50) default NULL,
  `WorkPhone` varchar(50) default NULL,
  `HomePhone` varchar(50) default NULL,
  `Fax` varchar(50) default NULL,
  `Email` varchar(50) default NULL,
  `BillingMethod` tinyint(4) NOT NULL default '2',
  `SalesDiscount` double(4,2) NOT NULL default '0.00',
  `SalesPerson` varchar(30) default NULL,
  `Reference` int(11) default NULL,
  `Notes` text,
  `Domain` varchar(50) default NULL,
  `Tax` enum('0','-1') default '-1',
  `Contract` enum('0','-1') default '0',
  `TaxID` tinyint(4) NOT NULL default '1',
  `PrintInvoice` enum('0','-1') default '-1',
  `NoBill` enum('-1','0') default '-1',
  `ShitDebit` double(10,2) default '0.00',
  `ContactAddress` varchar(50) NOT NULL default '',
  `ContactName` varchar(50) NOT NULL default '',
  `ContactCity` varchar(50) NOT NULL default '',
  `ContactRegion` varchar(50) NOT NULL default '',
  `ContactContry` varchar(50) NOT NULL default '',
  `ContactZip` varchar(50) NOT NULL default '',
  `Penalty` tinyint(4) NOT NULL default '0',
  `EMailInvoices` tinyint(4) NOT NULL default '0',
  `EMailReminder` tinyint(4) NOT NULL default '0',
  `Debtor` enum('-1','0') NOT NULL default '0',
  PRIMARY KEY  (`CustomerID`),
  KEY `IDX2` (`Dealer`),
  KEY `K1` (`CustomerID`,`TaxID`)
) ENGINE=MyISAM AUTO_INCREMENT=4814 DEFAULT CHARSET=utf8 PACK_KEYS=1;

--
-- Table structure for table `tblUser`
--

DROP TABLE IF EXISTS `tblUser`;
CREATE TABLE `tblUser` (
  `UserModified` varchar(15) default NULL,
  `DateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `CustomerID` int(11) NOT NULL default '0',
  `UsersFullName` varchar(30) default NULL,
  `HostName` varchar(20) NOT NULL default '',
  `ShellName` varchar(20) default NULL,
  `ShellType` tinyint(4) default NULL,
  `SignupDate` date default '0000-00-00',
  `ActivationDate` date default '0000-00-00',
  `ClosedDate` date default NULL,
  `Closed` enum('0','-1') default '0',
  `PartialPaymentMade` enum('0','-1') default '0',
  `TmpClosed` enum('0','-1') default '0',
  `TmpClosedDate` date default NULL,
  `TmpOpenDate` date default NULL,
  `TmpNotes` varchar(100) default NULL,
  `UserID` int(11) NOT NULL auto_increment,
  `Test` enum('-1','0') default '0',
  `Remove` enum('0','-1') default '-1',
  `StudentNo` varchar(50) default NULL,
  PRIMARY KEY  (`UserID`),
  KEY `CustomerID` (`CustomerID`),
  KEY `Hostname` (`HostName`)
) ENGINE=MyISAM AUTO_INCREMENT=7735 DEFAULT CHARSET=utf8 PACK_KEYS=1;

--
-- Table structure for table `tblBillingPlanComponent`
--

DROP TABLE IF EXISTS `tblBillingPlanComponent`;
CREATE TABLE `tblBillingPlanComponent` (
  `UserModified` char(16) default NULL,
  `DateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ComponentID` char(20) NOT NULL default '',
  `PlanID` char(10) NOT NULL default '',
  `Description` char(255) default NULL,
  `Type` char(15) default NULL,
  `MonthsPerCharge` tinyint(4) default '1',
  `Units` decimal(4,2) default NULL,
  `UnitDesc` char(5) default NULL,
  `PricePerUnit` decimal(10,2) default NULL,
  `UnitsIncluded` decimal(4,2) default NULL,
  `MaxCharge` decimal(10,2) default NULL,
  `AccruePer` char(15) default NULL,
  `ProRate` enum('0','-1') default '0',
  `Notes` char(255) default NULL,
  PRIMARY KEY  (`ComponentID`),
  KEY `planID` (`PlanID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-03-22  9:17:26