Register Database Schema - Revision history

Monica: /* Dabase schema */

2020-08-06T13:28:42Z

‎Dabase schema

Monica: /* Dabase schema */

2020-08-06T13:02:16Z

‎Dabase schema

Monica: /* Dabase schema */

2020-08-06T13:02:02Z

‎Dabase schema

Monica: /* Dabase schema */

2020-08-06T13:00:58Z

‎Dabase schema

Dana: /* CDR queries */

2014-05-13T15:46:43Z

‎CDR queries

Dana: /* MySQL version with stored functions */

2014-04-08T08:58:00Z

‎MySQL version with stored functions

Andrei: /* MySQL version with stored functions */

2014-04-08T08:16:49Z

‎MySQL version with stored functions

Dana: /* CDR queries */

2014-01-11T10:51:00Z

‎CDR queries

Monica at 08:25, 23 August 2013

2013-08-23T08:25:57Z

Monica at 08:25, 23 August 2013

2013-08-23T08:25:41Z

@@ Line 82: / Line 82: @@
+  )
-  CREATE TABLE `users`
+  CREATE TABLE users
+  (
-   `password` text,
+   password text,
-   `first_name` text,
+   first_name text,
-   `last_name` text,
+   last_name text,
-   `address` text,
+   address text,
-   `inuse` int(11),
+   inuse int(11),
-   `location` text,
+   location text,
-   `expires` datetime,
+   expires datetime,
-   `username` text
+   username text
+  )

@@ Line 81: / Line 81: @@
   ended boolean
+  )
-−
-−
   CREATE TABLE `users`
+  (

@@ Line 83: / Line 83: @@
-CREATE TABLE `users` (
+ CREATE TABLE `users`
    `password` text,
    `first_name` text,
@@ Line 92: / Line 93: @@
    `expires` datetime,
    `username` text
-−
+ )
   For accounts table you can use the PostgreSQL version above.

@@ Line 82: / Line 82: @@
+  )
-  For users and accounts table you can use the PostgreSQL version above.
 ====CDR queries====

@@ Line 85: / Line 85: @@
 ====CDR queries====
-  cdr_initialize=INSERT INTO cdr(time, chan, address, direction, billid, caller, called, duration, billtime, ringtime, status, reason, ended) VALUES(from_unixtime(${time}), '${chan}', '${address}', '${direction}', '${billid}', '${caller}', '${called}', sec_to_time(${duration}), sec_to_time(${billtime}), sec_to_time(${ringtime}), '${status}', '${reason}', false)
+  cdr_initialize=INSERT INTO cdr(time, chan, address, direction, billid, caller, called, duration, billtime, ringtime, status, reason, ended) VALUES(from_unixtime(${time}, '%Y-%m-%d %H:%i:%s'), '${chan}', '${address}', '${direction}', '${billid}', '${caller}', '${called}', sec_to_time(${duration}), sec_to_time(${billtime}), sec_to_time(${ringtime}), '${status}', '${reason}', false)
-  cdr_update=UPDATE cdr SET address='${address}', direction='${direction}', billid='${billid}', caller='${caller}', called='${called}', duration=sec_to_time($duration}), billtime=sec_to_time(${billtime}), ringtime=sec_to_time(${ringtime}), status='${status}', reason='${reason}' WHERE chan='${chan}' AND time=from_unixtime(${time})
+  cdr_update=UPDATE cdr SET address='${address}', direction='${direction}', billid='${billid}', caller='${caller}', called='${called}', duration=sec_to_time($duration}), billtime=sec_to_time(${billtime}), ringtime=sec_to_time(${ringtime}), status='${status}', reason='${reason}' WHERE chan='${chan}' AND time=from_unixtime(${time}, '%Y-%m-%d %H:%i:%s')
-  cdr_finalize=UPDATE cdr SET address='${address}', direction='${direction}', billid='${billid}', caller='${caller}', called='${called}',duration=sec_to_time(${duration}), billtime=sec_to_time(${billtime}), ringtime=sec_to_time(${ringtime}), status='${status}', reason='${reason}', ended=true WHERE chan='${chan}' AND time=from_unixtime(${time})
+  cdr_finalize=UPDATE cdr SET address='${address}', direction='${direction}', billid='${billid}', caller='${caller}', called='${called}',duration=sec_to_time(${duration}), billtime=sec_to_time(${billtime}), ringtime=sec_to_time(${ringtime}), status='${status}', reason='${reason}', ended=true WHERE chan='${chan}' AND time=from_unixtime(${time}, '%Y-%m-%d %H:%i:%s')
 ====MySQL version with stored functions====

@@ Line 92: / Line 92: @@
 ====MySQL version with stored functions====
-One of ouer users suggested a more complex approach. Below is the CDR table with an equivalent MySQL-Function to be called on cdr_insert, cdr_update and cdr_finalize.
   NOTE: The table structure below only works with the functions under it.

@@ Line 60: / Line 60: @@
 ==== CDR queries ====
-The CDR queries for postgresql are in register.conf.sample.
+The CDR queries for PostgreSQL are in register.conf.sample.
 ===MySQL===

@@ Line 3: / Line 3: @@
 You also have the CDR queries for both versions.
-You can consider this schemas a starting point. You can modify them and the queries so you can customize the information you want to hold depending on your applucation.
+You can consider this schemas a starting point. You can modify them and the queries so you can customize the information you want to hold depending on your application.
 ===PostgreSQL===