[OpenSIPS-Devel] [opensips] Update location table column contact_id to BIGINT (#792)

[Jarrod Baumann]

Ah, I was not aware it was auto-generated, but yes that type does not exist:

```
postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "postgres".
test=# CREATE TABLE location (
test(#     contact_id BIGINTSERIAL PRIMARY KEY NOT NULL,
test(#     username VARCHAR(64) DEFAULT '' NOT NULL,
test(#     domain VARCHAR(64) DEFAULT '' NOT NULL,
test(#     contact VARCHAR(255) DEFAULT '' NOT NULL,
test(#     received VARCHAR(128) DEFAULT NULL,
test(#     path VARCHAR(255) DEFAULT NULL,
test(#     expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
test(#     q REAL DEFAULT 1.0 NOT NULL,
test(#     callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
test(#     cseq INTEGER DEFAULT 13 NOT NULL,
test(#     last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
test(#     flags INTEGER DEFAULT 0 NOT NULL,
test(#     cflags VARCHAR(255) DEFAULT NULL,
test(#     user_agent VARCHAR(255) DEFAULT '' NOT NULL,
test(#     socket VARCHAR(64) DEFAULT NULL,
test(#     methods INTEGER DEFAULT NULL,
test(#     sip_instance VARCHAR(255) DEFAULT NULL,
test(#     attr VARCHAR(255) DEFAULT NULL,
test(#     CONSTRAINT location_account_contact_idx UNIQUE (username, domain, contact, callid)
test(# );
ERROR:  type "bigintserial" does not exist
LINE 2:     contact_id BIGINTSERIAL PRIMARY KEY NOT NULL,
                       ^
test=# select version()
test-# ;
                                            version                                            
-----------------------------------------------------------------------------------------------
 PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit
(1 row)
```

---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/pull/792#issuecomment-184274924
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20160215/74a6efac/attachment.htm>