Mercurialglpk-cmake / file revision
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
examples/sql/sudoku.sql
author Alpar Juttner <alpar@cs.elte.hu>
Mon, 06 Dec 2010 13:09:21 +0100
changeset 1 c445c931472f
permissions -rw-r--r--
Import glpk-4.45

- Generated files and doc/notes are removed 
     1 CREATE DATABASE glpk;

     2 CREATE USER glpk@localhost IDENTIFIED BY 'gnu';

     3 GRANT ALL PRIVILEGES ON glpk.* TO glpk@localhost;

     4 USE glpk;

     5 DROP TABLE sudoku;

     6 CREATE TABLE sudoku (

     7   ID   INT ,

     8   COL  INT ,

     9   LIN  INT ,

    10   VAL  INT ,

    11   PRIMARY KEY ( ID, COL, LIN )

    12   );

    13 DROP TABLE sudoku_solution;

    14 CREATE TABLE sudoku_solution (

    15   ID   INT ,

    16   COL  INT ,

    17   LIN  INT ,

    18   VAL  INT ,

    19   PRIMARY KEY ( ID, COL, LIN )

    20   );

    21 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 1, 5);

    22 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 2, 0);

    23 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 3, 0);

    24 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 4, 0);

    25 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 5, 4);

    26 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 6, 0);

    27 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 7, 0);

    28 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 8, 0);

    29 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 1, 9, 0);

    30 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 1, 0);

    31 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 2, 0);

    32 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 3, 3);

    33 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 4, 0);

    34 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 5, 0);

    35 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 6, 0);

    36 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 7, 6);

    37 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 8, 2);

    38 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 2, 9, 0);

    39 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 1, 0);

    40 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 2, 0);

    41 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 3, 0);

    42 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 4, 0);

    43 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 5, 0);

    44 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 6, 9);

    45 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 7, 0);

    46 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 8, 0);

    47 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 3, 9, 4);

    48 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 1, 0);

    49 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 2, 0);

    50 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 3, 6);

    51 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 4, 0);

    52 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 5, 0);

    53 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 6, 7);

    54 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 7, 2);

    55 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 8, 0);

    56 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 4, 9, 0);

    57 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 1, 8);

    58 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 2, 1);

    59 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 3, 0);

    60 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 4, 0);

    61 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 5, 0);

    62 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 6, 0);

    63 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 7, 0);

    64 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 8, 4);

    65 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 5, 9, 3);

    66 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 1, 0);

    67 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 2, 0);

    68 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 3, 9);

    69 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 4, 1);

    70 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 5, 0);

    71 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 6, 0);

    72 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 7, 0);

    73 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 8, 0);

    74 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 6, 9, 0);

    75 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 1, 7);

    76 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 2, 0);

    77 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 3, 0);

    78 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 4, 5);

    79 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 5, 0);

    80 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 6, 0);

    81 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 7, 0);

    82 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 8, 0);

    83 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 7, 9, 0);

    84 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 1, 0);

    85 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 2, 9);

    86 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 3, 2);

    87 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 4, 0);

    88 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 5, 0);

    89 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 6, 0);

    90 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 7, 8);

    91 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 8, 0);

    92 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 8, 9, 0);

    93 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 1, 0);

    94 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 2, 0);

    95 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 3, 0);

    96 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 4, 0);

    97 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 5, 3);

    98 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 6, 0);

    99 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 7, 0);

   100 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 8, 0);

   101 INSERT INTO sudoku (ID, COL, LIN, VAL) VALUES (1, 9, 9, 6);
glpk-cmake