Images, JavaScript, and Flash files that PHP sends to the browser are not affected by the GPL because they are data. However, Drupal's JavaScript, including the copy of jQuery that is included with Drupal, is itself under the GPL as well, so any Javascript that interacts with Drupal's JavaScript in the browser must also be under the GPL or a GPL compatible license.
Chapter 1. Drupal Overview - CHAPTER 1 Drupal Overview This book will show you how to build many different types of websites using the Drupal web publishing platform. Whether you're promoting your rock band or...
Arguably, Drupal is an excellent CMS; it’s used by “hundreds of thousands of projects” (from professional to proprietary to educational); it’s the platform I selected for my most recent DH project; and it’s one I’d recommend to others (it’s learnable; teachable; extensible). But I would by no means necessarily advocate Drupal over any other CMS.
Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive, which differs from standard SQL.