ocket8888 commented on code in PR #6802:
URL: https://github.com/apache/trafficcontrol/pull/6802#discussion_r875272907
##########
traffic_ops/app/db/create_tables.sql:
##########
@@ -462,6 +534,54 @@ ALTER TABLE cdn_id_seq OWNER TO traffic_ops;
ALTER SEQUENCE cdn_id_seq OWNED BY cdn.id;
+--
+-- Name: cdn_lock; Type: TABLE; Schema: public; Owner: traffic_ops
+--
+
+CREATE TABLE IF NOT EXISTS public.cdn_lock (
+ username text NOT NULL,
+ cdn text NOT NULL,
+ message text,
+ soft boolean NOT NULL DEFAULT TRUE,
+ last_updated timestamp with time zone DEFAULT now() NOT NULL,
+ CONSTRAINT pk_cdn_lock PRIMARY KEY ("cdn")
+);
+
+
+ALTER TABLE cdn_lock OWNER TO traffic_ops;
+
+--
+-- Name: cdn_notification; Type: TABLE; Schema: public; Owner: traffic_ops
+
+CREATE TABLE cdn_notification (
+ id bigint NOT NULL,
+ cdn text NOT NULL,
+ "user" text NOT NULL,
+ notification text,
+ last_updated timestamp with time zone DEFAULT now() NOT NULL,
+ CONSTRAINT pk_cdn_notification PRIMARY KEY (id)
+);
+
+--
+-- Name: cdn_notification_id_seq; Type: SEQUENCE; Schema: public; Owner:
traffic_ops
+--
+
+CREATE SEQUENCE IF NOT EXISTS cdn_notification_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE cdn_notification_id_seq OWNER TO traffic_ops;
+
+--
+-- Name: cdn_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public;
Owner: traffic_ops
+--
+
+ALTER SEQUENCE cdn_notification_id_seq OWNED BY cdn.id;
Review Comment:
copy/paste error - that could have been a big problem
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
