/*
PostgreSQL Backup
Database: antrian/public
Backup Time: 2020-09-24 10:55:02
*/

DROP SEQUENCE IF EXISTS "public"."antrian_id_antrian";
DROP SEQUENCE IF EXISTS "public"."dokter\_id_dokter_seq";
DROP SEQUENCE IF EXISTS "public"."id_antrian_seq2";
DROP SEQUENCE IF EXISTS "public"."id_antrian_seq";
DROP SEQUENCE IF EXISTS "public"."id_dokter_seq";
DROP SEQUENCE IF EXISTS "public"."id_ruang_seq";
DROP SEQUENCE IF EXISTS "public"."no_rekam_medis";
DROP SEQUENCE IF EXISTS "public"."pasien_id_pasien_seq";
DROP SEQUENCE IF EXISTS "public"."poli_id_poli_seq";
DROP SEQUENCE IF EXISTS "public"."register_antrian_id_register";
DROP SEQUENCE IF EXISTS "public"."user_data_header_iduser_seq";
DROP TABLE IF EXISTS "public"."antrian";
DROP TABLE IF EXISTS "public"."antrian_pasien";
DROP TABLE IF EXISTS "public"."condition";
DROP TABLE IF EXISTS "public"."counter_status";
DROP TABLE IF EXISTS "public"."divisi_witel";
DROP TABLE IF EXISTS "public"."dokter";
DROP TABLE IF EXISTS "public"."dokter_to_poli";
DROP TABLE IF EXISTS "public"."master_parameter";
DROP TABLE IF EXISTS "public"."pasien";
DROP TABLE IF EXISTS "public"."poli";
DROP TABLE IF EXISTS "public"."regional";
DROP TABLE IF EXISTS "public"."register_antrian";
DROP TABLE IF EXISTS "public"."register_dokter";
DROP TABLE IF EXISTS "public"."ruang";
DROP TABLE IF EXISTS "public"."user_data_access";
DROP TABLE IF EXISTS "public"."user_data_header";
DROP TABLE IF EXISTS "public"."user_data_map";
DROP TABLE IF EXISTS "public"."user_data_role";
DROP TABLE IF EXISTS "public"."user_data_session";
DROP FUNCTION IF EXISTS "public"."get_antrian_self()";
DROP FUNCTION IF EXISTS "public"."get_antriann(kode_antrian int4)";
DROP FUNCTION IF EXISTS "public"."get_film_count(len_from int4, len_to int4)";
DROP FUNCTION IF EXISTS "public"."get_no_mobile()";
DROP FUNCTION IF EXISTS "public"."get_no_web()";
DROP FUNCTION IF EXISTS "public"."insert_data(input_id_pasien int4, input_id_poli int4)";
CREATE SEQUENCE "antrian_id_antrian" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "dokter\_id_dokter_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 32767
START 1
CACHE 1;
CREATE SEQUENCE "id_antrian_seq2" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "id_antrian_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "id_dokter_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1
CYCLE ;
CREATE SEQUENCE "id_ruang_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "no_rekam_medis" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "pasien_id_pasien_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "poli_id_poli_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 32767
START 1
CACHE 1;
CREATE SEQUENCE "register_antrian_id_register" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
CREATE SEQUENCE "user_data_header_iduser_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;
CREATE TABLE "antrian" (
  "id_antrian" int2 DEFAULT nextval('antrian_id_antrian'::regclass),
  "no_antrian" int2,
  "kode_antrian" int2,
  "create_date" date
)
;
ALTER TABLE "antrian" OWNER TO "postgres";
CREATE TABLE "antrian_pasien" (
  "id_pasien" int2,
  "no_antrian" int2,
  "create_date" date,
  "nama" varchar(150) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "tempat_lahir" varchar(100) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "tanggal_lahir" varchar COLLATE "pg_catalog"."default",
  "alamat" varchar(150) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "no_hp" varchar(50) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "id_poli" int2,
  "id_dokter" int2,
  "ktp" varchar(16) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "kode_antrian" varchar(255) COLLATE "pg_catalog"."default",
  "id_register" int2,
  "id_antrian" int2 NOT NULL DEFAULT nextval('id_antrian_seq2'::regclass),
  "status_code" int2,
  "id_ruang" int2,
  "waktu" time(6)
)
;
ALTER TABLE "antrian_pasien" OWNER TO "postgres";
CREATE TABLE "condition" (
  "id_condition" int2 NOT NULL,
  "condition" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "condition" OWNER TO "postgres";
CREATE TABLE "counter_status" (
  "id_status" int2 NOT NULL,
  "status_code" int2,
  "status_name" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "counter_status" OWNER TO "postgres";
CREATE TABLE "divisi_witel" (
  "divisi_witel_id" varchar(3) COLLATE "pg_catalog"."default" NOT NULL,
  "divisi_witel_name" varchar(32) COLLATE "pg_catalog"."default",
  "id_dmaco" int4,
  "witel_imon" varchar(100) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "divisi_witel" OWNER TO "postgres";
CREATE TABLE "dokter" (
  "id_dokter" int2 NOT NULL DEFAULT nextval('id_dokter_seq'::regclass),
  "nama_dokter" varchar(30) COLLATE "pg_catalog"."default",
  "kode_dokter" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "dokter" OWNER TO "postgres";
CREATE TABLE "dokter_to_poli" (
  "id_dokter" int2 NOT NULL DEFAULT nextval('"dokter\_id_dokter_seq"'::regclass),
  "nama_dokter" varchar(30) COLLATE "pg_catalog"."default",
  "id_poli" int2,
  "id_condition" int2,
  "kode_dokter" varchar(255) COLLATE "pg_catalog"."default",
  "create_date" date
)
;
ALTER TABLE "dokter_to_poli" OWNER TO "postgres";
CREATE TABLE "master_parameter" (
  "idm_parameter" int4 NOT NULL,
  "param_type" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "param_val1" varchar(500) COLLATE "pg_catalog"."default",
  "param_val2" varchar(500) COLLATE "pg_catalog"."default",
  "param_val3" varchar(500) COLLATE "pg_catalog"."default",
  "param_desc" varchar(1000) COLLATE "pg_catalog"."default",
  "param_parent" int4
)
;
ALTER TABLE "master_parameter" OWNER TO "postgres";
COMMENT ON TABLE "master_parameter" IS 'master parameter';
CREATE TABLE "pasien" (
  "id_pasien" int2,
  "nama" varchar(255) COLLATE "pg_catalog"."default",
  "tempat_lahir" varchar(255) COLLATE "pg_catalog"."default",
  "tanggal_lahir" varchar(255) COLLATE "pg_catalog"."default",
  "alamat" varchar(255) COLLATE "pg_catalog"."default",
  "no_hp" varchar(255) COLLATE "pg_catalog"."default",
  "ktp" varchar(255) COLLATE "pg_catalog"."default",
  "create_date" date,
  "no_rekam_medis" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT lpad((nextval('no_rekam_medis'::regclass))::text, 8, '0'::text)
)
;
ALTER TABLE "pasien" OWNER TO "postgres";
CREATE TABLE "poli" (
  "id_poli" int2 NOT NULL DEFAULT nextval('poli_id_poli_seq'::regclass),
  "nama_poli" varchar(255) COLLATE "pg_catalog"."default",
  "kode_poli" varchar(5) COLLATE "pg_catalog"."default",
  "deskripsi_poli" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "poli" OWNER TO "postgres";
CREATE TABLE "regional" (
  "id_regional" int4 NOT NULL,
  "regional_name" varchar(30) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "regional" OWNER TO "postgres";
CREATE TABLE "register_antrian" (
  "id_register" int2 DEFAULT nextval('register_antrian_id_register'::regclass),
  "antrian_all" int2,
  "antrian_awal" int2,
  "antrian_akhir" int2,
  "create_date" date,
  "jam_mulai" varchar(6) COLLATE "pg_catalog"."default",
  "waktu_antrian" varchar(6) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "register_antrian" OWNER TO "postgres";
CREATE TABLE "register_dokter" (
  "id_register" int2 DEFAULT nextval('id_antrian_seq'::regclass),
  "id_poli" int2,
  "id_dokter" int2,
  "id_ruang" int2,
  "antrian_all" int2,
  "antrian_awal" int2,
  "antrian_akhir" int2,
  "create_date" date,
  "id_condition" int2,
  "jam_mulai" varchar(6) COLLATE "pg_catalog"."default",
  "waktu_antrian" varchar(6) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "register_dokter" OWNER TO "postgres";
CREATE TABLE "ruang" (
  "id_ruang" int2 NOT NULL DEFAULT nextval('id_ruang_seq'::regclass),
  "nama_ruang" varchar(255) COLLATE "pg_catalog"."default",
  "id_poli" int2,
  "id_condition" int2
)
;
ALTER TABLE "ruang" OWNER TO "postgres";
CREATE TABLE "user_data_access" (
  "access_id" int4 NOT NULL,
  "access_name" varchar(50) COLLATE "pg_catalog"."default",
  "access_type" varchar(255) COLLATE "pg_catalog"."default",
  "access_code" numeric(10),
  "access_desc" varchar(100) COLLATE "pg_catalog"."default",
  "access_action" varchar(100) COLLATE "pg_catalog"."default",
  "access_controller" varchar(100) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "user_data_access" OWNER TO "postgres";
COMMENT ON COLUMN "user_data_access"."access_action" IS 'NAMA FUNGSI PHP';
COMMENT ON COLUMN "user_data_access"."access_controller" IS 'NAMA CONTROLLERNYA';
CREATE TABLE "user_data_header" (
  "iduser" int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY (
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
),
  "username" varchar(100) COLLATE "pg_catalog"."default",
  "password" varchar(100) COLLATE "pg_catalog"."default",
  "name" varchar(100) COLLATE "pg_catalog"."default",
  "role" int4,
  "status" int4,
  "deviceid" varchar(255) COLLATE "pg_catalog"."default",
  "accessToken" varchar(255) COLLATE "pg_catalog"."default",
  "create_dtm" timestamp(6),
  "retries" varchar(10) COLLATE "pg_catalog"."default",
  "update_date" timestamp(6),
  "email" varchar(50) COLLATE "pg_catalog"."default",
  "authKey" varchar(255) COLLATE "pg_catalog"."default",
  "nik" varchar(100) COLLATE "pg_catalog"."default",
  "lokasi_p" varchar(100) COLLATE "pg_catalog"."default",
  "domain_p" varchar(100) COLLATE "pg_catalog"."default",
  "regional_id" int2,
  "witel_id" varchar(50) COLLATE "pg_catalog"."default",
  "last_update" timestamp(6)
)
;
ALTER TABLE "user_data_header" OWNER TO "postgres";
COMMENT ON COLUMN "user_data_header"."role" IS 'RELATION WITH TB: USER_DATA_ROLE';
COMMENT ON COLUMN "user_data_header"."status" IS 'SET STATUS USER: ';
CREATE TABLE "user_data_map" (
  "map_id" int4 NOT NULL,
  "access_code" int4,
  "role_code" int4,
  "access_status" varchar(255) COLLATE "pg_catalog"."default",
  "last_update" timestamp(6)
)
;
ALTER TABLE "user_data_map" OWNER TO "postgres";
CREATE TABLE "user_data_role" (
  "access_role_id" int4 NOT NULL,
  "name" varchar(50) COLLATE "pg_catalog"."default",
  "access_role_code" int4,
  "description" varchar(50) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "user_data_role" OWNER TO "postgres";
CREATE TABLE "user_data_session" (
  "session_id" varchar(500) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(200) COLLATE "pg_catalog"."default",
  "modified" numeric(20),
  "lifetime" numeric(20),
  "data" varchar(4000) COLLATE "pg_catalog"."default",
  "owner" varchar(200) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "user_data_session" OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "get_antrian_self"()
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   antrian_count integer;
begin

SELECT antrian.no_antrian
 into antrian_count FROM antrian 
INNER JOIN pasien 
ON antrian.id_pasien = pasien.id_pasien
WHERE pasien.create_date= CURRENT_DATE AND pasien.kode_antrian ='1' ORDER BY no_antrian DESC;

   
   return antrian_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "get_antrian_self"() OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "get_antriann"("kode_antrian" int4)
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   antrian_count integer;
begin

	INSERT INTO antrian(no_antrian,kode_antrian) VALUES ($1, $2);

   select count(*) 
   into antrian_count
   from antrian;
   
   return antrian_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "get_antriann"("kode_antrian" int4) OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "get_film_count"("len_from" int4, "len_to" int4)
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   film_count integer;
begin
   select count(*) 
   into film_count
   from film
   where length between len_from and len_to;
   
   return film_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "get_film_count"("len_from" int4, "len_to" int4) OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "get_no_mobile"()
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   antrian_count integer;
begin

SELECT count(antrian.no_antrian)
 into antrian_count FROM antrian 
INNER JOIN pasien 
ON antrian.id_pasien = pasien.id_pasien
WHERE pasien.create_date= CURRENT_DATE AND pasien.kode_antrian ='2' ;

   
   return antrian_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "get_no_mobile"() OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "get_no_web"()
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   antrian_count integer;
begin

SELECT count(antrian.no_antrian)
 into antrian_count FROM antrian 
INNER JOIN pasien 
ON antrian.id_pasien = pasien.id_pasien
WHERE pasien.create_date= CURRENT_DATE AND pasien.kode_antrian ='1' ;

   
   return antrian_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "get_no_web"() OWNER TO "postgres";
CREATE OR REPLACE FUNCTION "insert_data"("input_id_pasien" int4, "input_id_poli" int4)
  RETURNS "pg_catalog"."int4" AS $BODY$
declare
   antrian_count integer;
	 input_id_pasien INTEGER ;
	 input_id_poli INTEGER;
	 
begin

SELECT no_antrian into antrian_count FROM antrian WHERE "id_poli" = input_id_poli AND "id_pasien" IS NULL LIMIT 1 ;

UPDATE antrian SET id_pasien=input_id_pasien , kode_antrian='1' WHERE no_antrian=antrian_count AND id_poli=input_id_poli ;

   
   return antrian_count;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION "insert_data"("input_id_pasien" int4, "input_id_poli" int4) OWNER TO "postgres";
BEGIN;
LOCK TABLE "public"."antrian" IN SHARE MODE;
DELETE FROM "public"."antrian";
INSERT INTO "public"."antrian" ("id_antrian","no_antrian","kode_antrian","create_date") VALUES (2102, 1, 1, '2020-09-24'),(2103, 2, 1, '2020-09-24'),(2104, 3, 1, '2020-09-24'),(2105, 4, 1, '2020-09-24'),(2106, 5, 2, '2020-09-24'),(2107, 6, 2, '2020-09-24'),(2108, 7, 2, '2020-09-24'),(2109, 8, 2, '2020-09-24'),(2110, 9, 2, '2020-09-24'),(2111, 10, 2, '2020-09-24');
COMMIT;
BEGIN;
LOCK TABLE "public"."antrian_pasien" IN SHARE MODE;
DELETE FROM "public"."antrian_pasien";
INSERT INTO "public"."antrian_pasien" ("id_pasien","no_antrian","create_date","nama","tempat_lahir","tanggal_lahir","alamat","no_hp","id_poli","id_dokter","ktp","kode_antrian","id_register","id_antrian","status_code","id_ruang","waktu") VALUES (NULL, 2, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '1', 249, 2103, NULL, 16, NULL),(NULL, 3, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '1', 249, 2104, NULL, 16, NULL),(NULL, 4, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '1', 249, 2105, NULL, 16, NULL),(NULL, 5, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2106, NULL, 16, NULL),(NULL, 6, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2107, NULL, 16, NULL),(NULL, 7, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2108, NULL, 16, NULL),(NULL, 8, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2109, NULL, 16, NULL),(NULL, 9, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2110, NULL, 16, NULL),(NULL, 10, '2020-09-24', NULL, NULL, NULL, NULL, NULL, 9, 17, NULL, '2', 249, 2111, NULL, 16, NULL),(1, 1, '2020-09-24', '', '', '', '', '', 9, 17, '', '1', 249, 2102, 10, 16, NULL);
COMMIT;
BEGIN;
LOCK TABLE "public"."condition" IN SHARE MODE;
DELETE FROM "public"."condition";
INSERT INTO "public"."condition" ("id_condition","condition") VALUES (1, 'enable'),(2, 'disable');
COMMIT;
BEGIN;
LOCK TABLE "public"."counter_status" IN SHARE MODE;
DELETE FROM "public"."counter_status";
INSERT INTO "public"."counter_status" ("id_status","status_code","status_name") VALUES (1, 10, 'Queue'),(2, 20, 'Next'),(3, 30, 'Call'),(4, 40, 'Served'),(5, 50, 'Done'),(6, 60, 'Missed');
COMMIT;
BEGIN;
LOCK TABLE "public"."divisi_witel" IN SHARE MODE;
DELETE FROM "public"."divisi_witel";
COMMIT;
BEGIN;
LOCK TABLE "public"."dokter" IN SHARE MODE;
DELETE FROM "public"."dokter";
INSERT INTO "public"."dokter" ("id_dokter","nama_dokter","kode_dokter") VALUES (17, 'Azy', 'AZ');
COMMIT;
BEGIN;
LOCK TABLE "public"."dokter_to_poli" IN SHARE MODE;
DELETE FROM "public"."dokter_to_poli";
INSERT INTO "public"."dokter_to_poli" ("id_dokter","nama_dokter","id_poli","id_condition","kode_dokter","create_date") VALUES (17, 'Azy', 9, 2, 'AZ', '2020-09-24');
COMMIT;
BEGIN;
LOCK TABLE "public"."master_parameter" IN SHARE MODE;
DELETE FROM "public"."master_parameter";
INSERT INTO "public"."master_parameter" ("idm_parameter","param_type","param_val1","param_val2","param_val3","param_desc","param_parent") VALUES (1, 'USER_STATUS', 'ACTIVE', '10', NULL, 'USER ACTIVE GANS', NULL),(2, 'USER_STATUS', 'NOT ACTIVE', '20', NULL, 'USER NOT ACTIVE GANS', NULL),(3, 'USER_STATUS', 'BLOCKED', '30', NULL, 'USER NA DIBLOCK', NULL),(4, 'INPUT_TYPE', 'INPUT', '1', NULL, NULL, NULL),(5, 'INPUT_TYPE', 'TEXTAREA', '2', NULL, NULL, NULL),(6, 'INPUT_OPTION', 'SELECT_OPTION', '3', NULL, NULL, NULL),(7, 'INPUT_RADIO', 'RADION_BUTTON', '4', NULL, NULL, NULL),(8, 'TYPE_DATA', 'I_VARCHAR', '1', NULL, 'JENIS INPUTAN VARCHAR', NULL),(9, 'TYPE_DATA', 'I_NUMBER', '2', NULL, 'JENIS INPUTAN NUMBER', NULL);
COMMIT;
BEGIN;
LOCK TABLE "public"."pasien" IN SHARE MODE;
DELETE FROM "public"."pasien";
INSERT INTO "public"."pasien" ("id_pasien","nama","tempat_lahir","tanggal_lahir","alamat","no_hp","ktp","create_date","no_rekam_medis") VALUES (NULL, '', '', '', '', '', '', '2020-09-24', '00000002');
COMMIT;
BEGIN;
LOCK TABLE "public"."poli" IN SHARE MODE;
DELETE FROM "public"."poli";
INSERT INTO "public"."poli" ("id_poli","nama_poli","kode_poli","deskripsi_poli") VALUES (9, 'Umum', 'UM', '');
COMMIT;
BEGIN;
LOCK TABLE "public"."regional" IN SHARE MODE;
DELETE FROM "public"."regional";
COMMIT;
BEGIN;
LOCK TABLE "public"."register_antrian" IN SHARE MODE;
DELETE FROM "public"."register_antrian";
INSERT INTO "public"."register_antrian" ("id_register","antrian_all","antrian_awal","antrian_akhir","create_date","jam_mulai","waktu_antrian") VALUES (244, 10, 5, 10, '2020-09-24', '6:57', '0:20');
COMMIT;
BEGIN;
LOCK TABLE "public"."register_dokter" IN SHARE MODE;
DELETE FROM "public"."register_dokter";
INSERT INTO "public"."register_dokter" ("id_register","id_poli","id_dokter","id_ruang","antrian_all","antrian_awal","antrian_akhir","create_date","id_condition","jam_mulai","waktu_antrian") VALUES (249, 9, 17, 16, 10, 5, 10, '2020-09-24', 1, '6:57', '0:20');
COMMIT;
BEGIN;
LOCK TABLE "public"."ruang" IN SHARE MODE;
DELETE FROM "public"."ruang";
INSERT INTO "public"."ruang" ("id_ruang","nama_ruang","id_poli","id_condition") VALUES (16, 'R 1.1', 9, 2);
COMMIT;
BEGIN;
LOCK TABLE "public"."user_data_access" IN SHARE MODE;
DELETE FROM "public"."user_data_access";
INSERT INTO "public"."user_data_access" ("access_id","access_name","access_type","access_code","access_desc","access_action","access_controller") VALUES (1, 'DELETE TEST DATA', 'ACTION', 10, 'TEST FUNCTION', NULL, NULL),(2, 'MENU TEST DATA', 'MENU', 20, 'TEST MENU', NULL, NULL),(3, 'USER MANAGEMENT', 'MENU', 30, 'MENU USER MANAMEGENT', 'usermanagement', 'UserController');
COMMIT;
BEGIN;
LOCK TABLE "public"."user_data_header" IN SHARE MODE;
DELETE FROM "public"."user_data_header";
INSERT INTO "public"."user_data_header" ("iduser","username","password","name","role","status","deviceid","accessToken","create_dtm","retries","update_date","email","authKey","nik","lokasi_p","domain_p","regional_id","witel_id","last_update") VALUES (5, '930159', NULL, 'Ratna Wulan Sari', 30, 10, NULL, '$2y$10$e5IlkVkq/7zxhuVgORVH6uY850T5NiY.MZzoVk8ASnEfRr.6ooira', '2020-01-14 01:16:32', NULL, NULL, 'ratna.sari@telkom.co.id', 'a0e3e79e631b49115bd0cb927120f9eb', '930159', 'JAKARTA', 'Telkom', NULL, NULL, NULL),(9, 'witels', '758a27752fa96f0e612e8c75b0d619a9', 'witels', 20, 10, NULL, NULL, '2020-06-21 22:50:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, '351', NULL),(6, 'test1', '5a105e8b9d40e1329780d62ea2265d8a', 'test1', 10, 30, NULL, NULL, '2020-06-21 21:57:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(7, 'test1', '5a105e8b9d40e1329780d62ea2265d8a', 'test1', 10, 20, NULL, NULL, '2020-06-21 21:57:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(8, 'test2', 'ad0234829205b9033196ba818f7a872b', 'test2', 20, 10, NULL, NULL, '2020-06-21 21:59:39', 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(1, 'danirusdanx', '5036592afd6e403097c37eef12ad8285', 'danirusdan', 10, 10, NULL, NULL, '2017-07-09 22:30:23', 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(4, 'adminx', '$2y$10$7NnmhGtMZJTbS7gRVl/c0OIrCK29/rurfhBdZAKlgN8y/WcV8nbRa', 'Saya Karyawan', 30, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(3, 'danirusdan', '$2y$10$7NnmhGtMZJTbS7gRVl/c0OIrCK29/rurfhBdZAKlgN8y/WcV8nbRa', 'danirusdan', 10, 10, NULL, '$2y$10$zDNOrVtdYYGE3yBINaDDb.2506QHLSvGHn/hMxtqAkl21dWKEWsAG', NULL, '2', NULL, NULL, 'c46714daa0d91976579686bcad938849', NULL, NULL, NULL, NULL, NULL, NULL),(2, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Atang', 10, 10, NULL, NULL, '2017-08-10 10:29:40', 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;
BEGIN;
LOCK TABLE "public"."user_data_map" IN SHARE MODE;
DELETE FROM "public"."user_data_map";
INSERT INTO "public"."user_data_map" ("map_id","access_code","role_code","access_status","last_update") VALUES (4, 10, 20, 'TRUE', '2020-06-21 21:12:51.219377'),(5, 20, 20, 'TRUE', '2020-06-21 21:13:06.007902'),(1, 10, 10, 'TRUE', '2020-06-21 21:14:13.680576'),(3, 30, 10, 'TRUE', '2020-06-21 21:14:22.116003'),(2, 20, 10, 'FALSE', '2020-06-21 21:47:09.580874'),(6, 30, 20, 'FALSE', '2020-06-23 17:10:04.467554');
COMMIT;
BEGIN;
LOCK TABLE "public"."user_data_role" IN SHARE MODE;
DELETE FROM "public"."user_data_role";
INSERT INTO "public"."user_data_role" ("access_role_id","name","access_role_code","description") VALUES (1, 'MASTER', 10, 'BISA SAGALA EDANS'),(2, 'ADMIN', 20, 'ADMIN'),(3, 'REGIONAL', 30, 'EDAN1'),(4, 'WITEL', 40, 'UWU');
COMMIT;
BEGIN;
LOCK TABLE "public"."user_data_session" IN SHARE MODE;
DELETE FROM "public"."user_data_session";
INSERT INTO "public"."user_data_session" ("session_id","name","modified","lifetime","data","owner") VALUES ('8e7im25fc6a2i57hc5mee01ugp', 'KHANSIA', 1600833370, 86400, '__ZF|a:5:{s:20:"_REQUEST_ACCESS_TIME";d:1600833370.930789;s:6:"_VALID";a:1:{s:25:"Zend\Session\Validator\Id";s:26:"8e7im25fc6a2i57hc5mee01ugp";}s:3:"_LT";i:86400;s:3:"_LA";i:1600833370;s:6:"_OWNER";s:1:"2";}__KHANSIA|a:14:{s:14:"token_keamanan";s:32:"cfa97a952b0b994a6264a4ac1f5c6ced";s:7:"baseurl";s:16:"//frontend.indra";s:7:"user_id";s:1:"2";s:9:"usernamed";s:5:"admin";s:6:"passwd";s:32:"21232f297a57a5a743894a0e4a801fc3";s:4:"name";s:5:"Atang";s:4:"role";s:2:"10";s:6:"status";s:2:"10";s:8:"deviceid";N;s:5:"token";N;s:7:"retries";s:4:"NULL";s:10:"create_dtm";s:19:"2017-08-10 10:29:40";s:6:"access";a:0:{}s:9:"role_code";s:1:"E";}', '2'),('77j0vj9vahnbu84i2sb5ceo41s', 'KHANSIA', 1600919661, 86400, '__ZF|a:5:{s:20:"_REQUEST_ACCESS_TIME";d:1600919661.165525;s:6:"_VALID";a:1:{s:25:"Zend\Session\Validator\Id";s:26:"77j0vj9vahnbu84i2sb5ceo41s";}s:3:"_LT";i:86400;s:3:"_LA";i:1600919661;s:6:"_OWNER";s:1:"2";}__KHANSIA|a:14:{s:14:"token_keamanan";s:32:"a0ab4a5c76f3587f2a11611163d8d067";s:7:"baseurl";s:16:"//frontend.indra";s:7:"user_id";s:1:"2";s:9:"usernamed";s:5:"admin";s:6:"passwd";s:32:"21232f297a57a5a743894a0e4a801fc3";s:4:"name";s:5:"Atang";s:4:"role";s:2:"10";s:6:"status";s:2:"10";s:8:"deviceid";N;s:5:"token";N;s:7:"retries";s:4:"NULL";s:10:"create_dtm";s:19:"2017-08-10 10:29:40";s:6:"access";a:0:{}s:9:"role_code";s:1:"E";}', '2');
COMMIT;
ALTER TABLE "condition" ADD CONSTRAINT "condition_pkey" PRIMARY KEY ("id_condition");
ALTER TABLE "counter_status" ADD CONSTRAINT "counter_status_pkey" PRIMARY KEY ("id_status");
ALTER TABLE "divisi_witel" ADD CONSTRAINT "divisi_witel_pkey" PRIMARY KEY ("divisi_witel_id");
CREATE INDEX "idx_divisi_witel" ON "divisi_witel" USING btree (
  "divisi_witel_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
ALTER TABLE "dokter" ADD CONSTRAINT "dokter_to_poli_copy1_pkey" PRIMARY KEY ("id_dokter");
ALTER TABLE "dokter_to_poli" ADD CONSTRAINT "dokter\_pkey" PRIMARY KEY ("id_dokter");
ALTER TABLE "master_parameter" ADD CONSTRAINT "master_parameter_pkey" PRIMARY KEY ("idm_parameter");
CREATE INDEX "index2" ON "master_parameter" USING btree (
  "idm_parameter" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "index3" ON "master_parameter" USING btree (
  "param_type" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "index4" ON "master_parameter" USING btree (
  "param_val1" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "index5" ON "master_parameter" USING btree (
  "param_val2" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "index6" ON "master_parameter" USING btree (
  "param_val3" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "index7" ON "master_parameter" USING btree (
  "param_parent" "pg_catalog"."int4_ops" ASC NULLS LAST
);
ALTER TABLE "poli" ADD CONSTRAINT "poli_pkey" PRIMARY KEY ("id_poli");
ALTER TABLE "regional" ADD CONSTRAINT "regional_pkey" PRIMARY KEY ("id_regional");
ALTER TABLE "ruang" ADD CONSTRAINT "ruang_pkey" PRIMARY KEY ("id_ruang");
ALTER TABLE "user_data_access" ADD CONSTRAINT "user_data_access_pkey" PRIMARY KEY ("access_id");
ALTER TABLE "user_data_header" ADD CONSTRAINT "user_data_header_pkey" PRIMARY KEY ("iduser");
CREATE INDEX "xiduser" ON "user_data_header" USING btree (
  "iduser" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "xrole" ON "user_data_header" USING btree (
  "role" "pg_catalog"."int4_ops" ASC NULLS LAST
);
ALTER TABLE "user_data_map" ADD CONSTRAINT "user_data_map_pkey" PRIMARY KEY ("map_id");
ALTER TABLE "user_data_role" ADD CONSTRAINT "user_data_role_pkey" PRIMARY KEY ("access_role_id");
ALTER TABLE "user_data_session" ADD CONSTRAINT "user_data_session_pkey" PRIMARY KEY ("session_id");
ALTER TABLE "dokter_to_poli" ADD CONSTRAINT "dokter to poli" FOREIGN KEY ("id_poli") REFERENCES "public"."poli" ("id_poli") ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE "master_parameter" ADD CONSTRAINT "master_parameter_ibfk_1" FOREIGN KEY ("param_parent") REFERENCES "public"."master_parameter" ("idm_parameter") ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER SEQUENCE "antrian_id_antrian"
OWNED BY "antrian"."id_antrian";
SELECT setval('"antrian_id_antrian"', 2112, true);
ALTER SEQUENCE "antrian_id_antrian" OWNER TO "postgres";
ALTER SEQUENCE "dokter\_id_dokter_seq"
OWNED BY "dokter_to_poli"."id_dokter";
SELECT setval('"dokter\_id_dokter_seq"', 18, true);
ALTER SEQUENCE "dokter\_id_dokter_seq" OWNER TO "postgres";
ALTER SEQUENCE "id_antrian_seq2"
OWNED BY "antrian_pasien"."id_antrian";
SELECT setval('"id_antrian_seq2"', 2112, true);
ALTER SEQUENCE "id_antrian_seq2" OWNER TO "postgres";
ALTER SEQUENCE "id_antrian_seq"
OWNED BY "register_dokter"."id_register";
SELECT setval('"id_antrian_seq"', 250, true);
ALTER SEQUENCE "id_antrian_seq" OWNER TO "postgres";
ALTER SEQUENCE "id_dokter_seq"
OWNED BY "dokter"."id_dokter";
SELECT setval('"id_dokter_seq"', 18, true);
ALTER SEQUENCE "id_dokter_seq" OWNER TO "postgres";
ALTER SEQUENCE "id_ruang_seq"
OWNED BY "ruang"."id_ruang";
SELECT setval('"id_ruang_seq"', 17, true);
ALTER SEQUENCE "id_ruang_seq" OWNER TO "postgres";
SELECT setval('"no_rekam_medis"', 3, true);
ALTER SEQUENCE "no_rekam_medis" OWNER TO "postgres";
ALTER SEQUENCE "pasien_id_pasien_seq"
OWNED BY "antrian_pasien"."id_pasien";
SELECT setval('"pasien_id_pasien_seq"', 34, true);
ALTER SEQUENCE "pasien_id_pasien_seq" OWNER TO "postgres";
ALTER SEQUENCE "poli_id_poli_seq"
OWNED BY "poli"."id_poli";
SELECT setval('"poli_id_poli_seq"', 10, true);
ALTER SEQUENCE "poli_id_poli_seq" OWNER TO "postgres";
ALTER SEQUENCE "register_antrian_id_register"
OWNED BY "register_antrian"."id_register";
SELECT setval('"register_antrian_id_register"', 245, true);
ALTER SEQUENCE "register_antrian_id_register" OWNER TO "postgres";
ALTER SEQUENCE "user_data_header_iduser_seq"
OWNED BY "user_data_header"."iduser";
SELECT setval('"user_data_header_iduser_seq"', 2, false);
ALTER SEQUENCE "user_data_header_iduser_seq" OWNER TO "postgres";