It would seem to me that you'll want that field to be binary as well.
Usually when I store passwords, they're stored as small blobs.
Curtis
Jesse Norell said:
>
> Hello,
>
>> CREATE TABLE users (
>> user_idnr bigint(21) NOT NULL auto_increment,
>> userid varchar(100) NOT NULL default '',
>>
Jesse,
You're right. I have no idea where that one came from. So I've rebuild
the tables file.
As it is, indexes probably could use some further improvements.
Christopher had some ideas about that I think. I'll look into this
myself sometime later this week.
Also, there appears to be an is
Hello,
> CREATE TABLE users (
> user_idnr bigint(21) NOT NULL auto_increment,
> userid varchar(100) NOT NULL default '',
> passwd varchar(32) NOT NULL default '',
> client_idnr bigint(21) NOT NULL default '0',
> maxmail_size bigint(21) NOT NULL default '0',
> encryption_type varchar(20
Aaron Stone wrote:
The command is mysqldump ;-)
mysqldump -d dbmail
to be precise.
I've attached clean table schema that do not contain any of the
redundant indexes, and add the new indexes I published here earlier.
Change all the TYPE=InnoDB into TYPE=myisam or simply remove all
TYPE=In
The command is mysqldump ;-)
Aaron
On Tue, 29 Apr 2003, Robert L. Tom wrote:
> Paul,
>
> Robert L. Tom wrote:
> > I applied these to my dbmail 1.1 mysql database..
>
> > alter table messages add index (unique_id); <--Got an ERROR right here
> > alter table messages add index (status); <-
