#
# ChangeLog for petify-backend/sql/ddl.sql
#
# Generated by Trac 1.6
# 05/05/26 18:11:04

Tue, 05 May 2026 09:05:51 GMT veronika-ils <ilioskaveronika@…> [92e7c7a]
	* .gitignore (added)
	* petify-backend/.gitattributes (added)
	* petify-backend/.gitignore (added)
	* petify-backend/.mvn/wrapper/maven-wrapper.properties (added)
	* petify-backend/README.md (added)
	* petify-backend/docker-compose.yml (added)
	* petify-backend/mvnw (added)
	* petify-backend/mvnw.cmd (added)
	* petify-backend/pom.xml (added)
	* petify-backend/sql/ddl.sql (added)
	* petify-backend/sql/dml.sql (added)
	* petify-backend/src/main/java/com/petify/petify/PetifyApplication.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/AdminClinicApplicationsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/AnalyticsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/AppointmentsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/AuthController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/FavoritesController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/HealthRecordController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/ListingsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/NotificationsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/PetController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/PublicListingsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/RecommendationController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/ReviewController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/UserManagementController.java (added)
	* petify-backend/src/main/java/com/petify/petify/api/VetClinicsController.java (added)
	* petify-backend/src/main/java/com/petify/petify/config/SecurityConfig.java (added)
	* petify-backend/src/main/java/com/petify/petify/config/WebConfig.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Admin.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Appointment.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Client.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/ClinicReview.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/ClinicUnavailableSlot.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/FavoriteListing.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/FavoriteListingId.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/HealthRecord.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Listing.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Notification.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Owner.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Pet.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/Review.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/User.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/UserReview.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/UserType.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/VetClinic.java (added)
	* petify-backend/src/main/java/com/petify/petify/domain/VetClinicApplication.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/AdminListingsPageDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/AnimalResponseDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/AppointmentDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/AppointmentSlotDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/AuthResponse.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/ClinicAppointmentDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/ClinicUnavailableSlotDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreateAppointmentRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreateHealthRecordRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreateListingRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreatePetRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreateReviewRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/CreateUnavailableSlotRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/HealthRecordDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/ListingDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/LoginRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/NotificationDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/OwnerAppointmentDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/RecommendedListingProjection.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/ReviewDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/SignUpRequest.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/UserActivityRankingProjection.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/UserDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/VetClinicApplicationDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/dto/VetClinicDTO.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/AdminRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/AnalyticsRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/AppointmentRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/ClientRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/ClinicReviewRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/ClinicUnavailableSlotRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/FavoriteListingRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/HealthRecordContextView.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/HealthRecordRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/ListingRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/NotificationRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/OwnerRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/PetRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/PublicListingCardView.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/PublicListingRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/RecommendationRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/ReviewRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/UserRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/UserReviewRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/VetClinicApplicationRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/repo/VetClinicRepository.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/AnalyticsService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/AppointmentService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/AuthService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/FavoritesService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/HealthRecordService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/ListingService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/MaintenanceScheduler.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/PetService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/RecommendationService.java (added)
	* petify-backend/src/main/java/com/petify/petify/service/ReviewService.java (added)
	* petify-backend/src/main/resources/application-local.properties (added)
	* petify-backend/src/main/resources/application-remote.properties (added)
	* petify-backend/src/main/resources/application.properties (added)
	* petify-backend/src/main/resources/db/migration/R__appointments_rules_and_views.sql (added)
	* petify-backend/src/main/resources/db/migration/R__health_records_rules_and_views.sql (added)
	* petify-backend/src/main/resources/db/migration/R__listing_rules_and_view.sql (added)
	* petify-backend/src/main/resources/db/migration/R__reviews_rules_and_views.sql (added)
	* petify-backend/src/main/resources/db/migration/R__scheduled_jobs_and_maintenance_views.sql (added)
	* petify-backend/src/main/resources/db/migration/V10__Link_clinics_to_users.sql (added)
	* petify-backend/src/main/resources/db/migration/V1__Initial_schema.sql (added)
	* petify-backend/src/main/resources/db/migration/V2__Insert_initial_data.sql (added)
	* petify-backend/src/main/resources/db/migration/V3__create_get_top_active_users_function.sql (added)
	* petify-backend/src/main/resources/db/migration/V4__create_recommend_similar_listings_function.sql (added)
	* petify-backend/src/main/resources/db/migration/V5__create_rating_domain.sql (added)
	* petify-backend/src/main/resources/db/migration/V7__Move_vet_clinic_application_relationship.sql (added)
	* petify-backend/src/main/resources/db/migration/V8__Insert_more_vet_clinics_and_applications.sql (added)
	* petify-backend/src/main/resources/db/migration/V9__Create_clinic_unavailable_slots.sql (added)
	* petify-backend/src/test/java/com/petify/petify/PetifyApplicationTests.java (added)
	* petify-frontend/.editorconfig (added)
	* petify-frontend/.gitattributes (added)
	* petify-frontend/.gitignore (added)
	* petify-frontend/.prettierrc.json (added)
	* petify-frontend/.vscode/extensions.json (added)
	* petify-frontend/README.md (added)
	* petify-frontend/env.d.ts (added)
	* petify-frontend/eslint.config.ts (added)
	* petify-frontend/index.html (added)
	* petify-frontend/package-lock.json (added)
	* petify-frontend/package.json (added)
	* petify-frontend/public/favicon.ico (added)
	* petify-frontend/src/App.vue (added)
	* petify-frontend/src/api/admin.ts (added)
	* petify-frontend/src/api/auth.ts (added)
	* petify-frontend/src/api/favorites.ts (added)
	* petify-frontend/src/api/listings.ts (added)
	* petify-frontend/src/api/profile.ts (added)
	* petify-frontend/src/api/reviews.ts (added)
	* petify-frontend/src/components/ListingCard.vue (added)
	* petify-frontend/src/components/OwnerAppointmentsCalendar.vue (added)
	* petify-frontend/src/components/TopNav.vue (added)
	* petify-frontend/src/data/mockListings.ts (added)
	* petify-frontend/src/img/all_outline.png (added)
	* petify-frontend/src/img/bird_outline.png (added)
	* petify-frontend/src/img/bullseye.png (added)
	* petify-frontend/src/img/cat_outline.png (added)
	* petify-frontend/src/img/dog_outline.png (added)
	* petify-frontend/src/img/logo.png (added)
	* petify-frontend/src/img/star.png (added)
	* petify-frontend/src/img/trashcan.png (added)
	* petify-frontend/src/main.ts (added)
	* petify-frontend/src/router/index.ts (added)
	* petify-frontend/src/stores/auth.ts (added)
	* petify-frontend/src/stores/counter.ts (added)
	* petify-frontend/src/styles/theme.css (added)
	* petify-frontend/src/types/listing.ts (added)
	* petify-frontend/src/views/AdminClientsView.vue (added)
	* petify-frontend/src/views/AdminListingsView.vue (added)
	* petify-frontend/src/views/AdminModerationView.vue (added)
	* petify-frontend/src/views/ClinicDashboardView.vue (added)
	* petify-frontend/src/views/ListingDetailsView.vue (added)
	* petify-frontend/src/views/ListingsView.vue (added)
	* petify-frontend/src/views/LoginView.vue (added)
	* petify-frontend/src/views/OwnerProfileView.vue (added)
	* petify-frontend/src/views/ProfileView.vue (added)
	* petify-frontend/src/views/SignupView.vue (added)
	* petify-frontend/tsconfig.app.json (added)
	* petify-frontend/tsconfig.json (added)
	* petify-frontend/tsconfig.node.json (added)
	* petify-frontend/vite.config.ts (added)

	Petify fullstack project


