~ubuntu-branches/ubuntu/saucy/quassel/saucy-proposed

« back to all changes in this revision

Viewing changes to src/core/SQL/PostgreSQL/14/setup_050_buffer.sql

  • Committer: Bazaar Package Importer
  • Author(s): Scott Kitterman
  • Date: 2010-02-17 12:49:50 UTC
  • mto: This revision was merged to the branch mainline in revision 59.
  • Revision ID: james.westby@ubuntu.com-20100217124950-v9hajw5d2xa6fszn
Tags: upstream-0.6~beta1
ImportĀ upstreamĀ versionĀ 0.6~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
create TABLE buffer (
2
 
        bufferid serial PRIMARY KEY,
3
 
        userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
4
 
        groupid integer,
5
 
        networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE,
6
 
        buffername varchar(128) NOT NULL,
7
 
        buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
8
 
        buffertype integer NOT NULL DEFAULT 0,
9
 
        lastseenmsgid integer NOT NULL DEFAULT 0,
10
 
        key varchar(128),
11
 
        joined boolean NOT NULL DEFAULT FALSE, -- BOOL
12
 
        UNIQUE(userid, networkid, buffercname)
13
 
)