Connections database table

From TaskDepender

@@ Line 99: / Line 99: @@
 INSERT INTO Deliverables
-()
+SELECT
-   FROM Deliverables d WHERE Id IN (SELECT Id FROM SelectedDeliverables)
+   d.Name, d.Description, d.Resource, d.X, d.Y, d.Width, d.Height, d.Link, d.Available,
+  NewConnections.TaskId ContainerId, NewConnections.Id ConnectionId FROM Deliverables d, (SELECT Id, TaskId, DeliverableId FROM Connections
+WHERE Id NOT IN (SELECT ConnectionId FROM Deliverables)) AS NewConnections
-(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'))
-SELECT d.Name,d.Description, d.Resource, d.X, d.Y, d.Width, d.Height, d.Link, d.Available, NewConnections.TaskId ContainerId, NewConnections.Id ConnectionId
-SELECT Id, TaskId, DeliverableId FROM Connections
-WHERE Id NOT IN (SELECT ConnectionId FROM Deliverables) AS NewConnections
 </syntaxhighlight>

Revision as of 20:11, 22 November 2011