houzion-db-insert.sql

INSERT INTO nivel_acesso VALUES(DEFAULT, 'Administrador');
INSERT INTO nivel_acesso VALUES(DEFAULT, 'Moderador');
INSERT INTO nivel_acesso VALUES(DEFAULT, 'Usuário');
INSERT INTO nivel_acesso VALUES(DEFAULT, 'Visitante');
INSERT INTO familia VALUES(DEFAULT, 'Alunos TCC', 'CTI - "Profº Isaac Portal Roldán"');
INSERT INTO familia VALUES(DEFAULT, 'Santos', 'Residência Bauru - Jd. Bela Vista');
INSERT INTO grupo VALUES(DEFAULT, 1, 'Admin');
INSERT INTO grupo VALUES(DEFAULT, 1, 'Gabriel');
INSERT INTO grupo VALUES(DEFAULT, 1, 'Gisele');
INSERT INTO grupo VALUES(DEFAULT, 1, 'Caio');
INSERT INTO grupo VALUES(DEFAULT, 1, 'Pedro');
INSERT INTO grupo VALUES(DEFAULT, 1, 'José Rogério');
INSERT INTO grupo VALUES(DEFAULT, 1, 'José Almino');
INSERT INTO grupo VALUES(DEFAULT, 2, 'Gabriel');
INSERT INTO grupo VALUES(DEFAULT, 2, 'Amigos Gabriel');
INSERT INTO grupo VALUES(DEFAULT, 2, 'Irmãs');
INSERT INTO grupo VALUES(DEFAULT, 2, 'Madrasta');
INSERT INTO grupo VALUES(DEFAULT, 2, 'Pai');
INSERT INTO tipo VALUES(DEFAULT, 'Temperatura', 'temp');
INSERT INTO tipo VALUES(DEFAULT, 'Umidade', 'humidity');
INSERT INTO tipo VALUES(DEFAULT, 'Lâmpada', 'lamp');
INSERT INTO tipo VALUES(DEFAULT, 'Porta', 'door');
INSERT INTO tipo VALUES(DEFAULT, 'Miscelânea', 'misc');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Sala de TV');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Sala de jantar');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Cozinha');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Quarto');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Banheiro');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Quintal');
INSERT INTO ambiente VALUES(DEFAULT, 1, 'Geral');
INSERT INTO controle VALUES(DEFAULT, 1, 3, 'LUZ-TV', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 2, 3, 'LUZ-Jantar', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 3, 3, 'LUZ-Cozinha', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 4, 3, 'LUZ-Quarto', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 5, 3, 'LUZ-Banheiro', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 6, 3, 'LUZ-Caminho', 'lightbulb', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 6, 4, 'Portão', 'key', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 7, 5, 'Ventiladores', 'snowflake', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 7, 1, 'Temperatura', 'thermometer-half', DEFAULT);
INSERT INTO controle VALUES(DEFAULT, 7, 4, 'Umidade', 'tint', DEFAULT);
INSERT INTO permissao VALUES(1, 1);
INSERT INTO permissao VALUES(1, 2);
INSERT INTO permissao VALUES(1, 3);
INSERT INTO permissao VALUES(1, 4);
INSERT INTO permissao VALUES(1, 5);
INSERT INTO permissao VALUES(1, 6);
INSERT INTO permissao VALUES(1, 7);
INSERT INTO permissao VALUES(1, 8);
INSERT INTO permissao VALUES(1, 9);
INSERT INTO permissao VALUES(1, 10);
INSERT INTO usuario VALUES (DEFAULT, 'Administrador', 'Master', 'admin', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 1, 1, '2018-01-01 10:30:10', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'Gabriel', 'Santos', 'Makhiel', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 2, 2, '2018-01-01 10:30:10', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'Gisele', 'Almeida', 'giselinha', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 3, 2, '2018-01-01 10:30:10', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'Caio', 'Lucas', 'caiolucas', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 4, 2, '2018-07-25 20:51:00', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'Pedro', 'Zamboni', 'zambonifofex', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 5, 2, '2018-07-25 20:29:25', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'José', 'Rogério', 'joserogerio', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 6, 2, '2018-07-25 20:52:42', NULL);
INSERT INTO usuario VALUES (DEFAULT, 'José', 'Almino', 'josealmino', '202cb962ac59075b964b07152d234b70', '[email protected]', 1, 7, 2, '2018-01-01 10:30:10', NULL);