Differences

This shows you the differences between two versions of the page.

--- playlists_sql_examples [2018/10/09 14:08]
pinupadmin
+++ playlists_sql_examples [2020/03/27 13:48]
pinupadmin
@@ Line 2: / Line 2: @@
 Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/update each time you select them giving you ability to filter and grab tables dynamically.
+Sample Video by user showing example config: https://youtu.be/-ZwC32AzgIM
 Here are some sample of Playlists and the SQL you can set to use them:
@@ Line 11: / Line 13: @@
 [[https://vpinball.com/forums/topic/sql-helper-for-pinballx-users-going-to-pinup-menu/|https://vpinball.com/forums/topic/sql-helper-for-pinballx-users-going-to-pinup-menu/]]
-Here are the some columns for Game Table.
+Here are the some columns for Games Table.<code>
-<code>
     GameID          INTEGER
     EMUID           INTEGER,
@@ Line 48: / Line 48: @@
     GAMEVER         VARCHAR (100),
     ALTEXE          VARCHAR (250),
-    IPDBNum         VARCHAR (100)
+    IPDBNum         VARCHAR (100),
+    DateUpdated     DATETIME,
+    DateFileUpdated DATETIME,
+    AutoRecFlag     INTEGER        DEFAULT 0,
+    AltRunMode      VARCHAR (250),
+    WebLinkURL      VARCHAR (1000),
+    DesignedBy      VARCHAR (200)
 </code>

PinUP Virtual Pinball System