-- Adminer 4.8.1 PostgreSQL 14.7 (Ubuntu 14.7-1.pgdg18.04+1) dump

DROP SEQUENCE IF EXISTS mdl_user_id_seq;
CREATE SEQUENCE mdl_user_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1;

CREATE TABLE "public"."mdl_user" (
    "id" bigint DEFAULT nextval('mdl_user_id_seq') NOT NULL,
    "auth" character varying(20) DEFAULT 'manual' NOT NULL,
    "username" character varying(100) DEFAULT '' NOT NULL,
    "password" character varying(255) DEFAULT '' NOT NULL,
    "idnumber" character varying(255) DEFAULT '' NOT NULL,
    "firstname" character varying(100) DEFAULT '' NOT NULL,
    "lastname" character varying(100) DEFAULT '' NOT NULL,
    "email" character varying(100) DEFAULT '' NOT NULL,
    "phone1" character varying(20) DEFAULT '' NOT NULL,
    "phone2" character varying(20) DEFAULT '' NOT NULL,
    "institution" character varying(255) DEFAULT '' NOT NULL,
    "department" character varying(255) DEFAULT '' NOT NULL,
    "address" character varying(255) DEFAULT '' NOT NULL,
    "city" character varying(120) DEFAULT '' NOT NULL,
    "country" character varying(2) DEFAULT '' NOT NULL,
    "lang" character varying(30) DEFAULT 'en' NOT NULL,
    "calendartype" character varying(30) DEFAULT 'gregorian' NOT NULL,
    "description" text,
    "lastnamephonetic" character varying(255),
    "firstnamephonetic" character varying(255),
    "middlename" character varying(255),
    "alternatename" character varying(255),
    "moodlenetprofile" character varying(255),
    "checkme" smallint,
    "dropme" character varying(255),
    "webme" character varying(255),
    "textme" text,
    "inputme" character varying(255),
    "dateme" bigint,
    CONSTRAINT "mdl_user_id_pk" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "mdl_user_alt_ix" ON "public"."mdl_user" USING btree ("alternatename");

CREATE INDEX "mdl_user_aut_ix" ON "public"."mdl_user" USING btree ("auth");

CREATE INDEX "mdl_user_cit_ix" ON "public"."mdl_user" USING btree ("city");

CREATE INDEX "mdl_user_cou_ix" ON "public"."mdl_user" USING btree ("country");

CREATE INDEX "mdl_user_ema_ix" ON "public"."mdl_user" USING btree ("email");

CREATE INDEX "mdl_user_fir2_ix" ON "public"."mdl_user" USING btree ("firstnamephonetic");

CREATE INDEX "mdl_user_fir_ix" ON "public"."mdl_user" USING btree ("firstname");

CREATE INDEX "mdl_user_idn_ix" ON "public"."mdl_user" USING btree ("idnumber");

CREATE INDEX "mdl_user_las3_ix" ON "public"."mdl_user" USING btree ("lastnamephonetic");

CREATE INDEX "mdl_user_las_ix" ON "public"."mdl_user" USING btree ("lastname");

CREATE INDEX "mdl_user_mid_ix" ON "public"."mdl_user" USING btree ("middlename");

INSERT INTO "mdl_user" ("id", "auth", "username", "password", "idnumber", "firstname", "lastname", "email", "phone1", "phone2", "institution", "department", "address", "city", "country", "lang", "calendartype", "description", "lastnamephonetic", "firstnamephonetic", "middlename", "alternatename", "moodlenetprofile", "checkme", "dropme", "webme", "textme", "inputme", "dateme") VALUES
(2,	'manual',	'extdb1',	'extdb1',	'exidnumber1',	'FirstDB1405',	'LastBD1405',	'some405@moodle.com',	'999888777',	'888777',	'My institution',	'My department',	'adress db',	'Sevilla405',	'ES',	'en',	'gregorian',	'<p>some new description</p>',	'Myphonetic 1',	'Myphonetic 1',	'Mumiddlename1',	'Alt1',	NULL,	0,	'three',	'http://405moodle.com',	'Some new text 405',	'someinputvalue405',	1727218800);

-- 2024-09-25 16:59:23.227047+02
