<commit_before>ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_socso_status_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_username_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_role_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_race_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_marital_status_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_image_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_gender_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_department_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_username_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_allowance_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_created_by_fkey";
DROP INDEX IF EXISTS "public"."fki_user_socso_status_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_race_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_marital_status_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_gender_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_username_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_created_by_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_allowance_id_fkey";
DROP INDEX IF EXISTS "public"."fki_allowance_last_modified_by_fkey";
DROP INDEX IF EXISTS "public"."fki_allowance_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "username_allowance_id_unique";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_username_role_id_key";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_pkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_pkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_pkey";
ALTER TABLE IF EXISTS ONLY "public"."socso_status" DROP CONSTRAINT IF EXISTS "socso_status_pkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_pkey";
ALTER TABLE IF EXISTS ONLY "public"."race" DROP CONSTRAINT IF EXISTS "race_pkey";
ALTER TABLE IF EXISTS ONLY "public"."marital_status" DROP CONSTRAINT IF EXISTS "marital_status_pkey";
ALTER TABLE IF EXISTS ONLY "public"."image" DROP CONSTRAINT IF EXISTS "image_pkey";
ALTER TABLE IF EXISTS ONLY "public"."gender" DROP CONSTRAINT IF EXISTS "gender_pkey";
ALTER TABLE IF EXISTS ONLY "public"."department" DROP CONSTRAINT IF EXISTS "department_pkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_pkey";
ALTER TABLE IF EXISTS "public"."user_role" ALTER COLUMN "id" DROP DEFAULT;
ALTER TABLE IF EXISTS "public"."user_allowance" ALTER COLUMN "id" DROP DEFAULT;
ALTER TABLE IF EXISTS "public"."image" ALTER COLUMN "id" DROP DEFAULT;
DROP SEQUENCE IF EXISTS "public"."user_role_id_seq";
DROP TABLE IF EXISTS "public"."user_role";
DROP SEQUENCE IF EXISTS "public"."user_allowance_id_seq";
DROP TABLE IF EXISTS "public"."user_allowance";
DROP TABLE IF EXISTS "public"."user";
DROP TABLE IF EXISTS "public"."socso_status";
DROP TABLE IF EXISTS "public"."role";
DROP TABLE IF EXISTS "public"."race";
DROP TABLE IF EXISTS "public"."marital_status";
DROP SEQUENCE IF EXISTS "public"."image_id_seq";
DROP TABLE IF EXISTS "public"."image";
DROP TABLE IF EXISTS "public"."gender";
DROP TABLE IF EXISTS "public"."department";
DROP TABLE IF EXISTS "public"."allowance";
DROP SCHEMA IF EXISTS "public";
CREATE SCHEMA "public";
COMMENT ON SCHEMA "public" IS 'standard public schema';
CREATE TABLE "allowance" (
    "id" character(1) NOT NULL,
    "name" character varying(20) NOT NULL,
    "amount" numeric(7,2) NOT NULL,
    "created_by" character varying(20),
    "last_modified_by" character varying(20),
    "created_date" timestamp with time zone,
    "last_modified_date" timestamp with time zone
);
CREATE TABLE "department" (
    "id" character(10) NOT NULL,
    "name" character varying(20) NOT NULL,
    "created_by" character varying(20),
    "last_modified_by" character varying(20),<commit_msg>allows the allowance to be re-arranged if needed<commit_after>ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_socso_status_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_username_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_role_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_race_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_marital_status_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_image_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_gender_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_department_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_username_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_allowance_id_fkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_last_modified_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_created_by_fkey";
DROP INDEX IF EXISTS "public"."fki_user_socso_status_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_race_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_marital_status_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_gender_id_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_username_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_created_by_fkey";
DROP INDEX IF EXISTS "public"."fki_user_allowance_allowance_id_fkey";
DROP INDEX IF EXISTS "public"."fki_allowance_last_modified_by_fkey";
DROP INDEX IF EXISTS "public"."fki_allowance_created_by_fkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "username_allowance_id_unique";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_username_role_id_key";
ALTER TABLE IF EXISTS ONLY "public"."user_role" DROP CONSTRAINT IF EXISTS "user_role_pkey";
ALTER TABLE IF EXISTS ONLY "public"."user" DROP CONSTRAINT IF EXISTS "user_pkey";
ALTER TABLE IF EXISTS ONLY "public"."user_allowance" DROP CONSTRAINT IF EXISTS "user_allowance_pkey";
ALTER TABLE IF EXISTS ONLY "public"."socso_status" DROP CONSTRAINT IF EXISTS "socso_status_pkey";
ALTER TABLE IF EXISTS ONLY "public"."role" DROP CONSTRAINT IF EXISTS "role_pkey";
ALTER TABLE IF EXISTS ONLY "public"."race" DROP CONSTRAINT IF EXISTS "race_pkey";
ALTER TABLE IF EXISTS ONLY "public"."marital_status" DROP CONSTRAINT IF EXISTS "marital_status_pkey";
ALTER TABLE IF EXISTS ONLY "public"."image" DROP CONSTRAINT IF EXISTS "image_pkey";
ALTER TABLE IF EXISTS ONLY "public"."gender" DROP CONSTRAINT IF EXISTS "gender_pkey";
ALTER TABLE IF EXISTS ONLY "public"."department" DROP CONSTRAINT IF EXISTS "department_pkey";
ALTER TABLE IF EXISTS ONLY "public"."allowance" DROP CONSTRAINT IF EXISTS "allowance_pkey";
ALTER TABLE IF EXISTS "public"."user_role" ALTER COLUMN "id" DROP DEFAULT;
ALTER TABLE IF EXISTS "public"."user_allowance" ALTER COLUMN "id" DROP DEFAULT;
ALTER TABLE IF EXISTS "public"."image" ALTER COLUMN "id" DROP DEFAULT;
DROP SEQUENCE IF EXISTS "public"."user_role_id_seq";
DROP TABLE IF EXISTS "public"."user_role";
DROP SEQUENCE IF EXISTS "public"."user_allowance_id_seq";
DROP TABLE IF EXISTS "public"."user_allowance";
DROP TABLE IF EXISTS "public"."user";
DROP TABLE IF EXISTS "public"."socso_status";
DROP TABLE IF EXISTS "public"."role";
DROP TABLE IF EXISTS "public"."race";
DROP TABLE IF EXISTS "public"."marital_status";
DROP SEQUENCE IF EXISTS "public"."image_id_seq";
DROP TABLE IF EXISTS "public"."image";
DROP TABLE IF EXISTS "public"."gender";
DROP TABLE IF EXISTS "public"."department";
DROP TABLE IF EXISTS "public"."allowance";
DROP SCHEMA IF EXISTS "public";
CREATE SCHEMA "public";
COMMENT ON SCHEMA "public" IS 'standard public schema';
CREATE TABLE "allowance" (
    "id" character(1) NOT NULL,
    "name" character varying(20) NOT NULL,
    "position" integer,
    "amount" numeric(7,2) NOT NULL,
    "created_by" character varying(20),
    "last_modified_by" character varying(20),
    "created_date" timestamp with time zone,
    "last_modified_date" timestamp with time zone
);
CREATE TABLE "department" (
    "id" character(10) NOT NULL,
    "name" character varying(20) NOT NULL,
    "created_by" character varying(20),
    "last_modified_by" character varying(20),
{'fraction_non_alphanumeric': 0.09491045229181423, 'fraction_numerical': 0.0034402509359506223, 'mean_word_length': 6.740015661707126, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '797764', 'n_tokens_mistral': 3734, 'n_tokens_neox': 3299, 'n_words': 1068}