File: schema.mysql

package info (click to toggle)
request-tracker5 5.0.7%2Bdfsg-4
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 80,216 kB
  • sloc: javascript: 191,898; perl: 87,146; sh: 1,412; makefile: 487; python: 37; php: 15
file content (10 lines) | stat: -rw-r--r-- 286 bytes parent folder | download | duplicates (10) 
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)
);