/usr/share/doc/nuauth-extra/auth_mysql.ipv6.mysql.dump is in nuauth-extra 2.4.3-3.3build2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | -- MySQL dump 10.11
--
-- Host: localhost Database: nulog
-- ------------------------------------------------------
-- Server version 5.0.32-Debian_7etch1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `ipauth_sessions`
--
DROP TABLE IF EXISTS `ipauth_sessions`;
CREATE TABLE `ipauth_sessions` (
`ip_saddr` binary(16) NOT NULL,
`netmask` tinyint(1) unsigned NOT NULL default '128',
`user_id` int(10) unsigned default NULL,
`username` varchar(30) default NULL,
`start_time` datetime default NULL,
`end_time` datetime default NULL,
`cookie` varchar(255) default NULL,
`no_logout` enum('n','y') NOT NULL default 'n',
PRIMARY KEY (`ip_saddr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table `userinfo`
--
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`uid` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` char(41) default NULL,
`end_time` datetime default NULL,
`privacy` enum('n','y') default 'n',
`admingrant` enum('n','y') default 'n',
`name` varchar(255) default NULL,
`surname` varchar(255) default NULL,
`home_address` varchar(255) default NULL,
`cap` char(6) default NULL,
`fiscalcode` varchar(256) default NULL,
`email` varchar(255) default NULL,
`phone` varchar(20) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `fiscalcode` (`fiscalcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table `groupinfo`
--
DROP TABLE IF EXISTS `groupinfo`;
CREATE TABLE `groupinfo` (
`uid` int(11) NOT NULL,
`gid` int(11) NOT NULL,
PRIMARY KEY (`uid`,`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`gid` int(11) NOT NULL auto_increment,
`groupname` varchar(255) NOT NULL,
PRIMARY KEY (`gid`),
UNIQUE KEY `groupname` (`groupname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table `usersettings`
--
DROP TABLE IF EXISTS `usersettings`;
CREATE TABLE `usersettings` (
`uid` int(11) NOT NULL default '0',
`persistent` enum('n','y') NOT NULL default 'n',
`default_ip` binary(16) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`netmask` tinyint(1) unsigned NOT NULL default '128',
PRIMARY KEY (`uid`,`default_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2007-09-20 8:29:55
|