Changeset 75fa94be4e985c93bb38f0cefbd198b5e087e454

Timestamp:

01/20/07 18:41:00 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

Christopher Jung <bktheg@web.de> 1169314860 +0100

git-parent:

[264cd5ad5eb9ddb5a94decc2a3793260ae474918]

git-author:

Christopher Jung <bktheg@web.de> 1169314860 +0100

Message:

SQL-Stored Function getIntelliShipID() eingebaut

Files:

• db/functions.sql (added)
• db/updates.xml (modified) (1 diff)

db/updates.xml

@@ -110 +110 @@
-                ALTER TABLE ships_baubar CHANGE costs costs VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'
-        ]]></update>
+        <update type="structure" datum="2007-01-20"><![CDATA[
+                DELIMITER //
+                CREATE FUNCTION newIntelliShipID(minid INT) RETURNS INT
+                READS SQL DATA
+                BEGIN
+                  DECLARE done,sid,shouldId INT DEFAULT 0;
+                  DECLARE cur1 CURSOR FOR SELECT DISTINCT abs(id) iid FROM ships WHERE abs(id)>=minid ORDER BY iid;
+                  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
+                
+                  OPEN cur1;
+                  set shouldId = minid;
+                  REPEAT
+                    FETCH cur1 INTO sid;
+                    IF NOT done THEN
+                      IF sid <> shouldId THEN
+                        CLOSE cur1;
+                        RETURN shouldId;
+                      END IF;
+                      set shouldId = shouldId+1;
+                    END IF;
+                  UNTIL done END REPEAT;
+                
+                  CLOSE cur1;
+                  RETURN shouldId;
+                END;
+                //
+        ]]></update>
-</updates>