GLProgramming.com

home :: about :: development guides :: irc :: forums :: search :: paste :: links :: contribute :: code dump

-> Click here to learn how to get live help <-


New Paste :: Recent Pastes:: No Line Numbers


A Paste by Anonymous
1
 
CREATE TABLE CA (name char(50) not null,
             code char(20),
         rulestr char(50),
         description text,
         primary key(name));

CREATE TABLE WE1REP (representation char(50) not null,
             primary key(representation));

CREATE TABLE WE1REPRESENTED (name char(50) not null,
                 representation char(50) not null,
                 primary key(name, representation),
                 foreign key(name) references CA,
                 foreign key(representation) references WE1REP);