I want to implement hot-desking in asterisk. I have people working on rotating shifts (call centers), or I have people that don’t always work at the same desk.
I can understand the logic. But will you please provide the details about the database ? Is there any sample db available ? or any help/link will be highly appreciable.
[quote=“urmi.l”]I want to implement hot-desking in asterisk. I have people working on rotating shifts (call centers), or I have people that don’t always work at the same desk.
I can understand the logic. But will you please provide the details about the database ? Is there any sample db available ? or any help/link will be highly appreciable.
-Thanks[/quote]
This is mine :
CREATE TABLE “ast_users” (
“id” integer NOT NULL PRIMARY KEY AUTOINCREMENT,
“extension” integer(8,0) NOT NULL,
“first_name” text,
“last_name” text,
“pin” integer NOT NULL,
“context” text,
“status” integer(1,0) NOT NULL DEFAULT 0,
“location” text,
“queue” text NULL DEFAULT q2
);