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

« back to all changes in this revision

Viewing changes to src/core/SQL/PostgreSQL/16/setup_020_identity.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 identity (
 
2
       identityid serial PRIMARY KEY,
 
3
       userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
 
4
       identityname varchar(64) NOT NULL,
 
5
       realname varchar(128) NOT NULL,
 
6
       awaynick varchar(64),
 
7
       awaynickenabled boolean NOT NULL DEFAULT FALSE,
 
8
       awayreason varchar(256),
 
9
       awayreasonenabled boolean NOT NULL DEFAULT FALSE,
 
10
       autoawayenabled boolean NOT NULL DEFAULT FALSE,
 
11
       autoawaytime integer NOT NULL,
 
12
       autoawayreason varchar(256),
 
13
       autoawayreasonenabled boolean NOT NULL DEFAULT FALSE,
 
14
       detachawayenabled boolean NOT NULL DEFAULT FALSE,
 
15
       detachawayreason varchar(256),
 
16
       detachawayreasonenabled boolean NOT NULL DEFAULT FALSE,
 
17
       ident varchar(64),
 
18
       kickreason varchar(256),
 
19
       partreason varchar(256),
 
20
       quitreason varchar(256),
 
21
       sslcert bytea,
 
22
       sslkey bytea,
 
23
       UNIQUE (userid, identityname)
 
24
)