Data: Database Info

The unonatanium_database_info table is part of the Base Database Schema, it contains schema versioning metadata about a given database.

Valid keys are:

unobtanium_base_schema_version

The version of the base schema i.e. 0.1.0

unobtanium_database_kind

Which kind of database this is, either crawler or summary

unobtanium_crawler_schema_version

The version of the crawler database schema i.e. 1.0.0 (only if the database is a crawler database)

unobtanium_summary_schema_version

The version of the summary database schema i.e. 0.0.0 (only if the database is a summary database)

Note: The base schema may increment without the summary or crawler schema getting a version bump.

Manually adding version information

In case you have an "old" database run the following SQL manually.

For this to work the databases must have the right schema, otherwise they'll fail like they did previously: Error on some random SQL statement that happens to not work anymore.

For crawler databases:

INSERT INTO unobtanium_database_info(key,value) VALUES
	('unobtanium_base_schema_version', '0.1.0'),
	('unobtanium_database_kind', 'crawler'),
	('unobtanium_summary_schema_version','1.0.0');

For summary databases:

INSERT INTO unobtanium_database_info(key,value) VALUES
	('unobtanium_base_schema_version', '0.1.0'),
	('unobtanium_database_kind', 'summary'),
	('unobtanium_summary_schema_version','0.0.0');