Guest User

Untitled

a guest
Jul 17th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. sqlite> .schema people_person
  2. CREATE TABLE "people_person" ("picture" varchar(200), "first_name" varchar(64), "last_name" varchar(64), "description" text, "web_page" varchar(200), "visitor" bool NOT NULL DEFAULT False, "e_mail" varchar(75), "rank_id" integer, "current" bool, "public" bool, "mid_name" varchar(64), "id" integer PRIMARY KEY);
  3. sqlite> select 'production',visitor from people_person;
  4. production|False
  5. production|False
  6. production|False
  7. production|False
  8. production|False
  9. production|False
  10. production|False
  11. production|False
  12. production|False
  13. production|False
  14. production|False
  15. production|False
  16. production|False
  17. production|False
  18. production|False
  19. production|False
  20. production|False
  21. production|False
  22. production|False
  23. production|False
  24. production|False
  25. production|False
  26. production|False
  27. production|False
  28. production|False
  29. production|False
  30. production|False
  31. production|False
  32. production|False
  33.  
  34.  
  35.  
  36. sqlite> .schema people_person
  37. CREATE TABLE "people_person" ("picture" varchar(200), "first_name" varchar(64), "last_name" varchar(64), "description" text, "web_page" varchar(200), "visitor" bool NOT NULL DEFAULT False, "e_mail" varchar(75), "rank_id" integer, "id" integer PRIMARY KEY, "current" bool, "mid_name" varchar(64), "public" bool);
  38. sqlite> select 'dev', visitor from people_person;
  39. dev|0
  40. dev|0
  41. dev|0
  42. dev|0
  43. dev|0
  44. dev|0
  45. dev|0
  46. dev|0
  47. dev|0
  48. dev|1
  49. dev|0
  50. dev|0
  51. dev|0
  52. dev|0
  53. dev|0
  54. dev|0
  55. dev|0
  56. dev|0
  57. dev|0
  58. dev|0
  59. dev|1
  60. dev|0
  61. dev|0
  62. dev|1
  63. dev|0
Add Comment
Please, Sign In to add comment