<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="RIGHT: auto">Hi there,</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">On Dec. 18, 2011, I dowloaded the latest GIT version of freeswitch source codes by</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">git clone git://git.freeswitch.org/freeswitch.git</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">Then, I compiled the project solution with vs2008, and run FreeSwitch.exe from command-line on windows 2003. I got a bunch of errors complaining about SQL errors, for example,</div>
<div style="RIGHT: auto">{</div>
<div style="RIGHT: auto">switch_core_sqldb.c:890 SQL ERR [no such table: sip_registrations]<BR>[delete from sip_registrations where (contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='W2k3T602' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']</div>
<div style="RIGHT: auto">}</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">Unlike old version, the new version on windows system seems to require setting up extra database tables according to </div>
<div style="RIGHT: auto">log file [freeswitch.log].<STRONG><FONT style="BACKGROUND-COLOR: #ff0000"> The log file gave basic definitions (see below) of these SQL tables, however, primary key and/or constraints are NOT provided.</FONT></STRONG></div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">Could anyone tell me where to find the full definition of these SQL tables that are required by the latest GIT version of freeswitch? Thanks in adavance!</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">==== table definitions gave in freeswitch.log =========================</div>
<div style="RIGHT: auto"> </div>
<div style="RIGHT: auto">--<BR>-- table [sip_registrations]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_registrations (<BR> call_id VARCHAR(255),<BR> sip_user VARCHAR(255),<BR> sip_host VARCHAR(255),<BR> presence_hosts VARCHAR(255),<BR> contact VARCHAR(1024),<BR> status VARCHAR(255),<BR> rpid VARCHAR(255),<BR> expires INTEGER,<BR> user_agent VARCHAR(255),<BR> server_user VARCHAR(255),<BR>
server_host VARCHAR(255),<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> network_ip VARCHAR(255),<BR> network_port VARCHAR(6),<BR> sip_username VARCHAR(255),<BR> sip_realm VARCHAR(255),<BR> mwi_user VARCHAR(255),<BR> mwi_host VARCHAR(255),<BR> orig_server_host VARCHAR(255),<BR> orig_hostname VARCHAR(255)<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_subscriptions]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_subscriptions (<BR> proto VARCHAR(255),<BR> sip_user VARCHAR(255),<BR> sip_host VARCHAR(255),<BR> sub_to_user VARCHAR(255),<BR> sub_to_host VARCHAR(255),<BR> presence_hosts VARCHAR(255),<BR> event VARCHAR(255),<BR> contact VARCHAR(1024),<BR> call_id VARCHAR(255),<BR> full_from VARCHAR(255),<BR> full_via VARCHAR(255),<BR>
expires INTEGER,<BR> user_agent VARCHAR(255),<BR> accept VARCHAR(255),<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> network_port VARCHAR(6),<BR> network_ip VARCHAR(255),<BR> version INTEGER DEFAULT 0 NOT NULL,<BR> orig_proto VARCHAR(255),<BR> full_to VARCHAR(255)<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_dialogs]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_dialogs (<BR> call_id VARCHAR(255),<BR> uuid VARCHAR(255),<BR> sip_to_user VARCHAR(255),<BR> sip_to_host VARCHAR(255),<BR> sip_from_user VARCHAR(255),<BR> sip_from_host VARCHAR(255),<BR> contact_user VARCHAR(255),<BR> contact_host VARCHAR(255),<BR> state VARCHAR(255),<BR> direction VARCHAR(255),<BR> user_agent VARCHAR(255),<BR> profile_name VARCHAR(255),<BR>
hostname VARCHAR(255),<BR> contact VARCHAR(255),<BR> presence_id VARCHAR(255),<BR> presence_data VARCHAR(255),<BR> call_info VARCHAR(255),<BR> call_info_state VARCHAR(255),<BR> expires INTEGER default 0,<BR> status VARCHAR(255),<BR> rpid VARCHAR(255),<BR> sip_to_tag VARCHAR(255),<BR> sip_from_tag VARCHAR(255),<BR> rcd INTEGER not null default 0<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_presence]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_presence (<BR> sip_user VARCHAR(255),<BR> sip_host VARCHAR(255),<BR> status VARCHAR(255),<BR> rpid VARCHAR(255),<BR> expires INTEGER,<BR> user_agent VARCHAR(255),<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> network_ip VARCHAR(255),<BR> network_port VARCHAR(6),<BR> open_closed VARCHAR(255)<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_authentication]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_authentication (<BR> nonce VARCHAR(255),<BR> expires INTEGER, profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> last_nc INTEGER<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_shared_appearance_subscriptions]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_shared_appearance_subscriptions (<BR> subscriber VARCHAR(255),<BR> call_id VARCHAR(255),<BR> aor VARCHAR(255),<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> contact_str VARCHAR(255),<BR> network_ip VARCHAR(255)<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_shared_appearance_dialogs]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_shared_appearance_dialogs (<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> contact_str VARCHAR(255),<BR> call_id VARCHAR(255),<BR> network_ip VARCHAR(255),<BR> expires INTEGER<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [sip_recovery]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE sip_recovery (<BR> runtime_uuid VARCHAR(255),<BR> profile_name VARCHAR(255),<BR> hostname VARCHAR(255),<BR> uuid VARCHAR(255),<BR> metadata text<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [fifo_outbound]<BR>--</div>
<div style="RIGHT: auto">create table fifo_outbound (<BR> uuid varchar(255),<BR> fifo_name varchar(255),<BR> originate_string varchar(255),<BR> simo_count integer,<BR> use_count integer,<BR> timeout integer,<BR> lag integer,<BR> next_avail integer not null default 0,<BR> expires integer not null default 0,<BR> static integer not null default 0,<BR> outbound_call_count integer not null default 0,<BR> outbound_fail_count integer not null default 0,<BR> hostname varchar(255),<BR> taking_calls integer not null default 1,<BR> status varchar(255),<BR> outbound_call_total_count integer not null default 0,<BR> outbound_fail_total_count integer not null default 0,<BR> active_time integer not null default 0,<BR> inactive_time integer not null default 0,<BR> manual_calls_out_count integer not null default 0,<BR> manual_calls_in_count integer not null default
0,<BR> manual_calls_out_total_count integer not null default 0,<BR> manual_calls_in_total_count integer not null default 0,<BR> ring_count integer not null default 0,<BR> start_time integer not null default 0,<BR> stop_time integer not null default 0<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [fifo_bridge]<BR>--</div>
<div style="RIGHT: auto">create table fifo_bridge (<BR> fifo_name varchar(1024) not null,<BR> caller_uuid varchar(255) not null,<BR> caller_caller_id_name varchar(255),<BR> caller_caller_id_number varchar(255),<BR> consumer_uuid varchar(255) not null,<BR> consumer_outgoing_uuid varchar(255),<BR> bridge_start integer<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [fifo_callers]<BR>--</div>
<div style="RIGHT: auto">create table fifo_callers (<BR> fifo_name varchar(255) not null,<BR> uuid varchar(255) not null,<BR> caller_caller_id_name varchar(255),<BR> caller_caller_id_number varchar(255),<BR> timestamp integer<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [voicemail_msgs]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE voicemail_msgs (<BR> created_epoch INTEGER,<BR> read_epoch INTEGER,<BR> username VARCHAR(255),<BR> domain VARCHAR(255),<BR> uuid VARCHAR(255),<BR> cid_name VARCHAR(255),<BR> cid_number VARCHAR(255),<BR> in_folder VARCHAR(255),<BR> file_path VARCHAR(255),<BR> message_len INTEGER,<BR> flags VARCHAR(255),<BR> read_flags VARCHAR(255),<BR> forwarded_by VARCHAR(255)<BR>);</div>
<div style="RIGHT: auto">--<BR>-- table [voicemail_prefs]<BR>--</div>
<div style="RIGHT: auto">CREATE TABLE voicemail_prefs (<BR> username VARCHAR(255),<BR> domain VARCHAR(255),<BR> name_path VARCHAR(255),<BR> greeting_path VARCHAR(255),<BR> password VARCHAR(255)<BR>);<BR><VAR id=yui-ie-cursor></VAR></div></div></body></html>