Skip to content

Instantly share code, notes, and snippets.

@autarch
Created September 27, 2013 15:21
Show Gist options
  • Save autarch/6730296 to your computer and use it in GitHub Desktop.
Save autarch/6730296 to your computer and use it in GitHub Desktop.
CREATE TABLE "Domain" (
domain_id integer NOT NULL,
web_hostname hostname NOT NULL,
email_hostname hostname NOT NULL,
requires_ssl boolean DEFAULT false,
creation_datetime timestamp without time zone DEFAULT now() NOT NULL,
CONSTRAINT valid_email_hostname CHECK (((email_hostname)::citext <> ''::citext)),
CONSTRAINT valid_web_hostname CHECK (((web_hostname)::citext <> ''::citext))
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment