Nurfog/openccb
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
openccb/services/cms-service/migrations
T
History
Nurfog 553036cb58 feat: add external SAM ID support to courses and update API documentation
2026-04-27 18:01:31 -04:00
..
20231219000000_initial_schema.sql
feat: add external SAM ID support to courses and update API documentation
2026-04-27 18:01:31 -04:00
20231219000001_lesson_metadata.sql
Initial commit: Clean workspace without heavy binaries
2025-12-19 15:36:54 -03:00
20231219000002_assets_table.sql
Initial commit: Clean workspace without heavy binaries
2025-12-19 15:36:54 -03:00
20231219000003_users_table.sql
feat: update CMS service handlers and main application logic.
2025-12-22 13:54:35 -03:00
20231221000001_grading_system.sql
feat: update CMS service handlers and main application logic.
2025-12-22 13:54:35 -03:00
20231222000001_lesson_attempts.sql
feat: Implement lesson attempt tracking, retry functionality, and max attempt limits for interactive blocks.
2025-12-22 15:47:18 -03:00
20231222000002_add_roles.sql
feat: Implement comprehensive course analytics, RBAC with roles and authentication, and dynamic passing thresholds.
2025-12-23 10:12:53 -03:00
20231222000003_add_passing_percentage.sql
feat: Implement comprehensive course analytics, RBAC with roles and authentication, and dynamic passing thresholds.
2025-12-23 10:12:53 -03:00
20231223000001_add_certificate_template.sql
feat: implement audit logging and add certificate template field to courses
2025-12-23 11:04:36 -03:00
20251226000000_multi_tenancy.sql
feat: Implement organization branding, course pacing, and display upcoming deadlines in the experience portal.
2025-12-29 01:30:48 -03:00
20251227000000_add_lesson_summary.sql
feat: Implement organization branding, course pacing, and display upcoming deadlines in the experience portal.
2025-12-29 01:30:48 -03:00
20251229000001_add_organization_branding.sql
feat: Implement organization branding, course pacing, and display upcoming deadlines in the experience portal.
2025-12-29 01:30:48 -03:00
20251230000001_course_pacing_and_dates.sql
feat: Implement organization branding, course pacing, and display upcoming deadlines in the experience portal.
2025-12-29 01:30:48 -03:00
20251230000002_add_organization_domain.sql
feat: introduce CourseEditorLayout and AppHeader, add organization domain migration, and update Docker configurations and auth scripts
2025-12-29 18:00:34 -03:00
20251231000000_add_gamification_to_users.sql
feat: add gamification features for users, including XP and leveling, with corresponding database schema and API response updates.
2026-01-04 21:40:21 -03:00
20260111000000_gamification_users.sql
feat: fix migrations files
2026-01-11 02:46:02 -03:00
20260111000001_webhooks.sql
feat: fix migrations files
2026-01-11 02:46:02 -03:00
20260111000002_advanced_auditing.sql
feat: database-first refactor, unified architecture and visual developer manual
2026-01-11 02:34:23 -03:00
20260111000005_crud_functions.sql
feat: Introduce AI code hinting, enforce single-tenant organization model, and add a Code Lab block component.
2026-03-09 17:24:15 -03:00
20260111000006_add_org_to_content_tables.sql
feat: implement structured grading system with predefined assessment types
2026-01-12 00:52:26 -03:00
20260111000007_fix_audit_logs_constraint.sql
feat: implement structured grading system with predefined assessment types
2026-01-12 00:52:26 -03:00
20260111000008_fix_content_schema_final.sql
feat: implement structured grading system with predefined assessment types
2026-01-12 00:52:26 -03:00
20260111000009_seed_tutorials.sql
feat: implement structured grading system with predefined assessment types
2026-01-12 00:52:26 -03:00
20260115000002_make_audit_user_nullable.sql
feat: Introduce multi-tenancy support with organization-specific data, add interactive transcript functionality, and enhance lesson/course schemas.
2026-01-15 18:02:04 -03:00
20260115000003_add_transcription_status.sql
feat: Introduce multi-tenancy support with organization-specific data, add interactive transcript functionality, and enhance lesson/course schemas.
2026-01-15 18:02:04 -03:00
20260116000010_update_fn_register_user.sql
actualizaciones
2026-03-03 17:44:24 -03:00
20260116000011_add_delete_functions.sql
feat: Implement video play count tracking, refactor user update API, add missing CMS delete functions, and update database transaction handling.
2026-01-16 13:43:58 -03:00
20260117000000_add_profile_fields.sql
feat: Implement user profile management, add multi-language interactive transcripts, and lay groundwork for SSO.
2026-01-17 00:26:42 -03:00
20260117000100_add_sso_config.sql
feat: Implement user profile management, add multi-language interactive transcripts, and lay groundwork for SSO.
2026-01-17 00:26:42 -03:00
20260117000200_add_course_id_to_assets.sql
feat: Implement course-level asset management and interactive media markers.
2026-01-17 13:55:04 -03:00
20260121000000_add_api_key_to_orgs.sql
feat: Introduce external API endpoints with API key authentication and re-enable Whisper transcription and Ollama summarization.
2026-01-21 16:22:12 -03:00
20260123000000_add_branding_fields.sql
feat: add favicon, logo and Update the platform name (only available to the superuser) and company names
2026-01-23 09:32:36 -03:00
20260215000000_monetization.sql
feat: Update monetary column data types to DOUBLE PRECISION, add IF NOT EXISTS to column additions, and introduce a timestamp trigger function.
2026-02-15 14:43:31 -03:00
20260216000004_content_libraries.sql
feat: introduce content library management for reusable content blocks with dedicated API endpoints and database schema.
2026-02-16 20:45:48 -03:00
20260217000001_advanced_grading.sql
feat: Implement LTI deep linking, live sessions, predictive analytics, and portfolios with associated UI and database migrations.
2026-02-24 09:37:16 -03:00
20260218000001_lesson_dependencies.sql
feat: Implement LTI deep linking, live sessions, predictive analytics, and portfolios with associated UI and database migrations.
2026-02-24 09:37:16 -03:00
20260219000001_course_teams.sql
feat: Implement full-stack course announcements management with cohort segmentation.
2026-02-17 23:11:25 -03:00
20260223000000_add_lesson_preview.sql
feat: Add LTI launch, lesson preview, course progress, bookmarks, and asset management features.
2026-02-23 15:43:45 -03:00
20260223150000_update_assets_table.sql
feat: Add LTI launch, lesson preview, course progress, bookmarks, and asset management features.
2026-02-23 15:43:45 -03:00
20260226000001_add_logo_variant.sql
feat: Implement organization-based SSO login with an AsyncCombobox and add logo variant branding options.
2026-02-26 11:50:34 -03:00
20260303000000_add_video_generation_status.sql
actualizaciones
2026-03-03 17:44:24 -03:00
20260304000000_add_course_marketing.sql
feat: Introduce course marketing features with dedicated metadata, image generation, and UI in both studio and experience apps.
2026-03-04 15:41:34 -03:00
20260304000001_update_course_status_support.sql
feat: Add generation status to courses, implement cancellation, and enhance AI bridge call with retry logic.
2026-03-04 16:55:31 -03:00
20260309000000_cleanup_ai_image_traces.sql
refactor: remove obsolete AI image and video generation traces from courses and lessons.
2026-03-09 10:52:57 -03:00
20260309000001_enforce_single_tenant_org_name.sql
feat: Introduce AI code hinting, enforce single-tenant organization model, and add a Code Lab block component.
2026-03-09 17:24:15 -03:00
20260316000000_test_templates.sql
feat: creacion de plantillas para pruebas, prototipo
2026-03-16 12:28:29 -03:00
20260316000001_question_bank.sql
feat: token count implement
2026-03-17 12:07:56 -03:00
20260316000002_ai_usage_tracking.sql
feat: token count implement
2026-03-17 12:07:56 -03:00
20260318000000_mysql_courses_integration.sql
feat: implementing embedding AI
2026-03-18 17:15:39 -03:00
20260318000001_fix_test_templates_reference.sql
feat: implementing embedding AI
2026-03-18 17:15:39 -03:00
20260319000000_dummy.sql
feat: Fix tokens Revenue stream
2026-03-19 14:54:31 -03:00
20260319000001_ai_usage_add_prompt_response.sql
feat: SAM integration, deployment scripts, and audio response enhancements
2026-03-27 09:20:23 -03:00
20260319000002_pgvector_embeddings.sql
feat: Fix tokens Revenue stream
2026-03-19 14:54:31 -03:00
20260320000002_add_course_language_config.sql
feat: i18n full support, responsive UI, multi-model AI config, and bug fixes
2026-03-23 12:24:22 -03:00
20260323000000_monthly_token_limits.sql
feat: Monthly token limits per user
2026-03-23 16:10:27 -03:00
20260323000001_token_limit_alerts.sql
feat: Token Limit Alerts System (Phase 3)
2026-03-23 17:08:01 -03:00
20260325000000_sam_integration.sql
feat: SAM integration, deployment scripts, and audio response enhancements
2026-03-27 09:20:23 -03:00
20260331000001_fix_schema_drift.sql
feat: Añadir columna organization_id a course_instructors y actualizar migraciones para alinear con el modelo compartido
2026-03-31 13:40:37 -03:00
20260406000010_course_templates.sql
feat(cms/studio): agregar plantillas de curso reutilizables
2026-04-06 15:34:57 -04:00
20260406203000_add_assets_english_level.sql
feat: Implement SAM structure mirroring in PostgreSQL for study plans and courses
2026-04-06 17:04:36 -04:00
20260406212000_add_assets_sam_structure.sql
feat: Implement SAM structure mirroring in PostgreSQL for study plans and courses
2026-04-06 17:04:36 -04:00
20260406214000_create_sam_mirror_tables.sql
feat: Implement SAM structure mirroring in PostgreSQL for study plans and courses
2026-04-06 17:04:36 -04:00
20260407000000_add_unit_asset_link.sql
feat: enhance asset import functionality and unit tracking
2026-04-07 13:38:22 -04:00
20260413000001_organization_exercise_settings.sql
feat: add organization exercise settings management
2026-04-13 16:55:09 -04:00
20260414000001_add_certificate_toggle.sql
feat: add organization-level certificate toggle and update tower-governor imports
2026-04-14 13:58:58 -04:00
20260414000002_organization_email_settings.sql
feat: add email settings management
2026-04-15 09:33:50 -04:00
20260414000003_organization_email_services.sql
feat: add email settings management
2026-04-15 09:33:50 -04:00
20260415000001_organization_email_templates.sql
feat: add organization email templates management
2026-04-15 10:26:44 -04:00
20260417000001_background_tasks_zip_rag.sql
feat: Implement ZIP RAG import functionality with background processing
2026-04-17 12:51:50 -04:00
20260421000001_add_assets_zip_batch_metadata.sql
feat: agregar historial de importación de ZIP y metadatos a los activos
2026-04-21 11:43:09 -04:00
20260427000000_add_external_sam_id_to_courses.sql
feat: add external SAM ID support to courses and update API documentation
2026-04-27 18:01:31 -04:00
20260427000001_lesson_collaborative_canvas.sql
feat: add PluginBlock component for rendering external web components in sandboxed iframes
2026-04-27 12:22:05 -04:00
20260427000002_lesson_collaborative_canvas_revision.sql
feat: add PluginBlock component for rendering external web components in sandboxed iframes
2026-04-27 12:22:05 -04:00
20260427000003_org_plugins.sql
feat: add PluginBlock component for rendering external web components in sandboxed iframes
2026-04-27 12:22:05 -04:00
20260427000004_lti_tool_consumer.sql
feat: add LTI 1.3 Tool Consumer support with database migrations and API endpoints
2026-04-27 12:51:13 -04:00
20260427000005_study_rooms.sql
feat: add study rooms feature with BigBlueButton integration
2026-04-27 14:04:06 -04:00
20260427000006_lti_ags.sql
feat: implement AGS support with OAuth2 token management and score passback functionality
2026-04-27 14:22:09 -04:00
20260427000007_collaborative_docs.sql
feat: add collaborative document functionality for lessons
2026-04-27 14:47:41 -04:00