5c5
< -- Server version	5.0.37-community-log
---
> -- Server version	5.0.37-community
41,43c41,43
<   `cookie` text NOT NULL,
<   `name` text NOT NULL,
<   `ipnr` text NOT NULL,
---
>   `cookie` varchar(64) NOT NULL,
>   `name` varchar(64) NOT NULL,
>   `ipnr` varchar(32) NOT NULL,
45c45
<   PRIMARY KEY  (`cookie`(111),`ipnr`(111),`name`(111))
---
>   PRIMARY KEY  (`cookie`,`ipnr`,`name`)
54,55c54,55
<   `name` text NOT NULL,
<   `owner` text,
---
>   `name` varchar(64) NOT NULL,
>   `owner` varchar(64) ,
57c57
<   PRIMARY KEY  (`name`(255))
---
>   PRIMARY KEY  (`name`)
66,69c66,69
<   `type` text NOT NULL,
<   `name` text NOT NULL,
<   `value` text,
<   PRIMARY KEY  (`type`(166),`name`(166))
---
>   `type` varchar(64) NOT NULL,
>   `name` varchar(64)  NOT NULL,
>   `value` varchar(32) ,
>   PRIMARY KEY  (`type`,`name`)
78c78
<   `name` text NOT NULL,
---
>   `name` varchar(64) NOT NULL,
82c82
<   PRIMARY KEY  (`name`(255))
---
>   PRIMARY KEY  (`name`)
107,109c107,109
<   `username` text NOT NULL,
<   `action` text NOT NULL,
<   PRIMARY KEY  (`username`(166),`action`(166))
---
>   `username` varchar(64) NOT NULL,
>   `action` varchar(64) NOT NULL,
>   PRIMARY KEY  (`username`,`action`)
119c119
<   `author` text,
---
>   `author` varchar(64) ,
132c132
<   `rev` text NOT NULL,
---
>   `rev` varchar(20) NOT NULL,
134c134
<   `author` text,
---
>   `author` varchar(64) ,
136c136
<   PRIMARY KEY  (`rev`(20)),
---
>   PRIMARY KEY  (`rev`),
146c146
<   `sid` text NOT NULL,
---
>   `sid` varchar(64) NOT NULL,
149c149
<   PRIMARY KEY  (`sid`(32),`authenticated`),
---
>   PRIMARY KEY  (`sid`,`authenticated`),
160c160
<   `sid` text NOT NULL,
---
>   `sid` varchar(64) NOT NULL,
162c162
<   `name` text NOT NULL,
---
>   `name` varchar(64) NOT NULL,
164c164
<   PRIMARY KEY  (`sid`(32),`authenticated`,`name`(64))
---
>   PRIMARY KEY  (`sid`,`authenticated`,`name`)
188,192c188,192
<   `component` text,
<   `severity` text,
<   `priority` text,
<   `owner` text,
<   `reporter` text,
---
>   `component` varchar(64),
>   `severity` varchar(64),
>   `priority` varchar(64),
>   `owner` varchar(64) ,
>   `reporter` varchar(64),
194,197c194,197
<   `version` text,
<   `milestone` text,
<   `status` text,
<   `resolution` text,
---
>   `version` varchar(64),
>   `milestone` varchar(64) ,
>   `status` varchar(64),
>   `resolution` varchar(64) ,
203c203,206
<   KEY `ticket_status_idx` (`status`(255))
---
>   KEY `ticket_status_idx` (`status`),
>   KEY `ticket_priority_idx` (`priority`),
>   KEY `ticket_milestone_idx` (`milestone`),
>   KEY `ticket_component_idx` (`component`)
214,215c217,218
<   `author` text,
<   `field` text NOT NULL,
---
>   `author` varchar(64),
>   `field` varchar(64) NOT NULL,
218c221
<   PRIMARY KEY  (`ticket`,`time`,`field`(111)),
---
>   PRIMARY KEY  (`ticket`,`time`,`field`),
241c244
<   `name` text NOT NULL,
---
>   `name` varchar(64) NOT NULL,
244c247
<   PRIMARY KEY  (`name`(255))
---
>   PRIMARY KEY  (`name`)
256,257c259,260
<   `author` text,
<   `ipnr` text,
---
>   `author` varchar(64),
>   `ipnr` varchar(32),
274c277
< -- Dump completed on 2008-03-07 20:00:43
---
> -- Dump completed on 2008-03-07 16:49:16