| Server IP : 85.214.239.14 / Your IP : 3.17.174.204 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/2/cwd/proc/2/root/proc/2/cwd/proc/3/root/usr/share/doc/spamassassin/sql/ |
Upload File : |
CREATE TABLE txrep ( username varchar(100) NOT NULL default '', email varchar(255) NOT NULL default '', ip varchar(40) NOT NULL default '', msgcount bigint NOT NULL default '0', totscore float NOT NULL default '0', signedby varchar(255) NOT NULL default '', last_hit timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (username,email,signedby,ip) ); create index txrep_last_hit on txrep (last_hit); create OR REPLACE function update_txrep_last_hit() RETURNS TRIGGER AS $$ BEGIN NEW.last_hit = CURRENT_TIMESTAMP; RETURN NEW; END; $$ language 'plpgsql'; create TRIGGER update_txrep_update_last_hit BEFORE UPDATE ON txrep FOR EACH ROW EXECUTE PROCEDURE update_txrep_last_hit(); ALTER TABLE txrep SET (fillfactor=95);