Fix errors in SQLite dump (via Jim)
1. Comments should lead with '--' not '#', which is standard sql.
1. There's no trailing ';' on the create table statements.
1. The hanging ',' on the last column in each create table statement causes sqlite to complain (and not create the table).
1. There's no trailing ';' on the create table statements.
1. The hanging ',' on the last column in each create table statement causes sqlite to complain (and not create the table).
Leave a comment
The SQLite dump wasn't truly fixed:
Tested in version 2 and 3 under windows and version 3 under linux
- Added -- for comments (this is a standard ANSI SQL comment)
- Added ; to the end of each query (gave syntax errors otherwise)
- Replaced 0000-00-00 with NULL for due date fields
Tested in version 2 and 3 under windows and version 3 under linux
on 2005-04-08 16:57 *
By Anonymous
Attachment sqlite_fix.patch added
Attachment sqlite_fix.patch added
<a href='http://www.assembla.com/spaces/tracks-tickets/documents/aGcuGs0SOr3AbUab7jnrAJ'>sqlite_fix.patch</a>: Fixes the sqlite dump