Location: PHPKode > projects > Helpdesk Solutions > helpdesk/dbHelpdeskDump.txt
#
# Table structure for table `article_catog`
#

CREATE TABLE article_catog (
  artcat_id int(11) NOT NULL auto_increment,
  artcat_name varchar(50) default NULL,
  PRIMARY KEY  (artcat_id)
) TYPE=MyISAM;

#
# Dumping data for table `article_catog`
#

INSERT INTO article_catog VALUES ( '1', 'MS Word');
INSERT INTO article_catog VALUES ( '2', 'MS Excel');
INSERT INTO article_catog VALUES ( '3', 'AS400');
# --------------------------------------------------------

#
# Table structure for table `buildings`
#

CREATE TABLE buildings (
  build_id int(11) NOT NULL auto_increment,
  build_name varchar(50) default NULL,
  PRIMARY KEY  (build_id)
) TYPE=MyISAM;

#
# Dumping data for table `buildings`
#

INSERT INTO buildings VALUES ( '1', 'James Went');
INSERT INTO buildings VALUES ( '2', 'Hawthorn');
INSERT INTO buildings VALUES ( '3', 'Fletcher');
INSERT INTO buildings VALUES ( '4', 'Other');
# --------------------------------------------------------

#
# Table structure for table `department`
#

CREATE TABLE department (
  dept_id int(11) NOT NULL auto_increment,
  dept_name varchar(50) default NULL,
  PRIMARY KEY  (dept_id)
) TYPE=MyISAM;

#
# Dumping data for table `department`
#

INSERT INTO department VALUES ( '1', 'IT');
INSERT INTO department VALUES ( '2', 'Finance');
INSERT INTO department VALUES ( '3', 'Personal');
INSERT INTO department VALUES ( '4', 'Manufacturing');
# --------------------------------------------------------

#
# Table structure for table `error_messages`
#

CREATE TABLE error_messages (
  msg_id int(11) default NULL,
  msg_name text
) TYPE=MyISAM;

#
# Dumping data for table `error_messages`
#

INSERT INTO error_messages VALUES ( '1', 'You cannot access this page.');
INSERT INTO error_messages VALUES ( '2', 'You do not have administrative priviledges and cannot access this page.');
INSERT INTO error_messages VALUES ( '3', 'You are not logged into the system. Please login here.');
# --------------------------------------------------------

#
# Table structure for table `help_users`
#

