"Fossies" - the Fresh Open Source Software Archive

Member "dbdiff-0.2.0/test/modify_view/target.sql" (20 Sep 2006, 204 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 CREATE TABLE authors (
    2   `id` int(11) NOT NULL auto_increment,
    3   `name` char(60) NOT NULL,
    4   PRIMARY KEY  (`id`)
    5 ) ENGINE=innodb DEFAULT CHARSET=latin1;
    6 
    7 CREATE VIEW authors_v as (SELECT * FROM authors);