[platal.git] / upgrade / 0.9.16 / 00_profile.sql

create table watch_profile (
  uid int(5) unsigned not null,
  ts timestamp not null default CURRENT_TIMESTAMP,
  field enum('nom', 'freetext', 'mobile', 'nationalite', 'nick', 'web', 'appli1', 'appli2',
             'addresses', 'section', 'binets', 'medals', 'cv', 'jobs', 'photo'),

  primary key field (uid, field)
) charset=utf8;


alter table auth_user_quick change column profile_freetext profile_freetext mediumtext;

# vim:set syntax=mysql:
Commit	Line	Data
a2a1c2f2 FB	1	create table watch_profile (
	2	uid int(5) unsigned not null,
	3	ts timestamp not null default CURRENT_TIMESTAMP,
	4	field enum('nom', 'freetext', 'mobile', 'nationalite', 'nick', 'web', 'appli1', 'appli2',
	5	'addresses', 'section', 'binets', 'medals', 'cv', 'jobs', 'photo'),
	6
	7	primary key field (uid, field)
	8	) charset=utf8;
	9
acee3022 FB	10
	11	alter table auth_user_quick change column profile_freetext profile_freetext mediumtext;
	12
a2a1c2f2	13	# vim:set syntax=mysql: