· 5 years ago · May 08, 2020, 03:08 AM
1', "receiveSMS" BOOLEAN NOT NULL DEFAULT true, "subscribeNews" BOOLEAN NOT NULL DEFAULT true, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
2Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'CoachProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
3Executing (default): DROP TABLE IF EXISTS "CoachClubs" CASCADE;
4Executing (default): CREATE TABLE IF NOT EXISTS "CoachClubs" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "coachProfileId" INTEGER NOT NULL REFERENCES "CoachProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","coachProfileId"));
5Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'CoachClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
6Executing (default): DROP TABLE IF EXISTS "Donations" CASCADE;
7Executing (default): CREATE TABLE IF NOT EXISTS "Donations" ("id" SERIAL , "customerId" VARCHAR(255) NOT NULL, "tokenId" VARCHAR(255) NOT NULL, "cardId" VARCHAR(255) NOT NULL, "planId" VARCHAR(255) NOT NULL, "productId" VARCHAR(255) NOT NULL, "subscriptionId" VARCHAR(255) NOT NULL, "invoiceId" VARCHAR(255) NOT NULL, "email" VARCHAR(255) NOT NULL, "amount" DECIMAL(10,2) NOT NULL, "currency" VARCHAR(255) NOT NULL, "frequency" VARCHAR(255) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
8Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Donations' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
9Executing (default): DROP TABLE IF EXISTS "LeaderProfiles" CASCADE;
10Executing (default): CREATE TABLE IF NOT EXISTS "LeaderProfiles" ("id" SERIAL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
11Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'LeaderProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
12Executing (default): DROP TABLE IF EXISTS "LeaderClubs" CASCADE;
13Executing (default): CREATE TABLE IF NOT EXISTS "LeaderClubs" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "leaderProfileId" INTEGER NOT NULL REFERENCES "LeaderProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","leaderProfileId"));
14Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'LeaderClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
15Executing (default): DROP TABLE IF EXISTS "ParentProfiles" CASCADE;
16Executing (default): CREATE TABLE IF NOT EXISTS "ParentProfiles" ("id" SERIAL , "key" VARCHAR(7) NOT NULL, "usedKey" BOOLEAN NOT NULL DEFAULT false, "agreeMKLiability" BOOLEAN NOT NULL DEFAULT false, "receiveEmails" BOOLEAN NOT NULL DEFAULT false, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
17Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'ParentProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
18Executing (default): DROP TABLE IF EXISTS "RunnerProfiles" CASCADE;
19Executing (default): CREATE TABLE IF NOT EXISTS "RunnerProfiles" ("id" SERIAL , "studentId" VARCHAR(255), "grade" VARCHAR(255) NOT NULL DEFAULT '1', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
20Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
21Executing (default): DROP TABLE IF EXISTS "ParentRunners" CASCADE;
22Executing (default): CREATE TABLE IF NOT EXISTS "ParentRunners" ("status" VARCHAR(255) NOT NULL DEFAULT 'Pending', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "parentProfileId" INTEGER NOT NULL REFERENCES "ParentProfiles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "coachProfileId" INTEGER NOT NULL REFERENCES "CoachProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("parentProfileId","runnerProfileId"));
23Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'ParentRunners' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
24Executing (default): DROP TABLE IF EXISTS "Tracks" CASCADE;
25Executing (default): CREATE TABLE IF NOT EXISTS "Tracks" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "description" VARCHAR(255), "time" REAL DEFAULT '0', "lapDistance" REAL NOT NULL DEFAULT '0', "isDefault" BOOLEAN NOT NULL DEFAULT false, "enable" BOOLEAN NOT NULL DEFAULT true, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER REFERENCES "Clubs" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
26Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Tracks' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
27Executing (default): DROP TABLE IF EXISTS "Requests" CASCADE;
28Executing (default): CREATE TABLE IF NOT EXISTS "Requests" ("id" SERIAL , "status" VARCHAR(255) NOT NULL DEFAULT 'Created', "data" JSON, "requestTypeId" INTEGER NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userRequesterId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "userGranteeId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
29Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Requests' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
30Executing (default): DROP TABLE IF EXISTS "Registers" CASCADE;
31Executing (default): CREATE TABLE IF NOT EXISTS "Registers" ("id" SERIAL , "session" TIMESTAMP WITH TIME ZONE NOT NULL, "manualRegister" BOOLEAN NOT NULL DEFAULT false, "startDate" TIMESTAMP WITH TIME ZONE, "endDate" TIMESTAMP WITH TIME ZONE, "timed" BOOLEAN NOT NULL DEFAULT true, "device" JSON, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "trackId" INTEGER NOT NULL REFERENCES "Tracks" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "scannedById" INTEGER REFERENCES "Users" ("id") ON DELETE SET NULL ON UPDATE CASCADE, "requestId" INTEGER REFERENCES "Requests" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
32Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Registers' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
33Executing (default): DROP TABLE IF EXISTS "RunnerClasses" CASCADE;
34Executing (default): CREATE TABLE IF NOT EXISTS "RunnerClasses" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "classId" INTEGER NOT NULL REFERENCES "Classes" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("classId","runnerProfileId"));
35Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerClasses' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
36Executing (default): DROP TABLE IF EXISTS "RunnerClubs" CASCADE;
37Executing (default): CREATE TABLE IF NOT EXISTS "RunnerClubs" ("status" VARCHAR(255) NOT NULL DEFAULT 'Active', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","runnerProfileId"));
38Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
39Executing (default): DROP TABLE IF EXISTS "Sessions" CASCADE;
40Executing (default): CREATE TABLE IF NOT EXISTS "Sessions" ("token" VARCHAR(400) NOT NULL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("token"));
41Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Sessions' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
42Executing (default): DROP TABLE IF EXISTS "UserActivityTypes" CASCADE;
43Executing (default): CREATE TABLE IF NOT EXISTS "UserActivityTypes" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
44Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'UserActivityTypes' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
45Executing (default): DROP TABLE IF EXISTS "UserActivities" CASCADE;
46Executing (default): CREATE TABLE IF NOT EXISTS "UserActivities" ("id" SERIAL , "date" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT '2020-05-08 02:56:20.052 +00:00', "value" VARCHAR(255) NOT NULL, "description" VARCHAR(255), "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userActivityTypeId" INTEGER NOT NULL REFERENCES "UserActivityTypes" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
47Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'UserActivities' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
48Running seeds...
49Server running on http://0.0.0.0:3000
50172.31.16.157 - - [08/May/2020:02:56:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
51172.31.3.216 - - [08/May/2020:02:56:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
52172.31.16.157 - - [08/May/2020:02:57:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
53172.31.3.216 - - [08/May/2020:02:57:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
54172.31.16.157 - - [08/May/2020:02:57:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
55172.31.3.216 - - [08/May/2020:02:57:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
56172.31.16.157 - - [08/May/2020:02:58:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
57172.31.3.216 - - [08/May/2020:02:58:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
58172.31.16.157 - - [08/May/2020:02:58:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
59172.31.3.216 - - [08/May/2020:02:58:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
60172.31.16.157 - - [08/May/2020:02:59:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
61172.31.3.216 - - [08/May/2020:02:59:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
62172.31.16.157 - - [08/May/2020:02:59:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
63172.31.3.216 - - [08/May/2020:02:59:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
64172.31.16.157 - - [08/May/2020:03:00:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
65172.31.3.216 - - [08/May/2020:03:00:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
66172.31.16.157 - - [08/May/2020:03:00:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
67172.31.3.216 - - [08/May/2020:03:00:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
68root@api-dev:/opt/marathonkids-api# docker logs marathonkids-api_app_1
69
70> marathonkids-api@0.0.1 start /src/app
71> nodemon --exec babel-node index.js
72
73[nodemon] 2.0.3
74[nodemon] to restart at any time, enter `rs`
75[nodemon] watching path(s): *.*
76[nodemon] watching extensions: js,mjs,json
77[nodemon] starting `babel-node index.js`
78Initializing database ...
79Executing (default): DROP TABLE IF EXISTS "UserActivities" CASCADE;
80Executing (default): DROP TABLE IF EXISTS "UserActivityTypes" CASCADE;
81Executing (default): DROP TABLE IF EXISTS "Sessions" CASCADE;
82Executing (default): DROP TABLE IF EXISTS "RunnerClubs" CASCADE;
83Executing (default): DROP TABLE IF EXISTS "RunnerClasses" CASCADE;
84Executing (default): DROP TABLE IF EXISTS "Registers" CASCADE;
85Executing (default): DROP TABLE IF EXISTS "Requests" CASCADE;
86Executing (default): DROP TABLE IF EXISTS "Tracks" CASCADE;
87Executing (default): DROP TABLE IF EXISTS "ParentRunners" CASCADE;
88Executing (default): DROP TABLE IF EXISTS "RunnerProfiles" CASCADE;
89Executing (default): DROP TABLE IF EXISTS "ParentProfiles" CASCADE;
90Executing (default): DROP TABLE IF EXISTS "LeaderClubs" CASCADE;
91Executing (default): DROP TABLE IF EXISTS "LeaderProfiles" CASCADE;
92Executing (default): DROP TABLE IF EXISTS "Donations" CASCADE;
93Executing (default): DROP TABLE IF EXISTS "CoachClubs" CASCADE;
94Executing (default): DROP TABLE IF EXISTS "CoachProfiles" CASCADE;
95Executing (default): DROP TABLE IF EXISTS "Classes" CASCADE;
96Executing (default): DROP TABLE IF EXISTS "AssistantClubs" CASCADE;
97Executing (default): DROP TABLE IF EXISTS "Clubs" CASCADE;
98Executing (default): DROP TABLE IF EXISTS "AssistantProfiles" CASCADE;
99Executing (default): DROP TABLE IF EXISTS "Ambassadors" CASCADE;
100Executing (default): DROP TABLE IF EXISTS "Users" CASCADE;
101Executing (default): DROP TABLE IF EXISTS "Orgs" CASCADE;
102Executing (default): DROP TABLE IF EXISTS "Orgs" CASCADE;
103Executing (default): CREATE TABLE IF NOT EXISTS "Orgs" ("id" SERIAL , "name" VARCHAR(255) NOT NULL UNIQUE, "isSchool" BOOLEAN NOT NULL DEFAULT false, "country" VARCHAR(255) NOT NULL, "address" VARCHAR(255) NOT NULL, "city" VARCHAR(255) NOT NULL, "state" VARCHAR(255) NOT NULL, "zipCode" VARCHAR(255) NOT NULL, "longitude" DECIMAL(18,15) NOT NULL, "latitude" DECIMAL(18,15) NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
104Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Orgs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
105Executing (default): DROP TABLE IF EXISTS "Users" CASCADE;
106Executing (default): CREATE TABLE IF NOT EXISTS "Users" ("id" SERIAL , "email" VARCHAR(255), "password" VARCHAR(255), "pronoun" VARCHAR(255), "firstName" VARCHAR(255) NOT NULL, "lastName" VARCHAR(255) NOT NULL, "title" VARCHAR(255), "gender" VARCHAR(255), "phone" VARCHAR(255), "phoneLabel" VARCHAR(255), "filePath" VARCHAR(255), "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
107Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Users' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
108Executing (default): CREATE UNIQUE INDEX "users_email" ON "Users" ("email")
109Executing (default): DROP TABLE IF EXISTS "Ambassadors" CASCADE;
110Executing (default): CREATE TABLE IF NOT EXISTS "Ambassadors" ("id" SERIAL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "orgId" INTEGER NOT NULL REFERENCES "Orgs" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
111Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Ambassadors' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
112Executing (default): DROP TABLE IF EXISTS "AssistantProfiles" CASCADE;
113Executing (default): CREATE TABLE IF NOT EXISTS "AssistantProfiles" ("id" SERIAL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
114Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'AssistantProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
115Executing (default): DROP TABLE IF EXISTS "Clubs" CASCADE;
116Executing (default): CREATE TABLE IF NOT EXISTS "Clubs" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "startDate" TIMESTAMP WITH TIME ZONE NOT NULL, "endDate" TIMESTAMP WITH TIME ZONE NOT NULL, "anticipatedRunners" INTEGER NOT NULL DEFAULT 0, "marathonGoal" INTEGER NOT NULL DEFAULT 0, "isSample" BOOLEAN NOT NULL DEFAULT false, "publicProfile" VARCHAR(5000) NOT NULL DEFAULT '
117 <h2 style="text-align: center;"><strong>COME RUN WITH US!</strong></h2>
118 <div style="text-align: center;">
119 Our [RUN CLUB NAME] will meet: [DAY(S) OF THE WEEK] AT: [TIME]<br>
120 Who: [WHO INVITES OR GRADE]<br>
121 Where: [LOCATION OF RUN CLUB]<br>
122 </div>
123 <br>
124 <div style="text-align: center;">
125 Questions? Contact the coach:<br>
126 [COACH CONTACT INFORMATION]<br>
127 </div>
128 <br>
129 <div style="text-align: center;">
130 <strong>WHAT DO YOU GET?</strong><br>
131 FUN: A simple and effective program that get kids moving.<br>
132 GOALS: Opotunities for kids to learn effective goal setting.<br>
133 EXCITEMENT: Celebrating and rewarding individual and group progress.< br >
134 </div>
135 <br>
136', "filePath" VARCHAR(255), "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "orgId" INTEGER NOT NULL REFERENCES "Orgs" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "createdById" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
137Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Clubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
138Executing (default): DROP TABLE IF EXISTS "AssistantClubs" CASCADE;
139Executing (default): CREATE TABLE IF NOT EXISTS "AssistantClubs" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "assistantProfileId" INTEGER NOT NULL REFERENCES "AssistantProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, UNIQUE ("assistantProfileId", "clubId"), PRIMARY KEY ("assistantProfileId","clubId"));
140Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'AssistantClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
141Executing (default): DROP TABLE IF EXISTS "Classes" CASCADE;
142Executing (default): CREATE TABLE IF NOT EXISTS "Classes" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "description" VARCHAR(255), "alternateDescription" VARCHAR(255), "teacher" JSON NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "orgId" INTEGER NOT NULL REFERENCES "Orgs" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "createdById" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
143Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Classes' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
144Executing (default): DROP TABLE IF EXISTS "CoachProfiles" CASCADE;
145Executing (default): CREATE TABLE IF NOT EXISTS "CoachProfiles" ("id" SERIAL , "invitationTemplate" VARCHAR(5000) NOT NULL DEFAULT '
146 <h2 style="text-align: center;"><strong>COME RUN WITH US!</strong></h2>
147 <div style="text-align: center;">
148 Our[RUN CLUB NAME] will meet: [DAY(S) OF THE WEEK] AT: [TIME] < br >
149 Who: [WHO INVITES OR GRADE]<br>
150 Where: [LOCATION OF RUN CLUB]<br>
151 </div>
152 <br>
153 <div style="text-align: center;">
154 Questions? Contact the coach:<br>
155 [COACH CONTACT INFORMATION]<br>
156 </div>
157 <br>
158 <div style="text-align: center;">
159 <strong>WHAT DO YOU GET?</strong><br>
160 FUN: A simple and effective program that get kids moving.<br>
161 GOALS: Opotunities for kids to learn effective goal setting.<br>
162 EXCITEMENT: Celebrating and rewarding individual and group progress. < br >
163 </div>
164 <br>
165', "receiveSMS" BOOLEAN NOT NULL DEFAULT true, "subscribeNews" BOOLEAN NOT NULL DEFAULT true, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
166Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'CoachProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
167Executing (default): DROP TABLE IF EXISTS "CoachClubs" CASCADE;
168Executing (default): CREATE TABLE IF NOT EXISTS "CoachClubs" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "coachProfileId" INTEGER NOT NULL REFERENCES "CoachProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","coachProfileId"));
169Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'CoachClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
170Executing (default): DROP TABLE IF EXISTS "Donations" CASCADE;
171Executing (default): CREATE TABLE IF NOT EXISTS "Donations" ("id" SERIAL , "customerId" VARCHAR(255) NOT NULL, "tokenId" VARCHAR(255) NOT NULL, "cardId" VARCHAR(255) NOT NULL, "planId" VARCHAR(255) NOT NULL, "productId" VARCHAR(255) NOT NULL, "subscriptionId" VARCHAR(255) NOT NULL, "invoiceId" VARCHAR(255) NOT NULL, "email" VARCHAR(255) NOT NULL, "amount" DECIMAL(10,2) NOT NULL, "currency" VARCHAR(255) NOT NULL, "frequency" VARCHAR(255) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
172Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Donations' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
173Executing (default): DROP TABLE IF EXISTS "LeaderProfiles" CASCADE;
174Executing (default): CREATE TABLE IF NOT EXISTS "LeaderProfiles" ("id" SERIAL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
175Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'LeaderProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
176Executing (default): DROP TABLE IF EXISTS "LeaderClubs" CASCADE;
177Executing (default): CREATE TABLE IF NOT EXISTS "LeaderClubs" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "leaderProfileId" INTEGER NOT NULL REFERENCES "LeaderProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","leaderProfileId"));
178Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'LeaderClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
179Executing (default): DROP TABLE IF EXISTS "ParentProfiles" CASCADE;
180Executing (default): CREATE TABLE IF NOT EXISTS "ParentProfiles" ("id" SERIAL , "key" VARCHAR(7) NOT NULL, "usedKey" BOOLEAN NOT NULL DEFAULT false, "agreeMKLiability" BOOLEAN NOT NULL DEFAULT false, "receiveEmails" BOOLEAN NOT NULL DEFAULT false, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
181Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'ParentProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
182Executing (default): DROP TABLE IF EXISTS "RunnerProfiles" CASCADE;
183Executing (default): CREATE TABLE IF NOT EXISTS "RunnerProfiles" ("id" SERIAL , "studentId" VARCHAR(255), "grade" VARCHAR(255) NOT NULL DEFAULT '1', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
184Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerProfiles' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
185Executing (default): DROP TABLE IF EXISTS "ParentRunners" CASCADE;
186Executing (default): CREATE TABLE IF NOT EXISTS "ParentRunners" ("status" VARCHAR(255) NOT NULL DEFAULT 'Pending', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "parentProfileId" INTEGER NOT NULL REFERENCES "ParentProfiles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "coachProfileId" INTEGER NOT NULL REFERENCES "CoachProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("parentProfileId","runnerProfileId"));
187Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'ParentRunners' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
188Executing (default): DROP TABLE IF EXISTS "Tracks" CASCADE;
189Executing (default): CREATE TABLE IF NOT EXISTS "Tracks" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "description" VARCHAR(255), "time" REAL DEFAULT '0', "lapDistance" REAL NOT NULL DEFAULT '0', "isDefault" BOOLEAN NOT NULL DEFAULT false, "enable" BOOLEAN NOT NULL DEFAULT true, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER REFERENCES "Clubs" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
190Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Tracks' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
191Executing (default): DROP TABLE IF EXISTS "Requests" CASCADE;
192Executing (default): CREATE TABLE IF NOT EXISTS "Requests" ("id" SERIAL , "status" VARCHAR(255) NOT NULL DEFAULT 'Created', "data" JSON, "requestTypeId" INTEGER NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userRequesterId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "userGranteeId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
193Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Requests' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
194Executing (default): DROP TABLE IF EXISTS "Registers" CASCADE;
195Executing (default): CREATE TABLE IF NOT EXISTS "Registers" ("id" SERIAL , "session" TIMESTAMP WITH TIME ZONE NOT NULL, "manualRegister" BOOLEAN NOT NULL DEFAULT false, "startDate" TIMESTAMP WITH TIME ZONE, "endDate" TIMESTAMP WITH TIME ZONE, "timed" BOOLEAN NOT NULL DEFAULT true, "device" JSON, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "trackId" INTEGER NOT NULL REFERENCES "Tracks" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "scannedById" INTEGER REFERENCES "Users" ("id") ON DELETE SET NULL ON UPDATE CASCADE, "requestId" INTEGER REFERENCES "Requests" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
196Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Registers' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
197Executing (default): DROP TABLE IF EXISTS "RunnerClasses" CASCADE;
198Executing (default): CREATE TABLE IF NOT EXISTS "RunnerClasses" ("active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "classId" INTEGER NOT NULL REFERENCES "Classes" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("classId","runnerProfileId"));
199Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerClasses' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
200Executing (default): DROP TABLE IF EXISTS "RunnerClubs" CASCADE;
201Executing (default): CREATE TABLE IF NOT EXISTS "RunnerClubs" ("status" VARCHAR(255) NOT NULL DEFAULT 'Active', "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "clubId" INTEGER NOT NULL REFERENCES "Clubs" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "runnerProfileId" INTEGER NOT NULL REFERENCES "RunnerProfiles" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("clubId","runnerProfileId"));
202Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'RunnerClubs' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
203Executing (default): DROP TABLE IF EXISTS "Sessions" CASCADE;
204Executing (default): CREATE TABLE IF NOT EXISTS "Sessions" ("token" VARCHAR(400) NOT NULL , "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("token"));
205Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Sessions' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
206Executing (default): DROP TABLE IF EXISTS "UserActivityTypes" CASCADE;
207Executing (default): CREATE TABLE IF NOT EXISTS "UserActivityTypes" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
208Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'UserActivityTypes' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
209Executing (default): DROP TABLE IF EXISTS "UserActivities" CASCADE;
210Executing (default): CREATE TABLE IF NOT EXISTS "UserActivities" ("id" SERIAL , "date" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT '2020-05-08 02:56:20.052 +00:00', "value" VARCHAR(255) NOT NULL, "description" VARCHAR(255), "active" BOOLEAN NOT NULL DEFAULT true, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userActivityTypeId" INTEGER NOT NULL REFERENCES "UserActivityTypes" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "userId" INTEGER NOT NULL REFERENCES "Users" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, PRIMARY KEY ("id"));
211Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'UserActivities' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
212Running seeds...
213Server running on http://0.0.0.0:3000
214172.31.16.157 - - [08/May/2020:02:56:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
215172.31.3.216 - - [08/May/2020:02:56:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
216172.31.16.157 - - [08/May/2020:02:57:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
217172.31.3.216 - - [08/May/2020:02:57:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
218172.31.16.157 - - [08/May/2020:02:57:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
219172.31.3.216 - - [08/May/2020:02:57:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
220172.31.16.157 - - [08/May/2020:02:58:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
221172.31.3.216 - - [08/May/2020:02:58:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
222172.31.16.157 - - [08/May/2020:02:58:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
223172.31.3.216 - - [08/May/2020:02:58:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
224172.31.16.157 - - [08/May/2020:02:59:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
225172.31.3.216 - - [08/May/2020:02:59:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
226172.31.16.157 - - [08/May/2020:02:59:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
227172.31.3.216 - - [08/May/2020:02:59:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
228172.31.16.157 - - [08/May/2020:03:00:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
229172.31.3.216 - - [08/May/2020:03:00:20 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
230172.31.16.157 - - [08/May/2020:03:00:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
231172.31.3.216 - - [08/May/2020:03:00:50 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
232172.31.16.157 - - [08/May/2020:03:01:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
233172.31.3.216 - - [08/May/2020:03:01:21 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
234172.31.16.157 - - [08/May/2020:03:01:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
235172.31.3.216 - - [08/May/2020:03:01:51 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
236172.31.16.157 - - [08/May/2020:03:02:12 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
237172.31.3.216 - - [08/May/2020:03:02:21 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"
238172.31.16.157 - - [08/May/2020:03:02:42 +0000] "GET /api/admin/health HTTP/1.1" 401 - "-" "ELB-HealthChecker/2.0"