> > | mysql> describe repligard;
> > | +-----------+-------------+------+-----+---------------------+-------+
> > | | Field | Type | Null | Key | Default | Extra |
> > | +-----------+-------------+------+-----+---------------------+-------+
> > | | id | int(11) | | | 0 | |
> > | | timestamp | datetime | | | 0000-00-00 00:00:00 | |
> > | | updated | datetime | | | 0000-00-00 00:00:00 | |
> > | | realm | varchar(32) | | | | |
> > | | tag | varchar(32) | | MUL | | |
> > | | sitegroup | int(11) | | | 0 | |
> > | +-----------+-------------+------+-----+---------------------+-------+
> > | 6 rows in set (0.00 sec)
> Yes, this is correct.
Are you sure, I had a similar set of problems upgrading our main server, (not
helped by problems with apache 1.3.14 (from debian-woody) which appears to
refuse to work with midgard due to some problems with the regcomp library.. -
ended up down grading to 1.3.9 (from potato).)
anyway my table looks like this (note the GUID is not in the table above ....)
mysql> describe repligard;
+-----------+----------------------------------+------+-----+---------------------+----------------+----------------------+
| Field | Type | Null | Key |
Default | Extra | Privileges |
+-----------+----------------------------------+------+-----+---------------------+----------------+----------------------+
| autoid | int(11) | | PRI |
NULL | auto_increment | select,insert,update |
| id | int(11) | | |
0 | | select,insert,update |
| timestamp | datetime | | | 0000-00-00
00:00:00 | | select,insert,update |
| updated | datetime | | | 0000-00-00
00:00:00 | | select,insert,update |
| realm | varchar(32) | |
| | | select,insert,update |
| tag | varchar(32) | | MUL
| | | select,insert,update |
| sitegroup | int(11) | | |
0 | | select,insert,update |
| guid | varchar(32) | YES | |
NULL | | select,insert,update |
| action | enum('create','update','delete') | YES | |
create | | select,insert,update |
| changed | timestamp(14) | YES | |
NULL | | select,insert,update |
+-----------+----------------------------------+------+-----+---------------------+----------------+----------------------+
10 rows in set (0.00 sec)
--
Technical Director
Linux Center (HK) Ltd.
www.hklc.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
