Re: mysql

[Brian Kolaci]

  > Brian Kolaci <[EMAIL PROTECTED]> wrote:
  > > How about set the field as 'NOT NULL' rather than set a default?
  > 
  >   I'm no SQL guy.
  > 
  >   Patch?
  > 
  >   Alan DeKok.

Here you go...

This is a diff for db_mysql.sql in the directory
/local/src/radius/freeradius-0.7.1/src/modules/rlm_sql/drivers/rlm_sql_mysql


Brian

*** db_mysql.sql        Fri Mar  8 14:17:04 2002
--- db_mysql.sql.new    Fri Nov  8 16:11:52 2002
***************
*** 56,62 ****
    UserName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253) NOT NULL default '',
!   op char(2),
    PRIMARY KEY  (id),
    KEY UserName (UserName(32))
  ) ;
--- 56,62 ----
    UserName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253) NOT NULL default '',
!   op char(2) NOT NULL,
    PRIMARY KEY  (id),
    KEY UserName (UserName(32))
  ) ;
***************
*** 70,76 ****
    GroupName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253)  NOT NULL default '',
!   op char(2),
    PRIMARY KEY  (id),
    KEY GroupName (GroupName(32))
  ) ;
--- 70,76 ----
    GroupName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253)  NOT NULL default '',
!   op char(2) NOT NULL,
    PRIMARY KEY  (id),
    KEY GroupName (GroupName(32))
  ) ;
***************
*** 84,90 ****
    GroupName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253)  NOT NULL default '',
!   op char(2),
    prio int unsigned NOT NULL default '0',
    PRIMARY KEY  (id),
    KEY GroupName (GroupName(32))
--- 84,90 ----
    GroupName varchar(64) NOT NULL default '',
    Attribute varchar(32)  NOT NULL default '',
    Value varchar(253)  NOT NULL default '',
!   op char(2) NOT NULL,
    prio int unsigned NOT NULL default '0',
    PRIMARY KEY  (id),
    KEY GroupName (GroupName(32))
***************
*** 99,105 ****
    UserName varchar(64) NOT NULL default '',
    Attribute varchar(32) NOT NULL default '',
    Value varchar(253) NOT NULL default '',
!   op char(2),
    PRIMARY KEY  (id),
    KEY UserName (UserName(32))
  ) ;
--- 99,105 ----
    UserName varchar(64) NOT NULL default '',
    Attribute varchar(32) NOT NULL default '',
    Value varchar(253) NOT NULL default '',
!   op char(2) NOT NULL,
    PRIMARY KEY  (id),
    KEY UserName (UserName(32))
  ) ;