PHP Code:
DROP TABLE IF EXISTS `tickets`;
CREATE TABLE `tickets` (
`id` int(100) NOT NULL auto_increment,
`reason` varchar(50) NOT NULL,
`content` text NOT NULL,
`user_id` varchar(10) NOT NULL,
`status` int(10) default NULL,
`ticket_date` datetime NOT NULL,
`answer` text,
`answered_by` varchar(10) default NULL,
`answer_date` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
PHP Code:
`user_id` varchar(10) NOT NULL,
`status` int(10) default NULL,
`ticket_date` datetime NOT NULL,
`answer` text,
`answered_by` varchar(10) default NULL,
`answer_date` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
[Err] 1005 - Can't create table 'tickets' (errno: 13)
€dit: hab in der metin datenbank eine neu db hinzugefügt namens HP und hab da die hen homepage installiert