CREATE TABLE GDLCOMMENT
(
COMID INT NOT NULL,
ACOMMENT BLOB,
COMDATE DATE NOT NULL,
GDLID INT NOT NULL,
PRIMARY KEY (COMID)
);
CREATE TABLE TODOLIST
(
TDLID INT NOT NULL,
TASK VARCHAR(255) NOT NULL,
TDLDETAIL BLOB,
DATECREATE DATE NOT NULL,
DATEDUE DATE NOT NULL,
DATECOMPLETE DATE,
GDLID INT NOT NULL,
COMPLETED INT,
PRIMARY KEY (TDLID)
);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (1, 'First Task', 'First task', '2017/03/23', '2017/03/25', NULL, 1, 1);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (2, 'This is it', 'This is it', '2017/03/23', '2017/03/23', NULL, 1, 1);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (3, 'Second Task', 'This is the second todo I''ve entered via the programme.', '2017/03/23', '2017/03/28', NULL, 1, 0);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (5, 'Not to be', 'this should not be at the top', '2017/03/20', '2017/03/16', NULL, 1, 1);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (6, 'My best', 'who knows', '2017/03/23', '2017/05/25', '2017/04/30', 3, 1);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (20, 'test', NULL, '2017/04/24', '2017/04/18', NULL, 5, 0);
INSERT INTO TODOLIST (TDLID, TASK, TDLDETAIL, DATECREATE, DATEDUE, DATECOMPLETE, GDLID, COMPLETED) VALUES (21, 'test 2', NULL, '2017/04/24', '2017/05/02', NULL, 5, 0);
INSERT INTO GDLCOMMENT (COMID, ACOMMENT, COMDATE, GDLID) VALUES (1, 'My first comment. I made a change to it', '2017/03/21', 1);