@socialgouv/matomo-postgres - npm Package Compare versions

Comparing version 1.5.0 to 1.5.1

package.json

		{
		"name": "@socialgouv/matomo-postgres",
		"description": "Extract visitor events from Matomo API and push to Postgres",
		"version": "1.5.0",
		"version": "1.5.1",
		"types": "types/index.d.ts",
		@@ -6,0 +6,0 @@ "license": "Apache-2.0",

src/createTable.js

		@@ -64,14 +64,14 @@ const { Client } = require("pg");
		const migrations = [
		`CREATE INDEX IF NOT EXISTS idx_dimension1 ON matomo(dimension1);
		CREATE INDEX IF NOT EXISTS idx_dimension2 ON matomo(dimension2);
		CREATE INDEX IF NOT EXISTS idx_dimension3 ON matomo(dimension3);
		CREATE INDEX IF NOT EXISTS idx_dimension4 ON matomo(dimension4);
		CREATE INDEX IF NOT EXISTS idx_dimension5 ON matomo(dimension5);
		CREATE INDEX IF NOT EXISTS idx_userid ON matomo(userid);
		CREATE INDEX IF NOT EXISTS idx_actionurl ON matomo(action_url);
		CREATE INDEX IF NOT EXISTS idx_region ON matomo(region);`,
		`ALTER TABLE matomo ADD COLUMN IF NOT EXISTS visitorid text;
		ALTER TABLE matomo ADD COLUMN IF NOT EXISTS referrertype text;
		ALTER TABLE matomo ADD COLUMN IF NOT EXISTS referrername text;
		CREATE INDEX IF NOT EXISTS idx_visitorid ON matomo(visitorid);`,
		`CREATE INDEX IF NOT EXISTS idx_dimension1 ON ${table}(dimension1);
		CREATE INDEX IF NOT EXISTS idx_dimension2 ON ${table}(dimension2);
		CREATE INDEX IF NOT EXISTS idx_dimension3 ON ${table}(dimension3);
		CREATE INDEX IF NOT EXISTS idx_dimension4 ON ${table}(dimension4);
		CREATE INDEX IF NOT EXISTS idx_dimension5 ON ${table}(dimension5);
		CREATE INDEX IF NOT EXISTS idx_userid ON ${table}(userid);
		CREATE INDEX IF NOT EXISTS idx_actionurl ON ${table}(action_url);
		CREATE INDEX IF NOT EXISTS idx_region ON ${table}(region);`,
		`ALTER TABLE ${table} ADD COLUMN IF NOT EXISTS visitorid text;
		ALTER TABLE ${table} ADD COLUMN IF NOT EXISTS referrertype text;
		ALTER TABLE ${table} ADD COLUMN IF NOT EXISTS referrername text;
		CREATE INDEX IF NOT EXISTS idx_visitorid ON ${table}(visitorid);`,
		];
		@@ -78,0 +78,0 @@

@socialgouv/matomo-postgres - npm Package Compare versions

New alerts

Fixed alerts

Improved metrics