17 Commits

Author	SHA1	Message	Date
Markus Birth	1e1bfcddd3	Prepare tables for changelog.	2018-11-15 12:31:15 +01:00
Markus Birth	669618b46c	Fix type of date columns.	2018-11-15 12:30:51 +01:00
Markus Birth	35a77cde75	Added field to track revoked status of firmwares.	2018-05-16 16:14:21 +02:00
Markus Birth	c759256adc	Added possibly useful views.	2017-12-19 22:42:06 +01:00
Markus Birth	90c86f25f4	Separated initial data from db schema. Minor optimisations.	2017-12-19 22:36:42 +01:00
thurask	ed7a847b90	update location info for prds	2017-12-19 11:53:35 -05:00
Markus Birth	0d75037078	Add new CU Ref.	2017-12-17 01:51:29 +01:00
Markus Birth	ad530c6967	Add known PRDs and models to database.	2017-12-16 16:26:32 +01:00
Markus Birth	7deee59c3a	Restructure database. Also derive seenDate from filename (stamp).	2017-12-15 01:05:07 +01:00
Markus Birth	6d8f3bda7b	Move fv and tv into files table.	2017-12-12 01:51:18 +01:00
Markus Birth	d9daa4ddee	Move files into own table. Fix double UTF-8 encoding.	2017-12-11 02:40:07 +01:00
Markus Birth	c6cbd890e3	Ignore duplicate entries in db.	2017-12-11 01:28:52 +01:00
Markus Birth	44cd418c7b	Added seenDate also added note about FW_ID.	2017-11-04 00:56:55 +01:00
Markus Birth	d09dc1507a	Fix db schema.	2017-11-02 00:05:39 +01:00
Markus Birth	37a0433796	More info about update files.	2017-11-01 19:26:42 +01:00
Markus Birth	570ace7307	Use one table for all update files. Added mapping table.	2017-11-01 18:55:32 +01:00
Markus Birth	f2c2942d9c	First draft of database structure.	2017-11-01 18:47:41 +01:00