mirror of
https://github.com/Memo-2023/mana-monorepo.git
synced 2026-05-15 21:19:40 +02:00
61d181fbc2
Move inactive projects out of active workspace: - bauntown (community website) - maerchenzauber (AI story generation) - memoro (voice memo app) - news (news aggregation) - nutriphi (nutrition tracking) - reader (reading app) - uload (URL shortener) - wisekeep (AI wisdom extraction) Update CLAUDE.md documentation: - Add presi to active projects - Document archived projects section - Update workspace configuration Archived apps can be re-activated by moving back to apps/ 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
21 lines
647 B
SQL
21 lines
647 B
SQL
-- Check if trigger exists
|
|
SELECT
|
|
trigger_name,
|
|
event_manipulation,
|
|
event_object_table,
|
|
action_statement
|
|
FROM information_schema.triggers
|
|
WHERE trigger_name = 'feedback_vote_count_trigger';
|
|
|
|
-- Check current vote count and actual vote records for the problematic feedback
|
|
SELECT
|
|
uf.id,
|
|
uf.title,
|
|
uf.vote_count,
|
|
uf.upvote_count,
|
|
(SELECT COUNT(*) FROM feedback_votes WHERE feedback_id = uf.id) as actual_votes
|
|
FROM user_feedback uf
|
|
WHERE uf.id = '7367caac-b773-4947-b1fd-a5495c123be7';
|
|
|
|
-- Check all votes for this feedback
|
|
SELECT * FROM feedback_votes WHERE feedback_id = '7367caac-b773-4947-b1fd-a5495c123be7';
|