Lines Matching defs:authority
50 -- The primary authority. This table is conceptually scanned
54 CREATE TABLE authority (
65 expires FLOAT NOT NULL DEFAULT (5000000), -- expiration of rule authority (Julian date)
67 label TEXT NULL, -- text label for authority rule
78 CREATE INDEX authority_type ON authority (type);
79 CREATE INDEX authority_priority ON authority (priority);
80 CREATE INDEX authority_expires ON authority (expires);
83 CREATE TRIGGER authority_update AFTER UPDATE ON authority
85 UPDATE authority SET mtime = JULIANDAY('now') WHERE id = old.id;
90 SELECT * from authority
95 SELECT * from authority
105 authority INTEGER NOT NULL
106 REFERENCES authority(id) ON DELETE CASCADE
127 insert into authority (type, allow, priority, flags, label)
131 insert into authority (type, allow, priority, flags, label, requirement)
135 insert into authority (type, allow, flags, label, requirement)
139 insert into authority (type, allow, flags, label, requirement)
143 insert into authority (type, allow, flags, label, requirement)
147 insert into authority (type, allow, flags, label, requirement)
149 insert into authority (type, allow, flags, label, requirement)
156 -- full evaluations of authority records, or by explicitly inserting
157 -- override rules that preempt the normal authority.
158 -- EACH object record must have a parent authority record from which it is derived;
159 -- this may be a normal authority rule or an override rule. If the parent rule is deleted,
168 authority INTEGER NOT NULL -- governing authority rule
169 REFERENCES authority(id) ON DELETE CASCADE,
196 authority.label,
197 object.authority,
200 authority.requirement,
201 authority.disabled,
203 FROM object, authority
204 WHERE object.authority = authority.id;