Tuesday, 17 August 2021

Postgresql : Generate token

 CREATE TABLE adempiere.license_tomato_app

(

    customerid integer,

    name text COLLATE pg_catalog."default",

    location text COLLATE pg_catalog."default",

    key text COLLATE pg_catalog."default" DEFAULT upper(substr(md5((random())::text), 0, 50)),

    plan text COLLATE pg_catalog."default",

    license_start_date timestamp without time zone,

    license_end_date timestamp without time zone,

    last_sync_data_time timestamp without time zone,

    industry_type character varying(50) COLLATE pg_catalog."default",

    business_name character varying(50) COLLATE pg_catalog."default",

    isactive integer DEFAULT 1,

    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,

    updated_at timestamp without time zone,

    created_by integer,

    updated_by integer

)

WITH (

    OIDS = FALSE

)

TABLESPACE pg_default;

No comments:

Data Sharing

  1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...