Revision 94243c86

b/snf-pithos-backend/pithos/backends/lib/sqlalchemy/node.py
172 172
        self.versions = Table('versions', metadata, *columns, mysql_engine='InnoDB')
173 173
        Index('idx_versions_node_mtime', self.versions.c.node, self.versions.c.mtime)
174 174
        Index('idx_versions_node_uuid', self.versions.c.uuid)
175
        Index('idx_versions_serial_cluster', self.versions.c.serial, self.versions.c.cluster)
176 175
        
177 176
        #create attributes table
178 177
        columns = []
b/snf-pithos-backend/pithos/backends/lib/sqlite/node.py
167 167
                    on versions(node, mtime) """)
168 168
        execute(""" create index if not exists idx_versions_node_uuid
169 169
                    on versions(uuid) """)
170
        execute(""" create index if not exists idx_versions_serial_cluster
171
                    on versions(serial, cluster) """)
172 170
        
173 171
        execute(""" create table if not exists attributes
174 172
                          ( serial integer,

Also available in: Unified diff