Differences

This shows you the differences between two versions of the page.

--- userdoc:tt_asterisk-odbc [2014/07/03 13:20]
abelbeck
+++ userdoc:tt_asterisk-odbc [2014/07/03 13:30]
abelbeck [Mass Deployment SQL Table]
@@ Line 102: / Line 102: @@
 !!Note: AstLinux 1.1.7 or later is required!!
+Using the SQL-Data tab in the web interface, view an example 'phoneprov' table generated by the PhoneProv tab:
+{{:userdoc:odbc-phoneprov-table.jpg?nolink|}}
+The SQL schema is of the form:
+  CREATE TABLE 'phoneprov' (
+    'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+    'ext' TEXT DEFAULT '',
+    'cid_name' TEXT DEFAULT '',
+    'account' TEXT DEFAULT '',
+    'line' INTEGER DEFAULT 1,
+    'mac_addr' TEXT DEFAULT '',
+    'template' TEXT DEFAULT '',
+    'model' TEXT DEFAULT '',
+    'vendor' TEXT DEFAULT ''
+  );