dev_r.sql 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  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,'000000004e7fe5149f74d3df3d230000');
  13. CREATE TABLE IF NOT EXISTS "n9" (
  14. "idx" INTEGER NOT NULL UNIQUE,
  15. "devid" TEXT
  16. );
  17. INSERT INTO n9 VALUES(1,'000000004e7fe4b89f74d3df3d230000');
  18. CREATE TABLE IF NOT EXISTS "adl200" (
  19. "idx" INTEGER NOT NULL UNIQUE,
  20. "devid" TEXT
  21. );
  22. INSERT INTO adl200 VALUES(1,'000000004e7fe5bb9f74d3df3d230000');
  23. CREATE TABLE IF NOT EXISTS "yf2825" (
  24. "idx" INTEGER NOT NULL UNIQUE,
  25. "devid" TEXT
  26. );
  27. INSERT INTO yf2825 VALUES(1,'000000004e7fe66d9f74d3df3d230000');
  28. CREATE TABLE IF NOT EXISTS "rh811ad053f" (
  29. "idx" INTEGER NOT NULL UNIQUE,
  30. "devid" TEXT
  31. );
  32. INSERT INTO rh811ad053f VALUES(1,'000000004e7fe5fc9f74d3df3d230000');
  33. CREATE TABLE IF NOT EXISTS "cd1f3300" (
  34. "idx" INTEGER NOT NULL UNIQUE,
  35. "devid" TEXT
  36. );
  37. INSERT INTO cd1f3300 VALUES(1,'000000004e7fe62b9f74d3df3d230000');
  38. CREATE TABLE IF NOT EXISTS "sdcs" (
  39. "idx" INTEGER NOT NULL UNIQUE,
  40. "devid" TEXT
  41. );
  42. INSERT INTO sdcs VALUES(1,'000000004e7fe78a9f74d3df3d230000');
  43. CREATE TABLE IF NOT EXISTS "mc0051gs" (
  44. "idx" INTEGER NOT NULL UNIQUE,
  45. "devid" TEXT
  46. );
  47. INSERT INTO mc0051gs VALUES(1,'000000004e7fe56e9f74d3df3d230000');
  48. CREATE TABLE IF NOT EXISTS "tongfei" (
  49. "idx" INTEGER NOT NULL UNIQUE,
  50. "devid" TEXT
  51. );
  52. INSERT INTO tongfei VALUES(1,NULL);
  53. CREATE TABLE IF NOT EXISTS "zh200" (
  54. "idx" INTEGER NOT NULL UNIQUE,
  55. "devid" TEXT
  56. );
  57. INSERT INTO zh200 VALUES(1,'000000004e7fe4589f74d3df3d230000');
  58. CREATE TABLE IF NOT EXISTS "cw1310" (
  59. "idx" INTEGER NOT NULL UNIQUE,
  60. "devid" TEXT
  61. );
  62. INSERT INTO cw1310 VALUES(1,'000000004f6874ea7774d3df3d230000');
  63. INSERT INTO cw1310 VALUES(2,'000000004f6875077774d3df3d230000');
  64. INSERT INTO cw1310 VALUES(3,'000000004f6875267774d3df3d230000');
  65. INSERT INTO cw1310 VALUES(4,'000000004f6875447774d3df3d230000');
  66. INSERT INTO cw1310 VALUES(5,'000000004f6875617774d3df3d230000');
  67. COMMIT;