X-Git-Url: https://git.cweiske.de/auerswald-callnotifier.git/blobdiff_plain/f4bd5ef0c711aa9a3d0f6b468370a8c14c0e247a..67eb8026d25dd261358ef5de1c8a5a6111a8e282:/docs/call-log.sql

diff --git a/docs/call-log.sql b/docs/call-log.sql
new file mode 100644
index 0000000..0b14b07
--- /dev/null
+++ b/docs/call-log.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `finished` (
+  `call_id` int(11) NOT NULL AUTO_INCREMENT,
+  `call_start` datetime NOT NULL,
+  `call_end` datetime NOT NULL,
+  `call_type` varchar(1) NOT NULL,
+  `call_from` varchar(32) DEFAULT NULL,
+  `call_from_name` varchar(32) DEFAULT NULL,
+  `call_from_location` varchar(32) DEFAULT NULL,
+  `call_to` varchar(32) DEFAULT NULL,
+  `call_to_name` varchar(32) DEFAULT NULL,
+  `call_to_location` varchar(32) DEFAULT NULL,
+  `call_length` int(11) NOT NULL,
+  PRIMARY KEY (`call_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='finished calls';