PHP Classes

File: test/sql/init/postgresql.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski   CMS Airship   test/sql/init/postgresql.sql   Download  
File: test/sql/init/postgresql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: CMS Airship
Content management system with security features
Author: By
Last change:
Date: 7 years ago
Size: 310 bytes
 

Contents

Class file image Download 
CREATE TABLE test_values (
  rowid BIGSERIAL PRIMARY KEY,
  name TEXT,
  foo BOOLEAN,
  created TIMESTAMP,
  modified TIMESTAMP
);

CREATE TABLE test_secondary (
  secondaryid BIGSERIAL PRIMARY KEY,
  test BIGINT REFERENCES test_values (rowid),
  numerical INTEGER,
  birthdate DATE NULL,
  extra_data JSONB
);