INSERT INTO mediatypes (mimetype,name) VALUES ( 'text/plain','Text');
INSERT INTO mediatypes (mimetype,name) VALUES ( 'text/html', 'HTML');
INSERT INTO mediatypes (mimetype,name) VALUES ( 'application/xml', 'XML');
INSERT INTO mediatypes (mimetype,name) VALUES ( 'application/xhtml+xml', 'XHTML');
INSERT INTO mediatypes (mimetype,name) VALUES ( 'application/vnd.sun.xml.writer', 'OpenOffice.org Writer');
INSERT INTO languages (code, localname) VALUES ( 'en', 'English');
INSERT INTO languages (code, localname) VALUES ( 'no' , 'Norsk');
INSERT INTO languages (code, localname) VALUES ( 'nb' , 'Bokmål');
INSERT INTO articles (
filename,
title,
description,
date,
format_ID,
lang_ID,
authorok,
editorok
) VALUES (
'thedahuts',
'The Freedom of the Dahut Hill',
'Several herds of dahuts lived peacefully on a hill, until they heard the yell.',
'2005-01-09',
4,
1,
true,
true
);
INSERT INTO articles (
filename,
title,
description,
date,
format_ID,
lang_ID
) VALUES (
'dafoooo',
'The foo of the dahut',
'An article about the foo of the dahuts.',
'2005-01-12',
1,
1
);
INSERT INTO articlecats (Article_ID, Cat_ID, field) VALUES (1, 2, 'primcat');
INSERT INTO articlecats (Article_ID, Cat_ID, field) VALUES (1, 4, 'seccat');
INSERT INTO articlecats (Article_ID, Cat_ID, field) VALUES (1, 3, 'seccat');
INSERT INTO articlecats (Article_ID, Cat_ID, field) VALUES (2, 4, 'primcat');
INSERT INTO articlecats (Article_ID, Cat_ID, field) VALUES (2, 3, 'seccat');
INSERT INTO articleuserroles (Code, Name) VALUES ('author', 'Author');
INSERT INTO articleusers (Article_ID, Users_ID, Role_ID) VALUES (1, 2, 1);
INSERT INTO articleusers (Article_ID, Users_ID, Role_ID) VALUES (1, 3, 1);
INSERT INTO articleusers (Article_ID, Users_ID, Role_ID) VALUES (2, 5, 1);