← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/jabberd2/oneiric-security

« back to all changes in this revision

Viewing changes to tools/db-setup.oracle

  • Committer: Bazaar Package Importer
  • Author(s): Nicolai Spohrer
  • Date: 2008-08-12 16:13:43 UTC
  • mfrom: (1.1.3 upstream) (0.1.2 sid)
  • Revision ID: james.westby@ubuntu.com-20080812161343-6trz3r97dtevxd17
Tags: 2.2.1-1ubuntu1
https://launchpad.net/bugs/257130
* Merge with Debian unstable (LP: #257130), remaining changes:
  - debian/control:
    + Modify Maintainer field as per spec
    + Depend on libdb4.6-dev instead of libdb4.4-dev
    + Added Conflicts and Replaces: ..., jabber for jabberd2
  - debian/rules: Added libtoolize call (jabberd2 ships with
     an older ltmain.sh version that conflicts with the
     current libtool version)
  - debian/init: create /var/run/jabber directory with correct
     permissions
* Dropped changes:
  - Debian already depends on libpq-dev

Show diffs side-by-side

added added

removed removed

Lines of Context:
tools/db-setup.oracle
35
35
CREATE TABLE "authreg" (
36
36
    "username" varchar2(256),
37
37
    "realm" varchar2(256),
38
 
    "password" varchar2(256),
39
 
    "token" varchar2(10),
40
 
    "sequence" number,
41
 
    "hash" varchar2(40) );
 
38
    "password" varchar2(256) );
42
39
 
43
40
CREATE SEQUENCE "seq-active" INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
44
41
CREATE SEQUENCE "seq-logout" INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
176
173
    "url" varchar2(4000),
177
174
    "tel" varchar2(4000),
178
175
    "email" varchar2(4000),
 
176
    "jabberid" varchar2(4000),
 
177
    "mailer" varchar2(4000),
179
178
    "title" varchar2(4000),
180
179
    "role" varchar2(4000),
181
180
    "bday" varchar2(4000),
189
188
    "adr-pcode" varchar2(4000),
190
189
    "adr-country" varchar2(4000),
191
190
    "org-orgname" varchar2(4000),
192
 
    "org-orgunit" varchar2(4000) );
 
191
    "org-orgunit" varchar2(4000),
 
192
    "uid" varchar2(4000) );
193
193
 
194
194
CREATE OR REPLACE TRIGGER "vcard-object-sequence"
195
195
BEFORE INSERT