Fix MySQL errors, as posted to the list by Marcos Roberto

[freeradius.git] / dialup_admin / sql / mysql / badusers.sql

diff --git a/dialup_admin/sql/mysql/badusers.sql b/dialup_admin/sql/mysql/badusers.sql
index c8b5032..286416d 100644 (file)
--- a/dialup_admin/sql/mysql/badusers.sql
+++ b/dialup_admin/sql/mysql/badusers.sql
@@ -2,12 +2,12 @@
 # Table structure for table 'badusers'
 #
 CREATE TABLE badusers (
-  id int(10) DEFAULT '0' NOT NULL auto_increment,
+  id int(10) NOT NULL auto_increment,
   UserName varchar(30),
   IncidentDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   Reason varchar(200),
   Admin varchar(30) DEFAULT '-',
   PRIMARY KEY (id),
   KEY UserName (UserName),
-  KEY Date (Date)
+  KEY IncidentDate (IncidentDate)
 );