Class::DBI::Sqlite

[prev] [thread] [next] [Date index for 2005/02/01]

Hello, 

I'm having trouble setting up a table use class::dbi::sqlite
Table create with te following syntax : 

    272 CREATE TABLE modulemode (
    273   momId INT PRIMARY KEY,
    274   modId int DEFAULT 0,
    275   momName varchar ,
    276   momDescription text
    277 );

if is try to include my DBI class i get the following error : 

SQL ERROR: Unknown column constraint: 'DEFAULT'!

SQL ERROR: Unknown column constraint: 'DEFAULT'!


When is use the following create statement :

    272 CREATE TABLE modulemode (
    273   momId INT PRIMARY KEY,
    274   modId int ,
    275   momName varchar ,
    276   momDescription text
    277 );

It all goes well, my question is, what schema is supported using
Class::DBI::Sqlite 

Kind regards daniel