Subversion Repositories logviewer

Rev

Go to most recent revision | Blame | Last modification | View Log | RSS feed

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