hVQS3Szj

1BEGIN TRANSACTION;
2DROP TABLE IF EXISTS supported_devices;
3DROP TABLE IF EXISTS device_address;
4CREATE TABLE supported_devices(device_id INTEGER PRIMARY KEY ASC, device TEXT NOT NULL, build_id TEXT NOT NULL, check_property_name TEXT, check_property_value TEXT, UNIQUE (device, build_id, check_property_name, check_property_value));
5
6CREATE TABLE device_address(device_id INTEGER NOT NULL, name TEXT NOT NULL, value INTEGER NOT NULL, PRIMARY KEY(device_id, name));
7
8INSERT INTO supported_devices(device_id, device, build_id, check_property_name, check_property_value) VALUES(1, 'ARM2-MX6DQ', 'UNKNOWN', 'ro.build.version.incremental', '.20190201.122706');
9  INSERT INTO device_address(device_id, name, value) VALUES(1, 'prepare_kernel_cred', '0xc00936dc');
10  INSERT INTO device_address(device_id, name, value) VALUES(1, 'commit_creds', '0xc0092ea4');
11  INSERT INTO device_address(device_id, name, value) VALUES(1, 'remap_pfn_range', '0xc00e720c');
12  INSERT INTO device_address(device_id, name, value) VALUES(1, 'ptmx_fops', '0xc0626c54');
13  INSERT INTO device_address(device_id, name, value) VALUES(1, 'vmalloc_exec', '0xc00f2200');
14
15INSERT INTO supported_devices(device_id, device, build_id, check_property_name, check_property_value) VALUES(2, 'ARM2-MX6DQ', 'UNKNOWN', 'ro.build.version.incremental', '.20190401.175249');
16  INSERT INTO device_address(device_id, name, value) VALUES(2, 'prepare_kernel_cred', '0xc00936dc');
17  INSERT INTO device_address(device_id, name, value) VALUES(2, 'commit_creds', '0xc0092ea4');
18  INSERT INTO device_address(device_id, name, value) VALUES(2, 'remap_pfn_range', '0xc00e73cc');
19  INSERT INTO device_address(device_id, name, value) VALUES(2, 'ptmx_fops', '0xc0626cb4');
20  INSERT INTO device_address(device_id, name, value) VALUES(2, 'vmalloc_exec', '0xc00f23c0');
21
22COMMIT;