import.sql 6.28 KB
-- INSERT avec identifiants car GenerationType.AUTO a du être changé en GenerationType.IDENTITY (2016-11-21)
//INSERT INTO ActionType (actionTypeId, actionTypeName) VALUES (1, 'Validate');
-- INSERT INTO Country (countryId, countryName) VALUES
--     (1, 'France'),
--     (2, 'Suisse'),
--     (3, 'Belgique'),
--     (4, 'Canada'),
--     (5, 'États-Unis d''Amérique'),
--     (6, 'Australie'),
--     (7, 'Espagne'),
--     (8, 'Portugal'),
--     (9, 'Royaume-Uni'),
--     (10, 'Allemagne'),
--     (11, 'Pologne'),
--     (12, 'Italie');
INSERT INTO Account (userId, username, password, firstName, lastName, nickname, email, activated, anonymous, visible,
                       criticProvider) VALUES
    (1, '1', null, '1f', '1l', '1n', '1@raza.org', TRUE, TRUE, TRUE, TRUE),
    (2, '2', null, '2f', '2l', '2n', '2@raza.org', TRUE, FALSE, TRUE, TRUE),
    (3, '3', null, '3f', '3l', '3n', '3@raza.org', TRUE, FALSE, TRUE, TRUE),
    (4, '4', null, '4f', '4l', '4n', '4@raza.org', TRUE, FALSE, TRUE, TRUE),
    (5, '5', null, '5f', '5l', '5n', '5@raza.org', TRUE, FALSE, TRUE, TRUE),
    (8, '8', null, '8f', '8l', '8n', '8@raza.org', TRUE, FALSE, TRUE, TRUE),
    (9, '9', null, '9f', '9l', '9n', '9@raza.org', TRUE, FALSE, TRUE, TRUE),
    (10, '10', null, '10f', '10l', '10n', '10@raza.org', TRUE, FALSE, TRUE, TRUE),
    (11, '11', null, '11f', '11l', '11n', '11@raza.org', TRUE, FALSE, TRUE, TRUE),
    (12, '12', null, '12f', '12l', '12n', '12@raza.org', TRUE, TRUE, TRUE, TRUE),
    (13, '13', null, '13f', '13l', '13n', '13@raza.org', TRUE, FALSE, TRUE, TRUE),
    (17, '17', null, '17f', '17l', '17n', '17@raza.org', TRUE, FALSE, TRUE, TRUE),
    (21, '21', null, '21f', '21l', '21n', '21@raza.org', TRUE, FALSE, TRUE, TRUE),
    (22, '22', null, '22f', '22l', '22n', '22@raza.org', TRUE, TRUE, TRUE, TRUE),
    (43, '43', null, '43f', '43l', '43n', '43@raza.org', TRUE, TRUE, TRUE, TRUE),
    (48, '48', null, '48f', '48l', '48n', '48@raza.org', TRUE, FALSE, TRUE, TRUE),
    (57, '57', null, '57f', '57l', '57n', '57@raza.org', TRUE, TRUE, TRUE, TRUE),
    (109, '109', null, '109f', '109l', '109n', '109@raza.org', TRUE, FALSE, TRUE, TRUE),
    (111, '111', null, '111f', '111l', '111n', '111@raza.org', TRUE, TRUE, TRUE, TRUE),
    (127, '127', null, '127f', '127l', '127n', '127@raza.org', TRUE, TRUE, TRUE, TRUE),
    (170, '170', null, '170f', '170l', '170n', '170@raza.org', TRUE, FALSE, TRUE, TRUE),
    (185, '185', null, '185f', '185l', '185n', '185@raza.org', TRUE, FALSE, TRUE, TRUE),
    (254, '254', null, '254f', '254l', '254n', '254@raza.org', TRUE, FALSE, TRUE, TRUE),
    (311, '311', null, '311f', '311l', '311n', '311@raza.org', TRUE, FALSE, TRUE, TRUE),
    (509, '509', null, '509f', '509l', '509n', '509@raza.org', TRUE, FALSE, TRUE, TRUE),
    (1017, '1017', null, '1017f', '1017l', '1017n', '1017@raza.org', TRUE, TRUE, TRUE, TRUE),
    (1028, '1028', null, '1028f', '1028l', '1028n', '1028@raza.org', TRUE, FALSE, TRUE, TRUE),
    (1152, '1152', null, '1152f', '1152l', '1152n', '1152@raza.org', TRUE, FALSE, TRUE, TRUE),
    (2316, '2316', null, '2316f', '2316l', '2316n', '2316@raza.org', TRUE, FALSE, TRUE, TRUE),
    (2374, '2374', null, '2374f', '2374l', '2374n', '2374@raza.org', TRUE, FALSE, TRUE, TRUE),
    (3362, '3362', null, '3362f', '3362l', '3362n', '3362@raza.org', TRUE, TRUE, TRUE, TRUE),
    (3431, '3431', null, '3431f', '3431l', '3431n', '3431@raza.org', TRUE, FALSE, TRUE, TRUE),
    (6, 'six', 'six', 'Kal', 'Varrik', 'six', 'six@raza.org', TRUE, FALSE, TRUE, TRUE);

