View | Details | Raw Unified | Return to bug 41999
Collapse All | Expand All

(-)file_not_specified_in_diff (-3 / +8 lines)
Line     Link Here 
0
-- services/univention-s4-connector/modules/univention/s4connector/lockingdb.py
0
++ services/univention-s4-connector/modules/univention/s4connector/lockingdb.py
 Lines 152-157   class LockingDB: Link Here 
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
 Lines 186-192   class S4Cache: Link Here 
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)

Return to bug 41999