Created
February 23, 2018 13:20
-
-
Save ManishLSN/c98099c34f27d8e22968f8e16e724ed3 to your computer and use it in GitHub Desktop.
basic users table
This file contains 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 public.users | |
( | |
id serial NOT NULL, | |
email character varying(155), | |
pwd text NOT NULL, | |
u_name character varying(155), | |
f_name character varying(100), | |
l_name character varying(100), | |
dob timestamp without time zone NOT NULL, | |
platform smallint DEFAULT 0, | |
device_key text, | |
mobile text, | |
is_active smallint DEFAULT 1, | |
created_at timestamp without time zone, | |
PRIMARY KEY (id) | |
) | |
WITH ( | |
OIDS = FALSE | |
) | |
; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment