From 3803cf2153091c4f319c379c3ac24cc8fc844b0a Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sat, 17 May 2008 08:20:45 -0400 Subject: upload and change avatars code to upload and change avatars. combined some code in the settings area, too. darcs-hash:20080517122045-84dde-8e13994e627805f29679c9533c2f62db81dc0925.gz --- db/stoica.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/stoica.sql b/db/stoica.sql index 7ee8f6ff8..1f2b28d95 100644 --- a/db/stoica.sql +++ b/db/stoica.sql @@ -16,10 +16,11 @@ create table profile ( create table avatar ( profile_id integer not null comment 'foreign key to profile table' references profile (id), + original boolean default false comment 'uploaded by user or generated?', width integer not null comment 'image width', height integer not null comment 'image height', - original boolean default false comment 'uploaded by user or generated?', mediatype varchar(32) not null comment 'file type', + filename varchar(255) null comment 'local filename, if local', url varchar(255) unique key comment 'avatar location', constraint primary key (profile_id, width, height), -- cgit v1.2.3-54-g00ecf