-- INSERT INTO Publisher (publisherId) VALUES (1), (2), (3), (4);

-- INSERT INTO PublisherVersion (publisherVersionId, publisher_publisherId, publisherName, publisherStreetAddress,
--                               publisherPostalCode, publisherPostOfficeBoxNumber, publisherAddressRegion,
--                               publisherAddressLocality, publisherAddressCountry_countryId, publisherTelephone,
--                               publisherEmail, publisherURL, publisherActive, publisherHistory,
--                               publisherVersionAuthor_userId, publisherVersionDatetime) VALUES
--     (1, 1, 'GRôG', '', '', '', '', '', 1, '', 'passerelle@legrog.org', 'www.legrog.org', TRUE, 'Ouvert…', 1, {ts '2000-05-08 00:00:47'}),
--     (2, 2, 'Rôliste TV', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'www.rolistetv.com', TRUE, 'Ouvert…', 3, {ts '2010-05-20 08:43:16'}),
--     (3, 3, 'La Vouivre', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'la-vouivre.com', TRUE, 'Ouvert…', 1, {ts '2000-01-01 00:02:33'}),
--     (4, 3, 'La Vouivre', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'la-vouivre.com', FALSE, '…  en 2015', 2, {ts '2015-01-01 00:05:22'}),
--     (5, 4, 'Archmagus', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'archimage.net', TRUE, 'Ouvert…', 4, {ts '2016-10-14 10:56:03'});
-- UPDATE Publisher SET validatedVersion_publisherVersionId = 1 WHERE publisherId = 1;
-- UPDATE Publisher SET validatedVersion_publisherVersionId = 2 WHERE publisherId = 2;
-- UPDATE Publisher SET validatedVersion_publisherVersionId = 4 WHERE publisherId = 3;

-- INSERT INTO PublisherAction (publisherActionId, actionType, publisherActionAuthor_userId,
--                              publisherVersion_publisherVersionId, publisherActionDatetime, publisher_publisherId) VALUES
--     (1, 0, 2, 1, {ts '2000-05-08 12:00:28'}, 1),
--     (2, 0, 1, 2, {ts '2010-06-20 14:27:35'}, 2),
--     (3, 0, 1, 4, {ts '2015-01-01 16:18:17'}, 3);

INSERT INTO AccountRole (userRoleId, rolename, visible) VALUES
    (1, 'VISITEUR', TRUE),
    (2,'RECRUE', TRUE),
    (3, 'CONTRIBUTEUR', TRUE),
    (4, 'ADMINISTRATEUR', TRUE),
    (5, 'RETRAITE', TRUE),
    (6, 'ASSOCE', TRUE);
INSERT INTO AccountProperty (userPropertyId, name, tag, visible) VALUES
    (1, 'nb_vignettes', 'Nombre de vignettes en home', TRUE),
    (2, 'avatar', 'Lien vers une icône ou une photo', TRUE),
    (3, 'tagline', 'Ligne de présentation pour les contributeurs', TRUE),
    (4, 'taille_listes', 'Nombre d''éléments affichés dans les listes', TRUE),
    (5,'skin', 'Thème visuel', TRUE);

INSERT INTO Account_AccountRole VALUES (1,2);
INSERT INTO Account_AccountRole VALUES (2,2);
INSERT INTO Account_AccountRole VALUES (3,2);
INSERT INTO Account_AccountRole VALUES (4,2);
INSERT INTO Account_AccountRole VALUES (5,2);
INSERT INTO Account_AccountRole VALUES (6,2);
INSERT INTO Account_AccountRole VALUES (5,4);