#77 Wrong schema for MySQL

[zdposter]

When I tried to create database schema with provided MySQL schema (openreports\database\schema\or_ddl_mysql.sql) I got error message:

ERROR 1064 (42000) at line 1: 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 'create table REPORT (REPORT_ID integer not null auto_increment, NAME varchar(255' at line 2

The reason for this that each sql statement should be closed by ";"

Tested on Widnows 2000/XP, Mysql 5.0.37

[zdposter]

Corrected mysql schema

[zdposter]

Logged In: YES
user_id=1246150
Originator: YES

I do not think is closed ;-) (at least not in http://downloads.sourceforge.net/oreports/or-3.0.zip?use_mirror=heanet or here: http://oreports.svn.sourceforge.net/viewvc/\*checkout*/oreports/trunk/openreports/database/schema/or_ddl_mysql.sql?revision=21)

There is no ";" at the end of lines/query. I will attach corected mysql schema.
File Added: or_ddl_mysql.ok.sql

[zdposter]

Corrected mysql schema

[zdposter]

Logged In: YES
user_id=1246150
Originator: YES

I do not think is closed ;-) (at least not in http://downloads.sourceforge.net/oreports/or-3.0.zip?use_mirror=heanet or here: http://oreports.svn.sourceforge.net/viewvc/\*checkout*/oreports/trunk/openreports/database/schema/or_ddl_mysql.sql?revision=21)

There is no ";" at the end of lines/query. I will attach corected mysql schema.
File Added: or_ddl_mysql.ok.sql

[Brice Quillerié]

Logged In: YES
user_id=1490857
Originator: NO

Hello,

I wanted to add ta a schema or_ddl_mysql_innodb.sql (as for quartz) would be nice ; just with TYPE=InnoDB at the end of the create statements.

I can not attach the file but it is simple to write.

Without it, the foreign keys in mysql are not effective.

[Scot Wilcoxon]

Still a problem. Semicolons not at the end of commands.

#1064 - 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 'create table OR_TAGS (TAG_ID integer not null auto_increment, TAGGED_OBJECT_ID i' at line 3