USE cl_10001;
INSERT INTO tipo
VALUES
    (1, "Termómetro"),
    (2, "Dinamómetro"),
    (3, "Extensómetro"),
    (4, "Vibrómetro"),
    (5, "Pressão"),
    (6, "Acelerómetro X"),
    (7, "Acelerómetro Y"),
    (8, "Acelerómetro Z");
INSERT INTO fase
VALUES
    (1, "Fecho"),
    (2, "Enchimento"),
    (3, "Compactação"),
    (4, "Abertura"),
    (5, "Extração");
INSERT INTO clientes
VALUES
    (10001, "Autocolismos & Company", "Rua das sanita, nº 2", "127.0.0.1", 3306);
INSERT INTO moldes
VALUES
    (10001, 9000, NULL, NULL),
    (10001, 9001, NULL, NULL),
    (10001, 9002, NULL, NULL),
    (10001, 9003, NULL, NULL);
INSERT INTO sensores
VALUES
    (9000, 1, 1, NULL, NULL),
    (9000, 2, 2, NULL, NULL),
    (9000, 3, 2, NULL, NULL),
    (9000, 4, 2, NULL, NULL),
    (9000, 5, 2, NULL, NULL),
    (9001, 1, 1, NULL, NULL),
    (9001, 2, 2, NULL, NULL),
    (9001, 3, 2, NULL, NULL),
    (9001, 4, 2, NULL, NULL),
    (9001, 5, 2, NULL, NULL),
    (9002, 1, 5, NULL, NULL),
    (9002, 2, 3, NULL, NULL),
    (9002, 3, 3, NULL, NULL),
    (9003, 1, 5, NULL, NULL),
    (9003, 2, 3, NULL, NULL),
    (9003, 3, 3, NULL, NULL);
USE cl_10002;
INSERT INTO tipo
VALUES
    (1, "Termómetro"),
    (2, "Dinamómetro"),
    (3, "Extensómetro"),
    (4, "Vibrómetro"),
    (5, "Pressão"),
    (6, "Acelerómetro X"),
    (7, "Acelerómetro Y"),
    (8, "Acelerómetro Z");
INSERT INTO fase
VALUES
    (1, "Fecho"),
    (2, "Enchimento"),
    (3, "Compactação"),
    (4, "Abertura"),
    (5, "Extração");
INSERT INTO clientes
VALUES
    (10002, "Máscaras de Carnaval LDA", "Rua de Elm street, nº 13", "127.0.0.1", 3306);
INSERT INTO moldes
VALUES
    (10002, 9004, NULL, NULL),
    (10002, 9005, NULL, NULL),
    (10002, 9006, NULL, NULL),
    (10002, 9010, NULL, NULL),
    (10002, 9011, NULL, NULL),
    (10002, 9012, NULL, NULL);
INSERT INTO sensores
VALUES
    (9004, 1, 1, NULL, NULL),
    (9004, 2, 2, NULL, NULL),
    (9004, 3, 3, NULL, NULL),
    (9004, 4, 4, NULL, NULL),
    (9004, 5, 5, NULL, NULL),
    (9005, 1, 1, NULL, NULL),
    (9005, 2, 2, NULL, NULL),
    (9005, 3, 3, NULL, NULL),
    (9005, 4, 4, NULL, NULL),
    (9005, 5, 5, NULL, NULL),
    (9006, 1, 1, NULL, NULL),
    (9006, 2, 2, NULL, NULL),
    (9006, 3, 3, NULL, NULL),
    (9006, 4, 4, NULL, NULL),
    (9006, 5, 5, NULL, NULL),
    (9010, 1, 1, NULL, NULL),
    (9010, 2, 2, NULL, NULL),
    (9010, 3, 3, NULL, NULL),
    (9010, 4, 4, NULL, NULL),
    (9010, 5, 5, NULL, NULL),
    (9011, 1, 1, NULL, NULL),
    (9011, 2, 2, NULL, NULL),
    (9011, 3, 3, NULL, NULL),
    (9011, 4, 4, NULL, NULL),
    (9011, 5, 5, NULL, NULL),
    (9012, 1, 1, NULL, NULL),
    (9012, 2, 2, NULL, NULL),
    (9012, 3, 3, NULL, NULL),
    (9012, 4, 4, NULL, NULL),
    (9012, 5, 5, NULL, NULL);
USE cl_10003;
INSERT INTO tipo
VALUES
    (1, "Termómetro"),
    (2, "Dinamómetro"),
    (3, "Extensómetro"),
    (4, "Vibrómetro"),
    (5, "Pressão"),
    (6, "Acelerómetro X"),
    (7, "Acelerómetro Y"),
    (8, "Acelerómetro Z");
INSERT INTO fase
VALUES
    (1, "Fecho"),
    (2, "Enchimento"),
    (3, "Compactação"),
    (4, "Abertura"),
    (5, "Extração");
INSERT INTO clientes
VALUES
    (10003, "Aperture Science", "Travessa de bolo, nº 404", "127.0.0.1", 3306);
INSERT INTO moldes
VALUES
    (10003, 9007, NULL, NULL),
    (10003, 9008, NULL, NULL);
INSERT INTO sensores
VALUES
    (9007, 1, 5, NULL, NULL),
    (9008, 1, 5, NULL, NULL);
USE cl_10004;
INSERT INTO tipo
VALUES
    (1, "Termómetro"),
    (2, "Dinamómetro"),
    (3, "Extensómetro"),
    (4, "Vibrómetro"),
    (5, "Pressão"),
    (6, "Acelerómetro X"),
    (7, "Acelerómetro Y"),
    (8, "Acelerómetro Z");
INSERT INTO fase
VALUES
    (1, "Fecho"),
    (2, "Enchimento"),
    (3, "Compactação"),
    (4, "Abertura"),
    (5, "Extração");
INSERT INTO clientes
VALUES
    (10004, "Black Mesa", "Área 51", "127.0.0.1", 3306);
INSERT INTO moldes
VALUES
    (10004, 9009, NULL, NULL);
INSERT INTO sensores
VALUES
    (9009, 1, 1, NULL, NULL),
    (9009, 2, 1, NULL, NULL),
    (9009, 3, 2, NULL, NULL),
    (9009, 4, 2, NULL, NULL),
    (9009, 5, 3, NULL, NULL),
    (9009, 6, 3, NULL, NULL),
    (9009, 7, 4, NULL, NULL),
    (9009, 8, 4, NULL, NULL),
    (9009, 9, 5, NULL, NULL),
    (9009, 10, 5, NULL, NULL);
USE cl_10005;
INSERT INTO tipo
VALUES
    (1, "Termómetro"),
    (2, "Dinamómetro"),
    (3, "Extensómetro"),
    (4, "Vibrómetro"),
    (5, "Pressão"),
    (6, "Acelerómetro X"),
    (7, "Acelerómetro Y"),
    (8, "Acelerómetro Z");
INSERT INTO fase
VALUES
    (1, "Fecho"),
    (2, "Enchimento"),
    (3, "Compactação"),
    (4, "Abertura"),
    (5, "Extração");
INSERT INTO clientes
VALUES
    (10005, "Vault-Tec Corporation", "Rua da caixa-forte, nº 1234", "127.0.0.1", 3306);
INSERT INTO moldes
VALUES
    (10005, 9013, NULL, NULL);
INSERT INTO sensores
VALUES
    (9013, 1, 3, NULL, NULL);
