create table w_produto (
  pk_id integer,
  descricao varchar(4),
  preco decimal(15, 2),
  quantidade decimal(15, 2)
 );
  
CREATE TABLE client(
  name varchar(23),
  id integer primary key generated always as identity not null default 0
);
GO
COMMIT

INSERT INTO
  client ( name ) values ('Roberta Franca')

Create table phone(
  description varchar(11),
  id integer primary key generated always as identity not null,
  parentid integer not null
);

Create table Historico_compras(
  Id integer primary key generated always as identity not null,
  Caixa varchar(23) not null,
  Custototal decimal(20,2),
  Funcionario varchar(23) not null,
  Data date not null, 
  Hora time not null
);
GO
COMMIT

Create table last_user(
  Id integer primary key generated always as identity not null,    
  Name varchar(31) not null,
  Senha varchar(31) not null
);

CREATE TABLE NivelDeAcesso(
  name varchar(64) primary key not null,
  categoria varchar(64) not null
);

CREATE TABLE TelasAcessiveis(
  Nivel integer not null primary key,
  Venda char(1) not null,
  Caduser char(1) not null,
  CadProd char(1) not null,
  CadNiveis char(1) not null,
  Imprimir char(1) not null,
  Historico char(1) not null,
  Categorias char(1) not null
);

Create table Chat_CISSMIRIM(
  Id integer primary key generated always as identity NOT NULL,
  Nome VARCHAR(50) NOT NULL,
  Companhia VARCHAR (30) NOT NULL,
  Mensagem VARCHAR (500)NOT NULL,
  Data DATE NOT NULL,
  Hora VARCHAR(8) NOT NULL
);
GO COMMIT

Create table LOG (
  Id integer primary  key generated always as identity,
  Usuario varchar(31) not null,
  Acao varchar(300) not null,
  data date not null,
  horavarchar(8) not null
);