[thesite] Re: [Admin] admin.evolt.org

[walker]

perhaps this might help:

here is the sql to build the voting app schema in oracle. If you choose to 
use this, i'll need to update the app to call the sequences, instead of 
using the auto increment for the primary key.

Let me know if you'd like me to do so.

-w

CREATE TABLE questions (
         question_id number NOT NULL,
         question_name varchar2 (50) NULL ,
         question text NULL,
         user_id varchar2 (50),
         dateadded date,
         active number NOT NULL,
         CONSTRAINT questions_pk PRIMARY KEY (question_id)
)
STORAGE(INITIAL 5M NEXT 5M);

CREATE TABLE choices (
         choice_id number NOT NULL,
         question_id number NULL ,
         choice_name varchar2 (50) NULL ,
         choice text NULL ,
         choice_order number NULL ,
         active number NOT NULL ,
         CONSTRAINT choice_pk PRIMARY KEY (choice_id),
         FOREIGN KEY (question_id) REFERENCES questions (question_id)
)
STORAGE(INITIAL 5M NEXT 5M);

CREATE TABLE responses (
         response_id number NOT NULL auto_increment,
         choice_id number NULL ,
         question_id number NULL ,
         user_ip varchar2 (50),
         user_id varchar2 (50),
         active number NOT NULL ,
         CONSTRAINT responses_pk PRIMARY KEY (response_id),
         FOREIGN KEY (question_id) REFERENCES questions (question_id)
         FOREIGN KEY (choice_id) REFERENCES choices (choice_id)
)
STORAGE(INITIAL 5M NEXT 5M);

create sequence CHOICE_ID_SEQ increment by 1 start with 1;
create sequence QUESTION_ID_SEQ increment by 1 start with 1;
create sequence RESPONSE_ID_SEQ increment by 1 start with 1;

At 01:55 PM 7/6/2001 -0500, you wrote:
>erf. everything *EXCEPT* the voting application since walkers data was in 
>mysql.
>
>oops
>
>Elfur Logadottir wrote:
>
>>From: "Daniel J. Cody" <djc at starkmedia.com>
>>
>>| also known by its despised name of 'thewife' is back up and running too.
>>| | isac and elfur, if you get a chance, check your jobs :)
>>supah, dupah working for me, thanks
>
>
>
>_______________________________________________
>For unsubscribe, archive, and options, go to:
>http://lists.evolt.org/mailman/listinfo/thesite

_________________________________________
walker fenton
walker at sdproductions.com
303.722.5473