| 1 | UPDATE ogAdmBD.parametros SET tipopa = '1', visual = '1' WHERE idparametro = 30; |
|---|
| 2 | |
|---|
| 3 | UPDATE ogAdmBD.idiomas SET descripcion = 'English' WHERE ididioma = 2; |
|---|
| 4 | UPDATE ogAdmBD.idiomas SET descripcion = 'Català' WHERE ididioma = 3; |
|---|
| 5 | |
|---|
| 6 | ALTER TABLE ogAdmBD.menus MODIFY resolucion smallint(4); |
|---|
| 7 | |
|---|
| 8 | ALTER TABLE ogAdmBD.perfileshard ADD winboot enum( 'reboot', 'kexec' ) NOT NULL DEFAULT 'reboot'; |
|---|
| 9 | |
|---|
| 10 | ALTER TABLE ogAdmBD.ordenadores_particiones |
|---|
| 11 | MODIFY codpar int(8) NOT NULL, |
|---|
| 12 | ADD numdisk tinyint(4) NOT NULL DEFAULT 1 AFTER idordenador, |
|---|
| 13 | ADD cache varchar(500), |
|---|
| 14 | DROP INDEX idordenadornumpar, |
|---|
| 15 | ADD UNIQUE idordenadornumdisknumpar(idordenador,numdisk,numpar); |
|---|
| 16 | |
|---|
| 17 | ALTER TABLE ogAdmBD.imagenes MODIFY codpar int(8) NOT NULL; |
|---|
| 18 | ALTER TABLE ogAdmBD.sistemasficheros MODIFY codpar int(8) NOT NULL; |
|---|
| 19 | ALTER TABLE ogAdmBD.tipospar MODIFY codpar int(8) NOT NULL; |
|---|
| 20 | INSERT INTO ogAdmBD.tipospar (codpar,tipopar,clonable) VALUES |
|---|
| 21 | (6, 'FAT16', 1), |
|---|
| 22 | (CONV('A5',16,10), 'FREEBSD', 1), |
|---|
| 23 | (CONV('A6',16,10), 'OPENBSD', 1), |
|---|
| 24 | (CONV('AF',16,10), 'HFS', 1), |
|---|
| 25 | (CONV('BE',16,10), 'SOLARIS-BOOT', 1), |
|---|
| 26 | (CONV('DA',16,10), 'DATA', 1), |
|---|
| 27 | (CONV('EE',16,10), 'GPT', 0), |
|---|
| 28 | (CONV('EF',16,10), 'EFI', 0), |
|---|
| 29 | (CONV('FB',16,10), 'VMFS', 1), |
|---|
| 30 | (CONV('0700',16,10), 'WINDOWS', 1), |
|---|
| 31 | (CONV('0C01',16,10), 'WIN-RESERV', 1), |
|---|
| 32 | (CONV('7F00',16,10), 'CHROMEOS-KRN', 1), |
|---|
| 33 | (CONV('7F01',16,10), 'CHROMEOS', 1), |
|---|
| 34 | (CONV('7F02',16,10), 'CHROMEOS-RESERV', 1), |
|---|
| 35 | (CONV('8200',16,10), 'LINUX-SWAP', 0), |
|---|
| 36 | (CONV('8300',16,10), 'LINUX', 1), |
|---|
| 37 | (CONV('8301',16,10), 'LINUX-RESERV', 1), |
|---|
| 38 | (CONV('8E00',16,10), 'LINUX-LVM', 1), |
|---|
| 39 | (CONV('A500',16,10), 'FREEBSD-DISK', 0), |
|---|
| 40 | (CONV('A501',16,10), 'FREEBSD-BOOT', 1), |
|---|
| 41 | (CONV('A502',16,10), 'FREEBSD-SWAP', 0), |
|---|
| 42 | (CONV('A503',16,10), 'FREEBSD', 1), |
|---|
| 43 | (CONV('AF00',16,10), 'HFS', 1), |
|---|
| 44 | (CONV('AF01',16,10), 'HFS-RAID', 1), |
|---|
| 45 | (CONV('BE00',16,10), 'SOLARIS-BOOT', 1), |
|---|
| 46 | (CONV('BF00',16,10), 'SOLARIS', 1), |
|---|
| 47 | (CONV('BF01',16,10), 'SOLARIS', 1), |
|---|
| 48 | (CONV('BF02',16,10), 'SOLARIS-SWAP', 0), |
|---|
| 49 | (CONV('BF03',16,10), 'SOLARIS-DISK', 1), |
|---|
| 50 | (CONV('BF04',16,10), 'SOLARIS', 1), |
|---|
| 51 | (CONV('BF05',16,10), 'SOLARIS', 1), |
|---|
| 52 | (CONV('CA00',16,10), 'CACHE', 0), |
|---|
| 53 | (CONV('EF00',16,10), 'EFI', 0), |
|---|
| 54 | (CONV('EF01',16,10), 'MBR', 0), |
|---|
| 55 | (CONV('EF02',16,10), 'BIOS-BOOT', 0), |
|---|
| 56 | (CONV('FD00',16,10), 'LINUX-RAID', 1), |
|---|
| 57 | (CONV('FFFF',16,10), 'UNKNOWN', 1); |
|---|
| 58 | |
|---|
| 59 | ALTER TABLE ogAdmBD.ordenadores ADD fotoord VARCHAR (250) NOT NULL; |
|---|
| 60 | |
|---|
| 61 | UPDATE ogAdmBD.aulas SET urlfoto = SUBSTRING_INDEX (urlfoto, '/', -1) WHERE urlfoto LIKE '%/%'; |
|---|
| 62 | |
|---|
