[Bug 14263] New: create_table option forcreate_user.sql is incorrect

http://bugs.winehq.org/show_bug.cgi?id=14263

Summary: create_table option forcreate_user.sql  is incorrect
           Product: WineHQ Apps Database
           Version: unspecified
          Platform: Other
        OS/Version: other
            Status: UNCONFIRMED
          Severity: trivial
          Priority: P2
         Component: appdb-unknown
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

Created an attachment (id=14555)
 --> (http://bugs.winehq.org/attachment.cgi?id=14555)
Patches create_tables to run when apidb does not exist

The create_table script has the following commands :

mysql -p -u root apidb < create_user.sql
cat create_apidb_base.sql appdb_tables.sql \
    prefs_list.sql user_list.sql user_prefs.sql \
    user_privs.sql app_category.sql \
    maintainers.sql buglinks.sql monitors.sql \
    error_log.sql distributions.sql testResults.sql \
| mysql -p -u root apidb

Removing the apidb database specification after mysql commands fixes this and
the script continues as expected.

Patch attached

[Bug 14263] create_table option forcreate_user.sql is incorrect

http://bugs.winehq.org/show_bug.cgi?id=14263

--- Comment #1 from Ken Sharp   2009-05-27 19:09:32 ---
Is this still an issue?

[Bug 14263] create_table option forcreate_user.sql is incorrect

http://bugs.winehq.org/show_bug.cgi?id=14263

--- Comment #2 from Henti Smith   2009-05-28 00:14:05 ---
Honestly have not looked at this since I posted it.

[Bug 14263] create_table option forcreate_user.sql is incorrect

http://bugs.winehq.org/show_bug.cgi?id=14263

Alexander Nicolaysen Sørnes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |[e-mail]
         Resolution|                            |FIXED

--- Comment #3 from Alexander Nicolaysen Sørnes   2009-07-13 09:19:34 ---
I have applied the patch now.

[Bug 14263] create_table option forcreate_user.sql is incorrect

http://bugs.winehq.org/show_bug.cgi?id=14263

Alexander Nicolaysen Sørnes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #4 from Alexander Nicolaysen Sørnes   2009-07-21 10:51:41 ---
closing