1. install xampp terlebih dulu
2. taruh directory phpmydesk di c:xampp/htdocs/”nama_dir
3. buat database di phpmyadmin dgn nama “pmd”
4. edit file “pmd config”
############ DATABASE CONFIGURATION ############
$host = “localhost”;
$user = “terserah anda”;
$pass = “terserah anda”;
$db = “pmd”;
############ DATABASE CONFIGURATION ############

5. buat database di phpmyadmin di dalam database “pmd”
6. buat sesuai dengan urutan di pmd.sql, seperti ini :

able structure for table `responses`

CREATE TABLE responses (
id int(11) NOT NULL auto_increment,
ticketid int(11) NOT NULL default ‘0′,
response text NOT NULL,
rtime datetime NOT NULL default ‘0000-00-00 00:00:00′,
responseby varchar(46) NOT NULL default ”,
PRIMARY KEY (id)
) TYPE=MyISAM;
# ——————————————————–

#
# Table structure for table `tickets`
#

CREATE TABLE tickets (
id int(11) NOT NULL auto_increment,
usr_id int(11) NOT NULL default ‘0′,
sub varchar(140) NOT NULL default ”,
details text NOT NULL,
pri smallint(6) NOT NULL default ‘0′,
status smallint(6) NOT NULL default ‘0′,
logg datetime NOT NULL default ‘0000-00-00 00:00:00′,
PRIMARY KEY (id)
) TYPE=MyISAM;
# ——————————————————–

#
# Table structure for table `users`
#

CREATE TABLE users (
id int(11) NOT NULL auto_increment,
usr varchar(16) NOT NULL default ”,
pwd varchar(16) NOT NULL default ”,
fn varchar(40) NOT NULL default ”,
ln varchar(40) NOT NULL default ”,
em varchar(250) NOT NULL default ”,
PRIMARY KEY (id)
) TYPE=MyISAM;


Silahkan download aplikasi supportdesk/phpmydesk disini

This entry was posted on Thursday, April 9, 2009 at 8:25 PM and is filed under , , . You can follow any responses to this entry through the comments feed .

0 comments

Post a Comment