|
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); |