sqls.Table.sql Maven / Gradle / Ivy

Go to download
drop table  if exists test_table;
create table if not exists test_table
(
    id bigserial not null
        constraint test_table_pkey
            primary key,
    a_int bigint,
    a_decimal numeric,
    a_varchar varchar,
    a_text text,
    a_byte bytea,
    a_time timestamp,
    a_date date,
    a_boolean boolean,
    a_uuid uuid,
    a_json jsonb
);

comment on table test_table is 'test table 评论';

alter table test_table owner to postgres;

create index if not exists index_test_table
    on test_table (a_text);