partsdb

electronic parts inventory
git clone https://git.e1e0.net/partsdb.git
Log | Files | Refs | README | LICENSE

base_data.sql (2296B)

      1 INSERT INTO categories (id, name) VALUES (1, 'Resistors');
      2 INSERT INTO categories (id, name) VALUES (2, 'Capacitors');
      3 INSERT INTO categories (id, name) VALUES (3, 'Inductors/Coils/Trsf');
      4 INSERT INTO categories (id, name) VALUES (4, 'Crystalls');
      5 INSERT INTO categories (id, name) VALUES (5, 'Diodes');
      6 INSERT INTO categories (id, name) VALUES (6, 'LEDs');
      7 INSERT INTO categories (id, name) VALUES (7, 'Optoelectronics');
      8 INSERT INTO categories (id, name) VALUES (8, 'Connectors');
      9 INSERT INTO categories (id, name) VALUES (9, 'Potentiometers');
     10 INSERT INTO categories (id, name) VALUES (10, 'Encoders');
     11 INSERT INTO categories (id, name) VALUES (11, 'Buttons');
     12 INSERT INTO categories (id, name) VALUES (12, 'Switches');
     13 INSERT INTO categories (id, name) VALUES (13, 'Transistors');
     14 INSERT INTO categories (id, name) VALUES (14, 'MicroControllers');
     15 INSERT INTO categories (id, name) VALUES (15, 'Op-Amps');
     16 INSERT INTO categories (id, name) VALUES (16, 'Voltage Regulators');
     17 INSERT INTO categories (id, name) VALUES (17, 'Other ICs');
     18 INSERT INTO categories (id, name) VALUES (18, 'Motors and Fans');
     19 INSERT INTO categories (id, name) VALUES (19, 'Voltage References');
     20 INSERT INTO categories (id, name) VALUES (20, 'Relays');
     21 INSERT INTO categories (id, name) VALUES (21, 'Fuses');
     22 INSERT INTO categories (id, name) VALUES (22, 'Cables');
     23 -- INSERT INTO categories (id, name) VALUES ();
     24 
     25 INSERT INTO storages (id, name) VALUES (2, 'Shelf-C1');
     26 INSERT INTO storages (id, name) VALUES (3, 'Shelf-C2');
     27 INSERT INTO storages (id, name) VALUES (4, 'Shelf-C3');
     28 INSERT INTO storages (id, name) VALUES (5, 'Shelf-C4');
     29 INSERT INTO storages (id, name) VALUES (6, 'Shelf-C5');
     30 INSERT INTO storages (id, name) VALUES (7, 'Shelf-C6');
     31 INSERT INTO storages (id, name) VALUES (13, 'Kallax-C1');
     32 INSERT INTO storages (id, name) VALUES (14, 'Kallax-C2');
     33 INSERT INTO storages (id, name) VALUES (15, 'Kallax-C3');
     34 INSERT INTO storages (id, name) VALUES (16, 'Kallax-C4');
     35 INSERT INTO storages (id, name) VALUES (17, 'Kallax-C5');
     36 INSERT INTO storages (id, name) VALUES (18, 'Kallax-C6');
     37 INSERT INTO storages (id, name) VALUES (19, 'Kallax-C7');
     38 INSERT INTO storages (id, name) VALUES (20, 'Kallax-C8');
     39 INSERT INTO storages (id, name) VALUES (30, 'Unsorted');
     40 -- INSERT INTO storages (id, name) VALUES ();