-BEGIN;
 /* local and remote users have profiles */
 create sequence profile_seq;
 create table profile (

    lon decimal(10,7) /* comment 'longitude'*/ ,
    location_id integer /* comment 'location id if possible'*/ ,
    location_ns integer /* comment 'namespace for location'*/ ,
    repeat_of integer /* comment 'notice this is a repeat of' */ references notice (id) 

/*    FULLTEXT(content) */
);

    primary key (user_id)
);

