Simple Invoices - Forum

Hey Apmuthu

email_attach.png has just been added in - the others should be there if you svn update

- i'll check on my pc at home to make sure that there actually in svn

re sql patches
- before the last release i made a number of changes to the sql_patches.php file
- you may have to create a new db from the .sql in the last release and then run the update again

Cheers

Justin

The email-attach.png is in the SVN (Revision 1083) now.
The others are still missing.
The printer.gif can be used to get the printer.png file.

The SimpleInvoices.sql file does not contain the info to get the patches 132 to 136 done. Are they necessary?
It would be nice to freshen the Oct 2nd release with the missing images and the SQL file.

Just checked out Revision 1083 and the images are now there.
Looks like a SVN cache issue.

Hey Apmuthu

is sql patches 132-136 in your sql_patches.pphp?

if its not there below
702 $patch['132']['name'] = "Create si_customFieldCategories table";
703 $patch['132']['patch'] = "CREATE TABLE `si_customFieldCategories` (
704 `id` int(11) NOT NULL auto_increment,
705 `name` varchar(40) NOT NULL,
706 PRIMARY KEY (`id`) );";
707 $patch['132']['date'] = "20070629";
708
709
710 $patch['133']['name'] = "Insert si_customFieldCategories default values";
711 $patch['133']['patch'] = "INSERT INTO `si_customFieldCategories` (`id`, `name`) VALUES
712 (1, 'biller'),
713 (2, 'customer'),
714 (3, 'product'),
715 (4, 'invoice');";
716 $patch['133']['date'] = "20070629";
717
718 $patch['134']['name'] = "Create si_customFieldValues table";
719 $patch['134']['patch'] = "CREATE TABLE `si_customFieldValues` (
720 `id` int(11) NOT NULL auto_increment,
721 `customFieldId` int(11) NOT NULL,
722 `itemId` int(11) NOT NULL COMMENT 'could be invocie-id,customer-id etc.',
723 `value` text NOT NULL,
724 PRIMARY KEY (`id`));";
725 $patch['134']['date'] = "20070629";
726
727 $patch['135']['name'] = "Create si_customFields table";
728 $patch['135']['patch'] = "CREATE TABLE `si_customFields` (
729 `id` int(11) NOT NULL auto_increment,
730 `pluginId` int(11) NOT NULL,
731 `categorieId` int(11) NOT NULL,
732 `name` varchar(30) character set latin1 NOT NULL,
733 `description` varchar(50) collate utf8_unicode_ci NOT NULL,
734 `active` tinyint(1) NOT NULL default '1',
735 PRIMARY KEY (`id`)
736 );";
737 $patch['135']['date'] = "20070629";
738
739 $patch['136']['name'] = "Add default status_id to invoices";
740 $patch['136']['patch'] = "ALTER TABLE si_invoices ADD status_id INT DEFAULT 0 NOT NULL";
741 $patch['136']['date'] = "20071006";

Cheers

Justin