Conditional SQLite check constraint?

Question

I have a table defined by the following SQL:

CREATE TABLE test (   id       integer PRIMARY KEY NOT NULL UNIQUE,   status   text NOT NULL,   enddate  date,   /* Checks */   CHECK (status IN ("Current", "Complete")) ); 

I'd like to add a constraint that requires enddate to be non-null if the status is "Complete".

Is this possible? I am using SQLite v3.6.16.

Answer 1

How about:

CHECK (status = "Current" or (status = "Complete" and enddate is not null)) 

Answer 2

CREATE TABLE test (   id       integer PRIMARY KEY,   status   text NOT NULL CHECK (status IN ('Current', 'Complete')),   enddate  date NOT NULL ); 

This will work in SQLite, with the CHECK constraint written inline. I changed double quotes to apostrophes so it can be used in PHP.