--- /dev/null
+package adullact.publicrowdfunding.model.local.database;
+
+import android.provider.BaseColumns;
+
+/**
+ * @author Ferrand and Nelaupe
+ */
+public class ProjectsTable implements BaseColumns {
+ private ProjectsTable() {}
+
+ /* ---- Meta ---- */
+ public static final String TABLE_NAME = "Project";
+ /* -------------- */
+
+ /* ---- Fields ---- */
+ public static final String COLUMN_NAME_ID = "id";
+ public static final String COLUMN_NAME_ACTIVE = "active";
+ public static final String COLUMN_NAME_TITLE = "title";
+ public static final String COLUMN_NAME_DESCRIPTION = "description";
+ public static final String COLUMN_NAME_VALIDATE = "validate";
+ public static final String COLUMN_NAME_PROPOSED_BY = "proposedBy";
+ public static final String COLUMN_NAME_REQUESTED_FUNDING = "requestedFunding";
+ public static final String COLUMN_NAME_CURRENT_FUNDING = "currentFunding";
+ public static final String COLUMN_NAME_CREATION_DATE = "creationDate";
+ public static final String COLUMN_NAME_BEGIN_DATE = "beginDate";
+ public static final String COLUMN_NAME_END_DATE = "endDate";
+ public static final String COLUMN_NAME_LATITUDE = "latitude";
+ public static final String COLUMN_NAME_LONGITUDE = "longitude";
+ public static final String COLUMN_NAME_ILLUSTRATION = "illustration";
+ public static final String COLUMN_NAME_CONTACT_ADDRESS = "contactAddress";
+ public static final String COLUMN_NAME_CONTACT_PHONE = "contactPhone";
+ public static final String COLUMN_NAME_CONTACT_WEBSITE = "contactWebsite";
+ /* ---------------- */
+
+ /* ---- Type ---- */
+ public static final String INTEGER_TYPE = " INTEGER";
+ public static final String NUMERIC_TYPE = " NUMERIC";
+ public static final String TEXT_TYPE = " TEXT";
+ /* -------------- */
+
+ /* -- Attributes/separator -- */
+ public static final String COMMA = ",";
+ public static final String NOT_NULL = " NOT NULL";
+ /* ----------------------- */
+
+ public static final String SQL_CREATE =
+ "CREATE TABLE " + TABLE_NAME + " (" +
+ _ID + " INTEGER PRIMARY KEY," +
+ COLUMN_NAME_ID + INTEGER_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_ACTIVE + INTEGER_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_TITLE + TEXT_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_DESCRIPTION + TEXT_TYPE + COMMA +
+ COLUMN_NAME_VALIDATE + INTEGER_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_PROPOSED_BY + TEXT_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_REQUESTED_FUNDING + NUMERIC_TYPE + COMMA +
+ COLUMN_NAME_CURRENT_FUNDING + NUMERIC_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_CREATION_DATE + TEXT_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_BEGIN_DATE + TEXT_TYPE + COMMA +
+ COLUMN_NAME_END_DATE + TEXT_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_LATITUDE + NUMERIC_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_LONGITUDE + NUMERIC_TYPE + COMMA +
+ COLUMN_NAME_ILLUSTRATION + INTEGER_TYPE + NOT_NULL + COMMA +
+ COLUMN_NAME_CONTACT_ADDRESS + TEXT_TYPE + COMMA +
+ COLUMN_NAME_CONTACT_PHONE + TEXT_TYPE + COMMA +
+ COLUMN_NAME_CONTACT_WEBSITE + TEXT_TYPE +
+ ")";
+
+ public static final String SQL_DELETE = "DROP TABLE IF EXISTS " + TABLE_NAME;
+}