The filesharing service everyone either hates or loves
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
QuadFile/statsschema.sql

37 lines
1022 B

-- noinspection SqlNoDataSourceInspectionForFile
drop table if exists qrscan;
create table qrscan (
time int,
ip text
);
drop table if exists stats;
create table stats (
variable text UNIQUE primary key,
value int
);
drop table if exists total_filetype;
create table total_filetype (
filetype text UNIQUE primary key,
uploads int DEFAULT 0,
views int DEFAULT 0,
total_size int
);
-- Prepopulate with needed stats
INSERT INTO stats VALUES ('urldeletions', 0);
INSERT INTO stats VALUES ('timedeletions', 0);
INSERT INTO stats VALUES ('aboutviews', 0);
INSERT INTO stats VALUES ('faqviews', 0);
INSERT INTO stats VALUES ('servicesviews', 0);
INSERT INTO stats VALUES ('welcomeviews', 0);
INSERT INTO stats VALUES ('dmcaviews', 0);
INSERT INTO stats VALUES ('czb', 0);
INSERT INTO stats VALUES ('invaliddeletionkey', 0);
INSERT INTO stats VALUES ('403', 0);
INSERT INTO stats VALUES ('404', 0);
INSERT INTO stats VALUES ('413', 0);
INSERT INTO stats VALUES ('418', 0);
INSERT INTO stats VALUES ('500', 0);