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 MS-SQL 2000+ using adl2mssql.xslt -- THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT IT. -- -- -- -- Code generator (c) 2007 Cygnet Solutions Ltd -- ------------------------------------------------------------------------------------------------- use ""; ------------------------------------------------------------------------------------------------- -- authentication roles ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- magic view for role membership, used in establishing security credentials ------------------------------------------------------------------------------------------------- CREATE VIEW RoleMembership AS SELECT dbuser.name as "dbuser", dbrole.name as "dbrole" FROM sysusers AS dbuser, sysmembers, sysusers AS dbrole WHERE dbuser.uid = sysmembers.memberuid AND dbrole.uid = sysmembers.groupuid GO GRANT SELECT on RoleMembership to public GO ------------------------------------------------------------------------------------------------- -- primary tables, views and permissions ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- link tables ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- primary referential integrity constraints ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- -- end of file ------------------------------------------------------------------------------------------------- /* */ ------------------------------------------------------------------------------------------------- -- security group ------------------------------------------------------------------------------------------------- execute sp_addrole @rolename = '' GO ALTER TABLE "" ADD FOREIGN KEY ( "") REFERENCES "" ON DELETE GO ADL: ERROR: Failed to infer link field name whilst processing list property of Entity is '', nearside is '' CASCADE CASCADE CASCADE NO ACTION ------------------------------------------------------------------------------------------------- -- primary table ------------------------------------------------------------------------------------------------- CREATE TABLE "" ( , , "" ) GO ---- permissions ------------------------------------------------------------------------------ , PRIMARY KEY( " ", ) ""."" + ' ' + GRANT SELECT ON "" TO "" GRANT INSERT ON "" TO "" GRANT SELECT, INSERT ON "" TO "" GRANT SELECT, INSERT, UPDATE ON "" TO "" GRANT SELECT, INSERT, UPDATE, DELETE ON "" TO "" REVOKE ALL ON "" FROM "" GO true true false true false -- Problems with responsibility for generating link tables: -- @entity = -- $nearside = -- $farside = -- farlink = -- comparison = '' -- my responsibility = ------------------------------------------------------------------------------------------------- -- link table joining with ------------------------------------------------------------------------------------------------- CREATE TABLE "" ( "" NOT NULL, "" NOT NULL ) GO ---- permissions ------------------------------------------------------------------------------ GRANT SELECT,INSERT,UPDATE,DELETE ON "" TO "" GRANT SELECT,INSERT,UPDATE,DELETE ON "" TO "" GRANT SELECT,INSERT,UPDATE,DELETE ON "" TO "" GRANT SELECT,INSERT,UPDATE,DELETE ON "" TO "" REVOKE ALL ON "" FROM "" REVOKE ALL ON "" FROM "" GRANT SELECT ON TO GO ---- referential integrity -------------------------------------------------------------------- -- Suppressing generation of , as it is not my responsibility -- Suppressing output of property , -- as it is the 'one' end of a one-to-many relationship IDENTITY( 1, 1) "" NOT NULL DEFAULT 1 0 '' '' "" DEFAULT NOT NULL ADL: WARNING: entity '' has a compound primary key; adl2mssql is not yet clever enough to generate appropriate code ADL: ERROR: property '' refers to entity '', but this entity has no key. ADL: ERROR: property '' refers to entity '', but no such entity exists. DATETIME DATETIME VARCHAR( ) VARCHAR( ) TEXT BIT DATETIME INT DOUBLE PRECISION DECIMAL( 16, 2) [sql:unknown? []] 0 -1 1