Changeset 17460

Show
Ignore:
Timestamp:
08/12/08 01:29:25 (5 months ago)
Author:
int128
Message:

foreign keys added

Location:
lang/java/slideboard/trunk/sql
Files:
2 added
1 modified

Legend:

Unmodified
Added
Removed

  • lang/java/slideboard/trunk/sql/create.sql

    r17290 r17460  
     1SET AUTOCOMMIT FALSE; 
     2 
     3CREATE TABLE author ( 
     4        id INTEGER generated by default as identity, 
     5        name VARCHAR(255) NOT NULL, 
     6        department VARCHAR(255) NOT NULL, 
     7        mail VARCHAR(255) NOT NULL, 
     8        PRIMARY KEY(id) 
     9); 
    110 
    211CREATE TABLE post ( 
    3         id integer generated by default as identity, 
    4         title varchar(255) not null, 
    5         description varchar(255) not null, 
    6         author_id integer not null 
     12        id INTEGER generated by default as identity, 
     13        title VARCHAR(255) NOT NULL, 
     14        description VARCHAR(255) NOT NULL, 
     15        author_id INTEGER NOT NULL, 
     16        PRIMARY KEY(id), 
     17        FOREIGN KEY(author_id) REFERENCES author(id) 
    718); 
    819 
    9 CREATE TABLE author ( 
    10         id integer generated by default as identity, 
    11         name varchar(255) not null, 
    12         department varchar(255) not null, 
    13         mail varchar(255) not null 
    14 ); 
     20INSERT INTO author VALUES(1, 'Taro', 'My Home Security', 'taro@example.com'); 
     21INSERT INTO author VALUES(2, 'Jiro', 'Your Home Security', 'jiro@example.com'); 
     22INSERT INTO author VALUES(3, 'Ikzo', 'My Home Security', 'ikzo@example.com'); 
    1523 
    1624INSERT INTO post VALUES(1, 'Post1', 'This is a test post.', 3); 
    … …  
    1826INSERT INTO post VALUES(3, 'Post3', 'This is a test post.', 1); 
    1927 
    20 INSERT INTO author VALUES(1, 'Taro', 'My Home Security', 'taro@example.com'); 
    21 INSERT INTO author VALUES(2, 'Jiro', 'Your Home Security', 'jiro@example.com'); 
    22 INSERT INTO author VALUES(3, 'Ikzo', 'My Home Security', 'ikzo@example.com'); 
    23  
    2428COMMIT;