version_20090310_install.sql

-- Amberdms initial database creation SQL.
--
--



--
-- AMBERDMS BILLING SYSTEM VERSION 1.0.0
--

CREATE DATABASE `billing_system` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `billing_system`;


-- 
-- Table structure for table `account_ap`
-- 

CREATE TABLE `account_ap` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `vendorid` int(11) NOT NULL default '0',
  `employeeid` int(11) NOT NULL default '0',
  `dest_account` int(11) NOT NULL default '0',
  `code_invoice` varchar(255) NOT NULL default '',
  `code_ordernumber` varchar(255) NOT NULL default '',
  `code_ponumber` varchar(255) NOT NULL default '',
  `date_due` date NOT NULL default '0000-00-00',
  `date_trans` date NOT NULL default '0000-00-00',
  `date_create` date NOT NULL default '0000-00-00',
  `amount_total` decimal(11,2) NOT NULL default '0.00',
  `amount_tax` decimal(11,2) NOT NULL default '0.00',
  `amount` decimal(11,2) NOT NULL default '0.00',
  `amount_paid` decimal(11,2) NOT NULL default '0.00',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_ap`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_ar`
-- 

CREATE TABLE `account_ar` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `customerid` int(11) NOT NULL default '0',
  `employeeid` int(11) NOT NULL default '0',
  `dest_account` int(11) NOT NULL default '0',
  `code_invoice` varchar(255) NOT NULL default '',
  `code_ordernumber` varchar(255) NOT NULL default '',
  `code_ponumber` varchar(255) NOT NULL default '',
  `date_due` date NOT NULL default '0000-00-00',
  `date_trans` date NOT NULL default '0000-00-00',
  `date_create` date NOT NULL default '0000-00-00',
  `date_sent` date NOT NULL default '0000-00-00',
  `sentmethod` varchar(10) NOT NULL default '',
  `amount_total` decimal(11,2) NOT NULL default '0.00',
  `amount_tax` decimal(11,2) NOT NULL default '0.00',
  `amount` decimal(11,2) NOT NULL default '0.00',
  `amount_paid` decimal(11,2) NOT NULL default '0.00',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_ar`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_chart_menu`
-- 

CREATE TABLE `account_chart_menu` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(50) NOT NULL default '',
  `groupname` varchar(50) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `account_chart_menu`
-- 

INSERT INTO `account_chart_menu` (`id`, `value`, `groupname`, `description`) VALUES (1, 'ar_summary_account', 'Accounts Receivables', 'Account to file all unpaid AR transactions/invoices too.'),
(2, 'ar_income', 'Accounts Receivables', 'Use this account to record income.'),
(3, 'tax_summary_account', 'Tax', 'Use this account for sales taxes.'),
(7, 'ap_summary_account', 'Accounts Payable', 'Account to file all unpaid AP transactions/invoices too.'),
(6, 'ar_payment', 'Accounts Receivables', 'Allow payments made by customers to be placed into this account'),
(8, 'ap_expense', 'Accounts Payable', 'Use this account for AP expenses'),
(9, 'ap_payment', 'Accounts Payable', 'Allow invoice payments to be taken from this account'),
(10, 'ap_expense_employeewages', 'Accounts Payable', 'Use this account for paying staff wages/expenses');

-- --------------------------------------------------------

-- 
-- Table structure for table `account_chart_type`
-- 

CREATE TABLE `account_chart_type` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(20) NOT NULL default '',
  `total_mode` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `account_chart_type`
-- 

INSERT INTO `account_chart_type` (`id`, `value`, `total_mode`) VALUES (1, 'Heading', ''),
(2, 'Asset', 'debit'),
(3, 'Liability', 'credit'),
(4, 'Equity', ''),
(5, 'Income', 'credit'),
(6, 'Expense', 'debit');

-- --------------------------------------------------------

-- 
-- Table structure for table `account_chart_types_menus`
-- 

