
START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'button_titles_ARRAY_edit', 'arrays', 'button_titles_ARRAY_edit', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Edit', 'script');

INSERT INTO `fields` VALUES (NULL, 'button_titles_ARRAY_delete', 'arrays', 'button_titles_ARRAY_delete', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Delete', 'script');

INSERT INTO `fields` VALUES (NULL, 'button_titles_ARRAY_send', 'arrays', 'button_titles_ARRAY_send', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Send', 'script');

INSERT INTO `fields` VALUES (NULL, 'button_titles_ARRAY_import', 'arrays', 'button_titles_ARRAY_import', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Import', 'script');

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblSendNow");
UPDATE `multi_lang` SET `content` = 'Send now' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblSendLater");
UPDATE `multi_lang` SET `content` = 'Send later' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

INSERT INTO `fields` VALUES (NULL, 'menuSend', 'backend', 'Menu / Send', 'script', '2015-05-05 14:06:08');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Send', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoMessagesTitle', 'backend', 'Infobox / List of messages', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'List of messages', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoMessagesDesc', 'backend', 'Infobox / List of messages', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can find below the list of defined messages. If you want to create new message, click on the button "+ Create message". You can also view or edit the details of a specific message by clicking on the pencil icon on the corresponding entry. ', '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, 'infoUsersTitle', 'backend', 'Infobox / List of users', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'List of users', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoUsersDesc', 'backend', 'Infobox / List of users', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can find below the list of users. If you want to add new user, just click on the button "+ Add user". Click on the pencil icon on the corresponding entry to edit user information.', '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, 'infoUpdateUserDesc', 'backend', 'Infobox / Update user', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can make any change on the form below and click "Save" button to update user information.', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoCreateUserTitle', '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, 'infoCreateUserDesc', 'backend', 'Infobox / Add new user', 'script', NULL);

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Fill in the form below with some mandatory fields and click "Save" button to add new user.', 'script');

COMMIT;