1ALTER TABLE repos RENAME TO repos_old;
 2
 3CREATE TABLE repos (
 4  id INTEGER PRIMARY KEY AUTOINCREMENT,
 5  name TEXT NOT NULL UNIQUE,
 6  project_name TEXT NOT NULL,
 7  description TEXT NOT NULL,
 8  private BOOLEAN NOT NULL,
 9  mirror BOOLEAN NOT NULL,
10  hidden BOOLEAN NOT NULL,
11  user_id INTEGER NOT NULL,
12  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
13  updated_at DATETIME NOT NULL,
14  CONSTRAINT user_id_fk
15  FOREIGN KEY(user_id) REFERENCES users(id)
16  ON DELETE CASCADE
17  ON UPDATE CASCADE
18);
19
20INSERT INTO repos (id, name, project_name, description, private, mirror, hidden, user_id, created_at, updated_at)
21SELECT id, name, project_name, description, private, mirror, hidden, (
22  SELECT id FROM users WHERE admin = true ORDER BY id LIMIT 1
23), created_at, updated_at
24FROM repos_old;
25