Android Open Source - watchme Has Tag Table

From Project

Back to project page watchme.

License

The source code is released under:

Copyright (c) 2012 Johan Brook, Robin Andersson, Lisa Stenberg, Mattias Henriksson Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documen...

If you think the Android project watchme listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

/**
 *  HasTagsTable.java// w  ww.ja  v a  2  s .  com
 *
 *  The table that holds data for Movies and Tags.
 * 
 *  COLUMN_MOVIE_ID is a foreign key to COLUMN_MOVIE_ID in MoviesTable
 *  COLUMN_TAG_ID is a foreign key to COLUMN_TAG_ID in TagsTable
 *
 *  @author lisastenberg
 *  @copyright (c) 2012 Johan Brook, Robin Andersson, Lisa Stenberg, Mattias Henriksson
 *  @license MIT
 */

package se.chalmers.watchme.database;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class HasTagTable {
  public static final String TABLE_HAS_TAG = "hastag";

  public static final String COLUMN_MOVIE_ID = "movieid";
  public static final String COLUMN_TAG_ID = "tagid";

  private static final String CREATE_HAS_TAG_TABLE = "CREATE TABLE "
      + TABLE_HAS_TAG + "(" + 
      COLUMN_MOVIE_ID + " INTEGER," + 
      COLUMN_TAG_ID + " INTEGER," + 
      "PRIMARY KEY(" + COLUMN_MOVIE_ID + ", " + COLUMN_TAG_ID + "), " + 
      "FOREIGN KEY(" + COLUMN_MOVIE_ID + ") REFERENCES " + 
      MoviesTable.TABLE_MOVIES + "(" + MoviesTable.COLUMN_MOVIE_ID +
      ") " +
      "FOREIGN KEY(" + COLUMN_TAG_ID + ") REFERENCES " + 
      TagsTable.TABLE_TAGS + "(" + TagsTable.COLUMN_TAG_ID + 
      ") " +
      ")";
  
  public static void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_HAS_TAG_TABLE);
  }

  public static void onUpgrade(SQLiteDatabase db, int oldVersion,
      int newVersion) {
    Log.w(HasTagTable.class.getName(), "Upgrading database from version "
        + oldVersion + " to " + newVersion
        + ", which will destroy all old data");
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_HAS_TAG);
    onCreate(db);
  }
}

Java Source Code List