create table trueguide.google_enquiry_tbl (enqid bigserial,sheet_id text default 'NA',sheet_name text default 'NA',instid bigint default -1,last_enq_id integer default 0,status integer default 1,tblname text default 'NA',batchid bigint default -1,formlink text default 'NA',cid bigint default 0);
create table trueguide.google_anth_schema(schmaid bigserial,colname text default 'NA',tblname text default 'NA',status integer default 1,colid bigint default -1,descr text default 'NA');
create table trueguide.tsheetidtoinsttbl(stiid bigserial,enqid bigint not null,instid bigint not null,cid bigint not null);
alter table trueguide.pinsttbl add column formfilter text default 'NA';
alter table trueguide.enquiry add column admclassid bigint default -1;
alter table trueguide.tbatchtbl add column gformadm integer default -1;
alter table trueguide.tstudinfotbl add column knowhow text default 'NA';
alter table trueguide.tstudinfotbl add column whythisinst text default 'NA';
alter table trueguide.tstudinfotbl add column isrte integer default -1;
alter table trueguide.tstudinfotbl add column handicaptype text default 'NA';
alter table trueguide.tstudinfotbl add column martstatus text default 'NA';
alter table trueguide.tstudinfotbl add column queryrtype text default 'NA'; 
 alter table trueguide.tstudinfotbl add column coarse text default 'NA';
alter table trueguide.tstudinfotbl add column futureintrst text default 'NA',add column atpost text default 'NA',add column taluk text default 'NA',add column district text default 'NA';
alter table trueguide.tstudinfotbl add column userphotolink text default 'NA'; 
 alter table trueguide.tstudinfotbl add column lcdoc text default 'NA',add column tcdoc text default 'NA',add column lastyrmarksdoc text default 'NA',add column studaadhardoc text default 'NA',add column studdomiciledoc text default 'NA',add column studdpandoc text default 'NA',add column studcastdoc text default 'NA',add column studcastvaliditydoc text default 'NA',add column studgapdoc text default 'NA',add column studincmdoc text default 'NA',add column studhandicapdoc text default 'NA',add column studmigrationdoc text default 'NA';
alter table trueguide.tstudinfotbl alter column rteno type text;
alter table trueguide.tstudinfotbl alter column rteno set default 'NA';
alter table trueguide.tstudinfotbl alter column annualincome  type text;
alter table trueguide.tstudinfotbl alter column annualincome set default 'NA';

