remove duplicate but different instance of FUNCTION public.ports_categories_set() RETURNS trigger

Adjust column aligment for better reading

Adjust column aligment for better reading

mv updates-2024-06-21.txt updates-2024-06-22.README.txt

Move users.cookie to a new table: user_cookie

This allows multiple logins for different sessions, say
from your desktop and from your laptop.

re: https://github.com/FreshPorts/freshports/issues/574

for package_notifications table, use package_notifications_abi_set_port_idx CONSTRAINT

Pulled in all the changes from the DB via PGAdmin 8.4

GRANT INSERT                 ON packages_last_checked TO abi_maintenance

first draft of triggers for package_notifications table

add update to abi_maintenance

For PackagesLastCheckedSetRepoDate(), indicate an update is required only if a_RepoDate
is not null. If it is null, there is no such repo and it cannot be imported.

See: https://news.freshports.org/2023/12/31/no-repos-need-importing-how-did-this-happen-this-should-never-happen/

Add more comments

Add new function: DoneProcessingCommit()

It is not invoked anywhere - I suspect that would
be somewhere inside the commit inserting/adding
code.

Remove unneeded declarations and notices.

Remove latest_link, no longer used.

When creating a port on a branch, use the ports table, not the ports_active
view to get the element_id. It won't be there because ports_active is now
head only.

re: https://github.com/FreshPorts/freshports/issues/413
    https://github.com/FreshPorts/freshports/issues/407

Add test_depends to views.

make both ports_all and ports_active head-specific.

We shall see if this works out OK

re: https://github.com/FreshPorts/freshports/issues/407
    https://github.com/FreshPorts/freshports/issues/406

When clearing cache for a port, consider all categories

re https://github.com/FreshPorts/freshports/issues/373

A port  has a primary category. e.g. x11/bemenu

However, this port is also listed in the wayland category,
which is a virtual category. This is known as a secondary
category. Secondary categories are  always vritual.

You can't browse to wayland/bemenu - but you can see bemenu
listed at https://www.freshports.org/wayland/

Therefore, we must flush that page from cache when that port
is updated.

The solution: insert both of these pairs into the cache_clearing_ports
table:

* x11,bemenu
* wayland,bemenu

The fp-listen daemon, which runs on the webserver nodes, will always clear
the category page in addition to  the port page.

It will also clear the now non-existent wayland/bemenu page - no harm done
there. Should the display of a port on a virtual page be implemented one
day, this solution will properly clear that cache too.

Fix a trigger optimization which avoided updating the table if the values
did not change.

re: https://news.freshports.org/2022/08/19/missing-ports_categories-entries/

don't tell me about required modifying the the parent % from a file to directory

better comment

Make sure the branch is in public.freshports_commit_record - fixes https://github.com/FreshPorts/freshports/issues/327

silence some entries.

return multiple records when searching for elements

add author and committer name and email

commiter -> committer

better suggestion from Magnus

This is the first attempt at converting expression which one ran on a single column
into one which runs on rows.

Previously, it ran on array_to_json(regexp_match(ports.pkg_plist, 'lib/[[:alpha:]]*?\.so'))

But now those values are speard across several rows in the generate_plist
table.

This first attempt is wrong.

Comment out some NOTICE and WARNINGS

use CREATE OR REPLACE FUNCTION instead of CREATE FUNCTION

ZTHEN -> THEN

Remove trailing ;

Add in the changes from the subversion branch.

Add stuff for updating the database for use by git

Attempt to being in updates for git which were not on this branch

spaces onlyi

svn_hostname => repo_hostname

Branch for git

Let's do nice SQL

Add missing element_pathname which takes a boolean for leading /

remove anchor_clid and replace it with latest_commits_anchor and latest_commits_ports_anchor

remove duplicate GetPortID

WatchListStagingClear now takes and returns int8
and also renamed WatchListID to UserID to reflect new strategy

WatchListStagingLogClearing now takes int8

ports_categories_set is moved to ri.txt as it becomes a trigger

Add the rules for commit_log_ports which keep it populated with new commits.
We still have to write the rules to clear out this table from time to time.

better logging

whitespace only

Add GetPortID

use TRIGGER not OPAQUE
convert some stuff to upper case

add trigger on categories for virtual categories

This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.