JCL/sql/Scripts/jegatroncomponents_smd_ceramic_cap.sql

INSERT INTO component_packages (component_package, package_display_name)
VALUES
('C01005', '01005 (0402 Metric)'),
('C0201', '0201 (0603 Metric)'),
('C0402', '0402 (1010 Metric)'),
('C0603', '0603 (1608 Metric)'),
('C0805', '0805 (2012 Metric)'),
('C1206', '1206 (3216 Metric)'),
('C1210', '1210 (3225 Metric)'),
('C1812', '1812 (4532 Metric)'),
('C2010', '2010 (5025 Metric)'),
('C2512', '2512 (6332 Metric)')
ON duplicate KEY UPDATE package_display_name = package_display_name;

INSERT INTO footprints_kicad (component_package, kicad_footprint, kicad_footprint_filter)
VALUES
('C01005', 'Capacitor_SMD:C_01005_0402Metric', 'Capacitor_SMD:C_01005_*'),
('C0201', 'Capacitor_SMD:C_0201_0603Metric', 'Capacitor_SMD:C_0201_*'),
('C0402', 'Capacitor_SMD:C_0402_1010Metric', 'Capacitor_SMD:C_0402_*'),
('C0603', 'Capacitor_SMD:C_0603_1608Metric', 'Capacitor_SMD:C_0603_*'),
('C0805', 'Capacitor_SMD:C_0805_2012Metric', 'Capacitor_SMD:C_0805_*'),
('C1206', 'Capacitor_SMD:C_1206_3216Metric', 'Capacitor_SMD:C_1206_*'),
('C1210', 'Capacitor_SMD:C_1210_3225Metric', 'Capacitor_SMD:C_1210_*'),
('R1812', 'Capacitor_SMD:C_1812_4532Metric', 'Capacitor_SMD:C_1812_*'),
('R2010', 'Capacitor_SMD:C_2010_5025Metric', 'Capacitor_SMD:C_2010_*'),
('R2512', 'Capacitor_SMD:C_2512_6332Metric', 'Capacitor_SMD:C_2512_*')
ON duplicate KEY UPDATE kicad_footprint = kicad_footprint;