|
From: <co...@us...> - 2008-06-26 10:45:29
|
Revision: 123
http://pdbsql.svn.sourceforge.net/pdbsql/?rev=123&view=rev
Author: collen
Date: 2008-06-26 03:45:37 -0700 (Thu, 26 Jun 2008)
Log Message:
-----------
New more comple sql scheme
Added Paths:
-----------
branches/pdbsql_3_2/sql-dumps/samba3.dump
Added: branches/pdbsql_3_2/sql-dumps/samba3.dump
===================================================================
--- branches/pdbsql_3_2/sql-dumps/samba3.dump (rev 0)
+++ branches/pdbsql_3_2/sql-dumps/samba3.dump 2008-06-26 10:45:37 UTC (rev 123)
@@ -0,0 +1,98 @@
+-- MySQL dump 10.11
+--
+-- Host: localhost Database: samba
+-- ------------------------------------------------------
+-- Server version 5.0.51a
+
+--
+-- Table structure for table `domains`
+--
+
+CREATE TABLE `domains` (
+ `domainname` varchar(128) NOT NULL COMMENT 'domain name',
+ `sid` varchar(64) NOT NULL COMMENT 'Security ID',
+ `minpwdlength` int(15) NOT NULL default '5' COMMENT 'minimal password lenght',
+ `pwdhistorylength` int(15) NOT NULL default '0' COMMENT 'password history length',
+ `logontochgpwd` int(2) NOT NULL default '0' COMMENT 'logon for password change',
+ `forcelogoff` int(2) NOT NULL default '-1' COMMENT 'Disconnect users outside logon hours',
+ `refusemachinepwdchange` int(2) unsigned NOT NULL default '0' COMMENT 'Allow machine password change',
+ `lockoutthreshold` int(2) NOT NULL default '0' COMMENT 'lockout users after bad logon attempts',
+ `minpwdage` int(2) NOT NULL default '0' COMMENT 'minimum password age (seconds)',
+ `maxpwdage` int(2) NOT NULL default '-1' COMMENT 'Maximum password age (seconds, -1 never)',
+ `lockoutduration` int(2) NOT NULL default '30' COMMENT 'Lockout duration minutes (-1 forever)',
+ `lockoutobservationwindow` int(2) NOT NULL default '30' COMMENT 'Reset time after lockout (minutes)',
+ `nextrid` int(2) NOT NULL COMMENT 'Next NT RID',
+ `nextuserrid` int(50) NOT NULL COMMENT 'Next NT RID to give our users',
+ `nextgrouprid` int(50) NOT NULL COMMENT 'Next NT group RID',
+ `algorithmicridbase` int(50) NOT NULL COMMENT 'RID base'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `groups`
+--
+
+CREATE TABLE `groups` (
+ `gidnumber` int(11) NOT NULL COMMENT 'Group identifyer in an domain',
+ `description` varchar(1024) default NULL COMMENT 'Descriptive Information',
+ `displayname` varchar(50) default NULL COMMENT 'Preferrence name to be used when displaying entries',
+ `grouptype` int(11) default NULL COMMENT 'NT Group type',
+ `sid` varchar(64) NOT NULL COMMENT 'Security ID'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `hosts`
+--
+
+CREATE TABLE `hosts` (
+ `id` int(10) unsigned default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `user`
+--
+
+CREATE TABLE `user` (
+ `logon_time` int(9) default NULL,
+ `logoff_time` int(9) default NULL,
+ `kickoff_time` int(9) default NULL,
+ `pass_last_set_time` int(9) default NULL,
+ `pass_can_change_time` int(9) default '0',
+ `pass_must_change_time` int(9) default '2147483647',
+ `username` varchar(255) default NULL,
+ `domain` varchar(255) default NULL,
+ `nt_username` varchar(255) default NULL,
+ `nt_fullname` varchar(255) default NULL,
+ `home_dir` varchar(255) default NULL,
+ `dir_drive` varchar(4) default NULL,
+ `logon_script` varchar(255) default NULL,
+ `profile_path` varchar(255) default NULL,
+ `acct_desc` varchar(255) default NULL,
+ `workstations` varchar(255) default NULL,
+ `unknown_str` varchar(255) default NULL,
+ `munged_dial` varchar(255) default NULL,
+ `uid` int(9) NOT NULL auto_increment,
+ `gid` int(9) default NULL,
+ `user_sid` varchar(255) default NULL,
+ `group_sid` varchar(255) default NULL,
+ `lm_pw` varchar(255) default NULL,
+ `nt_pw` varchar(255) default NULL,
+ `acct_ctrl` int(9) default '528',
+ `logon_divs` int(9) default '168',
+ `hours_len` int(9) default '21',
+ `unknown_6` int(9) default '1260',
+ `bad_password_count` int(9) default NULL,
+ `logon_count` int(9) default '0',
+ `logon_hours` varchar(42) default NULL,
+ `password_history` text,
+ PRIMARY KEY (`uid`),
+ KEY `username` (`username`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE `users` (
+ `sid` int(11) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|