--
--


-- Started on 2024-10-22 09:25:40

SELECT pg_catalog.set_config('search_path', '', false);



--
-- TOC entry 216 (class 1259 OID 41063)
-- Name: login; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.login (
    id integer NOT NULL,
    name character varying,
    "pwdHasher" character varying,
    "mobilId" character varying,
    "createdDate" date,
    "studentNumber" character varying,
    "passwordHashed" bytea,
    "passwordSalted" bytea
);


ALTER TABLE public.login OWNER TO postgres;

--
-- TOC entry 215 (class 1259 OID 41062)
-- Name: login_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.login_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.login_id_seq OWNER TO postgres;

--
-- TOC entry 4787 (class 0 OID 0)
-- Dependencies: 215
-- Name: login_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.login_id_seq OWNED BY public.login.id;


--
-- TOC entry 4634 (class 2604 OID 41066)
-- Name: login id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4781 (class 0 OID 41063)
-- Dependencies: 216
-- Data for Name: login; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.login (id, name, "pwdHasher", "mobilId", "createdDate", "studentNumber", "passwordHashed", "passwordSalted") FROM stdin;
2	\N	hamza	AP31.240617.003	2024-10-17	0230000234	\N	\N
3	\N	hamzay	UP1A.231005.007	2024-10-21	0230000233	\N	\N
8	\N	\N	caa59c5a3b1a0087	2024-10-21	0230000232	\\x2539d5908db385e9e972de22272d32588b181a523faad9a5c996d8012489b4aa56068a643fb879d7f022de210b2b2ba6c211ab784e36070c8af0ec256226c3fe	\\x59a3a919daeb0be6c7e6039c55474e6edd7f6ff893f75bf6364b27d36cf5692725bf080180b69cc8d51ee8d6c64a401aaf9e292f8537da55c12fc8140dd11e373e332804d6debf42e205d4dd4776b99aa29e5b3243ed9d854c69030f9ff1e54f89b523d14a5da135113a383a12935e02b3de7035e48a1402b1eef4dc74c26a27
\.


--
-- TOC entry 4788 (class 0 OID 0)
-- Dependencies: 215
-- Name: login_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.login_id_seq', 8, true);


--
-- TOC entry 4636 (class 2606 OID 41070)
-- Name: login login_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login
    ADD CONSTRAINT login_pkey PRIMARY KEY (id);


-- Completed on 2024-10-22 09:25:40

--
--

