source: dummy_database.sql@ 189cd8f

main
Last change on this file since 189cd8f was 64dc53b, checked in by anastasovv <simon@…>, 2 years ago

Code cleanings

  • Property mode set to 100644
File size: 4.4 KB
Line 
1DROP TABLE IF EXISTS "public"."players";
2-- 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.
3
4-- Squences
5CREATE SEQUENCE IF NOT EXISTS players_id_seq;
6
7-- Table Definition
8CREATE TABLE "public"."players" (
9 "id" int4 NOT NULL DEFAULT nextval('players_id_seq'::regclass),
10 "username" text NOT NULL,
11 "display_name" text NOT NULL,
12 "credits" float8
13);
14
15DROP TABLE IF EXISTS "public"."stats";
16-- 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.
17
18-- Squences
19CREATE SEQUENCE IF NOT EXISTS stats_id_seq;
20
21-- Table Definition
22CREATE TABLE "public"."stats" (
23 "id" int4 NOT NULL DEFAULT nextval('stats_id_seq'::regclass),
24 "username" text NOT NULL,
25 "blackjack_games" int8,
26 "roulette_games" int8,
27 "poker_games" int8,
28 "blackjack_won_games" int8,
29 "roulette_won_games" int8,
30 "poker_won_games" int8,
31 "money_bet" int8,
32 "money_earned" int8
33);
34
35DROP TABLE IF EXISTS "public"."users";
36-- 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.
37
38-- Squences
39CREATE SEQUENCE IF NOT EXISTS users_id_seq;
40
41-- Table Definition
42CREATE TABLE "public"."users" (
43 "id" int4 NOT NULL DEFAULT nextval('users_id_seq'::regclass),
44 "username" text NOT NULL,
45 "password" text NOT NULL,
46 "salt" text NOT NULL
47);
48
49INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES
50(9, 'david', 'Dvd', 1000);
51INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES
52(6, 'simon', 'Simon', 3553);
53INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES
54(8, 'gis', 'Gis', 1003);
55INSERT INTO "public"."players" ("id", "username", "display_name", "credits") VALUES
56(12, 'gigi', 'GG', 435),
57(10, 'test', 'Tester', 1000),
58(11, 'guest', 'guester', 1000);
59
60INSERT 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
61(6, 'gis', 0, 0, 0, 0, 0, 0, 0, 0);
62INSERT 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
63(7, 'david', 0, 0, 0, 0, 0, 0, 0, 0);
64INSERT 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
65(10, 'gigi', 7, 0, 0, 3, 0, 0, 4187, 3122);
66INSERT 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
67(8, 'test', 0, 0, 0, 0, 0, 0, 0, 0),
68(9, 'guest', 0, 0, 0, 0, 0, 0, 0, 0),
69(4, 'simon', 10, 0, 0, 5, 0, 0, 5180, 3899);
70
71INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES
72(10, 'simon', 'bcfdfad35ef0240e91e8bc969e0037b3ec1651a30fc5e0f56b2eb852124e592979f8b566abfbbe94872b43e43208e35053da81931a04d30f8b94460c2df52249', '99ab54b2affab7ec75ab3fbec005b4f0');
73INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES
74(12, 'gis', '4df04931f518225d0d55afc0db5e69cf5453a2d5ef0f6266223611aefc390f3c8971e37e75944d11f7ad185e3c5e5390c1fffbc5ef6d909a74adb6852ee2cfe0', '2a84f05ebf62c6d692f99dc72eec0c6e');
75INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES
76(13, 'david', 'e7cb9841fce607ab7d677fd3c6d02967249f92ac64c0bf0f14f84e1786f2a5787b2d2c7cbeece234f74aee0f75c27ae9fc354d088f30f89f5deef98865017ecb', 'a21f77281bba07b1d5ae5d5fe71ddf3d');
77INSERT INTO "public"."users" ("id", "username", "password", "salt") VALUES
78(14, 'test', '3b28f1d5ad3633ff23fbde106500e3ab6837779cad55092f83b9607294364177aa4eceb2e69f00bdd6f81cc6f062804a373d74503048dca1eceeb9de22425eab', '65ecbfcc453081ad8ae65470f7e50056'),
79(15, 'guest', 'a67c607687003434a04f89d805cc95b0a59bd310dfef6358b7e17c2a3c7b216f8c0c91d919fbfeea3c45635682b241b19d5a9841d83da43f164287c526efb924', '59eb67f0023c9b6fd246ff33382f739d'),
80(16, 'gigi', '690aa3232c85602d15fcaaf761ec0f7a14958df2c3054a177b5ac0a05584c959cde01015b009d95111798533add6bdf578867f5c58ebab8121a08b55b32c810c', '353a2adee3a03d28a7118ea138a76aac');
Note: See TracBrowser for help on using the repository browser.