mirror of
https://github.com/ajayyy/SponsorBlockServer.git
synced 2024-09-19 20:51:19 +02:00
14 lines
No EOL
312 B
SQL
14 lines
No EOL
312 B
SQL
BEGIN TRANSACTION;
|
|
|
|
CREATE TABLE IF NOT EXISTS "ratings" (
|
|
"videoID" TEXT NOT NULL,
|
|
"service" TEXT NOT NULL default 'YouTube',
|
|
"type" INTEGER NOT NULL,
|
|
"userID" TEXT NOT NULL,
|
|
"timeSubmitted" INTEGER NOT NULL,
|
|
"hashedIP" TEXT NOT NULL
|
|
);
|
|
|
|
UPDATE "config" SET value = 4 WHERE key = 'version';
|
|
|
|
COMMIT; |