Created
September 27, 2013 15:21
-
-
Save autarch/6730296 to your computer and use it in GitHub Desktop.
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 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