partsdb

commit 25b341a8f190c104b95bd8353ed7f80a58b2af4f
parent 806c8f8e4ad28cb649afa8ea3c502d8d21f6901f
Author: Paco Esteban <paco@e1e0.net>
Date:   Sun, 14 Mar 2021 13:06:59 +0100

categories and storages base data

Diffstat:
M
base_data.sql
 | 
43
++++++++++++++++++++++++++++++++++++++-----

1 file changed, 38 insertions(+), 5 deletions(-)
diff --git a/base_data.sql b/base_data.sql
@@ -1,5 +1,38 @@
-INSERT INTO categories (name) VALUES ('Resistors');
-INSERT INTO categories (name) VALUES ('Capacitors');
-INSERT INTO categories (name) VALUES ('Diodes');
-INSERT INTO categories (name) VALUES ();
-INSERT INTO categories (name) VALUES ();
+INSERT INTO categories (id, name) VALUES (1, 'Resistors');
+INSERT INTO categories (id, name) VALUES (2, 'Capacitors');
+INSERT INTO categories (id, name) VALUES (3, 'Inductors');
+INSERT INTO categories (id, name) VALUES (4, 'Crystalls');
+INSERT INTO categories (id, name) VALUES (5, 'Diodes');
+INSERT INTO categories (id, name) VALUES (6, 'LEDs');
+INSERT INTO categories (id, name) VALUES (7, 'Displays');
+INSERT INTO categories (id, name) VALUES (8, 'Connectors');
+INSERT INTO categories (id, name) VALUES (9, 'Potentiometers');
+INSERT INTO categories (id, name) VALUES (10, 'Encoders');
+INSERT INTO categories (id, name) VALUES (11, 'Buttons');
+INSERT INTO categories (id, name) VALUES (12, 'Switches');
+INSERT INTO categories (id, name) VALUES (13, 'MicroControllers');
+INSERT INTO categories (id, name) VALUES (14, 'Op-Amps');
+INSERT INTO categories (id, name) VALUES (15, 'Voltage Regulators');
+INSERT INTO categories (id, name) VALUES (16, 'Other ICs');
+INSERT INTO categories (id, name) VALUES (17, 'Motors');
+-- INSERT INTO categories (id, name) VALUES ();
+
+INSERT INTO storages (id, name) VALUES (1, 'Shelf-C1');
+INSERT INTO storages (id, name) VALUES (2, 'Shelf-C2');
+INSERT INTO storages (id, name) VALUES (3, 'Shelf-C3');
+INSERT INTO storages (id, name) VALUES (4, 'Shelf-C4');
+INSERT INTO storages (id, name) VALUES (5, 'Shelf-C5');
+INSERT INTO storages (id, name) VALUES (6, 'Shelf-C6');
+INSERT INTO storages (id, name) VALUES (7, 'Kallax-C1');
+INSERT INTO storages (id, name) VALUES (8, 'Kallax-C2');
+INSERT INTO storages (id, name) VALUES (9, 'Kallax-C3');
+INSERT INTO storages (id, name) VALUES (10, 'Kallax-C4');
+INSERT INTO storages (id, name) VALUES (11, 'Kallax-C5');
+INSERT INTO storages (id, name) VALUES (12, 'Kallax-C6');
+INSERT INTO storages (id, name) VALUES (13, 'Kallax-C7');
+INSERT INTO storages (id, name) VALUES (14, 'Kallax-C8');
+INSERT INTO storages (id, name) VALUES (15, 'Kallax-D1');
+INSERT INTO storages (id, name) VALUES (16, 'Kallax-D2');
+INSERT INTO storages (id, name) VALUES (17, 'Kallax-D3');
+INSERT INTO storages (id, name) VALUES (18, 'BigDrawer');
+-- INSERT INTO storages (id, name) VALUES ();