"Fossies" - the Fresh Open Source Software Archive

Member "dbdiff-0.2.0/test/table_fk2/source.sql" (20 Sep 2006, 402 Bytes) of package /linux/privat/old/dbdiff-0.2.0.tgz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 
    2 CREATE TABLE authors (
    3   `id` int(11) NOT NULL auto_increment,
    4   `name` char(60) NOT NULL,
    5   PRIMARY KEY  (`id`)
    6 ) ENGINE=innodb DEFAULT CHARSET=latin1;
    7 
    8 
    9 CREATE TABLE books (
   10   id int(11) NOT NULL auto_increment,
   11   author_id int not null,
   12   name char(60) NOT NULL,
   13   pages int not null,
   14   FOREIGN KEY (author_id) references authors(id),
   15   PRIMARY KEY  (`id`)
   16 ) ENGINE=innodb DEFAULT CHARSET=latin1;
   17