Creating table using query

Hello, I am trying to create a table in my database using a query, but it is not working. Here is the query:

CREATE TABLE `pastebin` (
	  `pid` int(11) NOT NULL auto_increment,
	  `poster` varchar(16) default NULL,
	  `posted` datetime default NULL,
	  `code` text,
	  `parent_pid` int(11) default '0',
	  `format` varchar(16) default NULL,
	  `codefmt` mediumtext,
	  `codecss` text,
	  `domain` varchar(255) default '',
	  `expires` DATETIME,
	  `expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',
	  
	  PRIMARY KEY  (`pid`),
	  KEY `domain` (`domain`),
	  KEY `parent_pid`,
	  KEY `expires`
	);

create table recent
(
	domain varchar(255),
	pid int not null,
	seq_no int not null,
	
	primary key(domain,seq_no)
);

Code (markup):

When I try putting that in phpmyadmin SQL query box, it returns:

What am I doing wrong? If I am not able to do this through phpmyadmin, how would I go about doing this using a .php file? I have tried doing this many times using guides, with no luck, so I would appreciate it if someone could help me.

 

I think the error is here: `domain` varchar(255) default '',

Try default null;

 

There are two potential issues. One, I don't know if MySQL allows datetime as a key field. Two, key fields should never allow null values. You did not set a default value for expires.

 

KEY `parent_pid`,
KEY `expires`

Code (markup):

...should be:

KEY (`parent_pid`),
KEY (`expires`)

Code (markup):

Everything else is fine.

 

Did you get it to work?

 

Yes, SoKickIt had the right solution

Thanks mate!