Subversion Repositories logviewer

Rev

Rev 2 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2 Rev 5
1 
 
 1 
 
2 
CREATE TABLE `vts_fehlerlog` (
 2 
CREATE TABLE `vts_fehlerlog` (
3 
  `id` BIGINT(20) NOT NULL,
 3 
  `id` BIGINT(20) NOT NULL,
4 
  `logfile` VARCHAR(255) NOT NULL,
 4 
  `logfile` VARCHAR(255) NOT NULL,
5 
  `modul` VARCHAR(30) NOT NULL,
 5 
  `modul` VARCHAR(30) NOT NULL,
6 
  `text` VARCHAR(512) NOT NULL,
 6 
  `text` VARCHAR(512) NOT NULL,
7 
  `anzahl` BIGINT(20) NOT NULL,
 7 
  `anzahl` BIGINT(20) NOT NULL,
8 
  `letzter` datetime NOT NULL,
 8 
  `letzter` datetime NOT NULL,
9 
  `anzahlsolved` BIGINT(20) NOT NULL DEFAULT '0'
 9 
  `anzahlsolved` BIGINT(20) NOT NULL DEFAULT '0'
10 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 10 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11 
 
 11 
 
12 
ALTER TABLE `vts_fehlerlog`
 12 
ALTER TABLE `vts_fehlerlog`
13 
  ADD PRIMARY KEY (`id`);
 13 
  ADD PRIMARY KEY (`id`);
14 
 
 14 
 
15 
ALTER TABLE `vts_fehlerlog`
 15 
ALTER TABLE `vts_fehlerlog`
16 
  MODIFY `id` BIGINT(20) NOT NULL AUTO_INCREMENT;
 16 
  MODIFY `id` BIGINT(20) NOT NULL AUTO_INCREMENT;
17 
COMMIT;
 17 
COMMIT;
18 
 
 18 
 
19 
 
 19