Author Topic: Invalid Syntax for anidb in patchdb  (Read 3270 times)

Offline krunk

  • Newbie
  • *
  • Posts: 2
  • Helpful: +0/-0
Invalid Syntax for anidb in patchdb
« on: 2014-04-29, 08:05:48 PM »
Has some semicolons where commas should be:

Code: [Select]
diff --git a/resources/db/patches/mysql/2014-04-11_208_anidb.sql b/resources/db/patches/mysql/2014-04-11_208_anidb.sql
index 91c50bc..8559fec 100755
--- a/resources/db/patches/mysql/2014-04-11_208_anidb.sql
+++ b/resources/db/patches/mysql/2014-04-11_208_anidb.sql
@@ -1,8 +1,8 @@
 DROP TABLE IF EXISTS anidb;
 CREATE TABLE anidb (
   anidbid    INT(7) UNSIGNED NOT NULL,
-  title_type VARCHAR(25)     NOT NULL DEFAULT '';
-  lang VARCHAR(25) NOT NULL DEFAULT '';
+  title_type VARCHAR(25)     NOT NULL DEFAULT '',
+  lang VARCHAR(25) NOT NULL DEFAULT '',
   imdbid INT(7) UNSIGNED NOT NULL,
   tvdbid INT(7) UNSIGNED NOT NULL,
   title VARCHAR(255) NOT NULL,

Offline archer

  • Overlord
  • ******
  • Posts: 25
  • Helpful: +5/-0
Re: Invalid Syntax for anidb in patchdb
« Reply #1 on: 2014-04-30, 03:03:57 PM »
This was fixed a couple days ago.
Also, the github issues is a better place to report fixes such as this. While a PR is not necessary for something this simple, the issues are read more frequently by most devs, and so likely to get a faster inclusion ;-)
Obviously a PR is the best way, and lets you know if you're up to date ot not.
« Last Edit: 2014-04-30, 03:07:23 PM by archer »
Support my tech addiction.