schema.sql

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE TABLE users (
    user_id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,
    user_email character varying(255) NOT NULL UNIQUE,
    user_code integer,
    user_date_created timestamp without time zone,
    user_last_login timestamp without time zone,
    user_active boolean DEFAULT false,
    youtube_auth boolean DEFAULT false,
    twitch_auth boolean DEFAULT false,
    facebook_auth boolean DEFAULT false,
    payment_tier character varying(255) DEFAULT 'FREE'::character varying
);

CREATE TABLE broadcasts (
    youtube_title character varying(255),
    youtube_description text,
    youtube_privacy_policy character varying(255),
    broadcast_time_created timestamp without time zone,
    youtube_broadcast_id character varying(255),
    youtube_stream_id character varying(255),
    youtube_destination_url character varying(255),
    facebook_title character varying(255),
    facebook_description text,
    facebook_live_video_id character varying(255),
    facebook_destination_url character varying(255),
    studio_id character varying(255) NOT NULL,
    twitch_title character varying(255),
    user_id uuid DEFAULT uuid_generate_v4() REFERENCES users(user_id),
    twitch_stream_key character varying(255),
    custom_rtmp_server character varying(255),
    custom_rtmp_stream_key character varying(255)
);

CREATE TABLE destinations (
    user_id uuid DEFAULT uuid_generate_v4() PRIMARY KEY REFERENCES users(user_id),
    twitch_user_id character varying(255),
    twitch_access_token character varying(255),
    twitch_refresh_token character varying(255),
    facebook_access_token character varying(255),
    twitch_stream_key character varying(255),
    youtube_access_token text,
    youtube_refresh_token text,
    facebook_long_access_token text,
    facebook_user_id character varying(255),
    twitch_user_name character varying(255)
);