002-add-token-bucket.sql 1004 B

1234567891011121314151617181920212223242526272829
  1. BEGIN TRANSACTION;
  2. -- Add user-relative bucket
  3. ALTER TABLE "users" ADD COLUMN "bucket_tokens" INTEGER NOT NULL DEFAULT 0;
  4. ALTER TABLE "users" ADD COLUMN "bucket_last_update" INTEGER NOT NULL DEFAULT 0;
  5. -- Remove "DEFAULT 0" from user-relative bucket
  6. CREATE TABLE "users_temp" (
  7. "id" INTEGER NOT NULL UNIQUE,
  8. "username" TEXT NOT NULL UNIQUE,
  9. "password" TEXT NOT NULL,
  10. "registration_date" TEXT NOT NULL,
  11. "bucket_tokens" INTEGER NOT NULL,
  12. "bucket_last_update" INTEGER NOT NULL,
  13. PRIMARY KEY("id" AUTOINCREMENT)
  14. );
  15. INSERT INTO "users_temp" SELECT "id","username","password","registration_date","bucket_tokens","bucket_last_update" FROM "users";
  16. DROP TABLE "users";
  17. ALTER TABLE "users_temp" RENAME TO "users";
  18. -- Add instance-wide bucket
  19. CREATE TABLE IF NOT EXISTS "params" (
  20. "name" TEXT NOT NULL UNIQUE,
  21. "value" TEXT NOT NULL
  22. );
  23. INSERT INTO "params"("name", "value") VALUES("instance_bucket_tokens", "0");
  24. INSERT INTO "params"("name", "value") VALUES("instance_bucket_last_update", "0");
  25. COMMIT;