Code: Select all
--
-- Table structure for table `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`User` int(11) NOT NULL,
`Subject` text NOT NULL,
`Text` text NOT NULL,
`Priority` int(11) NOT NULL,
`Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Status` int(11) NOT NULL,
`Last_comm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tickets`
--
INSERT INTO `tickets` (`ID`, `User`, `Subject`, `Text`, `Priority`, `Date`, `Status`, `Last_comm`) VALUES
(1, 1, 'Jucator cs:go', 'Salcf?', 1, '2016-03-13 23:45:37', 0, '2016-03-13 23:46:39'),
(2, 3, 'daia', 'salkf?', 2, '2016-03-16 21:38:41', 0, '2016-03-16 21:38:41');
-- --------------------------------------------------------