The schema for Sciveyor's SQL database
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Charles Pence f4fdc86c40
Add an 'attempts' column to tasks.
6 months ago
deploy Add an 'attempts' column to tasks. 6 months ago
revert Add an 'attempts' column to tasks. 6 months ago
verify Add an 'attempts' column to tasks. 6 months ago
.gitattributes Add union merge driver for sqitch.plan. 1 year ago
COPYING Add some template README. 1 year ago Remove Devise trackable columns from users. 1 year ago
dump_structure Switch to IDENTITY columns, re-dump structure. 1 year ago
sqitch.conf Set testing DB as default target, always verify. 1 year ago
sqitch.plan Add an 'attempts' column to tasks. 6 months ago
structure.sql Add an 'attempts' column to tasks. 6 months ago

Sciveyor Logo

Sciveyor SQL Schema

This repository contains a Sqitch project for building, migrating, and verifying the PostgreSQL database schema for Sciveyor. This SQL schema must be deployed to PostgreSQL 10 or higher, as we make extensive use of Postgres IDENTITY columns.

You can look at a user-friendly representation of this schema by visiting our SQL database documentation.

Deploying and Migrating

Edit sqitch.conf to create a new target for your deployment database. The easiest way to do this is by running:

sqitch target add flipr_test db:pg:flipr_test

If you want this target to become the default, edit sqitch.conf and set target = (your target) in the [engine "pg"] section. This is not recommended, however, as it will be too easy to accidentally clobber changes to your data (the default target is here set to a test database).

You then deploy your changes by running:

sqitch deploy <target>

This will deploy and automatically verify the deployment, based upon the current status of your database. To check the database's status, you can run, for instance:

sqitch status <target>

Full Schema

If you would like to read through the entire schema, as dumped from a current PostgreSQL instance, you can consult the structure.sql file. Note that this file is not read by Sqitch, and has nothing to do with the status or migrations of your server.


This database schema is released under the MIT license.