
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoNoteListBody");
UPDATE `multi_lang` SET `content` = 'Below you can see all the notes that you''ve created and protected. You can create a new note by clicking on the "+ Add note" button or edit any of the notes below by clicking on the Edit icon next to it.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoFileListBody");
UPDATE `multi_lang` SET `content` = 'Below you can see all the files that you''ve uploaded and protected. You can upload a new file by clicking on the button "+ Upload file" or edit any of the files below by clicking on the Edit icon next to it.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

INSERT INTO `fields` VALUES (NULL, 'btnAddGroup', 'backend', 'Button / + Add group', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Add group', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnAddMember', 'backend', 'Button / + Add member', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Add member', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnAddFile', 'backend', 'Button / + Upload file', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Upload file', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnAddNote', 'backend', 'Button / + Add note', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Add note', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnAddUser', 'backend', 'Button / + Add user', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Add user', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoMembersTitle', 'backend', 'Infobox / List of members', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'List of members', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoMembersBody', 'backend', 'Infobox / List of members description', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can see below the list of member. If you want to add new member, click on the button "+ Add member".', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoUpdateMemberTitle', 'backend', 'Infobox / Update member', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Update member', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoUpdateMemberBody', 'backend', 'Infobox / Update member description', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can make any changes on the form below and click on the "Save" button to update member information.', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoAddUserTitle', 'backend', 'Infobox / Add new user', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Add new user', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoAddUserBody', 'backend', 'Infobox / Add new user description', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Fill in the form below to add new user.', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoUpdateUserTitle', 'backend', 'Infobox / Update user', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Update user', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoUpdateUserBody', 'backend', 'Infobox / Update user description', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can make any changes on the form below and click on the "Save" button to update user information.', 'script');

COMMIT;