Merge ~cjwatson/launchpad:remove-hardwaredb-sampledata into launchpad:master
- Git
- lp:~cjwatson/launchpad
- remove-hardwaredb-sampledata
- Merge into master
Proposed by
Colin Watson
Status: | Merged |
---|---|
Approved by: | Colin Watson |
Approved revision: | 63c173898cf1afa727804bf580b8ea8108d3d19d |
Merge reported by: | Otto Co-Pilot |
Merged at revision: | not available |
Proposed branch: | ~cjwatson/launchpad:remove-hardwaredb-sampledata |
Merge into: | launchpad:master |
Diff against target: |
265 lines (+0/-154) 2 files modified
database/sampledata/current-dev.sql (+0/-77) database/sampledata/current.sql (+0/-77) |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Cristian Gonzalez (community) | Approve | ||
Review via email: mp+399287@code.launchpad.net |
Commit message
Remove hardware database rows from sampledata
Description of the change
We removed the corresponding database model a while back, so there's no point spending time inserting these rows during the test suite.
To post a comment you must log in.
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | diff --git a/database/sampledata/current-dev.sql b/database/sampledata/current-dev.sql |
2 | index 33ae82d..7287059 100644 |
3 | --- a/database/sampledata/current-dev.sql |
4 | +++ b/database/sampledata/current-dev.sql |
5 | @@ -3898,40 +3898,18 @@ ALTER TABLE gitsubscription ENABLE TRIGGER ALL; |
6 | |
7 | ALTER TABLE hwvendorname DISABLE TRIGGER ALL; |
8 | |
9 | -INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI'); |
10 | -INSERT INTO hwvendorname (id, name) VALUES (2, 'Unknown'); |
11 | -INSERT INTO hwvendorname (id, name) VALUES (3, 'Optiarc'); |
12 | -INSERT INTO hwvendorname (id, name) VALUES (4, 'SEAGATE'); |
13 | -INSERT INTO hwvendorname (id, name) VALUES (5, 'nVidia Corporation'); |
14 | -INSERT INTO hwvendorname (id, name) VALUES (6, 'Cypress Semiconductor Corp.'); |
15 | - |
16 | |
17 | ALTER TABLE hwvendorname ENABLE TRIGGER ALL; |
18 | |
19 | |
20 | ALTER TABLE hwvendorid DISABLE TRIGGER ALL; |
21 | |
22 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (1, 0, 'MSI', 1); |
23 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (2, 1, '0x10de', 5); |
24 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (3, 2, '0x04b4', 6); |
25 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (4, 2, '0x0dda', 2); |
26 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (5, 7, 'Optiarc', 3); |
27 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (6, 7, 'SEAGATE', 4); |
28 | - |
29 | |
30 | ALTER TABLE hwvendorid ENABLE TRIGGER ALL; |
31 | |
32 | |
33 | ALTER TABLE hwdevice DISABLE TRIGGER ALL; |
34 | |
35 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (1, 1, 'MS-7369', NULL, 'MS-7369', 0); |
36 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (2, 2, '0x0455', NULL, 'MCP65 USB Controller', 0); |
37 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (3, 3, '0x6560', NULL, 'CY7C65640 USB-2.0 "TetraHub"', 0); |
38 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (4, 4, '0x2026', NULL, 'USB2.0 Card Reader', 0); |
39 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (5, 2, '0x045d', NULL, 'MCP65 SATA Controller', 0); |
40 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (6, 5, 'DVD RW AD-7170S ', NULL, 'DVD RW AD-7170S', 0); |
41 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (7, 6, 'ST3250820NS ', NULL, 'ST3250820NS', 0); |
42 | - |
43 | |
44 | ALTER TABLE hwdevice ENABLE TRIGGER ALL; |
45 | |
46 | @@ -3951,39 +3929,12 @@ ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL; |
47 | |
48 | ALTER TABLE hwdriver DISABLE TRIGGER ALL; |
49 | |
50 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL); |
51 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (2, 'linux-image-2.6.24-19-generic', 'usb', NULL); |
52 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (3, 'linux-image-2.6.24-19-generic', 'usb-storage', NULL); |
53 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (4, 'linux-image-2.6.24-19-generic', 'sd', NULL); |
54 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (5, 'linux-image-2.6.24-19-generic', 'hub', NULL); |
55 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (6, 'linux-image-2.6.24-19-generic', 'ahci', NULL); |
56 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (7, 'linux-image-2.6.24-19-generic', 'sr', NULL); |
57 | - |
58 | |
59 | ALTER TABLE hwdriver ENABLE TRIGGER ALL; |
60 | |
61 | |
62 | ALTER TABLE hwdevicedriverlink DISABLE TRIGGER ALL; |
63 | |
64 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (1, 1, NULL); |
65 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (2, 2, NULL); |
66 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (3, 2, 1); |
67 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (4, 2, 2); |
68 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (5, 3, NULL); |
69 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (6, 3, 2); |
70 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (7, 4, NULL); |
71 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (8, 4, 2); |
72 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (9, 4, 3); |
73 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (10, 4, 4); |
74 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (11, 3, 5); |
75 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (12, 2, 5); |
76 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (13, 5, NULL); |
77 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (14, 5, 6); |
78 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (15, 6, NULL); |
79 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (16, 6, 7); |
80 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (17, 7, NULL); |
81 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (18, 7, 4); |
82 | - |
83 | |
84 | ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL; |
85 | |
86 | @@ -4003,18 +3954,12 @@ ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL; |
87 | |
88 | ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL; |
89 | |
90 | -INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600'); |
91 | -INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (2, 'MSI MS-7369'); |
92 | - |
93 | |
94 | ALTER TABLE hwsystemfingerprint ENABLE TRIGGER ALL; |
95 | |
96 | |
97 | ALTER TABLE hwsubmission DISABLE TRIGGER ALL; |
98 | |
99 | -INSERT INTO hwsubmission (id, date_created, date_submitted, format, status, private, contactable, submission_key, owner, distroarchseries, raw_submission, system_fingerprint, raw_emailaddress) VALUES (1, '2007-09-11 00:00:00', '2007-09-11 15:23:45.653316', 1, 1, false, false, 'test_submission_id_1', 12, NULL, 63, 1, 'test@canonical.com'); |
100 | -INSERT INTO hwsubmission (id, date_created, date_submitted, format, status, private, contactable, submission_key, owner, distroarchseries, raw_submission, system_fingerprint, raw_emailaddress) VALUES (2, '2008-09-26 17:19:18', '2008-09-30 08:19:00.222131', 1, 2, false, false, 'sample-submission', 12, 6, 92, 2, 'test@canonical.com'); |
101 | - |
102 | |
103 | ALTER TABLE hwsubmission ENABLE TRIGGER ALL; |
104 | |
105 | @@ -4057,28 +4002,6 @@ ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL; |
106 | |
107 | ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL; |
108 | |
109 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11); |
110 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (2, 2, 2, 1, 121); |
111 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (3, 3, 2, 2, 121); |
112 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (4, 4, 2, 3, 122); |
113 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (5, 5, 2, 4, 123); |
114 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (6, 6, 2, 5, 123); |
115 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (7, 7, 2, 6, 124); |
116 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (8, 8, 2, 7, 124); |
117 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (9, 9, 2, 8, 125); |
118 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (10, 10, 2, 9, 136); |
119 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (11, 10, 2, 9, 130); |
120 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (12, 10, 2, 9, 127); |
121 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (13, 10, 2, 9, 133); |
122 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (14, 11, 2, 6, 139); |
123 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (15, 12, 2, 4, 140); |
124 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (16, 13, 2, 1, 65); |
125 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (17, 14, 2, 16, 65); |
126 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (18, 15, 2, 17, 67); |
127 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (19, 16, 2, 18, 67); |
128 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (20, 17, 2, 17, 71); |
129 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (21, 18, 2, 20, 71); |
130 | - |
131 | |
132 | ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL; |
133 | |
134 | diff --git a/database/sampledata/current.sql b/database/sampledata/current.sql |
135 | index 4711745..dfed6dd 100644 |
136 | --- a/database/sampledata/current.sql |
137 | +++ b/database/sampledata/current.sql |
138 | @@ -3822,40 +3822,18 @@ ALTER TABLE gitsubscription ENABLE TRIGGER ALL; |
139 | |
140 | ALTER TABLE hwvendorname DISABLE TRIGGER ALL; |
141 | |
142 | -INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI'); |
143 | -INSERT INTO hwvendorname (id, name) VALUES (2, 'Unknown'); |
144 | -INSERT INTO hwvendorname (id, name) VALUES (3, 'Optiarc'); |
145 | -INSERT INTO hwvendorname (id, name) VALUES (4, 'SEAGATE'); |
146 | -INSERT INTO hwvendorname (id, name) VALUES (5, 'nVidia Corporation'); |
147 | -INSERT INTO hwvendorname (id, name) VALUES (6, 'Cypress Semiconductor Corp.'); |
148 | - |
149 | |
150 | ALTER TABLE hwvendorname ENABLE TRIGGER ALL; |
151 | |
152 | |
153 | ALTER TABLE hwvendorid DISABLE TRIGGER ALL; |
154 | |
155 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (1, 0, 'MSI', 1); |
156 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (2, 1, '0x10de', 5); |
157 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (3, 2, '0x04b4', 6); |
158 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (4, 2, '0x0dda', 2); |
159 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (5, 7, 'Optiarc', 3); |
160 | -INSERT INTO hwvendorid (id, bus, vendor_id_for_bus, vendor_name) VALUES (6, 7, 'SEAGATE', 4); |
161 | - |
162 | |
163 | ALTER TABLE hwvendorid ENABLE TRIGGER ALL; |
164 | |
165 | |
166 | ALTER TABLE hwdevice DISABLE TRIGGER ALL; |
167 | |
168 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (1, 1, 'MS-7369', NULL, 'MS-7369', 0); |
169 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (2, 2, '0x0455', NULL, 'MCP65 USB Controller', 0); |
170 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (3, 3, '0x6560', NULL, 'CY7C65640 USB-2.0 "TetraHub"', 0); |
171 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (4, 4, '0x2026', NULL, 'USB2.0 Card Reader', 0); |
172 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (5, 2, '0x045d', NULL, 'MCP65 SATA Controller', 0); |
173 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (6, 5, 'DVD RW AD-7170S ', NULL, 'DVD RW AD-7170S', 0); |
174 | -INSERT INTO hwdevice (id, bus_vendor_id, bus_product_id, variant, name, submissions) VALUES (7, 6, 'ST3250820NS ', NULL, 'ST3250820NS', 0); |
175 | - |
176 | |
177 | ALTER TABLE hwdevice ENABLE TRIGGER ALL; |
178 | |
179 | @@ -3875,39 +3853,12 @@ ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL; |
180 | |
181 | ALTER TABLE hwdriver DISABLE TRIGGER ALL; |
182 | |
183 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL); |
184 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (2, 'linux-image-2.6.24-19-generic', 'usb', NULL); |
185 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (3, 'linux-image-2.6.24-19-generic', 'usb-storage', NULL); |
186 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (4, 'linux-image-2.6.24-19-generic', 'sd', NULL); |
187 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (5, 'linux-image-2.6.24-19-generic', 'hub', NULL); |
188 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (6, 'linux-image-2.6.24-19-generic', 'ahci', NULL); |
189 | -INSERT INTO hwdriver (id, package_name, name, license) VALUES (7, 'linux-image-2.6.24-19-generic', 'sr', NULL); |
190 | - |
191 | |
192 | ALTER TABLE hwdriver ENABLE TRIGGER ALL; |
193 | |
194 | |
195 | ALTER TABLE hwdevicedriverlink DISABLE TRIGGER ALL; |
196 | |
197 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (1, 1, NULL); |
198 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (2, 2, NULL); |
199 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (3, 2, 1); |
200 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (4, 2, 2); |
201 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (5, 3, NULL); |
202 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (6, 3, 2); |
203 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (7, 4, NULL); |
204 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (8, 4, 2); |
205 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (9, 4, 3); |
206 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (10, 4, 4); |
207 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (11, 3, 5); |
208 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (12, 2, 5); |
209 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (13, 5, NULL); |
210 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (14, 5, 6); |
211 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (15, 6, NULL); |
212 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (16, 6, 7); |
213 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (17, 7, NULL); |
214 | -INSERT INTO hwdevicedriverlink (id, device, driver) VALUES (18, 7, 4); |
215 | - |
216 | |
217 | ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL; |
218 | |
219 | @@ -3927,18 +3878,12 @@ ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL; |
220 | |
221 | ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL; |
222 | |
223 | -INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600'); |
224 | -INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (2, 'MSI MS-7369'); |
225 | - |
226 | |
227 | ALTER TABLE hwsystemfingerprint ENABLE TRIGGER ALL; |
228 | |
229 | |
230 | ALTER TABLE hwsubmission DISABLE TRIGGER ALL; |
231 | |
232 | -INSERT INTO hwsubmission (id, date_created, date_submitted, format, status, private, contactable, submission_key, owner, distroarchseries, raw_submission, system_fingerprint, raw_emailaddress) VALUES (1, '2007-09-11 00:00:00', '2007-09-11 15:23:45.653316', 1, 1, false, false, 'test_submission_id_1', 12, NULL, 63, 1, 'test@canonical.com'); |
233 | -INSERT INTO hwsubmission (id, date_created, date_submitted, format, status, private, contactable, submission_key, owner, distroarchseries, raw_submission, system_fingerprint, raw_emailaddress) VALUES (2, '2008-09-26 17:19:18', '2008-09-30 08:19:00.222131', 1, 2, false, false, 'sample-submission', 12, 6, 92, 2, 'test@canonical.com'); |
234 | - |
235 | |
236 | ALTER TABLE hwsubmission ENABLE TRIGGER ALL; |
237 | |
238 | @@ -3981,28 +3926,6 @@ ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL; |
239 | |
240 | ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL; |
241 | |
242 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11); |
243 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (2, 2, 2, 1, 121); |
244 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (3, 3, 2, 2, 121); |
245 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (4, 4, 2, 3, 122); |
246 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (5, 5, 2, 4, 123); |
247 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (6, 6, 2, 5, 123); |
248 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (7, 7, 2, 6, 124); |
249 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (8, 8, 2, 7, 124); |
250 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (9, 9, 2, 8, 125); |
251 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (10, 10, 2, 9, 136); |
252 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (11, 10, 2, 9, 130); |
253 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (12, 10, 2, 9, 127); |
254 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (13, 10, 2, 9, 133); |
255 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (14, 11, 2, 6, 139); |
256 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (15, 12, 2, 4, 140); |
257 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (16, 13, 2, 1, 65); |
258 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (17, 14, 2, 16, 65); |
259 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (18, 15, 2, 17, 67); |
260 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (19, 16, 2, 18, 67); |
261 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (20, 17, 2, 17, 71); |
262 | -INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (21, 18, 2, 20, 71); |
263 | - |
264 | |
265 | ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL; |
266 |
Nice clean up!