Bug 3189 - Mysql table definition needs improvement
Summary: Mysql table definition needs improvement
Alias: None
Product: Samba 3.0
Classification: Unclassified
Component: pdb_sql (show other bugs)
Version: 3.0.9
Hardware: Sparc Solaris
: P3 normal
Target Milestone: none
Assignee: pdb_sql maintainers mail alias
QA Contact: Samba QA Contact
Depends on:
Reported: 2005-10-18 19:40 UTC by Gary Mills
Modified: 2006-02-10 08:42 UTC (History)
0 users

See Also:

Improved Mysql table definition (976 bytes, text/plain)
2005-10-18 19:41 UTC, Gary Mills
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gary Mills 2005-10-18 19:40:16 UTC
The file examples/pdb/mysql/mysql.dump in the source distribution
needs some improvements.  First of all, it's missing the definition
for the logon_hours column.  This must have been recently added to
the SQL backend.  As well, the uid column is defined as the primary
key, even though this column (as well as the gid column) is never read
or written by the SQL backend.  The columns that are used for selects
and updates by keys are not indexed.  I've remedied all of these failings
in the file samba.sql, which can be obtained by anonymous FTP at
ftp.cc.umanitoba.ca in the source directory.
Comment 1 Gary Mills 2005-10-18 19:41:34 UTC
Created attachment 1524 [details]
Improved Mysql table definition
Comment 2 Gerald (Jerry) Carter (dead mail address) 2006-02-10 08:42:08 UTC
See bug 3375.  If someone wants to maintain these modules outside
the Samba source tree, that is fine.  But the source has been removed
from the upcoming 3.0.22 release.