Task list database table
From TaskDepender
(→Design) |
(→Implementation) |
||
Line 29: | Line 29: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
− | CREATE TEMPORARY TABLE | + | CREATE TEMPORARY TABLE TaskList |
AS SELECT *, | AS SELECT *, | ||
(SELECT COUNT(ContainerId) from Tasks where Tasks.ContainerId=t.Id)>0 | (SELECT COUNT(ContainerId) from Tasks where Tasks.ContainerId=t.Id)>0 | ||
Line 47: | Line 47: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
− | UPDATE | + | UPDATE TaskList SET Parent=Id |
</syntaxhighlight> | </syntaxhighlight> | ||
Line 53: | Line 53: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
− | DROP TABLE | + | DROP TABLE TaskList |
</syntaxhighlight> | </syntaxhighlight> | ||