1234567891011121314151617181920212223 |
- -- Location Bot
- --
- -- Douglas Thrift
- --
- -- $Id$
- create schema locationbot;
- create table locationbot.nick (
- id serial primary key,
- nick text not null unique,
- secret char(32) not null,
- masks text[],
- channels text[],
- timezone text,
- location text,
- updated timestamp with time zone,
- latitude bigint
- );
- create index nick_location_index on locationbot.nick (location);
- create index nick_updated_index on locationbot.nick (updated);
- create index nick_latitude_index on locationbot.nick (latitude);
|