Хранилища Subversion ant

Редакция

Авторство | Последнее изменение | Открыть журнал | Скачать | RSS

CREATE TABLE distrs (id INTEGER PRIMARY KEY, distr VARCHAR);
CREATE TABLE vers (id INTEGER PRIMARY KEY, distr_id INTEGER KEY, vernum VARCHAR, codename VARCHAR);

INSERT INTO distrs VALUES (1, "Debian");
INSERT INTO distrs VALUES (2, "Ubuntu");

INSERT INTO vers VALUES (NULL, 1, "1.1", "buzz");
INSERT INTO vers VALUES (NULL, 1, "1.2", "rex");
INSERT INTO vers VALUES (NULL, 1, "1.3", "bo");
INSERT INTO vers VALUES (NULL, 1, "2.0", "hamm");
INSERT INTO vers VALUES (NULL, 1, "2.1", "slink");
INSERT INTO vers VALUES (NULL, 1, "2.2", "potato");
INSERT INTO vers VALUES (NULL, 1, "3.0", "woody");
INSERT INTO vers VALUES (NULL, 1, "3.1", "sarge");
INSERT INTO vers VALUES (NULL, 1, "4.0", "etch");
INSERT INTO vers VALUES (NULL, 1, "5.0", "lenny");
INSERT INTO vers VALUES (NULL, 1, "6.0", "squeeze");

INSERT INTO vers VALUES (NULL, 2, "4.10", "warty");
INSERT INTO vers VALUES (NULL, 2, "5.04", "hoary");
INSERT INTO vers VALUES (NULL, 2, "5.10", "breezy");
INSERT INTO vers VALUES (NULL, 2, "6.06", "dapper");
INSERT INTO vers VALUES (NULL, 2, "6.10", "edgy");
INSERT INTO vers VALUES (NULL, 2, "7.04", "feisty");
INSERT INTO vers VALUES (NULL, 2, "7.10", "gutsy");
INSERT INTO vers VALUES (NULL, 2, "8.04", "hardy");
INSERT INTO vers VALUES (NULL, 2, "8.10", "intrepid");
INSERT INTO vers VALUES (NULL, 2, "9.04", "jaunty");
INSERT INTO vers VALUES (NULL, 2, "9.10", "karmic");