Connections database table
From TaskDepender
(→Constraints) |
(→Connect) |
||
| Line 78: | Line 78: | ||
SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency, | SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency, | ||
FROM SelectedTasks t, SelectedDeliverables d; | FROM SelectedTasks t, SelectedDeliverables d; | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | <syntaxhighlight lang="sql"> | ||
| + | INSERT INTO Deliverables | ||
| + | SELECT d.Name, d.Description, d.Resource, d.X, d.Y, d.Width, d.Height, d.Link, d.Available, | ||
| + | ConnectionId, | ||
| + | ContainerId) | ||
| + | FROM Deliverables d WHERE Id IN (SELECT Id FROM SelectedDeliverables) | ||
| + | (Name,Description, Resource, X, Y, Width, Height, Link, Available, ConnectionId, ContainerId) | ||
| + | VALUES (%s, %s, %s, %d, %d, %d, %d, %s, %d, 0, (SELECT Val FROM StateVariables WHERE Name='CurrentContainerId')) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
