Help with phpMYadmin sql error


#1

I’m adding this to my db:

CREATE TABLE `videos_transactions` (`id` int(11) NOT NULL AUTO_INCREMENT,`user_id` int(11) NOT NULL DEFAULT '0',`paid_id` 

but I’m getting an error “A closing bracket was expected. (near “paid_id” at position 112)”. So I tried:

CREATE TABLE `videos_transactions` (`id` int(11) NOT NULL AUTO_INCREMENT,`user_id` int(11) NOT NULL DEFAULT '0',`paid_id` )

and I see: " 1. Unrecognized data type. (near “)” at position 121)
2. A closing bracket was expected. (near “)” at position 121)

Any help with resolving this will be appreciated.


#2

You haven’t specified a data type for paid_id.