$ /home/craig/bacula-git/etc/create_sqlite3_database
$ /home/craig/bacula-git/etc/make_sqlite3_tables
SQL error near line 41: near "INDEX": syntax error
SQL error near line 55: no such table: main.RestoreObject
$ apt-cache policy sqlite3
sqlite3:
Installed: 3.6.16-1ubuntu1
Candidate: 3.6.16-1ubuntu1
Version table:
*** 3.6.16-1ubuntu1 0
500 http://ftp.iinet.net.au karmic/main Packages
100 /var/lib/dpkg/status
Looks like it might not like the in-line index specifier on line 64 of
the shell script. Removing:
INDEX(JobID)
and the preceeding comma fixes the issue. As the index is created
explicitly shortly thereafter, I'm guessing this was just a
copy'n'paste-o from another DB's schema definitions.
--
Craig Ringer
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
