summaryrefslogtreecommitdiff
path: root/db/stoica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-05-15 12:28:44 -0400
committerEvan Prodromou <evan@prodromou.name>2008-05-15 12:28:44 -0400
commitfac522f4d7cce9a35e605fac2bba0b2d23616ad0 (patch)
tree3f4bc68a5f9fce6f9d1cb597bb0834ded3eddd88 /db/stoica.sql
parentb6cfd2dffeeb733f07818db5f4ce11d4b3d51771 (diff)
settings and avatars
Did considerable work on the settings section. Redesigned the DB to allow avatars. Each avatar image has a size and an URL. There can be multiple avatars per profile, just different sizes. Added accessors in Profile for avatar. Show the avatar in lots of places, where it makes sense. Constants for avatar sizes in common.php. darcs-hash:20080515162844-84dde-fe0630366e247c02ca8ca9d1cc6b963cfce57a26.gz
Diffstat (limited to 'db/stoica.sql')
-rw-r--r--db/stoica.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/db/stoica.sql b/db/stoica.sql
index 28e8f7662..7ee8f6ff8 100644
--- a/db/stoica.sql
+++ b/db/stoica.sql
@@ -14,6 +14,18 @@ create table profile (
index profile_nickname_idx (nickname)
);
+create table avatar (
+ profile_id integer not null comment 'foreign key to profile table' references profile (id),
+ 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',
+ url varchar(255) unique key comment 'avatar location',
+
+ constraint primary key (profile_id, width, height),
+ index avatar_profile_id_idx (profile_id),
+);
+
/* local users */
create table user (