Changeset 9543 for branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql
- Timestamp:
- 05/09/08 12:34:30 (5 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
branches/rel_1_2/Open-ILS/src/sql/Pg/reporter-schema.sql
r9475 r9543 52 52 description TEXT NOT NULL, 53 53 data TEXT NOT NULL, 54 folder INT NOT NULL REFERENCES reporter.template_folder (id) 54 folder INT NOT NULL REFERENCES reporter.template_folder (id) DEFERRABLE INITIALLY DEFERRED 55 55 ); 56 56 CREATE INDEX rpt_tmpl_owner_idx ON reporter.template (owner); … … 66 66 template INT NOT NULL REFERENCES reporter.template (id) DEFERRABLE INITIALLY DEFERRED, 67 67 data TEXT NOT NULL, 68 folder INT NOT NULL REFERENCES reporter.report_folder (id) ,68 folder INT NOT NULL REFERENCES reporter.report_folder (id) DEFERRABLE INITIALLY DEFERRED, 69 69 recur BOOL NOT NULL DEFAULT FALSE, 70 70 recurance INTERVAL … … 77 77 id SERIAL PRIMARY KEY, 78 78 report INT NOT NULL REFERENCES reporter.report (id) DEFERRABLE INITIALLY DEFERRED, 79 folder INT NOT NULL REFERENCES reporter.output_folder (id) ,79 folder INT NOT NULL REFERENCES reporter.output_folder (id) DEFERRABLE INITIALLY DEFERRED, 80 80 runner INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, 81 81 run_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
