CREATE TABLE `cms_invoices` (
`id` int(255) unsigned NOT NULL auto_increment,
`uid` int(255) NOT NULL default '0',
`paydate` tinyint(2) NOT NULL default '0',
`paymonth` tinyint(2) NOT NULL default '0',
`payyear` smallint(4) NOT NULL default '0',
`duedate` tinyint(2) NOT NULL default '0',
`duemonth` tinyint(2) NOT NULL default '0',
`dueyear` smallint(4) NOT NULL default '0',
`status` varchar(6) NOT NULL default 'unpaid',
`total` decimal(253,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `cms_invoices_details` (
`id` int(255) unsigned NOT NULL auto_increment,
`iid` int(255) NOT NULL default '0',
`description` text NOT NULL,
`unitprice` decimal(253,2) NOT NULL default '0.00',
`quantity` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `cms_templates` (
`id` int(255) unsigned NOT NULL auto_increment,
`name` text NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `cms_templates` VALUES (1, 'Default Invoice', '\r\n\r\n\r\n\r\n\r\n\r\n\r\nDear _CLIENTNAME_,
\r\nYour invoice appears below. Please remit payment at your earliest convenience. \r\nThank you for your business - we appreciate it very much.
\r\n
\r\nPayment Due On: _DUEDATE_
\r\n\r\n \r\n | Description | \r\n Quantity | \r\n \r\n Price | \r\n
\r\n_DETAILS_\r\n
\r\n\r\n \r\n | \r\n Total: | \r\n \r\n _TOTAL_ | \r\n
\r\n
\r\nIf you are paying via paypal, you may click the following link:
\r\n\r\nClick here to pay!\r\n\r\n
\r\nSincerely,
\r\n=|MoA|= Hosting
\r\nwww.moahosting.com \r\n\r\n\r\n\r\n');