summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.6/mysql/patch/sysmaps_links.sql
blob: 010b0b598e209af65ddbfb53747a760e18eea52e (plain)
1
2
3
4
5
6
7
8
9
alter table sysmaps_links drop triggerid;
alter table sysmaps_links drop drawtype_off;
alter table sysmaps_links drop color_off;
alter table sysmaps_links drop drawtype_on;
alter table sysmaps_links drop color_on;

alter table sysmaps_links add drawtype integer DEFAULT '0' NOT NULL;
alter table sysmaps_links add color varchar(6) DEFAULT '000000' NOT NULL;