Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-23) was last changed on 24-Sep-2009 18:53 by 213.252.50.50  

This page was created on 17-Dec-2005 05:59 by MyTestUser

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 238 added 37 lines
----
Oracle script:\\
\\CREATE TABLE USERS(USERID VARCHAR(32) NOT NULL PRIMARY KEY,
PASSWD VARCHAR(32) NOT NULL,
EMAIL VARCHAR(64),
CREATED TIMESTAMP,
MODIFIED TIMESTAMP,
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
FULLNAME VARCHAR(50),
WIKINAME VARCHAR(50),
ISGROUP NUMBER DEFAULT 0 NOT NULL);
\\
\\CREATE TABLE ROLES(USERID VARCHAR(32) NOT NULL,
ROLEID VARCHAR(32) NOT NULL,
PRIMARY KEY(USERID,ROLEID),
CONSTRAINT FK_USERS FOREIGN KEY(USERID) REFERENCES USERS(USERID));
\\
\\CREATE TABLE GROUPMEMBERS(USERID VARCHAR(32) NOT NULL,
GROUPID VARCHAR(32) NOT NULL,
CONSTRAINT FK_GRPMEM_USERS FOREIGN KEY(USERID) REFERENCES USERS(USERID),
CONSTRAINT FK_GRPMEM_GROUPS FOREIGN KEY(GROUPID) REFERENCES USERS(USERID));
\\
\\CREATE VIEW V_ROLES (USERID,GROUPID,ROLEID) AS select gm.USERID, gm.GROUPID, r.ROLEID
from GROUPMEMBERS gm
inner join ROLES r on gm.GROUPID = r.USERID
union
select u.USERID, null, r.ROLEID
from USERS u
inner join ROLES r on u.USERID = r.USERID
where u.ISGROUP=0;
--Dean Pullen, 11-Nov-2008 11:57
Version Date Modified Size Author Changes ... Change note
23 24-Sep-2009 18:53 17.338 kB 213.252.50.50 to previous
22 18-May-2009 16:34 17.207 kB TomDuffy to previous | to last
21 18-May-2009 16:33 17.251 kB TomDuffy to previous | to last
« This page (revision-23) was last changed on 24-Sep-2009 18:53 by 213.252.50.50