Code: Select all
CREATE TABLE IF NOT EXISTS SST_Probleme (
Id INTEGER PRIMARY KEY AUTO_INCREMENT,
ProjektId INTEGER NOT NULL,
LfdNr INTEGER NOT NULL,
EFL INTEGER NOT NULL,
Beschreibung VARCHAR(4000) NULL,
Bemerkung VARCHAR(4000) NULL,
Erfasst DATETIME NOT NULL,
SETeam VARCHAR(20 ) NULL,
Timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
CONSTRAINT UNIQUE KEY keyProjektIdLfdNr (ProjektId,LfdNr),
CONSTRAINT UNIQUE KEY keyProjektIdEFL (ProjektId,EFL),
FOREIGN KEY(ProjektId) REFERENCES Anlaufmanagement.SST_Projekte(Id) ON DELETE CASCADE)
Code: Select all
5 Query BEGIN
5 Query update anlaufmanagement.sst_probleme
set SETeam = 'HAllo'
where ((Id = 1) and (`Timestamp` = '2011-01-24 14:47:14'))
;select `Timestamp`
from anlaufmanagement.sst_probleme
where Id = p1
5 Query ROLLBACK
SSDL:
Code: Select all
Best regards
Heiko Denk