CREATE TABLE help_users (
  user_id int(11) NOT NULL auto_increment,
  username varchar(30) default NULL,
  password varchar(100) default NULL,
  per_id int(11) default NULL,
  f_name varchar(75) default NULL,
  m_name varchar(75) default NULL,
  l_name varchar(75) default NULL,
  work_num varchar(20) default NULL,
  mobile_num varchar(20) default NULL,
  email varchar(100) default NULL,
  fax varchar(20) default NULL,
  job_title varchar(100) default NULL,
  dept_id varchar(100) default NULL,
  build_id varchar(100) default NULL,
  site_id varchar(100) default NULL,
  comments text,
  mod_date date default NULL,
  wrt_lock varchar(5) default NULL,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

#
# Dumping data for table `help_users`
#

INSERT INTO help_users VALUES ( '1', 'mickey', '40203abe6e81ed98cbc97cdd6ec4f144', '1', 'Micky', '', 'Mouse', '7485', '077845123', 'hide@address.com', '', 'Disney Character', 'Finance', 'James Went', 'Milton Keynes', '', '0000-00-00', NULL);
INSERT INTO help_users VALUES ( '2', 'roger', 'a51e47f646375ab6bf5dd2c42d3e6181', '2', 'Roger', '', 'Rabbit', '647931', '0123456', 'hide@address.com', '0874563', 'Actor', 'Finance', 'Fletcher', 'Milton Keynes', '', '0000-00-00', NULL);
INSERT INTO help_users VALUES ( '3', 'donald', '0d343c0f0ca763f983c8042350059f56', '3', 'Donald', '', 'Duck', '45612', '04954231', 'hide@address.com', '0157521', 'Disney', 'Manufacturing', 'Other', 'Freshwater Lake', '', '0000-00-00', NULL);
INSERT INTO help_users VALUES ( '4', 'scooby', 'b0fc08a18d29407428cbac5d2e5cc682', '4', 'Scooby', '', 'Doo', '465513', '', 'hide@address.com', '0213545', 'Dog Actor', 'Personal', 'Fletcher', 'Haunt Ville', '', '0000-00-00', NULL);
# --------------------------------------------------------

#
# Table structure for table `log_status`
#

CREATE TABLE log_status (
  status_id int(11) NOT NULL auto_increment,
  status_name varchar(50) default NULL,
  PRIMARY KEY  (status_id)
) TYPE=MyISAM;

#
# Dumping data for table `log_status`
#

INSERT INTO log_status VALUES ( '6', 'On Hold');
INSERT INTO log_status VALUES ( '2', 'Being Looked at');
INSERT INTO log_status VALUES ( '5', 'Project');
INSERT INTO log_status VALUES ( '4', 'Waiting for Parts');
INSERT INTO log_status VALUES ( '20', 'Closed');
# --------------------------------------------------------

#
# Table structure for table `order_order`
#

CREATE TABLE order_order (
  order_id int(11) NOT NULL auto_increment,
  order_name varchar(10) default NULL,
  PRIMARY KEY  (order_id)
) TYPE=MyISAM;

#
# Dumping data for table `order_order`
#

INSERT INTO order_order VALUES ( '1', 'Ascending');
INSERT INTO order_order VALUES ( '2', 'Descending');
# --------------------------------------------------------

#
# Table structure for table `order_prefs`
#

CREATE TABLE order_prefs (
  order_id int(11) NOT NULL auto_increment,
  user_id int(11) default NULL,
  order_name varchar(10) default NULL,
  view varchar(20) default NULL,
  sorted varchar(20) default NULL,
  ordering varchar(20) default NULL,
  support_view varchar(20) default NULL,
  PRIMARY KEY  (order_id)
) TYPE=MyISAM;

#
# Dumping data for table `order_prefs`
#

INSERT INTO order_prefs VALUES ( '1', '1', 'users', 'all', 'f_name', '2', NULL);
INSERT INTO order_prefs VALUES ( '2', '1', 'requests', 'Open', 'start_datetime', '2', 'all');
# --------------------------------------------------------

#
# Table structure for table `permissions`
#

CREATE TABLE permissions (
  per_id int(11) NOT NULL auto_increment,
  per_level int(11) default NULL,
  per_name varchar(50) default NULL,
  PRIMARY KEY  (per_id)
) TYPE=MyISAM;

#
# Dumping data for table `permissions`
#

INSERT INTO permissions VALUES ( '1', '1', 'Administrator');
INSERT INTO permissions VALUES ( '2', '2', 'Assistant Admin');
INSERT INTO permissions VALUES ( '3', '3', 'Support Staff');
INSERT INTO permissions VALUES ( '4', '4', 'Advanced User');
INSERT INTO permissions VALUES ( '5', '5', 'Normal User');
# --------------------------------------------------------

#
# Table structure for table `priorities`
#

CREATE TABLE priorities (
  prio_id int(11) NOT NULL auto_increment,
  prio_level int(11) default NULL,
  prio_name varchar(50) default NULL,
  prio_time int(11) default NULL,
  PRIMARY KEY  (prio_id)
) TYPE=MyISAM;

#
# Dumping data for table `priorities`
#

INSERT INTO priorities VALUES ( '1', '1', 'High', '3');
INSERT INTO priorities VALUES ( '2', '2', 'Medium', '5');
INSERT INTO priorities VALUES ( '3', '3', 'Low', '7');
# --------------------------------------------------------

#
# Table structure for table `request_type`
#

CREATE TABLE request_type (
  type_id int(11) NOT NULL auto_increment,
  type_name varchar(50) default NULL,
  PRIMARY KEY  (type_id)
) TYPE=MyISAM;

#
# Dumping data for table `request_type`
#

INSERT INTO request_type VALUES ( '1', 'Hardware');
INSERT INTO request_type VALUES ( '2', 'Software2');
INSERT INTO request_type VALUES ( '7', 'MS Word');
INSERT INTO request_type VALUES ( '4', 'Monitor');
INSERT INTO request_type VALUES ( '5', 'Other');
# --------------------------------------------------------

#
# Table structure for table `requests`
#

CREATE TABLE requests (
  request_id int(11) NOT NULL auto_increment,
  random_number blob,
  request_used varchar(50) default NULL,
  user_name varchar(50) default NULL,
  user_id int(11) default NULL,
  work_num varchar(25) default NULL,
  email varchar(25) default NULL,
  fax varchar(25) default NULL,
  mobile_num varchar(25) default NULL,
  contact_by varchar(25) default NULL,
  logged_by_name varchar(50) default NULL,
  logged_by_id varchar(50) default NULL,
  assigned_to_name varchar(50) default NULL,
  assigned_to_id varchar(50) default NULL,
  modified_by_name varchar(50) default NULL,
  modified_by_id varchar(50) default NULL,
  start_datetime datetime default NULL,
  respond_bytime varchar(50) default NULL,
  call_prio varchar(8) default NULL,
  call_type varchar(20) default NULL,
  call_state varchar(20) default NULL,
  linked_logs varchar(10) default NULL,
  log_summary varchar(60) default NULL,
  prob_desc text,
  intern_anal text,
  contact_history text,
  solution varchar(250) default NULL,
  fin_datetime datetime default NULL,
  closed_by varchar(50) default NULL,
  time_spent datetime default NULL,
  request_closed varchar(5) default NULL,
  PRIMARY KEY  (request_id)
) TYPE=MyISAM;

#
# Dumping data for table `requests`
#

INSERT INTO requests VALUES ( '1', '243025970', 'yes', 'Donald Duck', '3', '45612', 'hide@address.com', '0157521', '04954231', '1', 'Micky Mouse', '1', 'Micky Mouse', '1', NULL, NULL, '2001-10-23 14:19:11', '2001-10-23 19:19:11', 'Medium', 'Other', 'Being Looked at', '', 'Where is the Any key?', 'Hes forgotten again! Tch', '', '', '', NULL, NULL, NULL, NULL);
INSERT INTO requests VALUES ( '2', '1511948623', 'yes', 'Roger Rabbit', '2', '647931', 'hide@address.com', '0874563', '0123456', '2', 'Micky Mouse', '1', 'Micky Mouse', '1', NULL, NULL, '2001-10-23 14:22:17', '2001-10-23 21:22:17', 'Low', 'Hardware', 'Waiting for Parts', '', 'Harddrive broken', 'Again.....', '', '', '', NULL, NULL, NULL, NULL);
INSERT INTO requests VALUES ( '3', '670931056', 'yes', 'Scooby Doo', '4', '465513', 'hide@address.com', '0213545', '', '3', 'Micky Mouse', '1', 'Roger Rabbit', '2', NULL, NULL, '2001-10-23 14:24:19', '2001-10-23 19:24:19', 'Medium', 'Monitor', 'On Hold', '', 'Monitor gone bust', 'Purple tinges around the edges!', 'Sounds like it needs kicking!!', '', '', NULL, NULL, NULL, NULL);
# --------------------------------------------------------

#
# Table structure for table `sites`
#

CREATE TABLE sites (
  site_id int(11) NOT NULL auto_increment,
  site_name varchar(50) default NULL,
  PRIMARY KEY  (site_id)
) TYPE=MyISAM;

#
# Dumping data for table `sites`
#

INSERT INTO sites VALUES ( '1', 'Leicester');
INSERT INTO sites VALUES ( '2', 'Sheffield');
INSERT INTO sites VALUES ( '3', 'Disneyland');
INSERT INTO sites VALUES ( '4', 'Freshwater Lake');
INSERT INTO sites VALUES ( '5', 'Haunt Ville');
# --------------------------------------------------------

#
# Table structure for table `sortedby_requests`
#

CREATE TABLE sortedby_requests (
  requests_group_id int(11) NOT NULL auto_increment,
  requests_sortedby varchar(50) default NULL,
  requests_dname varchar(20) default NULL,
  PRIMARY KEY  (requests_group_id)
) TYPE=MyISAM;

#
# Dumping data for table `sortedby_requests`
#

INSERT INTO sortedby_requests VALUES ( '1', 'by Request No.', 'request_id');
INSERT INTO sortedby_requests VALUES ( '2', 'by User Name', 'user_name');
INSERT INTO sortedby_requests VALUES ( '3', 'by Contact', 'contact_by');
INSERT INTO sortedby_requests VALUES ( '4', 'by Subject/Summary', 'log_summary');
INSERT INTO sortedby_requests VALUES ( '5', 'by Priority', 'call_prio');
INSERT INTO sortedby_requests VALUES ( '6', 'by Status', 'call_state');
INSERT INTO sortedby_requests VALUES ( '7', 'by Respond By', 'respond_by');
INSERT INTO sortedby_requests VALUES ( '8', 'by Date Created', 'start_datetime');
# --------------------------------------------------------

#
# Table structure for table `sortedby_users`
#

CREATE TABLE sortedby_users (
  users_group_id int(11) NOT NULL auto_increment,
  users_sortedby varchar(50) default NULL,
  users_dname varchar(10) default NULL,
  PRIMARY KEY  (users_group_id)
) TYPE=MyISAM;

#
# Dumping data for table `sortedby_users`
#

INSERT INTO sortedby_users VALUES ( '1', 'by First Name', 'f_name');
INSERT INTO sortedby_users VALUES ( '2', 'by Surname', 'l_name');
INSERT INTO sortedby_users VALUES ( '3', 'by Username', 'username');
INSERT INTO sortedby_users VALUES ( '4', 'by Permissions', 'per_id');
INSERT INTO sortedby_users VALUES ( '5', 'by Department', 'dept_id');
INSERT INTO sortedby_users VALUES ( '6', 'by Building', 'build_id');
INSERT INTO sortedby_users VALUES ( '7', 'by Site', 'site_id');
# --------------------------------------------------------

#
# Table structure for table `view_order`
#

CREATE TABLE view_order (
  view_id int(11) NOT NULL auto_increment,
  view_name varchar(10) default NULL,
  PRIMARY KEY  (view_id)
) TYPE=MyISAM;

#
# Dumping data for table `view_order`
#

INSERT INTO view_order VALUES ( '1', 'Open');
INSERT INTO view_order VALUES ( '2', 'Closed');
INSERT INTO view_order VALUES ( '3', 'All');
# --------------------------------------------------------
Return current item: Helpdesk Solutions