Fix for newer versions of MySQL

[freeradius.git] / raddb / sql / mysql / schema.sql

diff --git a/raddb/sql/mysql/schema.sql b/raddb/sql/mysql/schema.sql
index b1f1ef1..0634584 100644 (file)
--- a/raddb/sql/mysql/schema.sql
+++ b/raddb/sql/mysql/schema.sql
@@ -1,12 +1,12 @@
 ###########################################################################
 # $Id$                 #
 #                                                                         #
-#  db_mysql.sql                     rlm_sql - FreeRADIUS SQL Module       #
+#  schema.sql                       rlm_sql - FreeRADIUS SQL Module       #
 #                                                                         #
 #     Database schema for MySQL rlm_sql module                            #
 #                                                                         #
 #     To load:                                                            #
-#         mysql -uroot -prootpass radius < db_mysql.sql                   #
+#         mysql -uroot -prootpass radius < schema.sql                     #
 #                                                                         #
 #                                   Mike Machado <mike@innercite.com>     #
 ###########################################################################
@@ -16,7 +16,7 @@
 
 CREATE TABLE radacct (
   radacctid bigint(21) NOT NULL auto_increment,
-  acctsessionid varchar(32) NOT NULL default '',
+  acctsessionid varchar(64) NOT NULL default '',
   acctuniqueid varchar(32) NOT NULL default '',
   username varchar(64) NOT NULL default '',
   groupname varchar(64) NOT NULL default '',
@@ -59,7 +59,7 @@ CREATE TABLE radacct (
 CREATE TABLE radcheck (
   id int(11) unsigned NOT NULL auto_increment,
   username varchar(64) NOT NULL default '',
-  attribute varchar(32)  NOT NULL default '',
+  attribute varchar(64)  NOT NULL default '',
   op char(2) NOT NULL DEFAULT '==',
   value varchar(253) NOT NULL default '',
   PRIMARY KEY  (id),
@@ -73,7 +73,7 @@ CREATE TABLE radcheck (
 CREATE TABLE radgroupcheck (
   id int(11) unsigned NOT NULL auto_increment,
   groupname varchar(64) NOT NULL default '',
-  attribute varchar(32)  NOT NULL default '',
+  attribute varchar(64)  NOT NULL default '',
   op char(2) NOT NULL DEFAULT '==',
   value varchar(253)  NOT NULL default '',
   PRIMARY KEY  (id),
@@ -87,7 +87,7 @@ CREATE TABLE radgroupcheck (
 CREATE TABLE radgroupreply (
   id int(11) unsigned NOT NULL auto_increment,
   groupname varchar(64) NOT NULL default '',
-  attribute varchar(32)  NOT NULL default '',
+  attribute varchar(64)  NOT NULL default '',
   op char(2) NOT NULL DEFAULT '=',
   value varchar(253)  NOT NULL default '',
   PRIMARY KEY  (id),
@@ -101,7 +101,7 @@ CREATE TABLE radgroupreply (
 CREATE TABLE radreply (
   id int(11) unsigned NOT NULL auto_increment,
   username varchar(64) NOT NULL default '',
-  attribute varchar(32) NOT NULL default '',
+  attribute varchar(64) NOT NULL default '',
   op char(2) NOT NULL DEFAULT '=',
   value varchar(253) NOT NULL default '',
   PRIMARY KEY  (id),
@@ -129,6 +129,6 @@ CREATE TABLE radpostauth (
   username varchar(64) NOT NULL default '',
   pass varchar(64) NOT NULL default '',
   reply varchar(32) NOT NULL default '',
-  authdate timestamp(14) NOT NULL,
+  authdate timestamp NOT NULL,
   PRIMARY KEY  (id)
 ) ;