File: schema.mysql

package info (click to toggle)
request-tracker4 4.4.3-2%2Bdeb10u2
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 43,364 kB
  • sloc: perl: 61,929; javascript: 22,938; sh: 1,084; makefile: 467; php: 15
file content (10 lines) | stat: -rw-r--r-- 286 bytes parent folder | download | duplicates (11) 
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)
);