dinoco_schema.sql

  1. CREATE TABLE "eventos" (
  2. "_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  3. "fecha" TEXT NOT NULL,
  4. "nombre" TEXT NOT NULL,
  5. "horas" REAL,
  6. "id_tipo" INTEGER
  7. );
  8. CREATE TABLE sqlite_sequence(name,seq);
  9. CREATE TABLE "tipos" (
  10. "_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  11. "tipo" TEXT NOT NULL
  12. );
  13. CREATE UNIQUE INDEX "tipo" ON tipos (tipo ASC);
  14.  

Proinf.net