es.org.openl.rules.repository.5.27.8.source-code.openl-db-repository-postgresql.properties Maven / Gradle / Ivy
# Override queries from openl-db-repository.properties file for specific database or add DB initialization scripts here.
# Initialization scripts must have prefix "init.".
# If the order of init queries is important, give them keys like: init.1.table, init.2.sequence, init.3.something etc
init.1.table = CREATE TABLE ${setting.tablename} (\n\
\ id BIGSERIAL PRIMARY KEY,\n\
\ file_name VARCHAR(1000) NOT NULL,\n\
\ author VARCHAR(45),\n\
\ file_comment VARCHAR(255) NULL,\n\
\ modified_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,\n\
\ file_data BYTEA\n\
\ );
init.2.index = CREATE INDEX ${setting.tablename}_idx on ${setting.tablename} (file_name ASC)