Hi Bogdan,<br><br>Let's suppose that we have 2 tables, one for domains and other for users but with the domain field the foreign key from domains table. Also I have in the users table the bit type fields "local", "mobile"...<br>
In this case our output from the created view "grp" will be<br><br>username domain grp last_modified<br>xxyy10 sip1.abcd.efg international 1900-01-01 00:00:01<br>xxyy10 sip1.abcd.efg local 1900-01-01 00:00:01<br>
xxyy10 sip1.abcd.efg mobile 1900-01-01 00:00:01<br>xxyy10 sip1.abcd.efg national 1900-01-01 00:00:01<br><br>So, each table has a primary key, but the "result" - not. Can I use this result for group module? Or, I should generate also a primary key?<br>
<br>Best regards,<br>Oleg<br><br><br><div class="gmail_quote">On Tue, Feb 2, 2010 at 4:13 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Oleg,<br>
<br>
most of the "id" columns are not used by opensips (neither written, nor<br>
read) - but they are used as primary keys.<br>
<br>
So, you can remove the columns, but be sure in setting another primary<br>
key for the tables.<br>
<br>
Regards,<br>
Bogdan<br>
<div><div></div><div class="h5"><br>
Oleg Burlacu wrote:<br>
> Hi!<br>
> I'm planning to migrate from fixed database tables to views.<br>
> But I have a touble to generate the auto increment field - "id".<br>
> Can opensips operate with tables without the "id" filed?<br>
><br>
> Thanks,<br>
> Oleg<br>
</div></div>> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
<br>
--<br>
Bogdan-Andrei Iancu<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br>