[Phpgroupware-developers] phpgwapi/async database table vs. SAP DB

[Kai Hofmann]

Hi all,

I am working on the SAP DB database access.
During this work I found a problem that must be fixed.
The original create table statement generated by phpgw is:


CREATE TABLE phpgw_async (id VARCHAR(255) NOT NULL, next INTEGER NOT NULL,
times VARCHAR(255) NOT NULL, method VARCHAR(80) NOT NULL, data LONG NOT
NULL, account_id INTEGER NOT NULL DEFAULT '0', PRIMARY KEY(id))


The problem here is that "next" as column name is a reserved keyword in SAP
DB.

So it would be nice if the maintainer of the async stuff could change this.


Thanks in advance

  Kai

-- 
*****    Open Source und Linux im professionellen Einsatz    *****
**  komplexe Mailserver, Groupware, Office: sprechen Sie uns an **
Dipl.-Inform. Kai Hofmann                    Team Softwarelösungen
pro|business AG, EXPO Plaza 1 (Deutscher Pavillon), 30539 Hannover
E-Mail: address@hidden,   Tel.: 0511/60066-332, Fax: -355
WWW: http://www.probusiness.de/