|
-
Feb 26th, 2007, 08:56 PM
#1
Thread Starter
Frenzied Member
Error in Mysql inster
For some reason it doesent like the timestamp part any ideas?
It was working in one of my DB's then i had to change to a new server so i did a mysql dump, and tired reuploading and i get this 
CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`is_active` int(1) NOT NULL default '1',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`admin` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) AUTO_INCREMENT=2 ;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|