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