/
softailor
/
gridient
Обзор
Документация
Войти
/
softailor
/
gridient
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
db/PostgreSQL/02-import.sql
353 строки
56 KB
Jenkins
Auto add
18 фев 2026, 10:19
18 фев 2026, 10:19
1e6c4f8
Код
Авторство
О чём код?
\c gridient_db SET search_path TO public; -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO lists (title, last_item_id, version_max, list_type) VALUES ('Отделы', 3, 1, 1), ('Типы документов', 2, 1, 1), ('Сотрудники', 4, 1, 0), ('Задачи', 3, 1, 0), ('Документы', 3, 1, 0), ('Проекты', 4, 1, 0) ; -- ********************************************************************************************************************************************************************** -- ВАЖНО: Данные о доступах к спискам (list_groups) находятся в БД gridient_authorization -- Они должны быть импортированы отдельным скриптом 02-import-authorization.sql -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO field_groups (list_id, name, sort_order) VALUES ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 'Основные данные', 1), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Основные данные', 1), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Расширенные данные', 2), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Основные данные', 1), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Основные данные', 1), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Расширенные данные', 2), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'Основные данные', 1), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 'Основные данные', 1) ; -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) values ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'FirstName', 'Имя', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 1, NULL, 'true', 'true', 1), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'LastName', 'Фамилия', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 2, NULL, 'true', 'true', 2), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Email', 'Email', '@company.com','Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 3, NULL, 'true', 'false', 3), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Position', 'Должность', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 5, NULL, 'true', 'true', 5), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'HireDate', 'Дата приёма', '[TODAY]','Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 6, NULL, 'true', 'true', 6), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Phone', 'Телефон', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 7, NULL, NULL, 'false', 7), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Photo', 'Фото', NULL,'File', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 8, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'IsActive', 'Активен', NULL,'Boolean', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 9, NULL, 'true', 'false', 8) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) values ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Title', 'Название', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 1, NULL, 'true', NULL, 1), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Confidential', 'Конфиденциально', NULL,'Boolean', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 2, NULL, 'true', 'true', NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Type', 'Тип документа', NULL,'Choice', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 2, 'Договор;Отчёт;Презентация', 'true', 'false', 2), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Created', 'Дата создания', '[TODAY]','Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 4, NULL, 'true', 'false', 4), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Modified', 'Дата изменения', '[TODAY]','Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 5, NULL, NULL, 'false', 5), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'File', 'Файл', NULL,'File', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 6, NULL, 'true', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 'Keywords', 'Ключевые слова', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 8, NULL, NULL, 'false', NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) values ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'Title', 'Название проекта', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 1, NULL, 'true', NULL, 1), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'ProjectCode', 'Код проекта', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 2, NULL, 'true', 'false', 0), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'StartDate', 'Дата начала', NULL,'Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 4, NULL, 'true', 'false', 3), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'EndDate', 'Дата окончания', NULL,'Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 5, NULL, NULL, 'false', 3), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'Budget', 'Бюджет', NULL,'Number', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 6, NULL, NULL, 'false', 4), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'Status', 'Статус', NULL,'Choice', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 7, 'Планируется;В работе;Завершён;Заморожен', 'true', 'false', 5), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 'Description', 'Описание', NULL,'Note', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 8, NULL, NULL, 'false', 6) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) values ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 'Title', 'Название отдела', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 1, NULL, 'true', NULL, 1), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 'Code', 'Код отдела', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 2, NULL, 'true', 'false', 2), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 'Budget', 'Годовой бюджет', NULL,'Number', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 4, NULL, NULL, 'true', 4), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 'IsActive', 'Активен', NULL,'Boolean', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 5, NULL, 'true', 'true', 5) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) VALUES ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Title', 'Название задачи', NULL, 'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 1, NULL, 'true', NULL, 1), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'StartDate', 'Дата начала', NULL, 'Date', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 2, NULL, NULL, false, 3), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'DueDate', 'Срок выполнения', NULL, 'Date', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 3, NULL, 'true', true, 4), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Status', 'Статус', NULL, 'Choice', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 4, 'Отменена;Не начата;В работе;Завершена', 'true', false, 5), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Priority', 'Приоритет', 'Средний', 'Choice', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 5, 'Низкий;Средний;Высокий;Критичный', 'true', true, 6), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Progress', 'Прогресс', '0', 'Number', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 6, NULL, NULL, false, 7), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Category', 'Категория', NULL, 'Choice', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 3, 'Разработка;Тестирование;Документация', NULL, true, 8), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Description', 'Описание', NULL, 'Note', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 5, NULL, NULL, false, 2), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'Attachments', 'Вложения', NULL, 'File', (SELECT id FROM field_groups WHERE name = 'Расширенные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 4, NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order ) values ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 'Title', 'Наименование', NULL,'Text', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 1, NULL, 'true', NULL, 1), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 'RetentionYears', 'Срок хранения (лет)', '5','Number', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 2, NULL, 'true', 'true', 2), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 'Confidential', 'Конфиденциальность', NULL,'Boolean', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 3, NULL, 'true', 'true', 3) ; -- ********************************************************************************************************************************************************************** INSERT INTO fields ( list_id, "name", title, default_value, field_type, group_id, sort_order, "options", required_condition, enable_filter, view_order, lookup_list_id, lookup_field_id ) values ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 'Department', 'Отдел', NULL,'Lookup', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1) LIMIT 1), 4, NULL, 'true', 'true', 4, (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), (SELECT id FROM fields WHERE "name" = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1) LIMIT 1)), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 'AssignedTo', 'Исполнитель', NULL, 'Lookup', (SELECT id FROM field_groups WHERE name = 'Основные данные' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1) LIMIT 1), 2, NULL, 'true', false, 2, (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), (SELECT id FROM fields WHERE "name" = 'LastName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1) LIMIT 1)) ; -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Confidential' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'File' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), '1', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Modified' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Created' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Type' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Договор', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Договор №123 с ООО "Восход"', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Keywords' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'клиент, 2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Confidential' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'File' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), '2', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Modified' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Created' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Type' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Отчёт', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Годовой отчёт за 2023 год', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Keywords' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'финансы, итоги', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Confidential' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'File' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), '3', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Modified' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Created' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), NULL, NULL, '2024-03-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Type' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Презентация', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'Презентация продукта X', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Keywords' AND list_id = (SELECT id FROM lists WHERE title = 'Документы' LIMIT 1)), 'маркетинг, запуск', NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Разработка мобильного приложения', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'ProjectCode' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'PROJ-APP-2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'EndDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, 2500000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'В работе', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Создание кроссплатформенного приложения для клиентов', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Маркетинговая кампания 2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'ProjectCode' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'PROJ-MKT-2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'EndDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, 1800000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'В работе', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Годовая рекламная кампания в соцсетях и медиа', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Обновление ИТ-инфраструктуры', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'ProjectCode' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'PROJ-INF-2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'EndDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, 3200000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Планируется', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Модернизация серверного оборудования и ПО', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Внедрение CRM системы', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'ProjectCode' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'PROJ-CRM-2024', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'EndDate' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), NULL, 1500000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Завершён', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1)), 'Интеграция новой CRM с текущими системами', NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'IT', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Code' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'DEP-IT', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), NULL, 500000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'Маркетинг', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Code' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'DEP-MKT', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), NULL, 300000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'Финансы', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Code' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'DEP-FIN', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Budget' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), NULL, 700000.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1)), 'true', NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'FirstName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Петр', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'LastName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Петров', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Email' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'ppetrov@company.com', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Phone' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), '+79161234567', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Department' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1) AND text_value = 'IT' LIMIT 1), 'IT'), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Position' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Разработчик', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'HireDate' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, '2000-01-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Photo' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'FirstName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Анна', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'LastName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Сидорова', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Email' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'asidorova@company.com', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Phone' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), '+79035556677', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Department' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1) AND text_value = 'Маркетинг' LIMIT 1), 'Маркетинг'), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Position' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Менеджер', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'HireDate' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, '2024-02-20', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Photo' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'FirstName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Олег', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'LastName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Безemail', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Email' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'NULL', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Phone' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Department' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1) AND text_value = 'Финансы' LIMIT 1), 'Финансы'), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Position' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Бухгалтер', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'HireDate' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, '2022-11-10', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Photo' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'FirstName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Константин', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'LastName' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Сидоров', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Email' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'k.sidorov@company.com', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Phone' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), '+79161234567', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Department' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1) AND text_value = 'Финансы' LIMIT 1), 'Финансы'), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Position' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'Финансовый директор', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'HireDate' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, '2020-09-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'Photo' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1), 4, (SELECT id FROM fields WHERE name = 'IsActive' AND list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1)), 'true', NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Разработать API', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'AssignedTo' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1) AND text_value = 'Петров' LIMIT 1), 'Петров'), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'DueDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-06-15', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'В работе', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Priority' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Высокий', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Progress' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, 65.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-06-01', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Category' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Разработка', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Attachments' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Создать REST API для модуля заказов', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Attachments' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Годовой отчёт по продажам', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Category' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Документация', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-05-20', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Progress' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, 100.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Priority' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Средний', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Завершена', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'DueDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-05-25', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'AssignedTo' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1) AND text_value = 'Сидорова' LIMIT 1), 'Сидорова'), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Подготовить отчёт', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'AssignedTo' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, (SELECT id FROM field_values WHERE list_id = (SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1) AND text_value = 'Петров' LIMIT 1), 'Петров'), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Тестирование формы', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Description' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Проверить валидацию полей ввода', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Attachments' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Category' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Тестирование', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'StartDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-06-05', NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Progress' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, 0.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Priority' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Средний', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'Status' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), 'Не начата', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1), 3, (SELECT id FROM fields WHERE name = 'DueDate' AND list_id = (SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1)), NULL, NULL, '2024-06-10', NULL, NULL) ; -- ********************************************************************************************************************************************************************** INSERT INTO field_values ( list_id, item_id, field_id, text_value, number_value, date_value, lookup_id, lookup_value ) VALUES ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 'Договор', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'RetentionYears' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), NULL, 10.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 1, (SELECT id FROM fields WHERE name = 'Confidential' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 'true', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Title' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), 'Отчёт', NULL, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'RetentionYears' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), NULL, 5.00, NULL, NULL, NULL), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1), 2, (SELECT id FROM fields WHERE name = 'Confidential' AND list_id = (SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1)), NULL, NULL, NULL, NULL, NULL) ; -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO attachments (name,"content") VALUES ('test_1.rar',decode('526173050400','hex')), ('test_2.rar',decode('526173050400','hex')), ('test_3.rar',decode('526173050400','hex')) ; -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** -- ********************************************************************************************************************************************************************** INSERT INTO list_items_sys_info (list_id, item_id, created_by_id, created_utc) VALUES ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1),2, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Задачи' LIMIT 1),3, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1),2, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1),3, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Сотрудники' LIMIT 1),4, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1),2, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Документы' LIMIT 1),3, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1),2, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1),3, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Проекты' LIMIT 1),4, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1),2, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Отделы' LIMIT 1),3, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1),1, 0, CURRENT_TIMESTAMP), ((SELECT id FROM lists WHERE title = 'Типы документов' LIMIT 1),2, 0, CURRENT_TIMESTAMP) ;