Hi Don.K,
I'm looking at your code, you have good ideas. I was thinking writing something similar by myself. When have some time I'll try make some tuning for "Asterisk Realtime".
Anyway.. This post is for the DB schema
| Code: : |
CREATE TABLE `pbook` (
`id` int(11) NOT NULL auto_increment,
`calld` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`bemerkung` text NOT NULL,
`Diverses` int(1) NOT NULL default '0',
KEY `id` (`id`),
KEY `calld` (`calld`),
KEY `name` (`name`)
) ;
CREATE TABLE `pbook_directory` (
`id` int(9) NOT NULL,
`tel` varchar(20) NOT NULL,
`name` varchar(50) NOT NULL,
`strasse` varchar(50) NOT NULL,
`ort` varchar(50) NOT NULL,
KEY `tel` (`tel`),
KEY `name` (`name`)
) ;
|
Make all columns in English (`bemerkung`, `Diverses`, etc). All other tables are in English.
Forum 
Favoured: 0
