OpenNebula

        # Feature #1565: New cid column in host, ds and vnet tables

        ########################################################################

        @db.run "ALTER TABLE host_pool RENAME TO old_host_pool;"

        @db.run "CREATE TABLE host_pool (oid INTEGER PRIMARY KEY, name VARCHAR(128), body TEXT, state INTEGER, last_mon_time INTEGER, uid INTEGER, gid INTEGER, owner_u INTEGER, group_u INTEGER, other_u INTEGER, cid INTEGER, UNIQUE(name));"

        @db.fetch("SELECT * FROM old_host_pool") do |row|

            doc = Document.new(row[:body])

            cluster_id = doc.root.get_text('CLUSTER_ID').to_s

            @db[:host_pool].insert(

                :oid            => row[:oid],

                :name           => row[:name],

                :body           => row[:body],

                :state          => row[:state],

                :last_mon_time  => row[:last_mon_time],

                :uid            => row[:uid],

                :gid            => row[:gid],

                :owner_u        => row[:owner_u],

                :group_u        => row[:group_u],

                :other_u        => row[:other_u],

                :cid            => cluster_id)

        end

        @db.run "DROP TABLE old_host_pool;"

        @db.run "ALTER TABLE network_pool RENAME TO old_network_pool;"

        @db.run "CREATE TABLE network_pool (oid INTEGER PRIMARY KEY, name VARCHAR(128), body TEXT, uid INTEGER, gid INTEGER, owner_u INTEGER, group_u INTEGER, other_u INTEGER, cid INTEGER, UNIQUE(name,uid));"

        @db.fetch("SELECT * FROM old_network_pool") do |row|

            doc = Document.new(row[:body])

            cluster_id = doc.root.get_text('CLUSTER_ID').to_s

            @db[:network_pool].insert(

                :oid            => row[:oid],

                :name           => row[:name],

                :body           => row[:body],

                :uid            => row[:uid],

                :gid            => row[:gid],

                :owner_u        => row[:owner_u],

                :group_u        => row[:group_u],

                :other_u        => row[:other_u],

                :cid            => cluster_id)

        end

        @db.run "DROP TABLE old_network_pool;"

        ########################################################################

        #

        # Feature #1565: New cid column in host, ds and vnet tables

        @db.run "CREATE TABLE datastore_pool (oid INTEGER PRIMARY KEY, name VARCHAR(128), body TEXT, uid INTEGER, gid INTEGER, owner_u INTEGER, group_u INTEGER, other_u INTEGER, cid INTEGER, UNIQUE(name));"

            cluster_id = doc.root.get_text('CLUSTER_ID').to_s

                :other_u    => row[:other_u],

                :cid        => cluster_id)

        @db.run "INSERT INTO datastore_pool VALUES(2,'files','<DATASTORE><ID>2</ID><UID>0</UID><GID>0</GID><UNAME>#{user_0_name}</UNAME><GNAME>#{group_0_name}</GNAME><NAME>files</NAME><PERMISSIONS><OWNER_U>1</OWNER_U><OWNER_M>1</OWNER_M><OWNER_A>0</OWNER_A><GROUP_U>1</GROUP_U><GROUP_M>0</GROUP_M><GROUP_A>0</GROUP_A><OTHER_U>1</OTHER_U><OTHER_M>0</OTHER_M><OTHER_A>0</OTHER_A></PERMISSIONS><DS_MAD>fs</DS_MAD><TM_MAD>ssh</TM_MAD><BASE_PATH>#{base_path}</BASE_PATH><TYPE>2</TYPE><DISK_TYPE>0</DISK_TYPE><CLUSTER_ID>-1</CLUSTER_ID><CLUSTER></CLUSTER><IMAGES></IMAGES><TEMPLATE><DS_MAD><![CDATA[fs]]></DS_MAD><TM_MAD><![CDATA[ssh]]></TM_MAD><TYPE><![CDATA[FILE_DS]]></TYPE></TEMPLATE></DATASTORE>',0,0,1,1,1,-1);"