Skip to content

Instantly share code, notes, and snippets.

@rodrigolang

rodrigolang/call_login.sql

Last active December 11, 2015 01:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rodrigolang/4525302 to your computer and use it in GitHub Desktop.
Save rodrigolang/4525302 to your computer and use it in GitHub Desktop.
Download ZIP
Script para criação da tabela no banco de dados PostgreSQL para o AGI de ligações por login e senha.
Raw
call_login.sql
CREATE TABLE login_ast (
login_id SERIAL,
nome varchar(30) NOT NULL,
login integer NOT NULL,
senha integer NOT NULL,
contexto varchar(30) NOT NULL,
CONSTRAINT login_ast_pk PRIMARY KEY (nome, login, senha, contexto),
CONSTRAINT login_ast_idx UNIQUE (login)
);
COMMENT ON TABLE login_ast IS 'Tabela do Asterisk de senhas para realizar ligacoes';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment