X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.1.0%2Fapply.sql;fp=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.1.0%2Fapply.sql;h=8ccc2a52a74ded76a1a985861b5c675c5ce2e5be;hp=0000000000000000000000000000000000000000;hb=726cd980f0ed5588cfe8cbb2d994d5e4aef6e292;hpb=3c145bc590577c738df4d279744f3e2f9a250294

diff --git a/src/db/postgres/sql/schema/1.1.0/apply.sql b/src/db/postgres/sql/schema/1.1.0/apply.sql
new file mode 100644
index 0000000..8ccc2a5
--- /dev/null
+++ b/src/db/postgres/sql/schema/1.1.0/apply.sql
@@ -0,0 +1,23 @@
+BEGIN;
+
+	CREATE TABLE redeemed_ticket (
+		ticket_id BIGINT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
+		created TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
+		subject TEXT NOT NULL,
+		resource TEXT NOT NULL,
+		iss TEXT,
+		token TEXT NOT NULL,
+		ticket TEXT NOT NULL,
+		published TIMESTAMP WITH TIME ZONE
+	);
+	COMMENT ON TABLE redeemed_ticket IS $docstring$
+Tickets which have been redeemed for tokens and published.
+	$docstring$;
+	CREATE INDEX redeemed_ticket_created_idx ON redeemed_ticket(created);
+	CREATE INDEX redeemed_ticket_published_idx ON redeemed_ticket(published) WHERE published IS NOT NULL;
+	CREATE INDEX redeemed_ticket_ref_idx ON redeemed_ticket(subject, resource, iss, ticket);
+
+	-- Update schema version
+	INSERT INTO _meta_schema_version (major, minor, patch) VALUES (1, 1, 0);
+
+COMMIT;