38,7 → 38,7 |
KEY `AcctDate` (`AcctDate`), |
KEY `UserOnDate` (`UserName`,`AcctDate`), |
KEY `NASIPAddress` (`NASIPAddress`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
84,7 → 84,7 |
KEY `acctstarttime` (`acctstarttime`), |
KEY `acctstoptime` (`acctstoptime`), |
KEY `nasipaddress` (`nasipaddress`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
102,7 → 102,7 |
`value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '', |
PRIMARY KEY (`id`), |
KEY `username` (`username`(32)) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
120,7 → 120,7 |
`value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '', |
PRIMARY KEY (`id`), |
KEY `groupname` (`groupname`(32)) |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
138,7 → 138,7 |
`value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '', |
PRIMARY KEY (`id`), |
KEY `groupname` (`groupname`(32)) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
154,7 → 154,7 |
`reply` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', |
`authdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
172,7 → 172,7 |
`value` varchar(253) COLLATE utf8_bin NOT NULL DEFAULT '', |
PRIMARY KEY (`id`), |
KEY `username` (`username`(32)) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
187,7 → 187,7 |
`groupname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', |
`priority` int(11) NOT NULL DEFAULT '1', |
KEY `username` (`username`(32)) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
214,7 → 214,7 |
KEY `UserOnDate` (`UserName`,`AcctDate`), |
KEY `NASIPAddress` (`NASIPAddress`), |
KEY `NASIPAddressOnDate` (`AcctDate`,`NASIPAddress`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
236,7 → 236,7 |
PRIMARY KEY (`id`), |
KEY `UserName` (`UserName`), |
KEY `Department` (`Department`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|