# Firefish SQL Snippets

## Introduction:

A selection of SQL scripts for the Firefish PostgreSQL database

Some of the SQL scripts need the "userId"

This can be found from the Iceshrimp Homepage:

* Profile | 3 little round buttons | About | ID

(The ID is the 10 digit alphanumeric string)

## Files:

* ### [SELECT_my_notes.sql]

	Links the 'note' and 'user' tables to show a chosen users notes (toots, tweets, whatever you want to call them)

* ### [SELECT_my_notes_and_user_info.sql]

	Brings **ALL** the fields back from the joined 'note' and 'user' tables

* ### [SELECT_notes_over_90_days.sql]

	Shows all of the 'notes' over 90 days old (date limit can be changed to suit)

* ### [UPDATE_announcement.sql]

	Udate an existing announcement (in case of spelling errors etc.)