lucas.favaro
518076f90f
1568 - Funcionários 1572 - Sub-categoria 1574 - Fornecedores 1573 - Tela de créditos 1567 - Tela lançamento de débitos 1571 - Sócios 1570 - Forma pagamento 1565 - Veículos 1566 - Operação
90 lines
2.1 KiB
SQL
90 lines
2.1 KiB
SQL
CREATE SEQUENCE public.categoria_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.categoria_seq RESTART WITH 15;
|
|
|
|
CREATE SEQUENCE public.combustivel_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.combustivel_seq RESTART WITH 10;
|
|
|
|
CREATE SEQUENCE public.controle_desp_comb_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.controle_desp_comb_seq RESTART WITH 6;
|
|
|
|
CREATE SEQUENCE public.controle_desp_op_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.controle_desp_op_seq RESTART WITH 30;
|
|
|
|
CREATE SEQUENCE public.controle_desp_pes_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.controle_desp_pes_seq RESTART WITH 7;
|
|
|
|
CREATE SEQUENCE public.controle_rec_fr_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.controle_rec_fr_seq RESTART WITH 7;
|
|
|
|
CREATE SEQUENCE public.forma_pagamento_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.forma_pagamento_seq RESTART WITH 11;
|
|
|
|
CREATE SEQUENCE public.fornecedor_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.fornecedor_seq RESTART WITH 12;
|
|
|
|
CREATE SEQUENCE public.funcionario_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.funcionario_seq RESTART WITH 9;
|
|
|
|
CREATE SEQUENCE public.operacao_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.operacao_seq RESTART WITH 15;
|
|
|
|
CREATE SEQUENCE public.socio_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.socio_seq RESTART WITH 12;
|
|
|
|
CREATE SEQUENCE public.subcategoria_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.subcategoria_seq RESTART WITH 3;
|
|
|
|
CREATE SEQUENCE public.veiculo_seq
|
|
INCREMENT 1 MINVALUE 1
|
|
MAXVALUE 99999999 START 1
|
|
CACHE 1;
|
|
|
|
ALTER SEQUENCE public.veiculo_seq RESTART WITH 6; |