CREATE TABLE `account_chart_types_menus` (
  `id` int(11) NOT NULL auto_increment,
  `menuid` int(11) NOT NULL,
  `chart_typeid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `account_chart_types_menus`
-- 

INSERT INTO `account_chart_types_menus` (`id`, `menuid`, `chart_typeid`) VALUES (1, 6, 2),
(2, 9, 2),
(3, 1, 2),
(4, 8, 2),
(5, 3, 3),
(6, 9, 3),
(7, 7, 3),
(8, 2, 5),
(9, 8, 6);

-- --------------------------------------------------------

-- 
-- Table structure for table `account_charts`
-- 

CREATE TABLE `account_charts` (
  `id` int(11) NOT NULL auto_increment,
  `code_chart` int(11) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `chart_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

-- 
-- Dumping data for table `account_charts`
-- 

INSERT INTO `account_charts` (`id`, `code_chart`, `description`, `chart_type`) VALUES (1, 1000, 'CURRENT ASSETS', 1),
(2, 1060, 'Current Account', 2),
(3, 1061, 'Savings Account', 2),
(5, 1065, 'Petty Cash', 2),
(6, 1200, 'Accounts Receivables', 2),
(7, 1205, 'Allowance for doubtful accounts', 2),
(8, 1500, 'INVENTORY ASSETS', 1),
(9, 1520, 'Inventory / General', 2),
(10, 1530, 'Inventory / Aftermarket Parts', 2),
(11, 1800, 'CAPITAL ASSETS', 1),
(12, 1820, 'Computer Equipment', 2),
(13, 2000, 'CURRENT LIABILITIES', 1),
(14, 2100, 'Accounts Payable', 3),
(15, 2110, 'Reimburse to Staff', 3),
(16, 2310, 'Sales Tax (GST)', 3),
(17, 4000, 'SALES REVENUE', 1),
(18, 4020, 'Sales / General', 5),
(19, 4021, 'Sales / Internet Services', 5),
(20, 4022, 'Sales / Webdevelopment', 5),
(21, 4023, 'Sales / Computer Hardware', 5),
(22, 4024, 'Sales / Server Support', 5),
(23, 4300, 'CONSULTING REVENUE', 1),
(24, 4320, 'Consulting', 5),
(25, 4400, 'OTHER REVENUE', 1),
(26, 4440, 'Interest', 5),
(28, 4460, 'Captial Investment', 4),
(29, 5000, 'COST OF GOODS SOLD', 1),
(30, 5010, 'Consulting Expenses', 6),
(31, 5020, 'Parts Purchased', 6),
(32, 5600, 'GENERAL & ADMINISTRATIVE EXPENSES', 1),
(33, 5610, 'Accounting & Legal', 6),
(34, 5611, 'Shareholder/Employee Withdrawals', 6),
(35, 5612, 'Webhosting', 6),
(36, 5615, 'Advertising & Promotions', 6),
(37, 5620, 'Bad Debts', 6),
(38, 5680, 'Taxes', 6),
(39, 5681, 'Withholding Tax', 6),
(40, 5685, 'Insurance', 6),
(41, 5690, 'Interest & Bank Charges', 6),
(42, 5700, 'Office Supplies', 6),
(43, 5760, 'Rent', 6),
(44, 5765, 'Repair & Maintenance', 6),
(45, 5785, 'Travel & Entertainment', 6),
(46, 5790, 'Utilities', 6),
(47, 5800, 'Colocation Hosting', 6),
(48, 5810, 'Foreign Exchange Loss', 6),
(49, 5820, 'Training/Conferences', 6),
(50, 5830, 'Shipping', 6),
(51, 1840, 'Furniture', 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `account_charts_menus`
-- 

CREATE TABLE `account_charts_menus` (
  `id` int(11) NOT NULL auto_increment,
  `chartid` int(11) NOT NULL default '0',
  `menuid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

-- 
-- Dumping data for table `account_charts_menus`
-- 

INSERT INTO `account_charts_menus` (`id`, `chartid`, `menuid`) VALUES (1, 2, 6),
(2, 2, 9),
(3, 3, 6),
(4, 3, 9),
(7, 5, 6),
(8, 5, 9),
(9, 6, 1),
(10, 12, 8),
(11, 14, 7),
(12, 15, 9),
(13, 16, 3),
(14, 18, 2),
(15, 19, 2),
(16, 20, 2),
(17, 21, 2),
(18, 22, 2),
(19, 24, 2),
(20, 30, 8),
(21, 31, 8),
(22, 33, 8),
(23, 34, 8),
(24, 35, 8),
(25, 36, 8),
(26, 40, 8),
(27, 42, 8),
(28, 43, 8),
(29, 44, 8),
(30, 45, 8),
(31, 46, 8),
(32, 47, 8),
(33, 49, 8),
(34, 50, 8),
(35, 10, 8);

-- --------------------------------------------------------

-- 
-- Table structure for table `account_gl`
-- 

CREATE TABLE `account_gl` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `code_gl` varchar(255) NOT NULL default '',
  `date_trans` date NOT NULL default '0000-00-00',
  `employeeid` int(11) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_gl`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_items`
-- 

CREATE TABLE `account_items` (
  `id` int(11) NOT NULL auto_increment,
  `invoiceid` int(11) NOT NULL default '0',
  `invoicetype` varchar(6) NOT NULL default '',
  `type` varchar(10) NOT NULL default '',
  `customid` int(11) NOT NULL default '0',
  `chartid` int(11) NOT NULL default '0',
  `quantity` float NOT NULL default '0',
  `units` varchar(10) NOT NULL default '',
  `amount` decimal(11,2) NOT NULL default '0.00',
  `price` decimal(11,2) NOT NULL default '0.00',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_items`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_items_options`
-- 

CREATE TABLE `account_items_options` (
  `id` int(11) NOT NULL auto_increment,
  `itemid` int(11) NOT NULL default '0',
  `option_name` varchar(20) NOT NULL default '',
  `option_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_items_options`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_quotes`
-- 

CREATE TABLE `account_quotes` (
  `id` int(11) NOT NULL auto_increment,
  `customerid` int(11) NOT NULL default '0',
  `employeeid` int(11) NOT NULL default '0',
  `code_quote` varchar(255) NOT NULL default '',
  `date_trans` date NOT NULL default '0000-00-00',
  `date_validtill` date NOT NULL default '0000-00-00',
  `date_create` date NOT NULL default '0000-00-00',
  `date_sent` date NOT NULL default '0000-00-00',
  `sentmethod` varchar(10) NOT NULL default '',
  `amount_total` decimal(11,2) NOT NULL default '0.00',
  `amount_tax` decimal(11,2) NOT NULL default '0.00',
  `amount` decimal(11,2) NOT NULL default '0.00',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_quotes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_taxes`
-- 

CREATE TABLE `account_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `name_tax` varchar(255) NOT NULL default '',
  `chartid` int(11) NOT NULL default '0',
  `taxrate` float NOT NULL default '0',
  `taxnumber` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_taxes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `account_trans`
-- 

CREATE TABLE `account_trans` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(6) NOT NULL default '',
  `customid` int(11) NOT NULL default '0',
  `chartid` int(11) NOT NULL default '0',
  `date_trans` date NOT NULL default '0000-00-00',
  `amount_debit` decimal(11,2) NOT NULL default '0.00',
  `amount_credit` decimal(11,2) NOT NULL default '0.00',
  `source` varchar(255) NOT NULL default '',
  `memo` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `account_trans`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `billing_cycles`
-- 

CREATE TABLE `billing_cycles` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `billing_cycles`
-- 

INSERT INTO `billing_cycles` (`id`, `name`, `description`) VALUES (1, 'monthly', 'Bill the customer every month since the start date'),
(2, '6monthly', 'Bill the customer every 6 months since the start date.'),
(3, 'yearly', 'Bill the customer once a year on the start date');

-- --------------------------------------------------------

-- 
-- Table structure for table `billing_modes`
-- 

CREATE TABLE `billing_modes` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `billing_modes`
-- 

INSERT INTO `billing_modes` (`id`, `name`, `description`) VALUES (1, 'periodend', 'Service is billed after it has been delivered.'),
(2, 'periodadvance', 'Service is billed in advance (before the service period has started)'),
(3, 'monthend', 'Service is billed after it has been delivered, with every period ending on the last day of the month.'),
(4, 'monthadvance', 'Service is billed in advance of the month beginning. The billing period will always end on the last date of the month.');

-- --------------------------------------------------------

-- 
-- Table structure for table `config`
-- 

CREATE TABLE `config` (
  `name` varchar(255) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `config`
-- 

INSERT INTO `config` (`name`, `value`) VALUES ('BLACKLIST_ENABLE', 'enabled'),
('BLACKLIST_LIMIT', '10'),
('JOURNAL_LOCK', '0'),
('UPLOAD_MAXBYTES', '5242880'),
('DATA_STORAGE_METHOD', 'database'),
('DATA_STORAGE_LOCATION', 'use_database'),
('ACCOUNTS_TERMS_DAYS', '20'),
('ACCOUNTS_AR_INVOICENUM', '100'),
('ACCOUNTS_INVOICE_LOCK', '0'),
('ACCOUNTS_AP_INVOICENUM', '100'),
('ACCOUNTS_GL_TRANSNUM', '100'),
('ACCOUNTS_QUOTES_NUM', '100'),
('ACCOUNTS_SERVICES_ADVANCEBILLING', '28'),
('CODE_CUSTOMER', '100'),
('CODE_VENDOR', '100'),
('CODE_PRODUCT', '100'),
('CODE_PROJECT', '100'),
('APP_PDFLATEX', '/usr/bin/pdflatex'),
('CODE_ACCOUNT', '1000'),
('CURRENCY_DEFAULT_NAME', 'NZD'),
('CURRENCY_DEFAULT_SYMBOL', '$'),
('COMPANY_NAME', 'Example Ltd'),
('COMPANY_ADDRESS1_STREET', '54a Stallman Lane\r\nFreeburbs'),
('COMPANY_ADDRESS1_CITY', 'Example City'),
('COMPANY_ADDRESS1_STATE', ''),
('COMPANY_ADDRESS1_COUNTRY', 'Example Country'),
('COMPANY_ADDRESS1_ZIPCODE', '0000'),
('COMPANY_CONTACT_PHONE', '00-11-111-1111'),
('COMPANY_CONTACT_FAX', '00-11-111-1112'),
('COMPANY_CONTACT_EMAIL', 'accounts@example.com'),
('COMPANY_PAYMENT_DETAILS', 'Please pay all invoices by direct transfer to XX-XXXX-XXXXXXX.'),
('ACCOUNTS_GL_LOCK', '0'),
('TIMESHEET_LOCK', '0'),
('TIMESHEET_BOOKTOFUTURE', 'disabled'),
('EMAIL_ENABLE', 'enabled'),
('ACCOUNTS_INVOICE_AUTOEMAIL', 'disabled'),
('DATEFORMAT', 'yyyy-mm-dd'),
('TIMEZONE_DEFAULT', 'SYSTEM'),
('SUBSCRIPTION_SUPPORT', 'none'),
('SUBSCRIPTION_ID', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `customers`
-- 

CREATE TABLE `customers` (
  `id` int(11) NOT NULL auto_increment,
  `code_customer` varchar(50) NOT NULL default '',
  `name_customer` varchar(255) NOT NULL default '',
  `name_contact` varchar(255) NOT NULL default '',
  `contact_email` varchar(255) NOT NULL default '',
  `contact_phone` varchar(255) NOT NULL default '',
  `contact_fax` varchar(255) NOT NULL default '',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `tax_number` varchar(255) NOT NULL default '0',
  `tax_default` int(11) NOT NULL default '0',
  `address1_street` varchar(255) NOT NULL default '',
  `address1_city` varchar(255) NOT NULL default '',
  `address1_state` varchar(255) NOT NULL default '',
  `address1_country` varchar(255) NOT NULL default '',
  `address1_zipcode` int(11) NOT NULL default '0',
  `address2_street` varchar(255) NOT NULL default '',
  `address2_city` varchar(255) NOT NULL default '',
  `address2_state` varchar(255) NOT NULL default '',
  `address2_country` varchar(255) NOT NULL default '',
  `address2_zipcode` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `customers`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `customers_taxes`
-- 

CREATE TABLE `customers_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `customerid` int(11) NOT NULL,
  `taxid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `customers_taxes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `file_upload_data`
-- 

CREATE TABLE `file_upload_data` (
  `id` int(11) NOT NULL auto_increment,
  `fileid` int(11) NOT NULL default '0',
  `data` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Table for use as database-backed file storage system' AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `file_upload_data`
-- 

INSERT INTO `file_upload_data` (`id`, `fileid`, `data`) VALUES (1, 1, 0x89504e470d0a1a0a0000000d49484452000000e60000003c080600000072cfc6f2000000017352474200aece1ce900000006624b474400ff00ff00ffa0bda793000000097048597300000b1300000b1301009a9c180000000774494d4507d9020e042b117833b6530000001d74455874436f6d6d656e7400437265617465642077697468205468652047494d50ef64256e00000d8f4944415478daed9d797c54d515c7bf93494236b2635248248190088100098802e206855aa8b6b5e2820b5494b2a9b5556955dc5aa46e154141ad45a4b4a8a82d582c08d45a10646b58c222c8d64022842064b22ffde34c78efcd4c26992c24d0f3fd7cde27b9efbdb9f7bdfbeeef9d73cfbd73c756b3861a14456953f86915288a0a53511415a6a2a830154551612a8a0a53511415a6a2a830154551612a8aa2c2541415a6a228cd817fab961e9c0601510d3fbfa606ce6cd0a7d65406e641609c91fe7a1a1c7ef69c5f46fc8f20bfd048cf180f8fdcdaf2e54e7811e62d35d259a9b0699e0ad320e50588f9be0fc2ac82cffc5558ff47acd8082b3619e9e8f6f0ab316a3115a55559b7135e78d748778efbff10a6f63115452d6603d8f9132fae6cb53e314585d92a1c7fbf61e705c643cacb60b31bfbf217c1890face7450c8184a9d67d07a643f14e67a76504440d87d01e10942c41117ba8049a2a4f42f15e38b50a8ece83f2639eaf25ed2df00f375dc74228580e17ff12e2ee907c2b4f42c15238f038941f95f3427b43d263107935d8c3a0f490dcffe1195075c6bd9cd437acc1b2fc8570622974bc17be330e42d2811a706c83dcd720ffeda63f8f8038c93f6a1884a4817f24541541c93e38b91c726743c5f1666f062f2c862f7220e7a04bf33805374eb7ee9bfc43b8aa8f91aeaa8257ff0a6ffd1d720e41803ff4498189d7c3ad4355982d4b799e8826e951635fd450d8b811ca8e38ef2e12ba2f84a044e39cbc05862801127f0151d7bae76f03022f922d7230243c08393749637425f607101063a48b7743e2431071b9e94572117ce7a710fd7dd83a10daf7976bf30b30ce09e9069da741f47761eb60a82e75296794359aead8091d2741b44b6b0b1f205bd450d87d27d0484f237e1c749b0df660970e501404f487f0fe90f0809471e2c3667dbc5fe4c0927fb9ef2f2e73df3fd254cda5e570fdafad01a3f24a58bb43b64fbe84a04015a6ef448fa8fb58c93ed96a39f804445e25c201f08f804be643f650b11cdde6584559bc07f64ef4ee2a579d81ea0a0888069ba90bee1f063dde852f53ebb69cb5243c00f610cfc7dac543fafb10dad32a4a33edb3a0d37d7064a6f772121f14eb5ea7b0c688f53cf29cefcfa1e324489dedbebfe2a4d473ada7e2df1ed2df836dd741e18a566f3e0fcdb58ad29577564268900ad3773296d77dece0932246c369815db740bfff18162bea1a48b80fca8e419c6950acaa14768e866a8735cfb2a3926fc1c7e0d86e5829bf20881905697f90c6572bce8e13e0e074eff7600f8192fd707826541543d274b186678597297fbf5d0bb9af827f14749961940372edf509d31e0a8e5d70e0517183c30738f331b9d5494fc0b137a0f254c39f41bb8b6528cbcc8965b0770294e7827f0ca4bd0e1d7ee4f42eec524f1bba424d79b334833b87c3653d64b864e566935314e61e95ed9f267ff7e7c29c8facc7e2a2e0d97b20a38bb8b58fbc0eb92754982d4fd97f61f758e8f537635ff20c773770ffcfc191edfef9dd7778ceb7ba148ebf071183ad7dd48821f55f535509fce71a283becb4c41590bed8c5faef87ec61505d62b8ba498f1bc743d391a0b91737b4ca21de416d9fb56833547c2316ccfc92e870231c7bd3076b790ff8b533f982f990331aaa8b255d5900bb6e972e807f84ec0b4a80d81be0f8bbcdf258470d84514051895598e1a1f08bd19e3fb3600554bb2c2db7e44918d44bfecf4c859ec990399e36bf02dd85318e59b0148efc1e12ef7736c620d9ce460c96c0d1d7bcd442944c7468df0fda75164be4e7ec880425b9589384faafe7e4724394b57d4e57f21618a20428dae6d2c7b58be5f366e90afe6e88f2ecbd7e081585d62051f8e5be0933f26af72e44cc751efaf9f986306b3fd74cc26c54bf74a74b4c2ed110652d7d52a05f1a6cdca3c2f48dec615efa985fd77deceb8721f20ae99f593e7310f6dcedc53a4c842e33c54d6d08f6069ce7c871b16c451eced9eed2bfadf41080aae7f114eff26446454801fd4d2f934ebe3d83a0ced674c420d9ea7581135ab5e9b8baa869899ecfbbe46215a6ef147edabcf9d9ecd4398f226614a4cef1e01e1f35862b0262ad11579badfe325dfbb19edc51d7e190ba0241dea8a9a863bf4b3fcfe663deb646360b7b58ab369d0a97775b601db71118409be7c29992d7f577eed612242a7bc95bb0e306f7639da658d3a58724ba586cb278c9cf40e75fb7cd7b0eecd8b0fd15053eb6f013d66199c2d590ff4efd9f2bcf6bd5ea880987af728df4d13a6efba8067fced513192591d8b306aa1caacb8c2867ecf5d0692ae4ceb27e2ee4126b3a7fa155940061596df7bea3470076715fcdf7149c6c3daf28dbb77ccf6c72069f9c04c440defc7aac6c208d1e2ff5d640eddeada299de29b0dee4dd6fda2313123a441afb4e3be0f36d6dbf49b7bdb9b25d9ff7be057575e9d724cad8a599038fc157935df27d0ec2fa7aefd785f6b6a63bdc04d1c3dbeed30b4e8694170d5735a003a47908f214fcd5b77cf3ffe4f272ea0d9d1f43665db85ae778997c3160bfb8fdcd4c6c848bb52b807756c8d0c8c13cd96ab961b08b01af847133e18c3398ec2881bb9f83a252b598be93f8a0f7e305cba0747f6da706ba2f92c90067ddae7fc291e7e5ed1d731d5ce48cadfb05428fc5b039d308c67cbbd66a5d624742e67a38bd11825344940de953b626095365da5ff93108ee621de60099b2e7d8e1633f7fa58c5bc68e34b9f44f41dc18f8f67319a6f18f86b00c9928616bb9f7fb80eeeefbee98e1f27e5d237f87f797ef566ede6b1c5bb65ebef799140f87f2c1711e88b26d5a4c5f487ed298f5035071ca3a056def0428350d5b847483d4b946faf06fa49199091f000993216684cc6fcd5fd476ef3f7f91dc734024847677176559aed44163d8751b9c7409c485a4cab4c284a932ab282ca3454509d0b79b08ae41312b1b2c9806112e93a18acb647281a314126261e4652acc9623f25ab8789a75df5793ace38795a76420dcfcad94b8db207eacf389ed96e199620fb1f3d31b60eb1550f255dbad03c77699537b7aa307abb70ab60c721fe76c2855a761db70d8331e8abc58dc8a4238fe11ecba5382462dc0874fc3e37740cf240869e7fddc1e49f0ef578cd940668665c1ba39d0a943db6fde36fd193ee7fb29ac0f04779555128a733c4f0a686dbc2d0912d243be2153e3fc764973bf5002e3e5db2bb5dd86ca4219572e3dd822419fe660c701d875480248195da06ba7f3a745ea0a06200dab688b6ce72bc539ee11e5e6a43cafd587437ca567b26ce7a9a950144585a9288abab21714d9c3ad53f7cafeab75a2c2545a1d47b6d681bab28aa2a830154551612a8a0a53511415a6a2a830150b61df6b997c23479ebf7532e14558bbdd7bdd0c9ce4b90ecdff9bcf51612ae79caaaa0beb7ed6e7c85294de5837a7fe7c1a728e0af31cf0bb3fc3ac25f2ff03b3e19a07e4ffd55be0b6679a7edcccfc4fe0d20990314e9637dcb8dbfad6feed4218f033e87a2b2c5d074f2f80cb2642f2cdb0ec0b6b5e0fcf83be7743d63d70c0b436f4378570ddc3d06bac94b1798fb58c69af43bf7be1b36cf95cd63d92cf4373ddad7243afe7f7ef43ea18e8fd535953d5956f0a61e43448bf4bee7dcd56d97f280f064d966b1d3c45d28d297fd721484d00bbdd7bdd34c4d370b5a4cf2e9267967c337c6c2a737faed46f6ddd9d8fde469b16e61519c632109bf6c81aa31595b26f4846d38f9bb961307c3917b6bd05f31f81c92f5b2d58a758d8f01abcf704dcfc14a47482f5afc292a7acc2a9aa9286b8f54df9ad8cfb4d8b994f7d45d644ddfe47787b9ab878b55456c984eb4df3e09a4cf9dcc4eb259fb444282b6fdcf53cf5b69c97fd0778f476f73a9e320baeec0d3be7cb3959a9c6fe71df936b1d3b42aebd31e52fdf00232eadbf6e1ae35524749067b6783afcd254e6fdb3e1fe1ba59c9ec9d6ba5361360359a922a8d30e68170897a74bfaf3ed22baa61e37b3fbb058d49e63e51bf2e61fb3b1d9e016e7cf9b64a6427535dc749591765df4a9f6dcdb86c9ef65d4b26a33fcfc55e87337dcfe5b38695a28cf06fcf84a23fdefedd67ccc0b29f8723d837ac29d33e04f2bddd7cf01f874334cf881916f78a8e7f2cdf7e14bf9ffd86808d35bddf88acd06a39dcbdf5edadd5ae6da1d70a3b32e475fddf617a1f0449b9e921718009de3c5cd1c980e195dc5d5da970bdd3b4b8537e5b89931bf81b71f9105824bcb217a94e9ede5675df2b05da0e19af942750dac9b0d211e7e3bc36e6ff88fddf8723d1f3d03abb7c2e235f0c74fe0d317dc1bb8cf6ff306965f5c0aa78aa063f32f05849f9ffc8a9737e16a1fb325ddd95ef0fc6218d25bfe9ffb37e89b62547c538fd772a6585c23803796c9f78d1bcb62e71a347f590d834d2b815f9b09f3965afb5f7531b897359fc65e4fee0918d60f9e9b00d9fbdc8f0fcd923a0129e3b4c3e846d496ffe75562797d65cd56b8ba6fc3eaa63919d8d3f845b0f73f6bdab354617ae9671e2b80cb7b405cb45815b31bda94e3e6f0fbcc7b61c87dd0ff5e283c2356a031d8edb0e788041e662d81974c65ccbe0f566d91404bfa5db07065ddf9bc34095ef940f2c939d8f8ebb9e56909fc5c3155eed1f5be674d1101a5df252ef616e7c2072f4f81373f96e0cf9b1f4bda57967f697563bdd54d73f2d224f97dcdccf1b0751f84069f7fc2d4a54594162373bc048802ce7187a9a44c5ec0361b7cf02f98fd21ac7e49fb988a02c096375aa7dc1d0764fdd88a4a086e271170b5988aa25cf87d4c4551612a8aa2c254144585a9282a4c455154988aa2c25414a565f91f99f595c2321aea960000000049454e44ae426082);

-- --------------------------------------------------------

-- 
-- Table structure for table `file_uploads`
-- 

CREATE TABLE `file_uploads` (
  `id` int(11) NOT NULL auto_increment,
  `customid` int(11) NOT NULL default '0',
  `type` varchar(20) NOT NULL default '',
  `timestamp` bigint(20) unsigned NOT NULL default '0',
  `file_name` varchar(255) NOT NULL default '',
  `file_size` varchar(255) NOT NULL default '',
  `file_location` char(2) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `file_uploads`
-- 

INSERT INTO `file_uploads` (`id`, `customid`, `type`, `timestamp`, `file_name`, `file_size`, `file_location`) VALUES (1, 0, 'COMPANY_LOGO', 1234659343, 'company_logo.png', '3640', 'db');

-- --------------------------------------------------------

-- 
-- Table structure for table `journal`
-- 

CREATE TABLE `journal` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `journalname` varchar(50) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `userid` int(11) NOT NULL default '0',
  `customid` int(11) NOT NULL default '0',
  `timestamp` bigint(20) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `journalname` (`journalname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `journal`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `language`
-- 

CREATE TABLE `language` (
  `id` int(11) NOT NULL auto_increment,
  `language` varchar(20) NOT NULL default '',
  `label` varchar(255) NOT NULL default '',
  `translation` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `language` (`language`),
  KEY `label` (`label`)
) ENGINE=MyISAM AUTO_INCREMENT=272 DEFAULT CHARSET=latin1 AUTO_INCREMENT=272 ;

-- 
-- Dumping data for table `language`
-- 

INSERT INTO `language` (`id`, `language`, `label`, `translation`) VALUES (1, 'en_us', 'name_customer', 'Customer Name'),
(2, 'en_us', 'name_contact', 'Contact Name'),
(4, 'en_us', 'customer_view', 'Customer Details'),
(5, 'en_us', 'address_billing', 'Billing Address'),
(6, 'en_us', 'address_shipping', 'Shipping Address'),
(7, 'en_us', 'id_customer', 'Customer ID'),
(8, 'en_us', 'submit', 'Save Information'),
(9, 'en_us', 'username_amberdms_bs', 'Username'),
(10, 'en_us', 'password_amberdms_bs', 'Password'),
(11, 'en_us', 'name_staff', 'Employee Name'),
(12, 'en_us', 'filter_date_start', 'Start Date'),
(13, 'en_us', 'filter_date_end', 'End Date'),
(14, 'en_us', 'filter_employee_id', 'Employee'),
(15, 'en_us', 'filter_customerid', 'Customer'),
(16, 'en_us', 'filter_hide_closed', 'Hide Options'),
(17, 'en_us', 'code_invoice', 'Invoice Number'),
(18, 'en_us', 'code_ordernumber', 'Order Number'),
(19, 'en_us', 'code_ponumber', 'PO Number'),
(20, 'en_us', 'date_trans', 'Transaction Date'),
(21, 'en_us', 'date_due', 'Date Due'),
(22, 'en_us', 'amount_tax', 'Amount of Tax'),
(23, 'en_us', 'amount_total', 'Total Amount'),
(24, 'en_us', 'amount_paid', 'Amount Paid'),
(25, 'en_us', 'sent', 'Sent'),
(26, 'en_us', 'filter_employeeid', 'Employee'),
(27, 'en_us', 'amount', 'Amount'),
(28, 'en_us', 'customerid', 'Customer'),
(29, 'en_us', 'employeeid', 'Employee'),
(30, 'en_us', 'dest_account', 'Destination Account'),
(31, 'en_us', 'notes', 'Notes/Details'),
(32, 'en_us', 'ar_invoice_details', 'AR Invoice Details'),
(33, 'en_us', 'ar_invoice_financials', 'AR Invoice Financials'),
(34, 'en_us', 'ar_invoice_other', 'AR Invoice Additional Details'),
(35, 'en_us', 'item_info', 'Item Information'),
(36, 'en_us', 'price', 'Price'),
(37, 'en_us', 'qnty', 'Qnty'),
(38, 'en_us', 'quantity', 'Quantity'),
(39, 'en_us', 'units', 'Units'),
(40, 'en_us', 'description', 'Description'),
(41, 'en_us', 'name_tax', 'Tax Name'),
(42, 'en_us', 'chartid', 'Account'),
(43, 'en_us', 'ar_invoice_item', 'AR Invoice Item Details'),
(44, 'en_us', 'timegroupid', 'Time Group'),
(45, 'en_us', 'productid', 'Product'),
(46, 'en_us', 'account', 'Account'),
(47, 'en_us', 'source', 'Source'),
(48, 'en_us', 'filter_title_search', 'Search Title'),
(49, 'en_us', 'filter_content_search', 'Search Content'),
(50, 'en_us', 'filter_hide_events', 'Hide Options'),
(51, 'en_us', 'ar_invoice_delete', 'Delete AR Invoice'),
(52, 'en_us', 'name_vendor', 'Vendor Name'),
(53, 'en_us', 'filter_vendorid', 'Vendor'),
(54, 'en_us', 'ap_invoice_details', 'AP Invoice Details'),
(55, 'en_us', 'ap_invoice_financials', 'AP Invoice Financials'),
(56, 'en_us', 'ap_invoice_other', 'AP Invoice Additional Details'),
(57, 'en_us', 'ap_invoice_item', 'AP Invoice Item Details'),
(58, 'en_us', 'ap_invoice_delete', 'Delete AP Invoice'),
(59, 'en_us', 'quote_details', 'Quote Details'),
(60, 'en_us', 'quote_other', 'Quote Additional Details'),
(61, 'en_us', 'quotes_invoice_item', 'Quote Item Details'),
(62, 'en_us', 'quote_delete', 'Delete Quote'),
(63, 'en_us', 'quote_convert_details', 'AR Invoice Details'),
(64, 'en_us', 'quote_invoice_financials', 'AR Invoice Financials'),
(65, 'en_us', 'journal_edit', 'Journal Entry Details'),
(66, 'en_us', 'title', 'Entry Title'),
(67, 'en_us', 'contents', 'Entry Content/Details'),
(68, 'en_us', 'upload', 'File to Upload'),
(69, 'en_us', 'code_quote', 'Quote Number'),
(70, 'en_us', 'delete_confirm', 'Confirm Deletion'),
(71, 'en_us', 'date_validtill', 'Expiry Date'),
(72, 'en_us', 'taxrate', 'Tax Rate'),
(73, 'en_us', 'taxnumber', 'Tax Number'),
(74, 'en_us', 'tax_details', 'Tax Details'),
(75, 'en_us', 'tax_delete', 'Delete Tax'),
(76, 'en_us', 'filter_mode', 'Mode'),
(77, 'en_us', 'code_chart', 'Account ID'),
(78, 'en_us', 'chart_type', 'Account Type'),
(79, 'en_us', 'debit', 'Debit'),
(80, 'en_us', 'credit', 'Credit'),
(81, 'en_us', 'chart_details', 'Account Details'),
(82, 'en_us', 'chart_delete', 'Delete Account'),
(83, 'en_us', 'memo', 'Memo/Details'),
(84, 'en_us', 'item_id', 'Transaction ID'),
(85, 'en_us', 'code_reference', 'Transaction ID'),
(86, 'en_us', 'filter_search', 'Search'),
(87, 'en_us', 'general_ledger_transaction_details', 'GL Transaction Details'),
(88, 'en_us', 'code_gl', 'Transaction ID'),
(89, 'en_us', 'filter_searchbox', 'Search'),
(90, 'en_us', 'code_customer', 'Customer ID'),
(91, 'en_us', 'contact_phone', 'Phone Number'),
(92, 'en_us', 'contact_email', 'Email Address'),
(93, 'en_us', 'contact_fax', 'Fax Number'),
(94, 'en_us', 'date_start', 'Start Date'),
(95, 'en_us', 'date_end', 'End Date'),
(96, 'en_us', 'tax_number', 'Tax Number'),
(97, 'en_us', 'address1_street', 'Street'),
(98, 'en_us', 'address1_city', 'City'),
(99, 'en_us', 'address1_state', 'State'),
(100, 'en_us', 'address1_country', 'Country'),
(101, 'en_us', 'address1_zipcode', 'Zipcode'),
(102, 'en_us', 'address2_street', 'Street'),
(103, 'en_us', 'address2_city', 'City'),
(104, 'en_us', 'address2_state', 'State'),
(105, 'en_us', 'address2_country', 'Country'),
(106, 'en_us', 'address2_zipcode', 'Zipcode'),
(107, 'en_us', 'filter_hide_ex_customers', 'Hide Options'),
(108, 'en_us', 'tax_default', 'Default Tax'),
(109, 'en_us', 'customer_taxes', 'Customer Tax Options'),
(110, 'en_us', 'name_service', 'Service Name'),
(111, 'en_us', 'active', 'Active'),
(112, 'en_us', 'typeid', 'Type'),
(113, 'en_us', 'date_period_next', 'Next Period'),
(114, 'en_us', 'label', 'translation'),
(115, 'en_us', 'service_edit', 'Service Details'),
(116, 'en_us', 'service_add', 'Service Details'),
(117, 'en_us', 'service_billing', 'Service Billing Details'),
(118, 'en_us', 'customer_delete', 'Delete Customer'),
(119, 'en_us', 'name_service', 'Service Name'),
(120, 'en_us', 'active', 'Active'),
(121, 'en_us', 'typeid', 'Type'),
(122, 'en_us', 'date_period_next', 'Next Period'),
(123, 'en_us', 'label', 'translation'),
(124, 'en_us', 'service_edit', 'Service Details'),
(125, 'en_us', 'service_add', 'Service Details'),
(126, 'en_us', 'service_billing', 'Service Billing Details'),
(127, 'en_us', 'customer_delete', 'Delete Customer'),
(128, 'en_us', 'paid', 'Paid'),
(129, 'en_us', 'invoiced', 'Invoiced'),
(130, 'en_us', 'service_delete', 'Delete Service'),
(131, 'en_us', 'code_vendor', 'Vendor ID'),
(132, 'en_us', 'filter_hide_ex_vendors', 'Hide Options'),
(133, 'en_us', 'vendor_taxes', 'Vendor Tax Options'),
(134, 'en_us', 'vendor_view', 'Vendor Details'),
(135, 'en_us', 'vendor_delete', 'Delete Vendor'),
(136, 'en_us', 'staff_code', 'Employee ID'),
(137, 'en_us', 'staff_position', 'Employee Position'),
(138, 'en_us', 'filter_hide_ex_employees', 'Hide Options'),
(139, 'en_us', 'staff_view', 'Employee Details'),
(140, 'en_us', 'staff_delete', 'Delete Employee'),
(141, 'en_us', 'code_product', 'Product ID'),
(142, 'en_us', 'name_product', 'Product Name'),
(143, 'en_us', 'account_sales', 'Sales Account'),
(144, 'en_us', 'price_cost', 'Cost Price'),
(145, 'en_us', 'price_sale', 'Sale Price'),
(146, 'en_us', 'date_current', 'Current Date'),
(147, 'en_us', 'quantity_instock', 'Quantity Instock'),
(148, 'en_us', 'paid', 'Paid'),
(149, 'en_us', 'invoiced', 'Invoiced'),
(150, 'en_us', 'service_delete', 'Delete Service'),
(151, 'en_us', 'code_vendor', 'Vendor ID'),
(152, 'en_us', 'filter_hide_ex_vendors', 'Hide Options'),
(153, 'en_us', 'vendor_taxes', 'Vendor Tax Options'),
(154, 'en_us', 'vendor_view', 'Vendor Details'),
(155, 'en_us', 'vendor_delete', 'Delete Vendor'),
(156, 'en_us', 'staff_code', 'Employee ID'),
(157, 'en_us', 'staff_position', 'Employee Position'),
(158, 'en_us', 'filter_hide_ex_employees', 'Hide Options'),
(159, 'en_us', 'staff_view', 'Employee Details'),
(160, 'en_us', 'staff_delete', 'Delete Employee'),
(161, 'en_us', 'code_product', 'Product ID'),
(162, 'en_us', 'name_product', 'Product Name'),
(163, 'en_us', 'account_sales', 'Sales Account'),
(164, 'en_us', 'price_cost', 'Cost Price'),
(165, 'en_us', 'price_sale', 'Sale Price'),
(166, 'en_us', 'date_current', 'Current Date'),
(167, 'en_us', 'quantity_instock', 'Quantity Instock'),
(168, 'en_us', 'quantity_vendor', 'Vendor''s Stock Quantity'),
(169, 'en_us', 'product_view', 'Product Details'),
(170, 'en_us', 'product_pricing', 'Product Pricing'),
(171, 'en_us', 'product_quantity', 'Product Stock'),
(172, 'en_us', 'product_supplier', 'Supplier Details'),
(173, 'en_us', 'code_product_vendor', 'Vendor Product ID'),
(174, 'en_us', 'product_delete', 'Delete Product'),
(175, 'en_us', 'included_units', 'Units Included'),
(176, 'en_us', 'price_extraunits', 'Price (per extra unit)'),
(177, 'en_us', 'billing_cycle', 'Billing Cycle'),
(178, 'en_us', 'service_details', 'Service Details'),
(179, 'en_us', 'service_plan', 'Service Plan Details'),
(180, 'en_us', 'service_plan_custom', 'Service Plan Options'),
(181, 'en_us', 'billing_mode', 'Billing Mode'),
(182, 'en_us', 'code_project', 'Project ID'),
(183, 'en_us', 'filter_hide_ex_projects', 'Hide Options'),
(184, 'en_us', 'details', 'details'),
(185, 'en_us', 'project_view', 'Project Details'),
(186, 'en_us', 'name_phase', 'Phase Name'),
(187, 'en_us', 'phase_edit', 'Phase Details'),
(188, 'en_us', 'date', 'Date'),
(189, 'en_us', 'time_group', 'Time Group'),
(190, 'en_us', 'time_booked', 'Time Booked'),
(191, 'en_us', 'filter_phaseid', 'Phase Name'),
(192, 'en_us', 'phaseid', 'Phase Name'),
(193, 'en_us', 'timereg_day', 'Day Time Booking'),
(194, 'en_us', 'filter_no_group', 'Hide Options'),
(195, 'en_us', 'time_billed', 'Billable Hours'),
(196, 'en_us', 'time_not_billed', 'Unbillable Hours'),
(197, 'en_us', 'timebilled_details', 'Time Group Details'),
(198, 'en_us', 'timebilled_selected', 'Time Group Registered Hours'),
(199, 'en_us', 'name_group', 'Time Group Name'),
(200, 'en_us', 'time_bill', 'Billable'),
(201, 'en_us', 'time_nobill', 'Unbillable'),
(202, 'en_us', 'project_delete', 'Delete Project'),
(203, 'en_us', 'name_project', 'Project Name'),
(204, 'en_us', 'projectandphase', 'Project/Phase'),
(205, 'en_us', 'priority', 'Priority'),
(206, 'en_us', 'filter_hide_ex_tickets', 'Hide Options'),
(207, 'en_us', 'status', 'Status'),
(208, 'en_us', 'code_support_ticket', 'Ticket ID'),
(209, 'en_us', 'support_ticket_details', 'Ticket Details'),
(210, 'en_us', 'support_ticket_status', 'Ticket Status'),
(211, 'en_us', 'support_delete', 'Delete Ticket'),
(212, 'en_us', 'username', 'Username'),
(213, 'en_us', 'realname', 'Realname'),
(214, 'en_us', 'password', 'Password'),
(215, 'en_us', 'password_confirm', 'Password - Confirm'),
(216, 'en_us', 'time', 'Time'),
(217, 'en_us', 'ipaddress', 'IP Address'),
(218, 'en_us', 'option_lang', 'Languages'),
(219, 'en_us', 'option_debug', 'Debugging'),
(220, 'en_us', 'user_view', 'User Details'),
(221, 'en_us', 'user_password', 'User Authentication'),
(222, 'en_us', 'user_info', 'User Information'),
(223, 'en_us', 'user_options', 'Account Options'),
(224, 'en_us', 'lastlogin_time', 'Lastlogin Time'),
(225, 'en_us', 'lastlogin_ipaddress', 'Lastlogin IP Address'),
(226, 'en_us', 'id_user', 'User ID'),
(227, 'en_us', 'user_permissions', 'User Permissions'),
(228, 'en_us', 'user_permissions_staff', 'User Staff Access Rights'),
(229, 'en_us', 'user_delete', 'Delete User Account'),
(230, 'en_us', 'blacklist_control', 'Blacklist Options'),
(231, 'en_us', 'blacklist_enable', 'Enable Blacklisting'),
(232, 'en_us', 'blacklist_limit', 'Max authentication attempts'),
(233, 'en_us', 'date_period_first', 'First Period'),
(234, 'en_us', 'option_dateformat', 'Date Format'),
(235, 'en_us', 'option_timezone', 'Timezone'),
(236, 'en_us', 'general_ledger_transaction_rows', 'GL Transaction Rows'),
(237, 'en_us', 'vendorid', 'Vendor'),
(238, 'en_us', 'tax_setup_options', 'Tax Setup Options'),
(239, 'en_us', 'ar_invoice_item_tax', 'AR Invoice Item Tax Selection'),
(240, 'en_us', 'ap_invoice_item_tax', 'AP Invoice Item Tax Selection'),
(241, 'en_us', 'instance_amberdms_bs', 'Customer Instance ID'),
(242, 'en_us', 'user_permissions_selectstaff', 'User Staff Configuration'),
(243, 'en_us', 'id_staff', 'Employee'),
(244, 'en_us', 'auditlock', 'Audit Locking'),
(245, 'en_us', 'date_lock', 'Lock Before'),
(246, 'en_us', 'content', 'Content'),
(247, 'en_us', 'content', 'Content'),
(248, 'en_us', 'option_shrink_tableoptions', 'Table Options Feature'),
(249, 'en_us', 'option_concurrent_logins', 'Concurrent Logins'),
(250, 'en_us', 'tbl_lnk_details', 'details'),
(251, 'en_us', 'tbl_lnk_permissions', 'permissions'),
(252, 'en_us', 'tbl_lnk_staffaccess', 'staffaccess'),
(253, 'en_us', 'tbl_lnk_timesheet', 'timesheet'),
(254, 'en_us', 'tbl_lnk_view_timeentry', 'View Time Entry'),
(255, 'en_us', 'date_as_of', 'Date as of'),
(256, 'en_us', 'mode', 'Mode'),
(257, 'en_us', 'service_tax', 'Service Tax'),
(258, 'en_us', 'usage_mode', 'Usage Mode'),
(259, 'en_us', 'serviceid', 'Service Plan'),
(260, 'en_us', 'timebilled_selection', 'Time Selection'),
(261, 'en_us', 'filter_groupby', 'Group By'),
(262, 'en_us', 'sender', 'Sender'),
(263, 'en_us', 'subject', 'Subject'),
(264, 'en_us', 'email_to', 'Email (To)'),
(265, 'en_us', 'email_message', 'Email Message'),
(266, 'en_us', 'email_cc', 'Email (CC)'),
(267, 'en_us', 'email_bcc', 'Email (BCC)'),
(268, 'en_us', 'account_purchase', 'Purchase Account'),
(269, 'en_us', 'description_useall', 'Description Useall'),
(270, 'en_us', 'general_ledger_transaction_submit', 'GL Transaction Submit'),
(271, 'en_us', 'invoice_gen_date', 'Invoice Gen Date');

-- --------------------------------------------------------

-- 
-- Table structure for table `language_avaliable`
-- 

CREATE TABLE `language_avaliable` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `language_avaliable`
-- 

INSERT INTO `language_avaliable` (`id`, `name`) VALUES (1, 'en_us');

-- --------------------------------------------------------

-- 
-- Table structure for table `menu`
-- 

CREATE TABLE `menu` (
  `id` int(11) NOT NULL auto_increment,
  `priority` int(11) NOT NULL default '0',
  `parent` varchar(50) NOT NULL default '',
  `topic` varchar(50) NOT NULL default '',
  `link` varchar(50) NOT NULL default '',
  `permid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=167 DEFAULT CHARSET=latin1 AUTO_INCREMENT=167 ;

-- 
-- Dumping data for table `menu`
-- 

INSERT INTO `menu` (`id`, `priority`, `parent`, `topic`, `link`, `permid`) VALUES (1, 210, 'Customers', 'View Customers', 'customers/customers.php', 3),
(2, 220, 'Customers', 'Add Customer', 'customers/add.php', 4),
(6, 300, 'top', 'Vendors/Suppliers', 'vendors/vendors.php', 5),
(4, 1, 'top', 'Overview', 'home.php', 0),
(5, 200, 'top', 'Customers', 'customers/customers.php', 3),
(13, 100, 'top', 'Accounts', 'accounts/accounts.php', 0),
(14, 500, 'top', 'Products/Services/Projects', 'products/main.php', 0),
(15, 700, 'top', 'Time Keeping', 'timekeeping/timekeeping.php', 17),
(16, 800, 'top', 'Support Tickets', 'support/support.php', 9),
(7, 400, 'top', 'Human Resources', 'hr/staff.php', 7),
(12, 211, 'View Customers', '', 'customers/view.php', 0),
(17, 310, 'Vendors/Suppliers', 'View Vendors', 'vendors/vendors.php', 5),
(18, 320, 'Vendors/Suppliers', 'Add Vendor', 'vendors/add.php', 6),
(19, 311, 'View Vendors', '', 'vendors/view.php', 5),
(24, 810, 'Support Tickets', 'View Tickets', 'support/support.php', 9),
(26, 510, 'Products/Services/Projects', 'Products', 'products/products.php', 11),
(21, 410, 'Human Resources', 'View Staff', 'hr/staff.php', 7),
(22, 420, 'Human Resources', 'Add Staff', 'hr/staff-add.php', 8),
(23, 411, 'View Staff', '', 'hr/staff-view.php', 7),
(25, 820, 'Support Tickets', 'Add Ticket', 'support/add.php', 10),
(27, 511, 'Products', 'View Products', 'products/products.php', 11),
(28, 512, 'Products', 'Add Product', 'products/add.php', 12),
(29, 501, 'Products/Services/Projects', '', 'products/main.php', 0),
(30, 514, 'Products', '', 'products/products.php', 11),
(31, 520, 'Products/Services/Projects', 'Services', 'services/services.php', 13),
(32, 521, 'Services', '', 'services/services.php', 13),
(33, 522, 'Services', 'View Services', 'services/services.php', 13),
(34, 523, 'View Services', '', 'services/view.php', 13),
(35, 524, 'Services', 'Add Service', 'services/add.php', 14),
(36, 513, 'View Products', '', 'products/view.php', 11),
(37, 530, 'Products/Services/Projects', 'Projects', 'projects/projects.php', 15),
(38, 531, 'Projects', '', 'projects/projects.php', 15),
(39, 533, 'View Projects', '', 'projects/view.php', 15),
(40, 534, 'Projects', 'Add Project', 'projects/add.php', 16),
(41, 532, 'Projects', 'View Projects', 'projects/projects.php', 15),
(42, 701, 'Time Keeping', '', 'timekeeping/timekeeping.php', 17),
(43, 710, 'Time Keeping', 'Time Registration', 'timekeeping/timereg.php', 17),
(44, 720, 'Time Keeping', 'Unbilled Time', 'timekeeping/unbilled.php', 32),
(46, 535, 'View Projects', '', 'projects/phases.php', 15),
(47, 536, 'View Projects', '', 'projects/timebooked.php', 15),
(48, 900, 'top', 'Admin', 'admin/admin.php', 2),
(49, 910, 'Admin', 'User Management', 'user/users.php', 2),
(58, 916, 'View Users', '', 'user/user-staffaccess.php', 2),
(51, 930, 'Admin', 'Brute-Force Blacklist', 'admin/blacklist.php', 2),
(52, 901, 'Admin', '', 'admin/admin.php', 2),
(53, 911, 'User Management', '', 'user/users.php', 2),
(54, 912, 'User Management', 'View Users', 'user/users.php', 2),
(55, 913, 'User Management', 'Add User', 'user/user-add.php', 2),
(56, 914, 'View Users', '', 'user/user-view.php', 2),
(57, 915, 'View Users', '', 'user/user-permissions.php', 2),
(60, 811, 'View Tickets', '', 'support/view.php', 9),
(61, 213, 'View Customers', '', 'customers/journal.php', 3),
(62, 214, 'View Customers', '', 'customers/journal-edit.php', 3),
(63, 812, 'View Tickets', '', 'support/journal.php', 9),
(64, 812, 'View Tickets', '', 'support/journal-edit.php', 9),
(65, 312, 'View Vendors', '', 'vendors/journal.php', 5),
(66, 313, 'View Vendors', '', 'vendors/journal-edit.php', 5),
(67, 412, 'View Staff', '', 'hr/staff-journal.php', 7),
(68, 413, 'View Staff', '', 'hr/staff-journal-edit.php', 7),
(69, 917, 'View Users', '', 'user/user-journal.php', 2),
(70, 918, 'View Users', '', 'user/user-journal-edit.php', 2),
(71, 537, 'View Projects', '', 'projects/journal.php', 15),
(72, 538, 'View Projects', '', 'projects/journal-edit.php', 15),
(73, 514, 'View Products', '', 'products/journal.php', 11),
(74, 514, 'View Products', '', 'products/journal-edit.php', 11),
(75, 101, 'Accounts', '', 'accounts/accounts.php', 0),
(76, 110, 'Accounts', 'Chart of Accounts', 'accounts/charts/charts.php', 18),
(77, 111, 'Chart of Accounts', 'View Accounts', 'accounts/charts/charts.php', 18),
(78, 112, 'Chart of Accounts', 'Add Account', 'accounts/charts/add.php', 19),
(79, 113, 'View Accounts', '', 'accounts/charts/view.php', 18),
(80, 916, 'View Users', '', 'user/user-staffaccess-edit.php', 2),
(81, 120, 'Accounts', 'Accounts Receivables', 'accounts/ar/ar.php', 20),
(82, 122, 'Accounts Receivables', 'Add Invoice', 'accounts/ar/invoice-add.php', 21),
(84, 121, 'Accounts Receivables', 'View Invoices', 'accounts/ar/ar.php', 20),
(85, 140, 'Accounts', 'Taxes', 'accounts/taxes/taxes.php', 22),
(86, 141, 'Taxes', 'View Taxes', 'accounts/taxes/taxes.php', 22),
(87, 142, 'View Taxes', '', 'accounts/taxes/view.php', 22),
(88, 143, 'Taxes', 'Add Taxes', 'accounts/taxes/add.php', 23),
(89, 124, 'View Invoices', '', 'accounts/ar/invoice-view.php', 20),
(90, 124, 'View Invoices', '', 'accounts/ar/journal-edit.php', 20),
(94, 124, 'View Invoices', '', 'accounts/ar/invoice-items.php', 20),
(91, 124, 'View Invoices', '', 'accounts/ar/journal.php', 20),
(92, 113, 'View Accounts', '', 'accounts/charts/ledger.php', 18),
(93, 124, 'View Invoices', '', 'accounts/ar/invoice-payments.php', 20),
(125, 122, 'Accounts Receivables', '', 'accounts/ar/invoice-delete.php', 21),
(96, 142, 'View Taxes', '', 'accounts/taxes/ledger.php', 22),
(97, 142, 'View Taxes', '', 'accounts/taxes/tax_collected.php', 22),
(98, 142, 'View Taxes', '', 'accounts/taxes/tax_paid.php', 22),
(99, 130, 'Accounts', 'Accounts Payable', 'accounts/ap/ap.php', 24),
(100, 131, 'Accounts Payable', 'View AP Invoices', 'accounts/ap/ap.php', 24),
(101, 132, 'Accounts Payable', 'Add AP Invoice', 'accounts/ap/invoice-add.php', 25),
(102, 134, 'View AP Invoices', '', 'accounts/ap/invoice-delete.php', 25),
(103, 134, 'View AP Invoices', '', 'accounts/ap/invoice-view.php', 24),
(104, 134, 'View AP Invoices', '', 'accounts/ap/journal-edit.php', 24),
(105, 134, 'View AP Invoices', '', 'accounts/ap/journal.php', 24),
(106, 134, 'View AP Invoices', '', 'accounts/ap/invoice-payments.php', 24),
(107, 134, 'View AP Invoices', '', 'accounts/ap/invoice-items.php', 24),
(108, 536, 'View Projects', '', 'projects/timebilled.php', 15),
(109, 536, 'View Projects', '', 'projects/timebilled-edit.php', 15),
(110, 536, 'View Projects', '', 'projects/timebilled-delete.php', 15),
(111, 535, 'View Projects', '', 'projects/phase-edit.php', 15),
(112, 535, 'View Projects', '', 'projects/phase-delete.php', 15),
(113, 711, 'Time Registration', '', 'timekeeping/timereg-day.php', 17),
(114, 535, 'View Projects', '', 'projects/delete.php', 15),
(115, 514, 'View Products', '', 'products/delete.php', 11),
(116, 214, 'View Customers', '', 'customers/delete.php', 3),
(117, 313, 'View Vendors', '', 'vendors/delete.php', 5),
(118, 413, 'View Staff', '', 'hr/staff-delete.php', 7),
(119, 811, 'View Tickets', '', 'support/delete.php', 9),
(120, 142, 'View Taxes', '', 'accounts/taxes/delete.php', 22),
(121, 918, 'View Users', '', 'user/user-delete.php', 2),
(122, 115, 'Accounts', 'General Ledger', 'accounts/gl/gl.php', 26),
(123, 116, 'General Ledger', 'View GL Transactions', 'accounts/gl/gl.php', 26),
(124, 117, 'General Ledger', 'Add GL Transaction', 'accounts/gl/add.php', 27),
(126, 124, 'View Invoices', '', 'accounts/ar/invoice-items-edit.php', 21),
(127, 124, 'View Invoices', '', 'accounts/ar/invoice-payments-edit.php', 21),
(128, 134, 'View AP Invoices', '', 'accounts/ap/invoice-payments-edit.php', 25),
(129, 134, 'View AP Invoices', '', 'accounts/ap/invoice-items-edit.php', 25),
(130, 117, 'View GL Transactions', '', 'accounts/gl/view.php', 26),
(131, 117, 'View GL Transactions', '', 'accounts/gl/delete.php', 27),
(132, 150, 'Accounts', 'Quotes', 'accounts/quotes/quotes.php', 28),
(133, 151, 'Quotes', 'View Quotes', 'accounts/quotes/quotes.php', 28),
(134, 152, 'Quotes', 'Add Quote', 'accounts/quotes/quotes-add.php', 29),
(135, 152, 'View Quotes', '', 'accounts/quotes/quotes-delete.php', 29),
(136, 154, 'View Quotes', '', 'accounts/quotes/quotes-view.php', 28),
(137, 154, 'View Quotes', '', 'accounts/quotes/journal-edit.php', 28),
(138, 154, 'View Quotes', '', 'accounts/quotes/journal.php', 28),
(139, 154, 'View Quotes', '', 'accounts/quotes/quotes-items.php', 28),
(140, 154, 'View Quotes', '', 'accounts/quotes/quotes-items-edit.php', 29),
(141, 152, 'View Quotes', '', 'accounts/quotes/quotes-convert.php', 29),
(142, 916, 'View Users', '', 'user/user-staffaccess-add.php', 2),
(143, 523, 'View Services', '', 'services/plan.php', 13),
(144, 523, 'View Services', '', 'services/journal.php', 13),
(145, 523, 'View Services', '', 'services/journal-edit.php', 13),
(146, 523, 'View Services', '', 'services/delete.php', 14),
(147, 211, 'View Customers', '', 'customers/invoices.php', 3),
(148, 211, 'View Customers', '', 'customers/services.php', 3),
(149, 211, 'View Customers', '', 'customers/service-edit.php', 4),
(150, 211, 'View Customers', '', 'customers/service-delete.php', 4),
(151, 311, 'View Vendors', '', 'vendors/invoices.php', 5),
(152, 211, 'View Customers', '', 'customers/service-history.php', 4),
(153, 711, 'Time Registration', '', 'timekeeping/timereg-day-edit.php', 17),
(154, 113, 'View Accounts', '', 'accounts/charts/delete.php', 19),
(155, 124, 'View Invoices', '', 'accounts/ar/invoice-export.php', 20),
(156, 154, 'View Quotes', '', 'accounts/quotes/quotes-export.php', 28),
(157, 180, 'Accounts', 'Reports', 'accounts/reports/reports.php', 30),
(158, 181, 'Reports', 'Trial Balance', 'accounts/reports/trialbalance.php', 30),
(159, 181, 'Reports', '', 'accounts/reports/reports.php', 30),
(160, 182, 'Reports', 'Income Statement', 'accounts/reports/incomestatement.php', 30),
(161, 183, 'Reports', 'Balance Sheet', 'accounts/reports/balancesheet.php', 30),
(162, 905, 'Admin', 'Configuration', 'admin/config.php', 2),
(163, 940, 'Admin', 'Audit Locking', 'admin/auditlock.php', 2),
(164, 411, 'View Staff', '', 'hr/staff-timebooked.php', 7),
(165, 514, 'View Products', '', 'products/taxes.php', 11),
(166, 514, 'View Products', '', 'products/taxes-edit.php', 12);

-- --------------------------------------------------------

-- 
-- Table structure for table `permissions`
-- 

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COMMENT='Stores all the possible permissions' AUTO_INCREMENT=33 ;

-- 
-- Dumping data for table `permissions`
-- 

INSERT INTO `permissions` (`id`, `value`, `description`) VALUES (1, 'disabled', 'Enabling the disabled permission will prevent the user from being able to login.'),
(2, 'admin', 'Provides access to user and configuration management features (note: any user with admin can provide themselves with access to any other section of this program)'),
(3, 'customers_view', 'Allows the user to view & search customer records'),
(4, 'customers_write', 'Allows the user to make changes to customer records or add new customers.'),
(5, 'vendors_view', 'Allows the user to view & search vendor/supplier records.'),
(6, 'vendors_write', 'Allows the user to make changes to vendor records or add new vendors.'),
(7, 'staff_view', 'Allows the user to view & search staff records.'),
(8, 'staff_write', 'Allows the user to make changes to staff records or add new employees.'),
(9, 'support_view', 'Allow the user to view support tickets.'),
(10, 'support_write', 'Allow the user to create and adjust support tickets.'),
(11, 'products_view', 'Allows the user to view & search product records'),
(12, 'products_write', 'Allows the user to make changes to product records or add new products.'),
(13, 'services_view', 'Allow the user to view configured services.'),
(14, 'services_write', 'Allow the user to modify services'),
(15, 'projects_view', 'Allows the user to view & search projects, phases and to view time booked against the project.'),
(16, 'projects_write', 'Allows the user to make changes to projects and phases or to add new projects and phases.'),
(17, 'timekeeping', 'Allows the user to view and book time using the time registration features for all the employees they have been assigned access to (see the user staff access rights page for details)'),
(18, 'accounts_charts_view', 'Allows the user to view the Chart of Accounts.'),
(19, 'accounts_charts_write', 'Allows the user to modify the Charts of Accounts, add new accounts or perform other operations.'),
(20, 'accounts_ar_view', 'Allow user to view invoices or transactions under Accounts Receivables'),
(21, 'accounts_ar_write', 'Allow user to create invoices or transactions under Accounts Receivables'),
(22, 'accounts_taxes_view', 'Allows user to view configured taxes.'),
(23, 'accounts_taxes_write', 'Allows user to adjust configured taxes.'),
(24, 'accounts_ap_view', 'Allow user to view invoices belonging to Accounts Payable'),
(25, 'accounts_ap_write', 'Allow user to create or adjust invoices belonging to Accounts Payable'),
(26, 'accounts_gl_view', 'Allows the user to view general ledger transactions'),
(27, 'accounts_gl_write', 'Allows the user to create general ledger transactions'),
(28, 'accounts_quotes_view', 'Allows user to view all quotes'),
(29, 'accounts_quotes_write', 'Allows the user to create and edit quotes'),
(30, 'accounts_reports', 'View/Create financial reports'),
(31, 'services_write_usage', 'Permit this user to upload service usage records via SOAP interface'),
(32, 'projects_timegroup', 'Permit the user to group unbilled time into groups for invoicing.');

-- --------------------------------------------------------

-- 
-- Table structure for table `permissions_staff`
-- 

CREATE TABLE `permissions_staff` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `permissions_staff`
-- 

INSERT INTO `permissions_staff` (`id`, `value`, `description`) VALUES (18, 'timereg_view', 'Able to view staff member''s booked time.'),
(19, 'timereg_write', 'Able to edit/book time for the staff member.');

-- --------------------------------------------------------

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
  `id` int(11) NOT NULL auto_increment,
  `code_product` varchar(50) NOT NULL default '',
  `name_product` varchar(255) NOT NULL default '',
  `details` text NOT NULL,
  `price_cost` decimal(11,2) NOT NULL default '0.00',
  `price_sale` decimal(11,2) NOT NULL default '0.00',
  `date_start` date NOT NULL,
  `date_end` date NOT NULL,
  `date_current` date NOT NULL default '0000-00-00',
  `quantity_instock` int(11) NOT NULL default '0',
  `quantity_vendor` int(11) NOT NULL default '0',
  `vendorid` int(11) NOT NULL default '0',
  `code_product_vendor` varchar(50) NOT NULL default '',
  `account_sales` int(11) NOT NULL default '0',
  `account_purchase` int(11) NOT NULL,
  `units` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `products`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `products_taxes`
-- 

CREATE TABLE `products_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `productid` int(11) NOT NULL,
  `taxid` int(11) NOT NULL,
  `manual_amount` decimal(11,2) NOT NULL,
  `manual_option` tinyint(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `products_taxes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `project_phases`
-- 

CREATE TABLE `project_phases` (
  `id` int(11) NOT NULL auto_increment,
  `projectid` int(11) NOT NULL default '0',
  `name_phase` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `project_phases`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `projects`
-- 

CREATE TABLE `projects` (
  `id` int(11) NOT NULL auto_increment,
  `code_project` varchar(50) NOT NULL default '',
  `name_project` varchar(255) NOT NULL default '',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `details` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `projects`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `service_types`
-- 

CREATE TABLE `service_types` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `service_types`
-- 

INSERT INTO `service_types` (`id`, `name`, `description`) VALUES (1, 'generic_no_usage', 'Generic service with no usage billing - ideal for regular, fixed price charges (eg: yearly domain name fee)'),
(2, 'data_traffic', 'Data traffic accounting - suitable for ISP services'),
(3, 'time', 'Time accounting - Suitable for use with ISP dialup accounts or other time-based services'),
(4, 'generic_with_usage', 'Generic service with usage billing.'),
(5, 'licenses', 'Ideal for services like software as a service, this service type will do regular billings with flexbile quantities of items.');

-- --------------------------------------------------------

-- 
-- Table structure for table `service_units`
-- 

CREATE TABLE `service_units` (
  `id` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `numrawunits` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `service_units`
-- 

INSERT INTO `service_units` (`id`, `typeid`, `name`, `description`, `numrawunits`) VALUES (1, 2, 'GB', 'Gigabyte - 1000e3 bytes', 1000000000),
(2, 2, 'MB', 'Megabyte - 1000e2 bytes', 1000000),
(3, 2, 'GiB', 'Gibibytes - 1024e3 bytes', 1073741824),
(4, 2, 'MiB', 'Mebibytes - 1024e2 bytes', 1048576),
(5, 3, 'Hours', '', 3600);

-- --------------------------------------------------------

-- 
-- Table structure for table `service_usage_modes`
-- 

CREATE TABLE `service_usage_modes` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `service_usage_modes`
-- 

INSERT INTO `service_usage_modes` (`id`, `name`, `description`) VALUES (1, 'incrementing', 'Total usage during entire period will be billed.'),
(2, 'peak', 'Highest amount of usage on any day during the period will be billed.'),
(3, 'average', 'Average amount of usage across the entire period will be billed.');

-- --------------------------------------------------------

-- 
-- Table structure for table `service_usage_records`
-- 

CREATE TABLE `service_usage_records` (
  `id` int(11) NOT NULL auto_increment,
  `services_customers_id` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `usage1` bigint(20) unsigned NOT NULL default '0',
  `usage2` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `service_usage_records`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `services`
-- 

CREATE TABLE `services` (
  `id` int(11) NOT NULL auto_increment,
  `name_service` varchar(255) NOT NULL default '',
  `chartid` int(11) NOT NULL default '0',
  `typeid` int(11) NOT NULL default '0',
  `units` varchar(255) NOT NULL default '0',
  `price` decimal(11,2) NOT NULL default '0.00',
  `price_extraunits` decimal(11,2) NOT NULL default '0.00',
  `included_units` int(11) NOT NULL default '0',
  `billing_cycle` int(11) NOT NULL default '0',
  `billing_mode` int(11) NOT NULL default '0',
  `usage_mode` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `services`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `services_customers`
-- 

CREATE TABLE `services_customers` (
  `id` int(11) NOT NULL auto_increment,
  `serviceid` int(11) NOT NULL default '0',
  `customerid` int(11) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `date_period_first` date NOT NULL default '0000-00-00',
  `date_period_next` date NOT NULL default '0000-00-00',
  `quantity` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `services_customers`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `services_customers_options`
-- 

CREATE TABLE `services_customers_options` (
  `id` int(11) NOT NULL auto_increment,
  `services_customers_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `services_customers_options`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `services_customers_periods`
-- 

CREATE TABLE `services_customers_periods` (
  `id` int(11) NOT NULL auto_increment,
  `services_customers_id` int(11) NOT NULL default '0',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `date_billed` date NOT NULL default '0000-00-00',
  `invoiceid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `services_customers_periods`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `services_taxes`
-- 

CREATE TABLE `services_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `serviceid` int(11) NOT NULL,
  `taxid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `services_taxes`
-- 

INSERT INTO `services_taxes` (`id`, `serviceid`, `taxid`) VALUES (3, 1, 1),
(4, 2, 1),
(5, 3, 1),
(6, 4, 1),
(7, 5, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `staff`
-- 

CREATE TABLE `staff` (
  `id` int(11) NOT NULL auto_increment,
  `name_staff` varchar(255) NOT NULL default '',
  `staff_code` varchar(255) NOT NULL default '',
  `staff_position` varchar(255) NOT NULL default '',
  `contact_phone` varchar(255) NOT NULL default '',
  `contact_fax` varchar(255) NOT NULL default '',
  `contact_email` varchar(255) NOT NULL default '',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `staff`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `support_tickets`
-- 

CREATE TABLE `support_tickets` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `status` int(11) NOT NULL default '0',
  `priority` int(11) NOT NULL default '0',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `customerid` int(11) NOT NULL default '0',
  `productid` int(11) NOT NULL default '0',
  `projectid` int(11) NOT NULL default '0',
  `serviceid` int(11) NOT NULL default '0',
  `details` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `support_tickets`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `support_tickets_priority`
-- 

CREATE TABLE `support_tickets_priority` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `support_tickets_priority`
-- 

INSERT INTO `support_tickets_priority` (`id`, `value`, `description`) VALUES (1, 'High', ''),
(2, 'Medium', ''),
(3, 'Low', ''),
(4, 'Unsorted', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `support_tickets_status`
-- 

CREATE TABLE `support_tickets_status` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `support_tickets_status`
-- 

INSERT INTO `support_tickets_status` (`id`, `value`, `description`) VALUES (1, 'Reported', ''),
(2, 'Testing', ''),
(3, 'Closed', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `templates`
-- 

CREATE TABLE `templates` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `data` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `templates`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `time_groups`
-- 

CREATE TABLE `time_groups` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `name_group` varchar(255) NOT NULL default '',
  `projectid` int(11) NOT NULL default '0',
  `customerid` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  `invoiceid` int(11) NOT NULL default '0',
  `invoiceitemid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `time_groups`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `timereg`
-- 

CREATE TABLE `timereg` (
  `id` int(11) NOT NULL auto_increment,
  `locked` tinyint(1) NOT NULL default '0',
  `employeeid` int(11) NOT NULL default '0',
  `phaseid` int(11) NOT NULL default '0',
  `groupid` int(11) NOT NULL default '0',
  `billable` tinyint(1) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `time_booked` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `timereg`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `realname` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `password_salt` varchar(20) NOT NULL default '',
  `contact_email` varchar(255) NOT NULL default '',
  `concurrent_logins` tinyint(1) NOT NULL default '0',
  `time` bigint(20) NOT NULL default '0',
  `ipaddress` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ipaddress` (`ipaddress`),
  KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='User authentication system.' AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` (`id`, `username`, `realname`, `password`, `password_salt`, `contact_email`, `concurrent_logins`, `time`, `ipaddress`) VALUES (1, 'setup', 'Setup Account', 'f2c370789ab902f977b3e483238967a8805bd21e', 'rokedpf8fiv9qgxf2uc2', 'support@amberdms.com', 1, 1234659154, '10.8.5.125');

-- --------------------------------------------------------

-- 
-- Table structure for table `users_blacklist`
-- 

CREATE TABLE `users_blacklist` (
  `id` int(11) NOT NULL auto_increment,
  `ipaddress` varchar(15) NOT NULL default '',
  `failedcount` int(11) NOT NULL default '0',
  `time` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COMMENT='Prevents automated login attacks.' AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `users_blacklist`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users_options`
-- 

CREATE TABLE `users_options` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=180 DEFAULT CHARSET=latin1 AUTO_INCREMENT=180 ;

-- 
-- Dumping data for table `users_options`
-- 

INSERT INTO `users_options` (`id`, `userid`, `name`, `value`) VALUES (179, 1, 'concurrent_logins', 'on'),
(23, 5, 'lang', 'en_us'),
(24, 5, 'debug', 'on'),
(149, 4, 'concurrent_logins', 'on'),
(45, 6, 'lang', 'en_us'),
(46, 6, 'dateformat', 'yyyy-mm-dd'),
(47, 6, 'timezone', 'SYSTEM'),
(48, 6, 'debug', 'disabled'),
(49, 5, 'timezone', 'SYSTEM'),
(178, 1, 'debug', ''),
(177, 1, 'shrink_tableoptions', ''),
(63, 7, 'lang', 'en_us'),
(64, 7, 'dateformat', 'yyyy-mm-dd'),
(65, 7, 'timezone', 'SYSTEM'),
(66, 7, 'debug', 'disabled'),
(148, 4, 'debug', ''),
(146, 4, 'timezone', 'SYSTEM'),
(147, 4, 'shrink_tableoptions', 'on'),
(145, 4, 'dateformat', 'dd-mm-yyyy'),
(144, 4, 'lang', 'en_us'),
(176, 1, 'dateformat', 'dd-mm-yyyy'),
(175, 1, 'timezone', 'SYSTEM'),
(174, 1, 'lang', 'en_us');

-- --------------------------------------------------------

-- 
-- Table structure for table `users_permissions`
-- 

CREATE TABLE `users_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `permid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1 COMMENT='Stores user permissions.' AUTO_INCREMENT=90 ;

-- 
-- Dumping data for table `users_permissions`
-- 

INSERT INTO `users_permissions` (`id`, `userid`, `permid`) VALUES (1, 1, 2),
(5, 1, 4),
(6, 1, 3),
(7, 1, 5),
(8, 1, 6),
(9, 1, 7),
(10, 1, 8),
(11, 1, 9),
(12, 1, 10),
(13, 1, 11),
(14, 1, 12),
(15, 1, 13),
(16, 1, 14),
(17, 1, 15),
(18, 1, 16),
(19, 1, 17),
(35, 1, 27),
(34, 1, 26),
(26, 1, 18),
(27, 1, 19),
(28, 1, 20),
(29, 1, 21),
(30, 1, 22),
(31, 1, 23),
(32, 1, 24),
(33, 1, 25),
(36, 1, 28),
(37, 1, 29),
(67, 1, 30),
(89, 1, 32);

-- --------------------------------------------------------

-- 
-- Table structure for table `users_permissions_staff`
-- 

CREATE TABLE `users_permissions_staff` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `staffid` int(11) NOT NULL default '0',
  `permid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `users_permissions_staff`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users_sessions`
-- 

CREATE TABLE `users_sessions` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `authkey` varchar(40) NOT NULL,
  `ipaddress` varchar(15) NOT NULL,
  `time` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=238 DEFAULT CHARSET=latin1 AUTO_INCREMENT=238 ;

-- 
-- Dumping data for table `users_sessions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vendors`
-- 

CREATE TABLE `vendors` (
  `id` int(11) NOT NULL auto_increment,
  `name_vendor` varchar(255) NOT NULL default '',
  `code_vendor` varchar(50) NOT NULL default '',
  `name_contact` varchar(255) NOT NULL default '',
  `contact_email` varchar(255) NOT NULL default '',
  `contact_phone` varchar(255) NOT NULL default '',
  `contact_fax` varchar(255) NOT NULL default '',
  `date_start` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `tax_default` int(11) NOT NULL default '0',
  `tax_number` varchar(255) NOT NULL default '0',
  `address1_street` varchar(255) NOT NULL default '',
  `address1_city` varchar(255) NOT NULL default '',
  `address1_state` varchar(255) NOT NULL default '',
  `address1_country` varchar(255) NOT NULL default '',
  `address1_zipcode` int(11) NOT NULL default '0',
  `address2_street` varchar(255) NOT NULL default '',
  `address2_city` varchar(255) NOT NULL default '',
  `address2_state` varchar(255) NOT NULL default '',
  `address2_country` varchar(255) NOT NULL default '',
  `address2_zipcode` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `vendors`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `vendors_taxes`
-- 

CREATE TABLE `vendors_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `vendorid` int(11) NOT NULL,
  `taxid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `vendors_taxes`
-- 


--
-- Custom Fixes
--

INSERT INTO `staff` (`id`, `name_staff`, `staff_code`, `staff_position`, `contact_phone`, `contact_fax`, `contact_email`, `date_start`, `date_end`) VALUES (1, 'Automated System', 'AUTO', 'Automatically generated invoices will be assigned to this employee.', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'services_customers_id', 'Service-Customer Assignment ID');


--
-- AMBERDMS BILLING SYSTEM VERSION 1.1.0 UPGRADES
--

ALTER TABLE `services` ADD `alert_80pc` TINYINT NOT NULL AFTER `description` ,
ADD `alert_100pc` TINYINT NOT NULL AFTER `alert_80pc` ,
ADD `alert_extraunits` INT NOT NULL AFTER `alert_100pc` ;

INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'alert_extraunits', 'Alert for every specified number of extra units');
INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'service_plan_alerts', 'Service Plan Alerts');
INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'usage_summary', 'Usage Summary');

ALTER TABLE `services_customers_periods` ADD `usage_summary` BIGINT( 20 ) NOT NULL AFTER `invoiceid` ;

INSERT INTO `config` ( `name` , `value` ) VALUES ('CODE_STAFF', '100');

ALTER TABLE `projects` ADD `internal_only` BOOL NOT NULL AFTER `date_end` ;

INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'internal_only', 'Internal Only');
INSERT INTO `language` ( `id` , `language` , `label` , `translation` ) VALUES (NULL , 'en_us', 'id_support_ticket', 'Ticket ID');


--
-- Set Schema Version
--

INSERT INTO `config` ( `name` , `value` ) VALUES ('SCHEMA_VERSION', '20090310');