Created
March 8, 2017 06:23
-
-
Save mokocchi/cf51dd24b34553808b0b8107580fa8c0 to your computer and use it in GitHub Desktop.
postgres script for sequence intialization (CTF-AdminDesafios)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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