PHP Classes

File: src/Installer/sql/pgsql/50-bridge-announcements.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski   CMS Airship   src/Installer/sql/pgsql/50-bridge-announcements.sql   Download  
File: src/Installer/sql/pgsql/50-bridge-announcements.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: CMS Airship
Content management system with security features
Author: By
Last change: PHPStorm only committed one file -_-
Add 'IF NOT EXISTS' clauses (requires PostgreSQL 9.5)
Date: 7 years ago
Size: 626 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS bridge_announcements ( announcementid BIGSERIAL PRIMARY KEY, uniqueid TEXT, title TEXT, contents TEXT, format TEXT, only_admins BOOLEAN DEFAULT FALSE, from_trusted_supplier BOOLEAN DEFAULT FALSE, created TIMESTAMP DEFAULT NOW() ); CREATE UNIQUE INDEX ON bridge_announcements (uniqueid); CREATE TABLE IF NOT EXISTS bridge_announcements_dismiss ( announcementid BIGINT REFERENCES bridge_announcements(announcementid), userid BIGINT REFERENCES airship_users(userid), created TIMESTAMP DEFAULT NOW() ); CREATE UNIQUE INDEX ON bridge_announcements_dismiss (announcementid, userid);