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:: Add Line Numbers

A Paste by Anonymous
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);