diff options
| author | Evan Prodromou <evan@prodromou.name> | 2008-05-17 08:20:45 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@prodromou.name> | 2008-05-17 08:20:45 -0400 |
| commit | 3803cf2153091c4f319c379c3ac24cc8fc844b0a (patch) | |
| tree | 11819210fbca89a8293c2cba1c0b1042cf3ddf6c /db/stoica.sql | |
| parent | fac522f4d7cce9a35e605fac2bba0b2d23616ad0 (diff) | |
upload and change avatars
code to upload and change avatars.
combined some code in the settings area, too.
darcs-hash:20080517122045-84dde-8e13994e627805f29679c9533c2f62db81dc0925.gz
Diffstat (limited to 'db/stoica.sql')
| -rw-r--r-- | db/stoica.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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), |