/usr/share/pegasus/sql/README is in pegasus-wms 4.0.1+dfsg-8.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | The annotational VDC is the new default VDC. If you have a previous VDC
before version 1.3.6, please use the -old.sql files for it.
The "real" Documentation
------------------------
Please refer to the Database Admin Guide for the in-depth documentation.
Filenames
---------
The schema-related filenames follow a pattern:
<work>-<db>-<schema>.sql
where
<work> is either "create" to instantiate a schema
or "delete" to drop the schema and all data.
The "update" is used to migrate an existing
database from an old schema to a new schema.
<db> is the database backend for which this flavor of
DDL instruction is being issued:
my MySQL 4.0.*
pg PostGreSQL 7.4.* (we do NOT recommend Pg 8.0.*)
sl SQLite 2.* (not supported)
<schema> is a short for a database schema description.
Currently we support:
init schema metadata upon which the rest depends
tc org.griphyn.common.catalog.transformation.Database
rc JDBC generic (uses autoinc) implementation
The schemas marked with a "+" are mutually exclusive. The special files:
<work>-<db>.sql
creates, deletes, or updates a recommended set of schemas
(init,tc,rc) for Annotations. Alternatively, the special
files:
<work>-<db>-old.sql
creates, deletes, or updates a recommended set of schemas
(init,tc,rc) for chunks.
|