dinoco_dump.sql

  1. PRAGMA foreign_keys=OFF;
  2. BEGIN TRANSACTION;
  3. CREATE TABLE "eventos" (
  4. "_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  5. "fecha" TEXT NOT NULL,
  6. "nombre" TEXT NOT NULL,
  7. "horas" REAL,
  8. "id_tipo" INTEGER
  9. );
  10. INSERT INTO "eventos" VALUES(1,'2018-11-15','Antonio en Barcelona',7.0,1);
  11. INSERT INTO "eventos" VALUES(2,'2018-11-15','Gómez en Sevilla',1.0,3);
  12. INSERT INTO "eventos" VALUES(3,'2018-11-16','Pérez en Baracaldo',2.0,4);
  13. INSERT INTO "eventos" VALUES(4,'2018-11-16','Rocio en Sabadell',3.0,3);
  14. INSERT INTO "eventos" VALUES(5,'2018-11-16','Montse en Calatayud',2.0,3);
  15. INSERT INTO "eventos" VALUES(6,'2018-11-17','María en Leganés',1.0,2);
  16. INSERT INTO "eventos" VALUES(7,'2018-11-19','Carlos en Madrid',2.0,5);
  17. INSERT INTO "eventos" VALUES(8,'2018-11-20','Antonio en Barcelona',2.0,1);
  18. INSERT INTO "eventos" VALUES(9,'2018-11-22','Luis en Terrassa',5.0,4);
  19. INSERT INTO "eventos" VALUES(10,'2018-11-23','Pepe en Huelva',3.0,6);
  20. CREATE TABLE "tipos" (
  21. "_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  22. "tipo" TEXT NOT NULL
  23. );
  24. INSERT INTO "tipos" VALUES(1,'Deportivo');
  25. INSERT INTO "tipos" VALUES(2,'Cultural');
  26. INSERT INTO "tipos" VALUES(3,'Tecnológico');
  27. INSERT INTO "tipos" VALUES(4,'Empresarial');
  28. INSERT INTO "tipos" VALUES(5,'Infantil');
  29. INSERT INTO "tipos" VALUES(6,'Boda');
  30. DELETE FROM sqlite_sequence;
  31. INSERT INTO "sqlite_sequence" VALUES('tipos',6);
  32. INSERT INTO "sqlite_sequence" VALUES('eventos',10);
  33. CREATE UNIQUE INDEX "tipo" ON tipos (tipo ASC);
  34. COMMIT;
  35.  

Proinf.net