CoreFiles by mySites.guru
3.9.0-2018-08-28.sql15 lines, 682 bytes, from Joomla_3.9.21-Stable-Full_Package.zip
Raw History Compare with 3.9.20
md5
ee3194f5289effc12ab312e8970784ef
sha1
1af581b79304d833a431735eb3c059efe115d11b
sha256
1b69ca7c9c0a61f1e81c9e1aa9ffe41ce843ee0bc52b4918abd009b03c6e3963
sp_rename "#__session", "#__session_old";

SELECT cast("session_id" AS varbinary) AS "session_id", "client_id", "guest", cast("time" AS int) AS "time", "data", "userid", "username"
INTO "#__session"
FROM "#__session_old";

DROP TABLE "#__session_old";

ALTER TABLE "#__session" ALTER COLUMN "session_id" varbinary(192) NOT NULL;
ALTER TABLE "#__session" ADD CONSTRAINT "PK_#__session_session_id" PRIMARY KEY CLUSTERED ("session_id") ON [PRIMARY];
ALTER TABLE "#__session" ALTER COLUMN "time" int NOT NULL;
ALTER TABLE "#__session" ADD DEFAULT (0) FOR "time";

CREATE NONCLUSTERED INDEX "time" ON "#__session" ("time");
CREATE NONCLUSTERED INDEX "userid" ON "#__session" ("userid");

The same content is in 91 releases, Joomla 3.9.0-alpha to 3.10.12. See them all, or every version of this file.