diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2012-08-07 15:09:48 +0200 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2012-08-07 15:09:48 +0200 |
| commit | f76b792464115de91324d1c74c692d8c5b4a34a8 (patch) | |
| tree | ae2b7a69c7cd7b9b4c4d4428fdc75f1529ef8208 /docs/create-call-log.sql | |
| parent | 67eb8026d25dd261358ef5de1c8a5a6111a8e282 (diff) | |
| download | auerswald-callnotifier-f76b792464115de91324d1c74c692d8c5b4a34a8.tar.gz auerswald-callnotifier-f76b792464115de91324d1c74c692d8c5b4a34a8.zip | |
rename database call log script
Diffstat (limited to 'docs/create-call-log.sql')
| -rw-r--r-- | docs/create-call-log.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/docs/create-call-log.sql b/docs/create-call-log.sql new file mode 100644 index 0000000..0b14b07 --- /dev/null +++ b/docs/create-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'; |