File: schema.mysql

package info (click to toggle)
request-tracker4 4.4.6%2Bdfsg-1.1%2Bdeb12u3
  • links: PTS, VCS
  • area: main
  • in suites: bookworm-proposed-updates
  • size: 63,472 kB
  • sloc: javascript: 130,444; perl: 65,299; sh: 1,322; makefile: 471; python: 37; php: 30
file content (10 lines) | stat: -rw-r--r-- 286 bytes parent folder | download | duplicates (13) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE IncrementalRecords (
  id         INTEGER NOT NULL AUTO_INCREMENT,
  ObjectType VARCHAR(50) NOT NULL,
  ObjectId   INTEGER NOT NULL,
  UpdateType TINYINT NOT NULL,
  AlteredAt  TIMESTAMP NOT NULL,
  PRIMARY KEY(ObjectType, ObjectId),
  UNIQUE KEY(id),
  KEY(UpdateType)
);