Files
archived-web-pecl/sql/downloads.sql
Peter Kokot 21e1b29108 Sync tabs and spaces
This patch syncs and converts all files to include spaces for indentation
except for Makefile. Prior to this patch there were mixed tabs and
spaces in most files.
2018-10-30 02:30:07 +01:00

16 lines
591 B
SQL

CREATE TABLE downloads (
id INTEGER NOT NULL,
file INTEGER NOT NULL, -- REFERENCES files(id),
package INTEGER NOT NULL, -- REFERENCES packages(id),
release INTEGER NOT NULL, -- REFERENCES releases(id),
author INTEGER NOT NULL, -- REFERENCES users(id),
category INTEGER NOT NULL, -- REFERENCES categories(id),
dl_when DATETIME NOT NULL,
dl_who VARCHAR(20),
dl_host VARCHAR(100),
PRIMARY KEY(id),
KEY package (package),
KEY release (release)
);