SET search_path = trueguide, pg_catalog;

CREATE SEQUENCE google_anth_schema_schmaid_seq
	START WITH 1
	INCREMENT BY 1
	NO MAXVALUE
	NO MINVALUE
	CACHE 1;

CREATE SEQUENCE google_enquiry_tbl_enqid_seq
	START WITH 1
	INCREMENT BY 1
	NO MAXVALUE
	NO MINVALUE
	CACHE 1;

CREATE SEQUENCE tonlineenquiryenabled_id_seq
	START WITH 1
	INCREMENT BY 1
	NO MAXVALUE
	NO MINVALUE
	CACHE 1;

CREATE SEQUENCE tstudsecmigratetbl_ssmid_seq
	START WITH 1
	INCREMENT BY 1
	NO MAXVALUE
	NO MINVALUE
	CACHE 1;

CREATE TABLE enquiry (
	"timestamp" timestamp without time zone,
	name text DEFAULT 'NA'::text,
	email text DEFAULT 'NA'::text,
	address text DEFAULT 'NA'::text,
	phone_number text DEFAULT 'NA'::text,
	comments text DEFAULT 'NA'::text,
	instid integer DEFAULT '-1'::integer,
	curtime timestamp without time zone DEFAULT now(),
	curepoch bigint DEFAULT (date_part('epoch'::text, now()))::bigint,
	enqid bigint DEFAULT '-1'::integer,
	batchid bigint DEFAULT '-1'::integer
);

CREATE TABLE google_anth_schema (
	schmaid bigint DEFAULT nextval('trueguide.google_anth_schema_schmaid_seq'::regclass) NOT NULL,
	colname text DEFAULT 'NA'::text,
	tblname text DEFAULT 'NA'::text,
	status integer DEFAULT 1,
	colid bigint DEFAULT '-1'::integer,
	isinusertbl integer DEFAULT '-1'::integer,
	usertblcol text DEFAULT 'NA'::text,
	descr text DEFAULT 'NA'::text
);

CREATE TABLE google_enquiry_tbl (
	enqid bigint DEFAULT nextval('trueguide.google_enquiry_tbl_enqid_seq'::regclass) NOT NULL,
	sheet_id text DEFAULT 'NA'::text,
	sheet_name text DEFAULT 'NA'::text,
	instid integer DEFAULT '-1'::integer,
	last_enq_id integer DEFAULT 0,
	status integer DEFAULT 1,
	tblname text DEFAULT 'NA'::text,
	batchid bigint DEFAULT '-1'::bigint
);

CREATE TABLE tonlineenquiryenabled (
	id bigint DEFAULT nextval('trueguide.tonlineenquiryenabled_id_seq'::regclass) NOT NULL,
	instid bigint DEFAULT '-1'::integer,
	status integer DEFAULT 1
);

CREATE TABLE tstudsecmigratetbl (
	ssmid bigint DEFAULT nextval('trueguide.tstudsecmigratetbl_ssmid_seq'::regclass) NOT NULL,
	instid bigint,
	classid bigint,
	batchid bigint,
	usrid bigint,
	studid bigint,
	oldsec text NOT NULL,
	cursec text NOT NULL,
	migdt date
);

ALTER TABLE tstudinfotbl
	ADD COLUMN handicaptype text DEFAULT 'NA'::text,
	ADD COLUMN isrte integer DEFAULT '-1'::integer,
	ADD COLUMN martstatus text DEFAULT 'NA'::text;

ALTER TABLE tusertbl
	ADD COLUMN userphotolink text DEFAULT 'NA'::text;

ALTER SEQUENCE google_anth_schema_schmaid_seq
	OWNED BY trueguide.google_anth_schema.schmaid;

ALTER SEQUENCE google_enquiry_tbl_enqid_seq
	OWNED BY trueguide.google_enquiry_tbl.enqid;

ALTER SEQUENCE tonlineenquiryenabled_id_seq
	OWNED BY trueguide.tonlineenquiryenabled.id;

ALTER SEQUENCE tstudsecmigratetbl_ssmid_seq
	OWNED BY trueguide.tstudsecmigratetbl.ssmid;