How are the definitions of the tables in SQL Server?
Well I think I’m having a problem with dates. When you save a task, saves a completely different date.
This is the definition of my tables:
CREATE TABLE gantt_tasks (
id INTEGER NOT NULL IDENTITY(1,1) PRIMARY KEY,
text varchar(255) NOT NULL DEFAULT ‘’,
start_date smalldatetime NOT NULL DEFAULT ‘2014-01-01 00:00:00’,
duration INTEGER NOT NULL DEFAULT ‘0’,
progress float NOT NULL DEFAULT ‘0.0’,
sortorder INTEGER NOT NULL DEFAULT ‘0’,
parent INTEGER NOT NULL DEFAULT ‘0’);
CREATE TABLE gantt_links (
id INTEGER NOT NULL IDENTITY(1,1) PRIMARY KEY,
source INTEGER NOT NULL DEFAULT ‘0’,
target INTEGER NOT NULL DEFAULT ‘0’,
type varchar(1) NOT NULL DEFAULT ‘’);