1CREATE TABLE IF NOT EXISTS lfs_objects (
 2  id INTEGER PRIMARY KEY AUTOINCREMENT,
 3  oid TEXT NOT NULL,
 4  size INTEGER NOT NULL,
 5  repo_id INTEGER NOT NULL,
 6  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 7  updated_at DATETIME NOT NULL,
 8  UNIQUE (oid, repo_id),
 9  CONSTRAINT repo_id_fk
10  FOREIGN KEY(repo_id) REFERENCES repos(id)
11  ON DELETE CASCADE
12  ON UPDATE CASCADE
13);
14
15CREATE TABLE IF NOT EXISTS lfs_locks (
16  id INTEGER PRIMARY KEY AUTOINCREMENT,
17  repo_id INTEGER NOT NULL,
18  user_id INTEGER NOT NULL,
19  path TEXT NOT NULL,
20  refname TEXT,
21  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
22  updated_at DATETIME NOT NULL,
23  UNIQUE (repo_id, path),
24  CONSTRAINT repo_id_fk
25  FOREIGN KEY(repo_id) REFERENCES repos(id)
26  ON DELETE CASCADE
27  ON UPDATE CASCADE,
28  CONSTRAINT user_id_fk
29  FOREIGN KEY(user_id) REFERENCES users(id)
30  ON DELETE CASCADE
31  ON UPDATE CASCADE
32);