Lines Matching refs:registry
1 CREATE TABLE ®istry..releases (
8 COMMENT ON TABLE ®istry..releases IS 'Sqitch registry releases.';
9 COMMENT ON COLUMN ®istry..releases.version IS 'Version of the Sqitch registry.';
10 COMMENT ON COLUMN ®istry..releases.installed_at IS 'Date the registry release was installed.';
11 COMMENT ON COLUMN ®istry..releases.installer_name IS 'Name of the user who installed the regist…
12 COMMENT ON COLUMN ®istry..releases.installer_email IS 'Email address of the user who installed t…
14 CREATE TABLE ®istry..projects (
22 COMMENT ON TABLE ®istry..projects IS 'Sqitch projects deployed to this database.…
23 COMMENT ON COLUMN ®istry..projects.project IS 'Unique Name of a project.';
24 COMMENT ON COLUMN ®istry..projects.uri IS 'Optional project URI';
25 COMMENT ON COLUMN ®istry..projects.created_at IS 'Date the project was added to the database…
26 COMMENT ON COLUMN ®istry..projects.creator_name IS 'Name of the user who added the project.';
27 COMMENT ON COLUMN ®istry..projects.creator_email IS 'Email address of the user who added the pr…
29 CREATE TABLE ®istry..changes (
33 project VARCHAR2(512 CHAR) NOT NULL REFERENCES ®istry..projects(project),
44 COMMENT ON TABLE ®istry..changes IS 'Tracks the changes currently deployed to t…
45 COMMENT ON COLUMN ®istry..changes.change_id IS 'Change primary key.';
46 COMMENT ON COLUMN ®istry..changes.script_hash IS 'Deploy script SHA-1 hash.';
47 COMMENT ON COLUMN ®istry..changes.change IS 'Name of a deployed change.';
48 COMMENT ON COLUMN ®istry..changes.project IS 'Name of the Sqitch project to which the ch…
49 COMMENT ON COLUMN ®istry..changes.note IS 'Description of the change.';
50 COMMENT ON COLUMN ®istry..changes.committed_at IS 'Date the change was deployed.';
51 COMMENT ON COLUMN ®istry..changes.committer_name IS 'Name of the user who deployed the change.';
52 COMMENT ON COLUMN ®istry..changes.committer_email IS 'Email address of the user who deployed the…
53 COMMENT ON COLUMN ®istry..changes.planned_at IS 'Date the change was added to the plan.';
54 COMMENT ON COLUMN ®istry..changes.planner_name IS 'Name of the user who planed the change.';
55 COMMENT ON COLUMN ®istry..changes.planner_email IS 'Email address of the user who planned the …
57 CREATE TABLE ®istry..tags (
60 project VARCHAR2(512 CHAR) NOT NULL REFERENCES ®istry..projects(project),
61 change_id CHAR(40) NOT NULL REFERENCES ®istry..changes(change_id),
72 COMMENT ON TABLE ®istry..tags IS 'Tracks the tags currently applied to the data…
73 COMMENT ON COLUMN ®istry..tags.tag_id IS 'Tag primary key.';
74 COMMENT ON COLUMN ®istry..tags.tag IS 'Project-unique tag name.';
75 COMMENT ON COLUMN ®istry..tags.project IS 'Name of the Sqitch project to which the tag b…
76 COMMENT ON COLUMN ®istry..tags.change_id IS 'ID of last change deployed before the tag was…
77 COMMENT ON COLUMN ®istry..tags.note IS 'Description of the tag.';
78 COMMENT ON COLUMN ®istry..tags.committed_at IS 'Date the tag was applied to the database.';
79 COMMENT ON COLUMN ®istry..tags.committer_name IS 'Name of the user who applied the tag.';
80 COMMENT ON COLUMN ®istry..tags.committer_email IS 'Email address of the user who applied the tag…
81 COMMENT ON COLUMN ®istry..tags.planned_at IS 'Date the tag was added to the plan.';
82 COMMENT ON COLUMN ®istry..tags.planner_name IS 'Name of the user who planed the tag.';
83 COMMENT ON COLUMN ®istry..tags.planner_email IS 'Email address of the user who planned the tag…
85 CREATE TABLE ®istry..dependencies (
86 …change_id CHAR(40) NOT NULL REFERENCES ®istry..changes(change_id) ON DELE…
89 dependency_id CHAR(40) NULL REFERENCES ®istry..changes(change_id),
97 COMMENT ON TABLE ®istry..dependencies IS 'Tracks the currently satisfied dependen…
98 COMMENT ON COLUMN ®istry..dependencies.change_id IS 'ID of the depending change.';
99 COMMENT ON COLUMN ®istry..dependencies.type IS 'Type of dependency.';
100 COMMENT ON COLUMN ®istry..dependencies.dependency IS 'Dependency name.';
101 COMMENT ON COLUMN ®istry..dependencies.dependency_id IS 'Change ID the dependency resolves to.';
103 CREATE TYPE ®istry..sqitch_array AS varray(1024) OF VARCHAR2(512);
106 CREATE TABLE ®istry..events (
113 project VARCHAR2(512 CHAR) NOT NULL REFERENCES ®istry..projects(project),
115 requires ®istry..SQITCH_ARRAY DEFAULT ®istry..SQITCH_ARRAY() NOT NULL,
116 conflicts ®istry..SQITCH_ARRAY DEFAULT ®istry..SQITCH_ARRAY() NOT NULL,
117 tags ®istry..SQITCH_ARRAY DEFAULT ®istry..SQITCH_ARRAY() NOT NULL,
126 CREATE UNIQUE INDEX ®istry..events_pkey ON ®istry..events(change_id, committed_at);
128 COMMENT ON TABLE ®istry..events IS 'Contains full history of all deployment eve…
129 COMMENT ON COLUMN ®istry..events.event IS 'Type of event.';
130 COMMENT ON COLUMN ®istry..events.change_id IS 'Change ID.';
131 COMMENT ON COLUMN ®istry..events.change IS 'Change name.';
132 COMMENT ON COLUMN ®istry..events.project IS 'Name of the Sqitch project to which the cha…
133 COMMENT ON COLUMN ®istry..events.note IS 'Description of the change.';
134 COMMENT ON COLUMN ®istry..events.requires IS 'Array of the names of required changes.';
135 COMMENT ON COLUMN ®istry..events.conflicts IS 'Array of the names of conflicting changes.';
136 COMMENT ON COLUMN ®istry..events.tags IS 'Tags associated with the change.';
137 COMMENT ON COLUMN ®istry..events.committed_at IS 'Date the event was committed.';
138 COMMENT ON COLUMN ®istry..events.committer_name IS 'Name of the user who committed the event.';
139 COMMENT ON COLUMN ®istry..events.committer_email IS 'Email address of the user who committed the…
140 COMMENT ON COLUMN ®istry..events.planned_at IS 'Date the event was added to the plan.';
141 COMMENT ON COLUMN ®istry..events.planner_name IS 'Name of the user who planed the change.';
142 COMMENT ON COLUMN ®istry..events.planner_email IS 'Email address of the user who plan planned …