/usr/share/pegasus/sql/create-pg-init.sql 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 | ---
--- schema: all
--- driver: PostGreSQL 7.4.*
--- $Revision: 150 $
---
CREATE TABLE pegasus_schema (
name VARCHAR(64) NOT NULL,
catalog VARCHAR(16),
version FLOAT,
creator VARCHAR(8) DEFAULT current_user,
creation TIMESTAMP WITH TIME ZONE DEFAULT current_timestamp(0),
CONSTRAINT pk_pegasus_schema PRIMARY KEY(name)
);
|