summaryrefslogtreecommitdiff
path: root/tools/sql-migrate-20050402.sql
blob: eea94358cac41b75faf1c8813ea20e4bec95037e (plain)
1
2
3
4
5
6
7
8
9
10
CREATE TABLE timestamps (
   name TEXT PRIMARY KEY,
   value TIMESTAMP
);
INSERT INTO timestamps(name, value) VALUES('http','1970-01-01');
INSERT INTO timestamps(name, value) VALUES('ftp','1970-01-01');

ALTER TABLE release_files ADD COLUMN downloads INTEGER;
ALTER TABLE release_files ALTER downloads SET DEFAULT 0;