GZQggsEB

1DROP DATABASE IF EXISTS mydb;
2CREATE DATABASE IF NOT EXISTS mydb;
3
4USE mydb;
5
6CREATE TABLE clientes (
7  cod_clientes INT UNSIGNED NOT NULL AUTO_INCREMENT,
8  nome VARCHAR (20) NOT NULL,
9  PRIMARY KEY (cod_clientes)
10) ENGINE = innodb;
11
12CREATE TABLE erros(
13  cod_erros INT UNSIGNED NOT NULL AUTO_INCREMENT,
14  nome_erro VARCHAR (150) NOT NULL,
15  solucao VARCHAR (255) NOT NULL,
16  data_ocorrencia DATE,
17  sistema VARCHAR (30) NOT NULL,
18  PRIMARY KEY (cod_erros)
19  ) ENGINE = innodb;
20
21CREATE TABLE funcionarios (
22  cod_funcionarios INT UNSIGNED NOT NULL AUTO_INCREMENT,
23  login VARCHAR(15) NOT NULL,
24  email VARCHAR(50) NOT NULL,
25  senha VARCHAR(15) NOT NULL,
26  cpf VARCHAR (11) NOT NULL UNIQUE,
27  PRIMARY KEY (cod_funcionarios),
28  Fk_Clientes INT UNSIGNED,
29  Fk_Erros INT UNSIGNED,
30  FOREIGN KEY Fk_Clientes (Fk_Clientes) REFERENCES clientes (cod_clientes) ON UPDATE CASCADE ON DELETE RESTRICT,
31  FOREIGN KEY Fk_Erros (Fk_erros) REFERENCES erros (cod_erros) ON UPDATE CASCADE ON DELETE RESTRICT
32  ) ENGINE = innodb; 
33     
34CREATE VIEW VIEW_LISTA_ERROS AS SELECT nome AS Cliente, 
35nome_erro AS Erro, solucao AS Solucao, 
36data_ocorrencia AS Data, sistema AS Sistema 
37FROM  erros, clientes;
38
39select *from VIEW_LISTA_ERROS; 
40     
41if ($row == 0) {
42    $query = "insert into erros(nome_erro,solucao,data_ocorrencia,sistema)
43    values('{$nome_erro}', ('{$solucao}'), ('{$data}'), '{$sistema}')";
44
45    $query2 = "insert into clientes(nome)
46    values('{$nome_cliente}'";
47
48    mysqli_query(conexao(), $query);
49
50    mysqli_query(conexao(), $query2);
51
52    header('location: paginaConsulta.php');
53  }
54}