From cd5181aa1b1899d053f9d4f782c53ef6eebe0d3f Mon Sep 17 00:00:00 2001 From: Irina Gómez Date: Thu, 10 Dec 2020 11:00:52 +0100 Subject: #1012 Change database field type of the partition size to support disk and partitions bigger 2Tb. --- admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 4 ++++ admin/Database/ogAdmBD.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) (limited to 'admin') diff --git a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql index 2310befa..e281ae4e 100644 --- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql @@ -62,3 +62,7 @@ ALTER TABLE remotepc MODIFY urllogin VARCHAR(255) DEFAULT NULL, MODIFY urllogout VARCHAR(255) DEFAULT NULL, MODIFY urlrelease VARCHAR(255) DEFAULT NULL; + +# Support hard disk bigger 2Tb (ticket #1012) +ALTER TABLE ordenadores_particiones + MODIFY tamano BIGINT NOT NULL DEFAULT '0'; diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 8520ea69..07080a1c 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -560,7 +560,7 @@ CREATE TABLE `ordenadores_particiones` ( `numdisk` smallint NOT NULL DEFAULT '0', `numpar` smallint NOT NULL DEFAULT '0', `codpar` int(8) NOT NULL DEFAULT '0', - `tamano` int(11) NOT NULL DEFAULT '0', + `tamano` bigint(20) NOT NULL DEFAULT '0', `uso` tinyint NOT NULL DEFAULT '0', `idsistemafichero` smallint(11) NOT NULL DEFAULT '0', `idnombreso` smallint(11) NOT NULL DEFAULT '0', -- cgit v1.2.3-18-g5258