|
0 |
-- services/univention-s4-connector/modules/univention/s4connector/lockingdb.py |
0 |
++ services/univention-s4-connector/modules/univention/s4connector/lockingdb.py |
|
152 |
sql_commands = [ |
152 |
sql_commands = [ |
153 |
"CREATE TABLE IF NOT EXISTS S4_LOCK (id INTEGER PRIMARY KEY, guid TEXT);", |
153 |
"CREATE TABLE IF NOT EXISTS S4_LOCK (id INTEGER PRIMARY KEY, guid TEXT);", |
154 |
"CREATE TABLE IF NOT EXISTS UCS_LOCK (id INTEGER PRIMARY KEY, uuid TEXT);", |
154 |
"CREATE TABLE IF NOT EXISTS UCS_LOCK (id INTEGER PRIMARY KEY, uuid TEXT);", |
|
|
155 |
"CREATE INDEX IF NOT EXISTS s4_lock_guid ON s4_lock(guid);", |
156 |
"CREATE INDEX IF NOT EXISTS ucs_lock_uuid ON ucs_lock(uuid);", |
155 |
] |
157 |
] |
156 |
|
158 |
|
157 |
self.__execute_sql_commands(sql_commands, fetch_result=False) |
159 |
self.__execute_sql_commands(sql_commands, fetch_result=False) |
158 |
-- services/univention-s4-connector/modules/univention/s4connector/s4cache.py |
160 |
++ services/univention-s4-connector/modules/univention/s4connector/s4cache.py |
|
186 |
sql_commands = [ |
186 |
sql_commands = [ |
187 |
"CREATE TABLE IF NOT EXISTS GUIDS (id INTEGER PRIMARY KEY, guid TEXT);", |
187 |
"CREATE TABLE IF NOT EXISTS GUIDS (id INTEGER PRIMARY KEY, guid TEXT);", |
188 |
"CREATE TABLE IF NOT EXISTS ATTRIBUTES (id INTEGER PRIMARY KEY, attribute TEXT);", |
188 |
"CREATE TABLE IF NOT EXISTS ATTRIBUTES (id INTEGER PRIMARY KEY, attribute TEXT);", |
189 |
"CREATE TABLE IF NOT EXISTS DATA (id INTEGER PRIMARY KEY, guid_id INTEGER, attribute_id INTEGER, value TEXT);" |
189 |
"CREATE TABLE IF NOT EXISTS DATA (id INTEGER PRIMARY KEY, guid_id INTEGER, attribute_id INTEGER, value TEXT);", |
|
|
190 |
"CREATE INDEX IF NOT EXISTS data_foreign_keys ON data(guid_id, attribute_id);", |
191 |
"CREATE INDEX IF NOT EXISTS attributes_attribute ON attributes(attribute);", |
192 |
"CREATE INDEX IF NOT EXISTS guids_guid ON guids(guid);", |
190 |
] |
193 |
] |
191 |
|
194 |
|
192 |
self.__execute_sql_commands(sql_commands, fetch_result=False) |
195 |
self.__execute_sql_commands(sql_commands, fetch_result=False) |