From fac522f4d7cce9a35e605fac2bba0b2d23616ad0 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 15 May 2008 12:28:44 -0400 Subject: 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 --- db/stoica.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'db') 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 ( -- cgit v1.2.3-54-g00ecf