CREATE TABLE perlDesk_accesslog (id int(11) unsigned NOT NULL auto_increment, user varchar(255), ip varchar(255), time varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_activitylog (id int(11) unsigned NOT NULL auto_increment, cid varchar(255) NOT NULL, date varchar(255) NOT NULL, user varchar(255) NOT NULL, action varchar(255) NOT NULL, PRIMARY KEY (id));
CREATE TABLE perlDesk_announce (id int(11) unsigned NOT NULL auto_increment, author varchar(255), subject varchar(255), message text, staff char(1), users char(1), time varchar(16),  display_until varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_blocked_email (id int(11) unsigned NOT NULL auto_increment, address varchar(255) NOT NULL, type varchar(255) NOT NULL, PRIMARY KEY (id));
CREATE TABLE perlDesk_calls (id int(11) unsigned NOT NULL auto_increment, status enum('OPEN','CLOSED','HOLD') NOT NULL, username varchar(30), email varchar(255), priority char(1), category varchar(255), subject varchar(255), description text, time varchar(20), ownership varchar(255), closedby varchar(255), method char(2), track varchar(50) NOT NULL, active varchar(50) NOT NULL, aw char(1), an char(1) NOT NULL, time_spent varchar(255) NOT NULL, sub_status TEXT, is_locked int(11) NOT NULL, ikey varchar(255) NOT NULL, close_timer int(11), lock_time int(11), due_date DATETIME, PRIMARY KEY (id), INDEX(status));
CREATE TABLE perlDesk_call_fields (id int(11) unsigned NOT NULL auto_increment, cid varchar(255), fid varchar(255), value text, PRIMARY KEY (id));
CREATE TABLE perlDesk_contacts (id int(11) unsigned NOT NULL auto_increment, staff int(11) NOT NULL, name varchar(50) NOT NULL, company varchar(50) NOT NULL, address varchar(255) NOT NULL, email varchar(90) NOT NULL, phone varchar(19), url varchar(90), PRIMARY KEY (id));
CREATE TABLE perlDesk_departments (id int(11) unsigned NOT NULL auto_increment, level varchar(255), from_name text, from_email text, assign_staff text, internal int(1) default 0, PRIMARY KEY (id));
CREATE TABLE perlDesk_em_forwarders (id int(11) unsigned NOT NULL auto_increment, address varchar(255), category varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_files (id int(11) unsigned NOT NULL auto_increment, cid int(11), nid int(11), filename varchar(255) NOT NULL, file varchar(255) NOT NULL, kb int(11), type text, PRIMARY KEY (id));
CREATE TABLE perlDesk_kb_cat (id int(11) unsigned NOT NULL auto_increment, category varchar(255), parent_category int(11) default 0, PRIMARY KEY (id));
CREATE TABLE perlDesk_kb_entries (id int(11) unsigned NOT NULL auto_increment, category varchar(255), catid int(11), author varchar(255), subject varchar(255), keywords text, description text, views varchar(50), stamp timestamp(14), filetype varchar(255), fileid int(11), PRIMARY KEY (id));
CREATE TABLE perlDesk_kb_acronym (id int(11) unsigned NOT NULL auto_increment, letter char(1), acronym varchar(255), acronymname varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_kb_glossary (id int(11) unsigned NOT NULL auto_increment, letter char(1), shortname varchar(255), description text, PRIMARY KEY (id));
CREATE TABLE perlDesk_kb_words (id int(11) unsigned NOT NULL auto_increment, word varchar(255), PRIMARY KEY (id), UNIQUE INDEX (word));
CREATE TABLE perlDesk_kb_ratings (id int(11) unsigned NOT NULL auto_increment, article_id int(11), word_id int(11), rating int(2), PRIMARY KEY (id), INDEX (article_id), INDEX (word_id));
CREATE TABLE perlDesk_kb_stats (id int(11) unsigned NOT NULL auto_increment, article_id int(11), number int(11), date DATE, PRIMARY KEY (id));
CREATE TABLE perlDesk_messages (id int(11) unsigned NOT NULL auto_increment, touser varchar(50) NOT NULL, sender varchar(50) NOT NULL, date varchar(20) NOT NULL, subject varchar(255) NOT NULL, message text NOT NULL, stamp varchar(20) NOT NULL, PRIMARY KEY (id));
CREATE TABLE perlDesk_notes (id int(11) unsigned NOT NULL auto_increment, owner char(1), visible char(1), action varchar(255), call int(11), author varchar(255), time varchar(20), ikey varchar(255), comment text, poster_ip varchar(40), PRIMARY KEY (id));
CREATE TABLE perlDesk_popservers (id int(11) unsigned NOT NULL auto_increment, pop_host varchar(255) NOT NULL, pop_user varchar(255) NOT NULL, pop_password varchar(255) NOT NULL, pop_port varchar(5) NOT NULL, PRIMARY KEY (id));
CREATE TABLE perlDesk_preans (id int(11) unsigned NOT NULL auto_increment, author varchar(25), subject varchar(255), text text, date varchar(20), PRIMARY KEY (id));
CREATE TABLE perlDesk_reviews (id int(11) unsigned NOT NULL auto_increment, owner varchar(255), staff varchar(255), nid varchar(255), rating varchar(255), comments text, PRIMARY KEY (id));
CREATE TABLE perlDesk_settings (setting varchar(50) NOT NULL, value varchar(225), PRIMARY KEY (setting));
CREATE TABLE perlDesk_settings_extra (setting varchar(50) NOT NULL, value text, PRIMARY KEY (setting));
CREATE TABLE perlDesk_signup_fields (id int(11) unsigned NOT NULL auto_increment, name varchar(255), value varchar(255), dorder varchar(10), PRIMARY KEY (id));
CREATE TABLE perlDesk_signup_values (id int(11) unsigned NOT NULL auto_increment, cid varchar(10), sid varchar(10), value varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_staff (id int(11) unsigned NOT NULL auto_increment, username varchar(20), password varchar(255), name varchar(50), email varchar(50), access varchar(255), notify char(1), responsetime varchar(20), callsclosed varchar(10), signature text, rkey char(2), lpage varchar(255), play_sound char(1), llogin varchar(255), address text, city text, state text, zip text, country text, phone text, mobile text, comments text, template text, number_new_main int(11), awatar int(11), report_access int(1), PRIMARY KEY (id));
CREATE TABLE perlDesk_staffactive (username varchar(20) NOT NULL, date varchar(20) NOT NULL);
CREATE TABLE perlDesk_stafflogin (username varchar(50), date varchar(20));
CREATE TABLE perlDesk_staffread (username varchar(50) NOT NULL, date varchar(20) NOT NULL);
CREATE TABLE perlDesk_taskbar (id int(11) unsigned NOT NULL auto_increment, username varchar(50), last_call varchar(50), PRIMARY KEY (id));
CREATE TABLE perlDesk_tasks (id int(11) NOT NULL auto_increment, user_id int(11), name varchar(50), details varchar(255), time datetime, notify tinyint(4), notify_type tinyint(4), notify_earlier int(11), notify_email varchar(255), your_period int(11), status tinyint(4), stamp timestamp(14), callid int(11), PRIMARY KEY (id));
CREATE TABLE perlDesk_templates (id int(11) NOT NULL auto_increment, user_dir text, staff_dir text, admin_dir text, name text, img_dir text, PRIMARY KEY (id));
CREATE TABLE perlDesk_ticket_fields (id int(11) unsigned NOT NULL auto_increment, name varchar(255), value varchar(255), dorder varchar(10), PRIMARY KEY (id));
CREATE TABLE perlDesk_tshooter (id int(11) NOT NULL auto_increment, name varchar(50), first_question_id int(11), stamp timestamp(14), PRIMARY KEY (id));
CREATE TABLE perlDesk_tshooter_archive (id int(11) NOT NULL auto_increment, tshooter_id int(11), parent_id int(11), name varchar(255), question text, answer text, level tinyint(4), action_type tinyint(4), stamp timestamp(14), PRIMARY KEY (id));
CREATE TABLE perlDesk_user_events (id int(11) unsigned NOT NULL auto_increment, user varchar(255), time varchar(255), subject varchar(255), description text, date varchar(50), PRIMARY KEY (id));
CREATE TABLE perlDesk_usergroups (id int(11) NOT NULL auto_increment, name varchar(255), PRIMARY KEY (id));
CREATE TABLE perlDesk_users (id int(11) unsigned NOT NULL auto_increment, username varchar(30), password varchar(255), name varchar(50), email text, url varchar(50), company varchar(50), rkey varchar(5), pending char(1) NOT NULL, active varchar(50), acode varchar(50), lcall varchar(255) NOT NULL, group_id int(11), secondary_email text, PRIMARY KEY (id));
CREATE TABLE perlDesk_staffaccess (staff_id int(11), dep_id int(11));
REPLACE INTO perlDesk_settings_extra (value, setting) VALUES ('Liquid', 'staff_default_template');
REPLACE INTO perlDesk_settings_extra (value, setting) VALUES ('Liquid', 'admin_default_template');
REPLACE INTO perlDesk_settings_extra (value, setting) VALUES ('Liquid', 'user_default_template');