BEFORE WORKING ON FEATURE:
- git pull
- refer to queries.sql
- test query using foo.sql and foo.sh
- add to queries.sql
- add method to Messenger.java
- add method call to user interface
- test with compile.sh
AFTER WORKING ON FEATURE:
- git pull
- git add .
- git commit -m "complete FEATURE description goes here"
- git push
TODO:
basic functionality
user account deletion - CASCADE DELETES ( should this delete all sent as well? or just delete usr from table and contact lists)
browse contact list / block list
add/delete users from contact/block list
browse list of chats
start new chat (select initial chat members) - private or group chat, chronological order - index
chat owner
- delete chat
- remove chat members
- add chat members
list chat messages
- last 10 messages, index by timestamp
- load earlier messages, batches of 10
chat member
- list chat messages ( load in batches of 10) index by timestamp
- create new message
- delete old message
chat message
- diplay author, creation date, text
implement block list functionality (use triggers or integrity constraints)
indexes.sql
GUI
triggers