Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
468 | diffor | 1 | CREATE TABLE distrs (id INTEGER PRIMARY KEY, distr VARCHAR); |
2 | CREATE TABLE vers (id INTEGER PRIMARY KEY, distr_id INTEGER KEY, vernum VARCHAR, codename VARCHAR); |
||
3 | |||
4 | INSERT INTO distrs VALUES (1, "Debian"); |
||
5 | INSERT INTO distrs VALUES (2, "Ubuntu"); |
||
6 | |||
7 | INSERT INTO vers VALUES (NULL, 1, "1.1", "buzz"); |
||
8 | INSERT INTO vers VALUES (NULL, 1, "1.2", "rex"); |
||
9 | INSERT INTO vers VALUES (NULL, 1, "1.3", "bo"); |
||
10 | INSERT INTO vers VALUES (NULL, 1, "2.0", "hamm"); |
||
11 | INSERT INTO vers VALUES (NULL, 1, "2.1", "slink"); |
||
12 | INSERT INTO vers VALUES (NULL, 1, "2.2", "potato"); |
||
13 | INSERT INTO vers VALUES (NULL, 1, "3.0", "woody"); |
||
14 | INSERT INTO vers VALUES (NULL, 1, "3.1", "sarge"); |
||
15 | INSERT INTO vers VALUES (NULL, 1, "4.0", "etch"); |
||
16 | INSERT INTO vers VALUES (NULL, 1, "5.0", "lenny"); |
||
17 | INSERT INTO vers VALUES (NULL, 1, "6.0", "squeeze"); |
||
18 | |||
19 | INSERT INTO vers VALUES (NULL, 2, "4.10", "warty"); |
||
20 | INSERT INTO vers VALUES (NULL, 2, "5.04", "hoary"); |
||
21 | INSERT INTO vers VALUES (NULL, 2, "5.10", "breezy"); |
||
22 | INSERT INTO vers VALUES (NULL, 2, "6.06", "dapper"); |
||
23 | INSERT INTO vers VALUES (NULL, 2, "6.10", "edgy"); |
||
24 | INSERT INTO vers VALUES (NULL, 2, "7.04", "feisty"); |
||
25 | INSERT INTO vers VALUES (NULL, 2, "7.10", "gutsy"); |
||
26 | INSERT INTO vers VALUES (NULL, 2, "8.04", "hardy"); |
||
27 | INSERT INTO vers VALUES (NULL, 2, "8.10", "intrepid"); |
||
28 | INSERT INTO vers VALUES (NULL, 2, "9.04", "jaunty"); |
||
29 | INSERT INTO vers VALUES (NULL, 2, "9.10", "karmic"); |