V15.0.0.20191024__element_border_color.sql 1.43 KB
Newer Older
1
2
3
4
5
6
7
8
9
alter table element_table rename column color to fill_color;
alter table element_table add column border_color bytea default E'\\xaced00057372000e6a6176612e6177742e436f6c6f7201a51783108f337502000546000666616c70686149000576616c75654c0002637374001b4c6a6176612f6177742f636f6c6f722f436f6c6f7253706163653b5b00096672676276616c75657400025b465b00066676616c756571007e0002787000000000ff010101707070';
update element_table set border_color=E'\\xaced00057372000e6a6176612e6177742e436f6c6f7201a51783108f337502000546000666616c70686149000576616c75654c0002637374001b4c6a6176612f6177742f636f6c6f722f436f6c6f7253706163653b5b00096672676276616c75657400025b465b00066676616c756571007e0002787000000000ff010101707070';
update element_table set border_color=font_color where element_type_db='PATHWAY';
update element_table set border_color=fill_color where element_type_db in 
   ('BOTTOM_SQUARE_COMPARTMENT', 'LEFT_SQUARE_COMPARTMENT', 'OVAL_COMPARTMENT', 'RIGHT_SQUARE_COMPARTMENT', 'SQUARE_COMPARTMENT', 'TOP_SQUARE_COMPARTMENT');
alter table element_table alter column border_color set not null;
update element_table set fill_color=E'\\xaced00057372000e6a6176612e6177742e436f6c6f7201a51783108f337502000546000666616c70686149000576616c75654c0002637374001b4c6a6176612f6177742f636f6c6f722f436f6c6f7253706163653b5b00096672676276616c75657400025b465b00066676616c756571007e0002787000000000ff010101707070' where fill_color is null;
alter table element_table alter column fill_color set not null;