summaryrefslogtreecommitdiff
path: root/db/stoica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-05-17 08:20:45 -0400
committerEvan Prodromou <evan@prodromou.name>2008-05-17 08:20:45 -0400
commit3803cf2153091c4f319c379c3ac24cc8fc844b0a (patch)
tree11819210fbca89a8293c2cba1c0b1042cf3ddf6c /db/stoica.sql
parentfac522f4d7cce9a35e605fac2bba0b2d23616ad0 (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.sql3
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),