v14pUY4T

1`latest`
2
3[services.d] starting services
4[services.d] done.
5
6Sequelize CLI [Node: 10.18.0, CLI: 5.5.0, ORM: 5.8.12]
7
8Loaded configuration file "../../config/config.json".
9No migrations were executed, database schema was already up to date.
102020-01-13T23:23:35.385Z warn: Session secret not set. Using random generated one. Please set `sessionSecret` in your config.js file. All users will be logged out.
112020-01-13T23:23:35.388Z warn: PDF export was disabled for this release to mitigate a critical security issue. This feature will hopefully become available again in future releases.
12Mon, 13 Jan 2020 23:23:35 GMT hsts deprecated The "includeSubdomains" parameter is deprecated. Use "includeSubDomains" (with a capital D) instead. at app.js:85:18
132020-01-13T23:23:36.053Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Users" ("id" UUID , "profileid" VARCHAR(255) UNIQUE, "profile" TEXT, "history" TEXT, "accessToken" TEXT, "refreshToken" TEXT, "deleteToken" UUID, "email" TEXT, "password" TEXT, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
142020-01-13T23:23:36.055Z info: Executing (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;
15(sequelize) Warning: PostgreSQL does not support TEXT with options. Plain `TEXT` will be used instead.
16>> Check: http://www.postgresql.org/docs/9.4/static/datatype.html
172020-01-13T23:23:36.064Z info: Executing (default): SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value FROM pg_type t JOIN pg_enum e ON t.oid = e.enumtypid JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'public' AND t.typname='enum_Notes_permission' GROUP BY 1
182020-01-13T23:23:36.067Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Notes" ("id" UUID , "shortid" VARCHAR(255) NOT NULL UNIQUE, "alias" VARCHAR(255) UNIQUE, "permission" "public"."enum_Notes_permission", "viewcount" INTEGER NOT NULL DEFAULT 0, "title" TEXT, "content" TEXT, "authorship" TEXT, "lastchangeAt" TIMESTAMP WITH TIME ZONE, "savedAt" TIMESTAMP WITH TIME ZONE, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "ownerId" UUID REFERENCES "Users" ("id") ON DELETE CASCADE, "lastchangeuserId" UUID, PRIMARY KEY ("id"));
192020-01-13T23:23:36.067Z info: Executing (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 = 'Notes' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
202020-01-13T23:23:36.070Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Authors" ("id" SERIAL , "color" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "noteId" UUID REFERENCES "Notes" ("id") ON DELETE CASCADE, "userId" UUID REFERENCES "Users" ("id") ON DELETE CASCADE, PRIMARY KEY ("id"));
212020-01-13T23:23:36.071Z info: Executing (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 = 'Authors' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
222020-01-13T23:23:36.073Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Revisions" ("id" UUID , "patch" TEXT, "lastContent" TEXT, "content" TEXT, "length" INTEGER, "authorship" TEXT, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "noteId" UUID REFERENCES "Notes" ("id") ON DELETE CASCADE, PRIMARY KEY ("id"));
232020-01-13T23:23:36.074Z info: Executing (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 = 'Revisions' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
242020-01-13T23:23:36.076Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Temps" ("id" VARCHAR(255) , "data" TEXT, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
252020-01-13T23:23:36.077Z info: Executing (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 = 'Temps' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
262020-01-13T23:23:36.079Z info: Executing (default): CREATE TABLE IF NOT EXISTS "Sessions" ("sid" VARCHAR(36) , "expires" TIMESTAMP WITH TIME ZONE, "data" TEXT, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("sid"));
272020-01-13T23:23:36.080Z info: Executing (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;
282020-01-13T23:23:36.088Z info: Executing (default): SELECT "id", "shortid", "alias", "permission", "viewcount", "title", "content", "authorship", "lastchangeAt", "savedAt", "createdAt", "updatedAt", "ownerId", "lastchangeuserId" FROM "Notes" AS "Note" WHERE (("Note"."lastchangeAt" IS NULL OR ("Note"."lastchangeAt" IS NOT NULL AND "Note"."lastchangeAt" > "createdAt")) AND ("Note"."savedAt" IS NULL OR "Note"."savedAt" < "lastchangeAt"));
292020-01-13T23:23:36.091Z info: HTTP Server listening at 0.0.0.0:3000
30
31
32`1.4.0-ls11`
33
34[services.d] starting services
35[services.d] done.
36
37Sequelize [Node: 10.16.2, CLI: 2.8.0, ORM: 3.34.0]
38
39Loaded configuration file "../../config/config.json".
40(node:266) DeprecationWarning: Using the automatically created return value from client.query as an event emitter is deprecated and will be removed in pg@7.0. Please see the upgrade guide at https://node-postgres.com/guides/upgrading
41No migrations were executed, database schema was already up to date.
422020-01-13T23:22:40.666Z warn: Session secret not set. Using random generated one. Please set `sessionSecret` in your config.js file. All users will be logged out.
432020-01-13T23:22:41.267Z info: dmp worker process started
44Mon, 13 Jan 2020 23:22:41 GMT hsts deprecated The "includeSubdomains" parameter is deprecated. Use "includeSubDomains" (with a capital D) instead. at app.js:85:18
45(node:244) DeprecationWarning: Using the automatically created return value from client.query as an event emitter is deprecated and will be removed in pg@7.0. Please see the upgrade guide at https://node-postgres.com/guides/upgrading
46>> WARNING: PostgreSQL does not support TEXT with options. Plain `TEXT` will be used instead.
47>> Check: http://www.postgresql.org/docs/9.4/static/datatype.html
482020-01-13T23:22:41.517Z info: Executing (default): SELECT "id", "shortid", "alias", "permission", "viewcount", "title", "content", "authorship", "lastchangeAt", "savedAt", "createdAt", "updatedAt", "ownerId", "lastchangeuserId" FROM "Notes" AS "Note" WHERE (("Note"."lastchangeAt" IS NULL OR ("Note"."lastchangeAt" IS NOT NULL AND "Note"."lastchangeAt" > "createdAt")) AND ("Note"."savedAt" IS NULL OR "Note"."savedAt" < "lastchangeAt"));
492020-01-13T23:22:41.521Z info: HTTP Server listening at 0.0.0.0:3000