Index: README.md =================================================================== --- README.md (revision 22367dbd434339cbf017e24df5eff637dc3738f9) +++ README.md (revision 41d3f60370077ca99cfecfaf1b8e6b74ea364357) @@ -8,4 +8,10 @@ POSTGRES_PASSWORD="postgres" POSTGRES_DB="postgres" + GOOGLE_EMAIL="YOUR_GOOGLE_EMAIL" + GOOGLE_APP_PASSWORD="YOUR_GOOGLE_APP_PASSWORD" + GOOGLE_CLIENT_ID=YOUR_GOOGLE_CLIENT_ID_OAUTH2 + GOOGLE_CLIENT_SECRET=YOUR_GOOGLE_CLIENT_SECRET_OAUTH2 + NEXT_SECRET="S0s2l3jzcxVw93sS0s2l3j" + NEXTAUTH_URL="http://localhost:3000/api/auth/" @@ -23,6 +29,6 @@ Open another console and run: - docker exec -it name_of_db_container /bin/bash - psql -U postgres postgres `<` /usr/local/app/dummy_database.sql + docker exec -it NAME_OF_DATABASE_CONTAINER /bin/bash + psql -U postgres postgres `<` /usr/local/app/caessino.sql -- Note: When inserting `<`, it should not be surrounded by quotation marks Index: caessino.sql =================================================================== --- caessino.sql (revision 41d3f60370077ca99cfecfaf1b8e6b74ea364357) +++ caessino.sql (revision 41d3f60370077ca99cfecfaf1b8e6b74ea364357) @@ -0,0 +1,207 @@ +DROP TABLE IF EXISTS "public"."admins"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS admins_id_seq; + +-- Table Definition +CREATE TABLE "public"."admins" ( + "id" int4 NOT NULL DEFAULT nextval('admins_id_seq'::regclass), + "username" text, + "password" text, + "salt" text +); + +DROP TABLE IF EXISTS "public"."blackjack"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Table Definition +CREATE TABLE "public"."blackjack" ( + "data" text, + "identifier" text DEFAULT 'blackjack_data'::text +); + +DROP TABLE IF EXISTS "public"."blackjack_history"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS blackjack_history_id_seq; + +-- Table Definition +CREATE TABLE "public"."blackjack_history" ( + "id" int4 NOT NULL DEFAULT nextval('blackjack_history_id_seq'::regclass), + "username" text, + "history" text +); + +DROP TABLE IF EXISTS "public"."complaints"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS complaints_id_seq; + +-- Table Definition +CREATE TABLE "public"."complaints" ( + "id" int4 NOT NULL DEFAULT nextval('complaints_id_seq'::regclass), + "date" text, + "by" text, + "description" text, + "answered" text, + "answer" text +); + +DROP TABLE IF EXISTS "public"."credit_cards"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS credit_cards_id_seq; + +-- Table Definition +CREATE TABLE "public"."credit_cards" ( + "id" int4 NOT NULL DEFAULT nextval('credit_cards_id_seq'::regclass), + "username" text, + "card_hash" text, + "card_salt" text +); + +DROP TABLE IF EXISTS "public"."players"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS players_id_seq; + +-- Table Definition +CREATE TABLE "public"."players" ( + "id" int4 NOT NULL DEFAULT nextval('players_id_seq'::regclass), + "username" text NOT NULL, + "display_name" text NOT NULL, + "credits" float8 +); + +DROP TABLE IF EXISTS "public"."poker"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Table Definition +CREATE TABLE "public"."poker" ( + "data" text, + "identifier" text DEFAULT 'poker_data'::text +); + +DROP TABLE IF EXISTS "public"."poker_history"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS poker_history_id_seq; + +-- Table Definition +CREATE TABLE "public"."poker_history" ( + "id" int4 NOT NULL DEFAULT nextval('poker_history_id_seq'::regclass), + "username" text, + "history" text +); + +DROP TABLE IF EXISTS "public"."roulette"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Table Definition +CREATE TABLE "public"."roulette" ( + "data" text, + "identifier" text DEFAULT 'roulette_data'::text +); + +DROP TABLE IF EXISTS "public"."roulette_history"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS roulette_history_id_seq; + +-- Table Definition +CREATE TABLE "public"."roulette_history" ( + "id" int4 NOT NULL DEFAULT nextval('roulette_history_id_seq'::regclass), + "username" text, + "history" text +); + +DROP TABLE IF EXISTS "public"."sessions"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Table Definition +CREATE TABLE "public"."sessions" ( + "data" text, + "identifier" text DEFAULT 'sessions_data'::text +); + +DROP TABLE IF EXISTS "public"."stats"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS stats_id_seq; + +-- Table Definition +CREATE TABLE "public"."stats" ( + "id" int4 NOT NULL DEFAULT nextval('stats_id_seq'::regclass), + "username" text NOT NULL, + "blackjack_games" int8, + "roulette_games" int8, + "poker_games" int8, + "blackjack_won_games" int8, + "roulette_won_games" int8, + "poker_won_games" int8, + "money_bet" int8, + "money_earned" int8 +); + +DROP TABLE IF EXISTS "public"."users"; +-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup. + +-- Sequence and defined type +CREATE SEQUENCE IF NOT EXISTS users_id_seq; + +-- Table Definition +CREATE TABLE "public"."users" ( + "id" int4 NOT NULL DEFAULT nextval('users_id_seq'::regclass), + "username" text NOT NULL, + "password" text NOT NULL, + "salt" text NOT NULL, + "email" text NOT NULL, + "email_activation_id" text NOT NULL, + "activated" text NOT NULL +); + +INSERT INTO "public"."admins" ("id", "username", "password", "salt") VALUES +(1, 'admin', 'c7258f1d118136a210cbd591a5bf03236226d34e6567bdf4ccc780dcd96a722c4a21b3433eb282220d8d4172d99c2ad6a7c7be1d2ab3b20e090cf8d3c799d578', 'fd67bce156239de46b59f05aaed57435'); + + +INSERT INTO "public"."blackjack" ("data", "identifier") VALUES +('[]', 'blackjack_data'); + + + + +INSERT INTO "public"."complaints" ("id", "date", "by", "description", "answered", "answer") VALUES +(1, '2022-07-13T19:22:46.631+02:00', 'simon', 'I have a problem with logging in. It says my name is already taken.', 'true', 'Unfortunately, that means that someone else has already registered with that username before you. Please choose a different a username.'); + + + + + + +INSERT INTO "public"."poker" ("data", "identifier") VALUES +('[]', 'poker_data'); + + + + +INSERT INTO "public"."roulette" ("data", "identifier") VALUES +('{}', 'roulette_data'); + + + + +INSERT INTO "public"."sessions" ("data", "identifier") VALUES +('[]', 'sessions_data'); + + + + + Index: mmy_database.sql =================================================================== --- dummy_database.sql (revision 22367dbd434339cbf017e24df5eff637dc3738f9) +++ (revision ) @@ -1,129 +1,0 @@ -DROP TABLE IF EXISTS "public"."blackjack"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Table Definition -CREATE TABLE "public"."blackjack" ( - "data" text, - "identifier" text DEFAULT 'blackjack_data'::text -); - -DROP TABLE IF EXISTS "public"."players"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Squences -CREATE SEQUENCE IF NOT EXISTS players_id_seq - --- Table Definition -CREATE TABLE "public"."players" ( - "id" int4 NOT NULL DEFAULT nextval('players_id_seq'::regclass), - "username" text NOT NULL, - "display_name" text NOT NULL, - "credits" float8 -); - -DROP TABLE IF EXISTS "public"."poker"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Table Definition -CREATE TABLE "public"."poker" ( - "data" text, - "identifier" text DEFAULT 'poker_data'::text -); - -DROP TABLE IF EXISTS "public"."roulette"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Table Definition -CREATE TABLE "public"."roulette" ( - "data" text, - "identifier" text DEFAULT 'roulette_data'::text -); - -DROP TABLE IF EXISTS "public"."sessions"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Table Definition -CREATE TABLE "public"."sessions" ( - "data" text, - "identifier" text DEFAULT 'sessions_data'::text -); - -DROP TABLE IF EXISTS "public"."stats"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Squences -CREATE SEQUENCE IF NOT EXISTS stats_id_seq - --- Table Definition -CREATE TABLE "public"."stats" ( - "id" int4 NOT NULL DEFAULT nextval('stats_id_seq'::regclass), - "username" text NOT NULL, - "blackjack_games" int8, - "roulette_games" int8, - "poker_games" int8, - "blackjack_won_games" int8, - "roulette_won_games" int8, - "poker_won_games" int8, - "money_bet" int8, - "money_earned" int8 -); - -DROP TABLE IF EXISTS "public"."users"; --- This script only contains the table creation statements and does not fully represent the table in database. It's still missing: indices, triggers. Do not use it as backup. - --- Squences -CREATE SEQUENCE IF NOT EXISTS users_id_seq - --- Table Definition -CREATE TABLE "public"."users" ( - "id" int4 NOT NULL DEFAULT nextval('users_id_seq'::regclass), - "username" text NOT NULL, - "password" text NOT NULL, - "salt" text NOT NULL -); - -INSERT INTO "public"."blackjack" ("data", "identifier") VALUES -('[]', 'blackjack_data'); - - -INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES -(8, 'gis', 'Gis', 1147); -INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES -(10, 'test', 'Tester', 1000); -INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES -(11, 'guest', 'guester', 1000); -INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES -(9, 'david', 'Dvd', 2650), -(6, 'simon', 'Simon', 10206); - -INSERT INTO "public"."poker" ("data", "identifier") VALUES -('[]', 'poker_data'); - - -INSERT INTO "public"."roulette" ("data", "identifier") VALUES -('{}', 'roulette_data'); - - -INSERT INTO "public"."sessions" ("data", "identifier") VALUES -('[{"id":"8fc8ea87-94a2-4e20-a315-bef5795b4b99","displayName":"Evgi","username":"evgi","credits":10506,"lastActivity":1657280778431},{"id":"d1abae2c-e9b2-4df9-bb92-f7dc9e88d374","displayName":"a","username":"a","credits":5340,"lastActivity":1657640369530},{"id":"d52e06f3-694b-4552-bd4d-58c0062ddead","displayName":"asdasd","username":"asdasd","credits":3593,"lastActivity":1657577539897},{"id":"7cb0abcc-fd94-425a-abaf-be6c67122e9d","displayName":"Gis","username":"gis","credits":1147,"lastActivity":1657640369532},{"id":"7e49c3ae-818e-4a49-ba46-a1980ef33ca6","displayName":"Dvd","username":"david","credits":2650,"lastActivity":1657640499011},{"id":"879c0abd-cfcb-400b-b042-b15f5b59a971","displayName":"Simon","username":"simon","credits":10206,"lastActivity":1657641589917}]', 'sessions_data'); - - -INSERT INTO "public"."stats" ("id", "username", "blackjack_games", "roulette_games", "poker_games", "blackjack_won_games", "roulette_won_games", "poker_won_games", "money_bet", "money_earned") VALUES -(6, 'gis', 0, 4, 0, 0, 1, 0, 72, 216); -INSERT INTO "public"."stats" ("id", "username", "blackjack_games", "roulette_games", "poker_games", "blackjack_won_games", "roulette_won_games", "poker_won_games", "money_bet", "money_earned") VALUES -(8, 'test', 0, 0, 0, 0, 0, 0, 0, 0); -INSERT INTO "public"."stats" ("id", "username", "blackjack_games", "roulette_games", "poker_games", "blackjack_won_games", "roulette_won_games", "poker_won_games", "money_bet", "money_earned") VALUES -(9, 'guest', 0, 0, 0, 0, 0, 0, 0, 0); -INSERT INTO "public"."stats" ("id", "username", "blackjack_games", "roulette_games", "poker_games", "blackjack_won_games", "roulette_won_games", "poker_won_games", "money_bet", "money_earned") VALUES -(7, 'david', 0, 2, 2, 0, 2, 1, 1768, 3418), -(4, 'simon', 28, 18, 43, 12, 2, 17, 47175, 33530); - -INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES -(10, 'simon', 'bcfdfad35ef0240e91e8bc969e0037b3ec1651a30fc5e0f56b2eb852124e592979f8b566abfbbe94872b43e43208e35053da81931a04d30f8b94460c2df52249', '99ab54b2affab7ec75ab3fbec005b4f0'); -INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES -(12, 'gis', '4df04931f518225d0d55afc0db5e69cf5453a2d5ef0f6266223611aefc390f3c8971e37e75944d11f7ad185e3c5e5390c1fffbc5ef6d909a74adb6852ee2cfe0', '2a84f05ebf62c6d692f99dc72eec0c6e'); -INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES -(13, 'david', 'e7cb9841fce607ab7d677fd3c6d02967249f92ac64c0bf0f14f84e1786f2a5787b2d2c7cbeece234f74aee0f75c27ae9fc354d088f30f89f5deef98865017ecb', 'a21f77281bba07b1d5ae5d5fe71ddf3d'); -INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES -(14, 'test', '3b28f1d5ad3633ff23fbde106500e3ab6837779cad55092f83b9607294364177aa4eceb2e69f00bdd6f81cc6f062804a373d74503048dca1eceeb9de22425eab', '65ecbfcc453081ad8ae65470f7e50056'), -(15, 'guest', 'a67c607687003434a04f89d805cc95b0a59bd310dfef6358b7e17c2a3c7b216f8c0c91d919fbfeea3c45635682b241b19d5a9841d83da43f164287c526efb924', '59eb67f0023c9b6fd246ff33382f739d');