Tasks database table

Revision as of 06:00, 30 November 2011 (view source) Fred (Talk | contribs) (→Design) ← Older edit		Revision as of 06:03, 30 November 2011 (view source) Fred (Talk | contribs) (→Create table) Newer edit →
Line 86:		Line 86:
	uint32 container_id		uint32 container_id
	} tdd_task;		} tdd_task;
−	</syntaxhighlight>
−
−	=== Create table ===
−
−	<syntaxhighlight lang="sql">
−	CREATE TABLE Tasks
−	(
−	Id INTEGER PRIMARY KEY,
−	Name TEXT,
−	Description TEXT,
−	ResourceId INTEGER REFERENCES Resources(Id) ON DELETE SET NULL,
−	X INTEGER,
−	Y INTEGER,
−	Width INTEGER,
−	Height INTEGER,
−	ContainerId INTEGER REFERENCES Tasks(Id) ON DELETE CASCADE
−	)
	</syntaxhighlight>		</syntaxhighlight>

---

Revision as of 06:03, 30 November 2011