Back to project page magicAnnotator.
The source code is released under:
GNU General Public License
If you think the Android project magicAnnotator listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
/* * Magic Annotator - The only thing you need to write down whatever you want. * Copyright (C) 2013 Nahuel Barrios <barrios.nahuel@gmail.com>. *// w w w .j a v a2s . c o m * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ /** * Created by: Nahuel Barrios. * On: 02/10/12 at 11:10hs. */ package com.nbempire.android.magicannotator.storage.schema; import com.nbempire.android.magicannotator.util.android.database.SQLiteUtil; /** * @author Nahuel Barrios. * @since 10 */ public abstract class MarketItemTable { /** * The name of the table. */ public static final String TABLE_NAME = "marketItems"; // Here goes the table columns... /** * Auto-incremental column that starts at 1 by default. */ public static final String ID = "id"; public static final String DESCRIPTION = "description"; public static final String QUANTITY = "quantity"; public static final String CHECKED = "checked"; /** * Script for create the table. * * @return SQL Script to create the MarketItem table. * * @since 10 */ public static String getCreateScript() { return "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" + ID + " INTEGER PRIMARY KEY AUTOINCREMENT" + ", " + DESCRIPTION + " varchar" + ", " + QUANTITY + " INT(3)" + ", " + CHECKED + " INTEGER" + ");"; } /** * Creates a SQL script to drop this table. * * @return SQL script to drop the MarketItem table. * * @since 10 */ public static String getDropScript() { return SQLiteUtil.getDropTableScript(TABLE_NAME); } }