BPII - LAB 8

CREATE DATABASE Test

USE Test

CREATE TABLE Kupci
(
    KupacID int PRIMARY KEY IDENTITY (1,1),
    Ime nvarchar (50),
    Prezime nvarchar (50),
    Adress nvarchar (100)
)

-- kreiranje tabele audit
CREATE TABLE KupciAudit
(
    AuditID int PRIMARY KEY IDENTITY (1,1),
    KupacID int,
    Ime nvarchar (50),
    Prezime nvarchar (50),
    Adress nvarchar (100),
    Komanda nvarchar (10),
    Korisnik nvarchar (50),
    Datum datetime
);

CREATE TRIGGER tr_Kupci_Insert
ON Kupci AFTER INSERT AS
    INSERT INTO KupciAudit
    (KupacID, Ime, Prezime, Adress, Komanda, Korisnik, Datum)
    SELECT i.KupacID,
            i.Ime,
            i.Prezime,
            i.Adress,
            'INSERT',
            SYSTEM_USER,
            GETDATE()
    FROM inserted AS i

INSERT INTO Kupci (Ime, Prezime, Adress) VALUES ('Sara', 'Sahinpasic', 'FIT')
INSERT INTO Kupci (Ime, Prezime, Adress) VALUES ('Jasmin', 'Kreho', 'ETF')

SELECT * FROM Kupci
SELECT * FROM KupciAudit


-- AFTER UPDATE TRIGGER