Added Attachment of Documents and a couple of links from supplier invoice/crfedit...

[fa-stable.git] / sql / alter2.1.sql

diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql
index 48f286ef50c2769155129cc42a12c4037173cfa4..7560011f364f5e3f6790e5c466dc4ce794397319 100644 (file)
--- a/sql/alter2.1.sql
+++ b/sql/alter2.1.sql
@@ -1,3 +1,19 @@
+DROP TABLE IF EXISTS `0_attachments`;
+
+CREATE TABLE `0_attachments` (
+  `id` int(11) NOT NULL auto_increment,
+  `description` varchar(60) NOT NULL default '',
+  `type_no` int(11) NOT NULL default '0',
+  `trans_no` int(11) NOT NULL default '0',
+  `bin_data` mediumblob NOT NULL,
+  `tran_date` date NOT NULL default '0000-00-00',
+  `filename` varchar(60) NOT NULL default '',
+  `filesize` int(11) NOT NULL default '0',
+  `filetype` varchar(60) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  KEY `type_no` (`type_no`,`trans_no`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
 DROP TABLE IF EXISTS `0_groups`;
 
 CREATE TABLE `0_groups` (