To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=46519
------- Additional comments from [EMAIL PROTECTED] Wed Apr 13 07:24:32 -0700
2005 -------
This time, it's only the "customer", "groups" and "invdet" tables that are
accessible. These tables are defined as follows:
CREATE TABLE `customer` (
`Customer` varchar(4) NOT NULL default '',
`Name` varchar(30) NOT NULL default '',
`Address1` varchar(30) NOT NULL default '',
`Address2` varchar(30) NOT NULL default '',
`Address3` varchar(30) NOT NULL default '',
`Address4` varchar(30) NOT NULL default '',
`Phone` varchar(12) NOT NULL default '',
`Price` tinyint(1) unsigned NOT NULL default '0' COMMENT '1..6',
`DateCreated` date default NULL,
`Contact` varchar(20) NOT NULL default '',
`DiscountPC` float NOT NULL default '0',
`CreditLimit` int(10) unsigned NOT NULL default '0',
`DDMandate` date default NULL,
`DDStatus` char(1) default NULL COMMENT 'null: don''t DD; F: first DD not done
yet; S: 2nd DD not done yet; D: 2nd DD has been done',
`DDName` varchar(18) default NULL,
`DDBranch` varchar(6) default NULL,
`DDAccount` varchar(8) default NULL,
`ExtraMonthsCredit` tinyint(1) unsigned default NULL,
`DisputedItems` int(10) unsigned default NULL,
`VatExemption` varchar(12) default NULL,
`LabelAddress` varchar(200) default NULL,
`Turnover1` int(11) default NULL COMMENT 'redundant',
`Turnover2` int(11) default NULL COMMENT 'redundant',
`Turnover3` int(11) default NULL COMMENT 'redundant',
`Turnover4` int(11) default NULL COMMENT 'redundant',
`Turnover5` int(11) default NULL COMMENT 'redundant',
`Turnover6` int(11) default NULL COMMENT 'redundant',
`Turnover7` int(11) default NULL COMMENT 'redundant',
`Turnover8` int(11) default NULL COMMENT 'redundant',
`Turnover9` int(11) default NULL COMMENT 'redundant',
`Turnover10` int(11) default NULL COMMENT 'redundant',
`Turnover11` int(11) default NULL COMMENT 'redundant',
`Turnover12` int(11) default NULL COMMENT 'redundant',
`Dead` set('1') NOT NULL default '',
`temp` tinyint(4) default NULL,
`RedirectAccount` varchar(4) default NULL,
`AutoEmail` varchar(255) default NULL,
PRIMARY KEY (`Customer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `groups` (
`GroupNo` tinyint(2) unsigned NOT NULL default '0',
`Description` char(25) default NULL,
PRIMARY KEY (`GroupNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=100
CREATE TABLE `invdet` (
`TranRef` mediumint(6) unsigned NOT NULL default '0' COMMENT '<100000 =
quotation',
`Seq` int(11) NOT NULL auto_increment,
`product` char(4) NOT NULL default '',
`Description` char(25) NOT NULL default '',
`price` int(10) unsigned NOT NULL default '0',
`unitsize` tinyint(2) unsigned NOT NULL default '0',
`quantity` smallint(6) NOT NULL default '0',
`quantityinners` tinyint(2) NOT NULL default '0',
`totalvalue` int(11) NOT NULL default '0',
`vatcode` tinyint(1) unsigned NOT NULL default '0',
`TranDate` date NOT NULL default '0000-00-00' COMMENT 'redundant',
`Customer` char(4) NOT NULL default '' COMMENT 'redundant',
`Cancelled` set('1') NOT NULL default '' COMMENT 'redundant',
PRIMARY KEY (`TranRef`,`Seq`),
KEY `CustDateProdIndex` (`Customer`,`TranDate`,`product`),
KEY `ProdDateCustIndex` (`product`,`TranDate`,`Customer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Here are the definitions of a couple of the other tables that have never been
accessible, but which no other applications (including OOo 1.1 as far as I
remember) have ever had any problems with:
CREATE TABLE `dockets` (
`Docket` mediumint(6) unsigned NOT NULL default '0',
`ScanDate` date NOT NULL default '0000-00-00',
`ImageSize` mediumint(9) NOT NULL default '0',
`CompressedImage` mediumblob
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `products` (
`Product` char(4) NOT NULL default '',
`Description` char(25) default NULL,
`GroupNo` tinyint(2) unsigned default NULL,
`UnitSize` tinyint(2) unsigned default NULL,
`Cost` int(10) unsigned default NULL,
`VatCode` tinyint(1) unsigned default NULL,
`Price1` int(10) unsigned default NULL,
`Price2` int(10) unsigned default NULL,
`Price3` int(10) unsigned default NULL,
`Price4` int(10) unsigned default NULL,
`Price5` int(10) unsigned default NULL,
`Price6` int(10) unsigned default NULL,
`Location` char(6) default NULL,
`ShelfLife` tinyint(1) unsigned default NULL,
`DateCreated` date default NULL,
`Discontinued` set('1') NOT NULL default '',
`ServiceOrCharge` set('1') NOT NULL default '',
`Supplier` char(4) default NULL,
`temp` tinyint(4) default NULL,
PRIMARY KEY (`Product`),
KEY `GroupIndex` (`GroupNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `supnotes` (
`Seq` smallint(6) NOT NULL default '0',
`Supplier` varchar(4) NOT NULL default '',
`NoteDateTime` datetime default NULL,
`Author` varchar(20) default NULL,
`KeepUntil` date default NULL,
`NoteText` varchar(255) default NULL,
PRIMARY KEY (`Seq`),
KEY `Supplier` (`Supplier`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Thanks.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
