[thesite] feo database changes

[Warden, Matt]

thesite,

(rudy, i know you're busy so i won't hold you to that promise of a reply)

Here are the database changes I made to allow reuse of the attribute table
for other items (here, this case, content):

CREATE TABLE ATTRIBUTETYPE (
	ATTRTYPEID NUMBER(8) NOT NULL PRIMARY KEY,
	ATTRTYPENAME VARCHAR(50) NOT NULL,
	DATEMOD DATE DEFAULT SYSDATE NOT NULL
);


ALTER TABLE ATTRIBUTE ADD ATTRTYPEID NUMBER(8) DEFAULT 1 NOT NULL
REFERENCES ATTRIBUTETYPE (ATTRTYPEID)


create table CONTENTATTR (
	CONTENTATTRID NUMBER(8) NOT NULL PRIMARY KEY,
	CONTENTID NUMBER(8) NOT NULL REFERENCES CONTENT (CONTENTID),
	ATTRID NUMBER(8) NOT NULL REFERENCES ATTRIBUTE (ATTRID),
	SEQ NUMBER(2) DEFAULT 0 NOT NULL,
	PRIV NUMBER(1) DEFAULT 0 NOT NULL,
	ATTRVALUE VARCHAR2(255) NULL,
	REMARKS VARCHAR2(255) NULL
);


I was tempted to go another step and make an ATTRVAL table and whack the
MEMBATTR table, but I figured I should make as little change as possible,
so I just added another specific table CONTENTATTR. Let me know what you
think (not just talking to rudy here, guys!).


Oh, and feel free to bitch about my syntax!!!!

Any questions/comments/complaints?



Thanks,


--
mattwarden
mattwarden.com