CREATE TRIGGER "main"."after_update_roomkey" AFTER UPDATE ON "ROOMKEY"
BEGIN
if (roomID=new.roomID)
update room set status='Available' where roomID=new.roomID;
else(roomID=old.roomID)
update room set status='Non Available' where roomID=new.roomID;
END
CREATE TABLE ROOM (
roomID VARCHAR(10) PRIMARY KEY,
numOfBed INTEGER,
roomFloor VARCHAR(5),
status VARCHAR(20),
categoryID VARCHAR(10),
FOREIGN KEY (categoryID) REFERENCES ROOMCATEGORY(categoryID)
)
CREATE TABLE "ROOMCATEGORY"
("categoryID" VARCHAR(10) PRIMARY KEY NOT NULL ,
"typesOfRoom" VARCHAR(50) NOT NULL DEFAULT (null) ,
"price" DOUBLE(10,2) NOT NULL )
I'm no expert in sqlite. Please help me solve this sqlite trigger in IF ELS statement.
Aucun commentaire:
Enregistrer un commentaire