• Home
• org.openurp.platform
• openurp-platform-portal
• 0.5.30
• source code
• 0.2.23_0.2.24.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

evolutions.0.2.23_0.2.24.sql Maven / Gradle / Ivy

create table bulletin.sensitive_words (id int4 not null, content varchar(30) not null, primary key (id));
alter table bulletin.notices add auditor_id bigint;
alter table bulletin.notices add status int4;
alter table bulletin.notices add created_at timestamp;
alter table bulletin.notices add updated_at timestamp;
alter table bulletin.notices add published_at timestamp;
update bulletin.notices set published_at = published_on;
update bulletin.notices set created_at=published_on;
update bulletin.notices set updated_at=published_on;
alter table bulletin.notices drop column published_on;

update bulletin.notices set status=3;
alter table bulletin.notices alter status  set not null;