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

[Dave Hall]

Kai Hofmann <address@hidden> wrote:

> 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 
> NOTNULL, 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.

async was ralf's code.  I would like to have a page on the wiki listing
a set of reserved words, so all developers know which fields names can't
be used.  This will prevent this type of problem.

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

Async was Ralf's code.  We can try change it before RC2.  Got a patch?

Cheers

Dave

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>