--
--


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);



--
-- Name: members; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.members (
    id integer NOT NULL,
    username character varying(30) NOT NULL,
    email character varying(50) NOT NULL,
    password character varying(128) NOT NULL,
    salt character varying(128) NOT NULL,
    roleid integer DEFAULT 5 NOT NULL,
    permissionid integer DEFAULT 0 NOT NULL,
    contactno bigint
);


ALTER TABLE public.members OWNER TO postgres;

--
-- Name: members_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.members_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.members_id_seq OWNER TO postgres;

--
-- Name: members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.members_id_seq OWNED BY public.members.id;


--
-- Name: members id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.members ALTER COLUMN id SET DEFAULT nextval('public.members_id_seq'::regclass);


--
-- Data for Name: members; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.members (id, username, email, password, salt, roleid, permissionid, contactno) FROM stdin;
1	AJAY	AJAY.P@GMAIL.COM	JJJ	KJ	2	0	2278672084
2	roshan	roshan@gmail.com	57c0dd37346f573225a0c9efbc322c9218c7b611489f773372f9c34ac24f84389cfc3d3cc2122f4211d2f4462c7897aedb56128fa5c43a1d143f178fe4ebe9c8	7b69fd0b5f7d6965ad22255842440e9dea90cfe23fd124031fb4eaaa2614cca53f9d77a0061bd586573b85e3dfc9509369800453a23c5ddf758905f17f54ca57	1	0	9986274799
3	Roshan_sg	roshansg@gmail.com	ff7e4ddf20fdb034cf5b7d50f2629e412b46b08274928f05eaeae4f137b2f22de0e9429769dba7ad40099faffafff9deffa04a39dd99dc00cdfeb23c83e2268d	77cdf433210d2c25da0b5aaa5f8429916b436593cbf4db7e3a7436fe746e33dd369ebcc95bc150ae70b2f8177f2e32e0f7dfeae6c184cab4abe6911640c308e9	2	0	9986274799
4	roshanasg	roshanasg@gmail.com	f7a876d7a02c9733ee94c920637ec8c06e1f6ca75e7eef796549007c6b219aa11b9545380b3ef530c23f4c08d1298f7d98ebc8beec02132142dfad8e20e329cf	899c55316db271dde983a372f8bca7dc280649c75340350e3725473f9e602b4525df9ccbb82c589ee324396aa283fc0b80054d2d6b76e88c0d8299f403f42c20	4	7	9986274799
5	roshandysg	roshandysg@gmail.com	f3035da689a3cbe71a7a3a1a631f2d1190b5ca0c406deed098d11734b551d7006de82ec8ecd1c6d046b74d5c36526b5777eed670fcfccefc03fa00e2eafeee8d	0ebaee4dec500bb306aed2203a71117f2273725b9c71b39252169eee1140e00ca59a65c8baefb9de0cfdb70a666e2d08861fb59336cc2d7914213f741af9b851	3	1	9986274799
6	roshanweb	roshanweb@gmail.com	a25e37f4005ae49ad9bdea59df0edb9372d22aba9d3846d38553d790522f07ce3e53f468717c8f900adfee53a359faabb1a4ed35fd2bfb4c37ed9f35d5ac76b3	4ff69166805bb2466311595dc3f354664cae5f3dca0c358eeabc9206788742903f3b02d9eb848eac383ca0a603f106a1f7af8c6ce1e1cda07c93952b7452b098	5	0	9986274799
7	User C Ward	userc@gmail.com	ec2f284085d9c09dd4068b358b1d66ef4db99d63700c6749c9b90c07d052901e6c4f7bd3f2cb9e50af8aa89511506ee73fa9ebb4b49572acf1240843d34cc8f8	4d1ad36019d93223bab7b474dc92251f3b3431c0a33aa353df7049738cb2cdfd87acfc8e8a0a72e052973be0ab21c33a307206aadf27bfeb331d8cbb270d37e4	4	2	1234567890
8	Admin	admin@gmail.com	f3f3dcae22b963b94f286d2fba2716a5484034792057468fd44c14bdbd63147d70ad2c019af18cb309b0dafbc7d00f17c4fd4b72e56f264116d3518753d988e0	f2675307c5925be89151baab323f3cfc541aad97b3bcb9482bb22bdb57f8c1fb043a45750f2474060282fa68da1fb36823a94bb2b8fa8e2257af3763bb950433	1	0	1234567890
9	User B Ward	userb@gmail.com	3a2af3641bfcc5decddaabb42977ae9a76dd9a7a7a59a1cc011adb272b35c09e1b235b33e2a67807827766e273b8b351e6a9cf17b7739fc3ef2eec4bf20695c0	9b273f8fc96753953e2583eeb40cac46eae9588a896776457f52af546777b1720e81685b2f3d6edc976691a0f0b8ad7318004d12bbf94d48845f6ac26fef6f5b	4	3	1234567890
10	officer	officer@gmail.com	1a1fca939a65be436de8a6a1197ce4d38806cdcd6c2e2f5cd0bd97f7f84bdc2c682dcc20bbb9bf8a277f5f2cf1e7d6e45a0513fa7d261782dbc57db5f92dc078	1bfc1ecfbffe71d63c0f83c45eeb1f72df4ff19e6d06c6d3e4cc590eff5e67fa7a87ab4302f4f1c67260f62e86b78548fb964adf7cb8028fe5f98824e3f6888b	5	0	123456789
\.


--
-- Name: members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.members_id_seq', 10, true);


--
-- Name: members members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.members
    ADD CONSTRAINT members_pkey PRIMARY KEY (id);


--
-- Name: members members_roleid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.members
    ADD CONSTRAINT members_roleid_fkey FOREIGN KEY (roleid) REFERENCES public.roles(id);


--
--

