Devart Forums

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 

Code: Select all

Code: Select all