upgrades/dbpatches/1.6/mysql/patch/profiles.sql


1
2
3
4
5
6
7

delete from profiles;

alter table profiles drop index profiles_1;

alter table profiles add value2          varchar(255)            DEFAULT ''      NOT NULL;
alter table profiles add source        varchar(255)            DEFAULT ''      NOT NULL;
CREATE INDEX profiles_1 on profiles (idx);