title: SQLITEASSETHELPER proper upgrade script
body: <p>I don't understand the documentation and I'm worried of accidentally dropping my table in my DB and corrupting the original file if I do this wrong. </p>
  
  <p><a href="https://github.com/jgilfelt/android-sqlite-asset-helper" rel="nofollow">https://github.com/jgilfelt/android-sqlite-asset-helper</a></p>
  
  <p>in reference to adding a column with values. The following code is provided via the creators git-hub sample</p>
  
  <pre><code>    -- add a FullNames column to Employees
  ALTER TABLE "Employees" RENAME TO 'Employees_ME_TMP';
  
  CREATE TABLE "Employees" 
  (
      "EmployeeID" int NOT NULL,
      "LastName" varchar(20) NOT NULL,
      "FirstName" varchar(10) NOT NULL,
      "FullName" varchar(150),
      PRIMARY KEY ("EmployeeID")
  );
  
  INSERT INTO "Employees"  
  (
      "EmployeeID", 
      "LastName", 
      "FirstName", 
      "FullName"
  ) 
  SELECT 
      "EmployeeID", 
      "LastName", 
      "FirstName", 
      "FirstName" || ' ' || "LastName" 
  FROM 
      "Employees_ME_TMP";
  
  DROP TABLE "Employees_ME_TMP";
  </code></pre>
  
  <p>If I need to add two columns and then insert a bunch values into those to columns, would this be the right syntax?</p>
  
  <pre><code>    -- add a FullNames column and NickName to Employees
  ALTER TABLE "Employees" RENAME TO 'Employees_ME_TMP';
  
  CREATE TABLE "Employees" 
  (
      "EmployeeID" int NOT NULL,
      "LastName" varchar(20) NOT NULL,
      "FirstName" varchar(10) NOT NULL,
      "FullName" varchar(150),
      "NickName" varchar(150),
      PRIMARY KEY ("EmployeeID")
  );
  
      INSERT INTO Employees (FullName, NickName)
      VALUES ('Tyler Durden','Jack')
      WHERE rowid = 18;
  
      INSERT INTO Employees (FullName, NickName)
      VALUES ('Donnie Darko','Jake')
      WHERE rowid = 19;
  
  DROP TABLE "Employees_ME_TMP";
  </code></pre>