7fucbsKA

1create table if not exists master.temp_property
2(
3	id varchar(64) not null
4		constraint temp_property_pk
5			primary key,
6	name varchar(64) not null,
7	address varchar,
8	property_type_id varchar(40) not null,
9	created_date timestamp(0),
10	created_by varchar(64),
11	is_deleted boolean default false not null,
12	updated_by varchar(64),
13	updated_date timestamp(0),
14	deleted_date timestamp(0),
15	deleted_by varchar(64),
16	logo varchar(500),
17	province_id varchar(64),
18	city_id varchar(64),
19	sub_district_id varchar(64),
20	website varchar,
21	zipcode integer,
22	active boolean default false not null,
23	temp_developer_id varchar(64) not null,
24	listing_id varchar default 64 not null
25);
26
27alter table master.temp_property owner to listing_user;
28
29grant insert, select, update, delete, truncate, references, trigger on master.temp_property to cms_listing_user;
30
31grant insert, select, update, delete, truncate, references, trigger on master.temp_property to cms_user;
32
33