dev.sql 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. PRAGMA foreign_keys=OFF;
  2. BEGIN TRANSACTION;
  3. CREATE TABLE IF NOT EXISTS "zlgmcu"(
  4. "idx" INTEGER NOT NULL UNIQUE,
  5. "devid" TEXT
  6. );
  7. INSERT INTO zlgmcu VALUES(0,NULL);
  8. CREATE TABLE IF NOT EXISTS "gt" (
  9. "idx" INTEGER NOT NULL UNIQUE,
  10. "devid" TEXT
  11. );
  12. INSERT INTO gt VALUES(1,NULL);
  13. CREATE TABLE IF NOT EXISTS "gaotai" (
  14. "idx" INTEGER NOT NULL UNIQUE,
  15. "devid" TEXT
  16. );
  17. INSERT INTO gaotai VALUES(1,NULL);
  18. CREATE TABLE IF NOT EXISTS "n9" (
  19. "idx" INTEGER NOT NULL UNIQUE,
  20. "devid" TEXT
  21. );
  22. INSERT INTO n9 VALUES(1,NULL);
  23. CREATE TABLE IF NOT EXISTS "kelong" (
  24. "idx" INTEGER NOT NULL UNIQUE,
  25. "devid" TEXT
  26. );
  27. INSERT INTO kelong VALUES(1,NULL);
  28. CREATE TABLE IF NOT EXISTS "adl200" (
  29. "idx" INTEGER NOT NULL UNIQUE,
  30. "devid" TEXT
  31. );
  32. INSERT INTO adl200 VALUES(1,NULL);
  33. CREATE TABLE IF NOT EXISTS "yf2825" (
  34. "idx" INTEGER NOT NULL UNIQUE,
  35. "devid" TEXT
  36. );
  37. INSERT INTO yf2825 VALUES(1,NULL);
  38. CREATE TABLE IF NOT EXISTS "rh811ad053f" (
  39. "idx" INTEGER NOT NULL UNIQUE,
  40. "devid" TEXT
  41. );
  42. INSERT INTO rh811ad053f VALUES(1,NULL);
  43. CREATE TABLE IF NOT EXISTS "cd1f3300" (
  44. "idx" INTEGER NOT NULL UNIQUE,
  45. "devid" TEXT
  46. );
  47. INSERT INTO cd1f3300 VALUES(1,NULL);
  48. CREATE TABLE IF NOT EXISTS "sdcs" (
  49. "idx" INTEGER NOT NULL UNIQUE,
  50. "devid" TEXT
  51. );
  52. INSERT INTO sdcs VALUES(1,NULL);
  53. CREATE TABLE IF NOT EXISTS "mc0051gs" (
  54. "idx" INTEGER NOT NULL UNIQUE,
  55. "devid" TEXT
  56. );
  57. INSERT INTO mc0051gs VALUES(1,NULL);
  58. CREATE TABLE IF NOT EXISTS "tongfei" (
  59. "idx" INTEGER NOT NULL UNIQUE,
  60. "devid" TEXT
  61. );
  62. INSERT INTO tongfei VALUES(1,NULL);
  63. CREATE TABLE IF NOT EXISTS "evc" (
  64. "idx" INTEGER NOT NULL UNIQUE,
  65. "devid" TEXT
  66. );
  67. INSERT INTO evc VALUES(1,NULL);
  68. CREATE TABLE IF NOT EXISTS "zh200" (
  69. "idx" INTEGER NOT NULL UNIQUE,
  70. "devid" TEXT
  71. );
  72. INSERT INTO zh200 VALUES(1,NULL);
  73. CREATE TABLE IF NOT EXISTS "rs311" (
  74. "idx" INTEGER NOT NULL UNIQUE,
  75. "devid" TEXT
  76. );
  77. INSERT INTO rs311 VALUES(1,NULL);
  78. CREATE TABLE IF NOT EXISTS "cw1310" (
  79. "idx" INTEGER NOT NULL UNIQUE,
  80. "devid" TEXT
  81. );
  82. INSERT INTO cw1310 VALUES(1,NULL);
  83. INSERT INTO cw1310 VALUES(2,NULL);
  84. INSERT INTO cw1310 VALUES(3,NULL);
  85. INSERT INTO cw1310 VALUES(4,NULL);
  86. INSERT INTO cw1310 VALUES(5,NULL);
  87. CREATE TABLE IF NOT EXISTS "eep07c" (
  88. "idx" INTEGER NOT NULL UNIQUE,
  89. "devid" TEXT
  90. );
  91. INSERT INTO eep07c VALUES(1,NULL);
  92. INSERT INTO eep07c VALUES(2,NULL);
  93. INSERT INTO eep07c VALUES(3,NULL);
  94. INSERT INTO eep07c VALUES(4,NULL);
  95. INSERT INTO eep07c VALUES(5,NULL);
  96. COMMIT;