Login | ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/logviewer/trunk/logviewer.sql
Revision: 5
Committed: Sat Jul 18 14:55:21 2020 UTC (2 months, 1 week ago) by daniel-marschall
Content type: application/x-sql
File size: 454 byte(s)
Log Message:
Small changes

File Contents

# Content
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

Properties

Name Value
svn:mime-type application/x-sql