CREATE TABLE trueguide.enquiry (
    "timestamp" timestamp without time zone,
    email text DEFAULT 'NA'::text,
    instid integer DEFAULT '-1'::integer,
    curtime timestamp without time zone DEFAULT now(),
    curepoch bigint DEFAULT '-1'::integer,
    enqid bigint DEFAULT '-1'::integer,
    batchid bigint DEFAULT '-1'::integer,
    name text DEFAULT 'NA'::text,
    fthrname text DEFAULT 'NA'::text,
    admitingstd text DEFAULT 'NA'::text,
    mthrname text DEFAULT 'NA'::text,
    dob text DEFAULT 'NA'::text,
    pob text DEFAULT 'NA'::text,
    gender text DEFAULT 'NA'::text,
    mobno text DEFAULT 'NA'::text,
    religion text DEFAULT 'NA'::text,
    caste text DEFAULT 'NA'::text,
    category text DEFAULT 'NA'::text,
    nationality text DEFAULT 'NA'::text,
    doa text DEFAULT 'NA'::text,
    prevschool text DEFAULT 'NA'::text,
    aadhar text DEFAULT 'NA'::text,
    stsno text DEFAULT 'NA'::text,
    prsntstreet text DEFAULT 'NA'::text,
    fmobno text DEFAULT 'NA'::text,
    mmobno text DEFAULT 'NA'::text,
    pan text DEFAULT 'NA'::text,
    bldgrp text DEFAULT 'NA'::text,
    orpan text DEFAULT 'NA'::text,
    handicap text DEFAULT 'NA'::text,
    singlemother text DEFAULT 'NA'::text,
    lstyearperc text DEFAULT 'NA'::text,
    lstsubstudied text DEFAULT 'NA'::text,
    subjgroup text DEFAULT 'NA'::text,
    knowhow text DEFAULT 'NA'::text,
    whythisinst text DEFAULT 'NA'::text,
    athrperson text DEFAULT 'NA'::text,
    rteno text DEFAULT 'NA'::text,
    isrte text DEFAULT 'NA'::text,
    handicaptype text DEFAULT 'NA'::text,
    martstatus text DEFAULT 'NA'::text,
    queryrtype text DEFAULT 'NA'::text,
    ews text DEFAULT 'NA'::text,
    singlegirlchild text DEFAULT 'NA'::text,
    admstat integer DEFAULT '-1'::integer,
    admdt date,
    email_address text DEFAULT 'NA'::text,
    key text unique NOT NULL,
    belongschedcaste text DEFAULT 'NA'::text,
    annualincome text DEFAULT 'NA'::text,
    mthrtng text DEFAULT 'NA'::text,
    bankname text DEFAULT 'NA'::text,
    ifsc text DEFAULT 'NA'::text,
    acctno text DEFAULT 'NA'::text,
    pickvehiclenocolor text DEFAULT 'NA'::text,
    lastschooltcno text DEFAULT 'NA'::text,
    fatheraadhar text DEFAULT 'NA'::text,
    motheraadhar text DEFAULT 'NA'::text,
    incmcertfno text DEFAULT 'NA'::text,
    castcertfno text DEFAULT 'NA'::text,
    fquali text DEFAULT 'NA'::text,
    mquali text DEFAULT 'NA'::text,
    foccupation text DEFAULT 'NA'::text,
    moccupation text DEFAULT 'NA'::text,
    userphotolink text DEFAULT 'NA'::text,
    lcdoc text DEFAULT 'NA'::text,
    tcdoc text DEFAULT 'NA'::text,
    lastyrmarksdoc text DEFAULT 'NA'::text,
    studaadhardoc text DEFAULT 'NA'::text,
    studdomiciledoc text DEFAULT 'NA'::text,
    studdpandoc text DEFAULT 'NA'::text,
    studcastdoc text DEFAULT 'NA'::text,
    studcastvaliditydoc text DEFAULT 'NA'::text,
    studgapdoc text DEFAULT 'NA'::text,
    studincmdoc text DEFAULT 'NA'::text,
    studhandicapdoc text DEFAULT 'NA'::text,
    studmigrationdoc text DEFAULT 'NA'::text,
    usrid bigint DEFAULT '-1'::integer,
    queryid bigserial,
    coarse text DEFAULT 'NA'::text,
    futureintrst text DEFAULT 'NA'::text,
    atpost text DEFAULT 'NA'::text,
    taluk text DEFAULT 'NA'::text,
    district text DEFAULT 'NA'::text,
    cid bigint DEFAULT 0,
    admclassid bigint DEFAULT '-1'::integer
);


create index usrid_idx on trueguide.tusertbl(usrid);

create index oeqid_index on trueguide.onlineexamanstbl(oeqid);
create index studid_index on trueguide.onlineexamanstbl(studid);
create index instid_index on trueguide.onlineexamanstbl(instid);
create index examid_index on trueguide.onlineexamanstbl(examid);
create index classid_index on trueguide.onlineexamanstbl(classid);
create index batchid_index on trueguide.onlineexamanstbl(batchid);
create table trueguide.tclspoattntbl(poattid bigserial, classid bigint default '-1',instid bigint default '-1',batchid bigint default '-1',poid bigint default '-1',poattn text default 'NA');
alter table trueguide.tclspoattntbl add Primary Key(classid,instid,batchid,poid);
create index usrid_index ON trueguide.tusertbl(usrid);
create table trueguide.tstudcoattntbl(attnid bigserial,studid bigint default '-1',classid bigint default '-1',instid bigint default '-1',batchid bigint default '-1',cos text default 'NA',exams text default 'NA', attn text default 'NA');
ALTER TABLE trueguide.tindextbl ADD PRIMARY KEY (indexname, instid, classid, subid);
ALTER TABLE trueguide.tsubindextbl ADD PRIMARY KEY(subindexname, indexid, instid, classid, subid);