summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql
blob: 5a1cdb2a9814678b1aae912a20027c9c18aa183a (plain)
1
2
3
4
5
6
7
8
TRUNCATE `Documents`;

INSERT INTO Documents VALUES (1, 'The World of Null-A', 'Book', 55, null);
INSERT INTO Documents VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon');
INSERT INTO Documents VALUES (3, 'Lord of the Rings', 'Book', 3587, null);
INSERT INTO Documents VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris');
INSERT INTO Documents VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris');
INSERT INTO Documents VALUES (6, 'Foundation', 'Monograph', 557, null);