SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `admins` (
  `adminid` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `username` varchar(200) NOT NULL default '',
  `password` varchar(200) NOT NULL default '',
  `email` varchar(200) NOT NULL default '',
  `notes` text NOT NULL,
  PRIMARY KEY  (`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

INSERT INTO `admins` (`adminid`, `name`, `username`, `password`, `email`, `notes`) VALUES
(1, 'iCDBILL Install Administrator', 'icdbill.admin', 'admin', 'you@yourdomain.com', 'This your install administrator.');

CREATE TABLE IF NOT EXISTS `clients` (
  `clientid` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `company` varchar(200) NOT NULL default '',
  `username` varchar(200) NOT NULL default '',
  `password` varchar(200) NOT NULL default '',
  `address` varchar(200) NOT NULL default '',
  `city` varchar(200) NOT NULL default '',
  `province` varchar(200) NOT NULL default '',
  `postalcode` varchar(200) NOT NULL default '',
  `country` varchar(200) NOT NULL default '',
  `bphone` varchar(200) NOT NULL default '',
  `bfax` varchar(200) NOT NULL default '',
  `mobile` varchar(200) NOT NULL default '',
  `email` varchar(200) NOT NULL default '',
  `notes` text NOT NULL,
  `status` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`clientid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `details` (
  `detailid` int(11) NOT NULL auto_increment,
  `invoiceid` varchar(200) NOT NULL default '',
  `serialnumber` varchar(200) NOT NULL default '',
  `itemid` varchar(200) NOT NULL default '',
  `sell` varchar(200) NOT NULL default '',
  `quantity` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`detailid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `events` (
  `eventid` int(11) NOT NULL auto_increment,
  `clientid` varchar(200) NOT NULL default '',
  `adminid` varchar(200) NOT NULL default '',
  `type` varchar(200) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `start` time NOT NULL default '00:00:00',
  `complete` time NOT NULL default '00:00:00',
  `description` text NOT NULL,
  `status` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `invoices` (
  `invoiceid` int(11) NOT NULL auto_increment,
  `clientid` varchar(200) NOT NULL default '',
  `notes` text NOT NULL,
  `discount` varchar(200) NOT NULL default '',
  `status` varchar(200) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `duedate` date NOT NULL default '0000-00-00',
  `tax` varchar(200) NOT NULL default '',
  `author` varchar(200) NOT NULL default '',
  `subtotal` varchar(200) NOT NULL default '',
  `received` varchar(200) NOT NULL default '',
  `warranty` varchar(200) NOT NULL default '',
  `notified` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`invoiceid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `items` (
  `itemid` int(11) NOT NULL auto_increment,
  `type` varchar(200) NOT NULL default '',
  `warranty` varchar(200) NOT NULL default '',
  `sku` varchar(200) NOT NULL default '',
  `partnumber` varchar(200) NOT NULL default '',
  `name` varchar(200) NOT NULL default '',
  `cost` varchar(200) NOT NULL default '',
  `sell` varchar(200) NOT NULL default '',
  `description` text NOT NULL,
  `status` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `logs` (
  `logid` int(11) NOT NULL auto_increment,
  `result` varchar(200) NOT NULL default '',
  `ipaddress` varchar(200) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  `username` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`logid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `payments` (
  `paymentid` int(11) NOT NULL auto_increment,
  `invoiceid` varchar(200) NOT NULL default '',
  `amount` varchar(200) NOT NULL default '',
  `method` varchar(200) NOT NULL default '',
  `rdate` date NOT NULL default '0000-00-00',
  `reference` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`paymentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;