Skip to content

Instantly share code, notes, and snippets.

@mokocchi
Created March 8, 2017 06:23
Show Gist options
  • Save mokocchi/cf51dd24b34553808b0b8107580fa8c0 to your computer and use it in GitHub Desktop.
Save mokocchi/cf51dd24b34553808b0b8107580fa8c0 to your computer and use it in GitHub Desktop.
postgres script for sequence intialization (CTF-AdminDesafios)
CREATE SEQUENCE category_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE category_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE category_id_seq RESTART 1;
CREATE SEQUENCE hint_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE hint_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE hint_id_seq RESTART 1;
CREATE SEQUENCE challenge_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE challenge_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE challenge_id_seq RESTART 1;
CREATE SEQUENCE team_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE team_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE team_id_seq RESTART 1;
CREATE SEQUENCE player_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE player_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE player_id_seq RESTART 1;
CREATE SEQUENCE configuration_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE configuration_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE configuration_id_seq RESTART 1;
CREATE SEQUENCE solved_challenge_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE solved_challenge_id_seq
OWNER TO dsa;
--inserts here
ALTER SEQUENCE solved_challenge_id_seq RESTART 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment