MySQL Error When Creating Tables Using subscriptions.mysql

Hello all.
I see this problem with MySQL 5.0.19 and 4.1.15

bash$ mysql -u drupal -p drupal < subscriptions.mysql
Enter password:
ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''rid')
)' at line 7

bash$ cat -n subscriptions.mysql
1 DROP TABLE IF EXISTS subscriptions;
2 CREATE TABLE subscriptions(
3 sid int(10) unsigned not null,
4 uid int(10) unsigned not null,
5 stype varchar(4) not null
6 );
7
8 DROP TABLE IF EXISTS subscriptions_holding;
9 CREATE TABLE subscriptions_holding (
10 rid int(11) NOT NULL auto_increment COMMENT 'Unique row ID',
11 content blob NOT NULL COMMENT 'The node array',
12 ptype tinytext NOT NULL COMMENT 'post type - node or comment',
13 op tinytext NOT NULL COMMENT 'The operation on the node',
14 pid int(11) NOT NULL default '0' COMMENT 'The ID of the poster',
15 PRIMARY KEY ('rid')
16 );
17
18
19