Small bug in MySQL DDL

[chrisgrze]

There is a small error in the nukes/src/resource/setup.ddl:

The two lines
INSERT INTO nuke_users VALUES (1,'admin','2003-12-11 18:57:21.074',1,'Administrator','[e-mail]','[e-mail]','http://www.mysite.com',0,'blank.gif','','','fwefwfe','27238723','',0,'','','Your name\u000d\u000aNukes CMS Administrator','wekjfnkjwefnjwefnfwekjnwefkj','21232F297A57A5A743894A0E4A801FC3','imagic','',0,0,0,4096,'2003-12-14 01:15:27.8','2003-12-14 01:15:27.8','','')
INSERT INTO nuke_users VALUES (2,'user','2003-12-11 18:57:21.08',1,'','[e-mail]','','',0,'blank.gif','','','','','',0,'','','','','EE11CBB19052E40B07AAC0CA060C23EE','','',0,0,'0',4096,'1974-09-21 00:00:00.0','1974-09-21 00:00:00.0','','')

Require a ; at the end, otherwise mysql complains.

-d

[julien1]

thanks done.

[estad]

Also in Nukes 1.0 RC1, I could only get prepare.ddl to work by changing the last statment :

"GRANT
Select,
Insert,
Update,
Delete,
Create,
Drop,
Reload,
File,
References,
Index,
Alter
ON nukes.* TO nukes@'localhost' WITH GRANT OPTION;"

to

"GRANT
Select,
Insert,
Update,
Delete,
Create,
Drop,
Reload,
File,
References,
Index,
Alter
ON nukes.* TO nukes@localhost WITH GRANT OPTION;"

I have only executed the DDL using phpMyAdmin.