Devart Forums

Code: Select all

CREATE TABLE [barang] (
  [kodebrg] VARCHAR(15) NOT NULL ON CONFLICT ABORT, 
  [barcode] VARCHAR(25) DEFAULT 0, 
  [namabrg] VARCHAR(55), 
  [satuan] VARCHAR(10) DEFAULT Pcs, 
  [jenis] VARCHAR(20), 
  [harga] INT DEFAULT 0, 
  [stokmin] INT DEFAULT 1, 
  [stokawal] INT DEFAULT 0, 
  [stokakhir] INT DEFAULT 0, 
  [expired] DATE NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  [ket] TEXT, 
  CONSTRAINT [sqlite_autoindex_barang_1] PRIMARY KEY ([kodebrg]) ON CONFLICT ABORT);

CREATE TABLE [masukdetail] (
  [kodebrg] VARCHAR(15) CONSTRAINT [FKbarang] REFERENCES [barang]([kodebrg]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [expire] DATE, 
  [qty] INTEGER, 
  [retur] INTEGER, 
  [total] INTEGER);

CREATE TRIGGER [TG_STOKMASUK]
AFTER INSERT
ON [masukdetail]
FOR EACH ROW
BEGIN
UPDATE barang SET stokakhir=stokakhir+NEW.qty, expired=NEW.expire
WHERE kodebrg=NEW.kodebrg;
END;