Only first table in create table statement being created

Posted by Craig on Stack Overflow See other posts from Stack Overflow or by Craig
Published on 2010-05-28T10:21:16Z Indexed on 2010/05/28 10:31 UTC
Read the original article Hit count: 516

Filed under:
|
|

The table "credentials" does show up in the adb shell. I've checked logcat and it doesn't seem to report a problem...

   private static final String DATABASE_CREATE =
        "create table credentials (_id integer primary key autoincrement, "
                + "username text not null, password text not null, "
                + "lastupdate text);"
      + "create table user (_id integer primary key autoincrement, "
                + "firstname text not null, "
                + "lastname text not null);"
      + "create table phone (_phoneid integer primary key autoincrement, "
                + "userid integer not null, phonetype text not null, "
                + "phonenumber text not null);"
      + "create table email (_emailid integer primary key autoincrement, "
                + "userid integer not null, emailtype text not null, "
                + "emailaddress text not null);"
      + "create table address (_addressid integer primary key autoincrement,"
                + "userid integer not null, addresstype text not null, "
                + "address text not null);"
      + "create table instantmessaging (_imid integer primary key autoincrement, "
                + "userid integer not null, imtype text not null, "
                + "imaccount text not null);";

I've been pouring over this and I bet its some silly syntax typo! Or, at least I hope it is something trivial ;-)

Craig

© Stack Overflow or respective owner

Related posts about android

Related posts about sqlite