diff options
| author | Irina Gómez <irinagomez@us.es> | 2020-12-10 11:00:52 +0100 |
|---|---|---|
| committer | Irina Gómez <irinagomez@us.es> | 2020-12-10 11:00:52 +0100 |
| commit | cd5181aa1b1899d053f9d4f782c53ef6eebe0d3f (patch) | |
| tree | a5eb6b7c41ce7cb8618f8eff6d9894548e6101da /admin/Database | |
| parent | 8ceb1f32ddb0382fba8bf428d70a1afbaef863b9 (diff) | |
#1012 Change database field type of the partition size to support disk and partitions bigger 2Tb.
Diffstat (limited to 'admin/Database')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 4 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 2 |
2 files changed, 5 insertions, 1 deletions
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', |