ABCDEFGHIJKLMNOPQRSTUVWXYZ abcdefghijklmnopqrstuvwxyz ADD EXCEPT PERCENT ALL EXEC PLAN ALTER EXECUTE PRECISION AND EXISTS PRIMARY ANY EXIT PRINT AS FETCH PROC ASC FILE PROCEDURE AUTHORIZATION FILLFACTOR PUBLIC BACKUP FOR RAISERROR BEGIN FOREIGN READ BETWEEN FREETEXT READTEXT BREAK FREETEXTTABLE RECONFIGURE BROWSE FROM REFERENCES BULK FULL REPLICATION BY FUNCTION RESTORE CASCADE GOTO RESTRICT CASE GRANT RETURN CHECK GROUP REVOKE CHECKPOINT HAVING RIGHT CLOSE HOLDLOCK ROLLBACK CLUSTERED IDENTITY ROWCOUNT COALESCE IDENTITY_INSERT ROWGUIDCOL COLLATE IDENTITYCOL RULE COLUMN IF SAVE COMMIT IN SCHEMA COMPUTE INDEX SELECT CONSTRAINT INNER SESSION_USER CONTAINS INSERT SET CONTAINSTABLE INTERSECT SETUSER CONTINUE INTO SHUTDOWN CONVERT IS SOME CREATE JOIN STATISTICS CROSS KEY SYSTEM_USER CURRENT KILL TABLE CURRENT_DATE LEFT TEXTSIZE CURRENT_TIME LIKE THEN CURRENT_TIMESTAMP LINENO TO CURRENT_USER LOAD TOP CURSOR NATIONAL TRAN DATABASE NOCHECK TRANSACTION DBCC NONCLUSTERED TRIGGER DEALLOCATE NOT TRUNCATE DECLARE NULL TSEQUAL DEFAULT NULLIF UNION DELETE OF UNIQUE DENY OFF UPDATE DESC OFFSETS UPDATETEXT DISK ON USE DISTINCT OPEN USER DISTRIBUTED OPENDATASOURCE VALUES DOUBLE OPENQUERY VARYING DROP OPENROWSET VIEW DUMMY OPENXML WAITFOR DUMP OPTION WHEN ELSE OR WHERE END ORDER WHILE ERRLVL OUTER WITH ESCAPE OVER WRITETEXT ------------------------------------------------------------------------------------------------- -- -- -- -- Database for application version -- Generated for PostgreSQL [7|8] using adl2psql.xsl $Revision: 1.3 $ -- -- -- -- Code generator (c) 2006 Simon Brooke [simon@weft.co.uk] -- http://www.weft.co.uk/library/jacquard/ -- ------------------------------------------------------------------------------------------------- use ""; ------------------------------------------------------------------------------------------------- -- authentication roles ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- tables, views and permissions ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- referential integrity constraints ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- end of file ------------------------------------------------------------------------------------------------- /* */ ------------------------------------------------------------------------------------------------- -- security group ------------------------------------------------------------------------------------------------- CREATE GROUP ; ALTER TABLE ADD CONSTRAINT ri_ FOREIGN KEY ( ) REFERENCES ON DELETE NO ACTION; ALTER TABLE ln__ ADD CONSTRAINT ri____id FOREIGN KEY ( _id) REFERENCES ON DELETE CASCADE; ALTER TABLE ln__ ADD CONSTRAINT ri____id FOREIGN KEY ( _id) REFERENCES ON DELETE CASCADE; ------------------------------------------------------------------------------------------------- -- primary table ------------------------------------------------------------------------------------------------- CREATE TABLE ( , ); ---- permissions ------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------- -- convenience view lv for lists ------------------------------------------------------------------------------------------------- CREATE VIEW lv AS SELECT AS . , FROM , AS WHERE AND . = ._id ; ---- permissions ------------------------------------------------------------------------------ ---- permissions ------------------------------------------------------------------------------ ln__ Template distinctfield entered, table is . Entity detected. . | ', ' | GRANT SELECT ON TO GROUP ; GRANT INSERT ON TO GROUP ; GRANT SELECT, INSERT ON TO GROUP ; GRANT SELECT, INSERT, UPDATE ON TO GROUP ; GRANT SELECT, INSERT, UPDATE, DELETE ON TO GROUP ; REVOKE ALL ON FROM GROUP ; REVOKE ALL ON lv_ FROM GROUP ; REVOKE ALL ON lv_ FROM GROUP ; GRANT SELECT ON lv_ TO GROUP ; _1 ------------------------------------------------------------------------------------------------- -- link table joining with ------------------------------------------------------------------------------------------------- CREATE TABLE ln__ ( _id INT NOT NULL, _id INT NOT NULL, ); INT DEFAULT NOT NULL VARCHAR( ) INT DOUBLE PRECISION DEFAULT NOT NULL PRIMARY KEY NOT NULL VARCHAR( ) DEFAULT NOT NULL PRIMARY KEY NOT NULL INT DEFAULT NOT NULL PRIMARY KEY NOT NULL DOUBLE PRECISION DEFAULT NOT NULL DEFAULT NOT NULL PRIMARY KEY NOT NULL