karma
15/04/2004, 17h31
Voilà la correction :
CREATE TABLE llx_bank(
rowid integer AUTO_INCREMENT PRIMARY KEY ,
datec datetime,
datev date,
dateo date,
amount real NOT NULL default 0,
label varchar( 255 ) ,
fk_account integer,
fk_user_author integer,
fk_user_rappro integer,
fk_type varchar( 4 ) ,
num_releve varchar( 50 ) ,
num_chq int,
rappro tinyint NOT NULL default 0,
note text,
author varchar( 40 )
)
Rajoute NOT NULL pour le champ "rappro"...
CREATE TABLE llx_bank(
rowid integer AUTO_INCREMENT PRIMARY KEY ,
datec datetime,
datev date,
dateo date,
amount real NOT NULL default 0,
label varchar( 255 ) ,
fk_account integer,
fk_user_author integer,
fk_user_rappro integer,
fk_type varchar( 4 ) ,
num_releve varchar( 50 ) ,
num_chq int,
rappro tinyint NOT NULL default 0,
note text,
author varchar( 40 )
)
Rajoute NOT NULL pour le champ "rappro"...