diff options
| author | albertogp <albertogp@uma.es> | 2021-04-27 21:37:56 +0200 |
|---|---|---|
| committer | albertogp <albertogp@uma.es> | 2021-05-04 13:07:50 +0200 |
| commit | 00cf45421042d623dc0602b82f925823abaddcd5 (patch) | |
| tree | 62056e685dd45858a9fde1b677336ce6c46ae6c1 /admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | |
| parent | 56c079ad5c48e367f8c37d901de72c1e38f5a104 (diff) | |
"#ID-1037 Preparando todos los ficheros para versión 1.2.1"
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1c-1.2.0.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 7 |
1 files changed, 7 insertions, 0 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 e281ae4e..ab1a9c20 100644 --- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql @@ -46,6 +46,13 @@ CREATE PROCEDURE altercols() BEGIN ADD filesystem varchar(100) NOT NULL DEFAULT '', ADD datasize bigint NOT NULL DEFAULT 0; END IF; + # Add tipodisco (ticket #1037). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='tdisk' AND TABLE_NAME='ordenadores_particiones' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE ordenadores_particiones + ADD tdisk VARCHAR(4) DEFAULT NULL AFTER idordenador; + END IF; END// # Run conditional update. DELIMITER ';' |