pano.sql 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : localhost_3306
  4. Source Server Version : 50617
  5. Source Host : localhost:3306
  6. Source Database : pano
  7. Target Server Type : MYSQL
  8. Target Server Version : 50617
  9. File Encoding : 65001
  10. Date: 2016-04-25 15:55:29
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for comment
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `comment`;
  17. CREATE TABLE `comment` (
  18. `cid` int(10) NOT NULL AUTO_INCREMENT,
  19. `uid` int(10) DEFAULT NULL,
  20. `pid` int(10) DEFAULT NULL,
  21. `comment` varchar(255) DEFAULT NULL,
  22. PRIMARY KEY (`cid`),
  23. KEY `comment_uid` (`uid`),
  24. KEY `comment_pid` (`pid`),
  25. CONSTRAINT `comment_pid` FOREIGN KEY (`pid`) REFERENCES `photo` (`pid`),
  26. CONSTRAINT `comment_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
  27. ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
  28. -- ----------------------------
  29. -- Records of comment
  30. -- ----------------------------
  31. INSERT INTO `comment` VALUES ('23', '7', '19', '东区操场');
  32. INSERT INTO `comment` VALUES ('24', '7', '20', '666');
  33. INSERT INTO `comment` VALUES ('25', '7', '21', '梅园');
  34. INSERT INTO `comment` VALUES ('26', '7', '22', '二食堂有很多好吃的');
  35. INSERT INTO `comment` VALUES ('27', '7', '23', '冬天的诗琴湖');
  36. INSERT INTO `comment` VALUES ('28', '7', '24', '绿色环保');
  37. INSERT INTO `comment` VALUES ('29', '7', '25', '新A哈哈哈');
  38. INSERT INTO `comment` VALUES ('30', '7', '26', '');
  39. INSERT INTO `comment` VALUES ('31', '7', '27', '');
  40. INSERT INTO `comment` VALUES ('32', '7', '28', '');
  41. INSERT INTO `comment` VALUES ('33', '7', '29', '');
  42. INSERT INTO `comment` VALUES ('34', '7', '30', '新知楼夜景');
  43. INSERT INTO `comment` VALUES ('35', '7', '31', '');
  44. INSERT INTO `comment` VALUES ('36', '7', '32', '');
  45. INSERT INTO `comment` VALUES ('37', '7', '33', '');
  46. INSERT INTO `comment` VALUES ('38', '7', '34', '');
  47. INSERT INTO `comment` VALUES ('39', '7', '35', '梅园');
  48. INSERT INTO `comment` VALUES ('40', '7', '36', '开学啦');
  49. INSERT INTO `comment` VALUES ('41', '7', '37', '');
  50. INSERT INTO `comment` VALUES ('42', '7', '38', '');
  51. INSERT INTO `comment` VALUES ('43', '7', '38', '');
  52. INSERT INTO `comment` VALUES ('44', '7', '38', '');
  53. INSERT INTO `comment` VALUES ('45', '9', null, '');
  54. INSERT INTO `comment` VALUES ('46', '7', '39', '');
  55. INSERT INTO `comment` VALUES ('47', '9', null, '');
  56. INSERT INTO `comment` VALUES ('48', '7', '40', '');
  57. INSERT INTO `comment` VALUES ('49', '7', '41', '');
  58. INSERT INTO `comment` VALUES ('50', '7', '42', '');
  59. INSERT INTO `comment` VALUES ('51', '7', '43', '');
  60. INSERT INTO `comment` VALUES ('52', '7', '44', '手绘案科');
  61. INSERT INTO `comment` VALUES ('53', '7', '45', '手绘安科2.0');
  62. -- ----------------------------
  63. -- Table structure for node
  64. -- ----------------------------
  65. DROP TABLE IF EXISTS `node`;
  66. CREATE TABLE `node` (
  67. `nodeid` int(10) NOT NULL,
  68. PRIMARY KEY (`nodeid`)
  69. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  70. -- ----------------------------
  71. -- Records of node
  72. -- ----------------------------
  73. INSERT INTO `node` VALUES ('1');
  74. INSERT INTO `node` VALUES ('2');
  75. INSERT INTO `node` VALUES ('3');
  76. INSERT INTO `node` VALUES ('4');
  77. INSERT INTO `node` VALUES ('5');
  78. INSERT INTO `node` VALUES ('6');
  79. INSERT INTO `node` VALUES ('7');
  80. INSERT INTO `node` VALUES ('8');
  81. INSERT INTO `node` VALUES ('9');
  82. INSERT INTO `node` VALUES ('10');
  83. INSERT INTO `node` VALUES ('11');
  84. INSERT INTO `node` VALUES ('12');
  85. INSERT INTO `node` VALUES ('13');
  86. INSERT INTO `node` VALUES ('15');
  87. INSERT INTO `node` VALUES ('16');
  88. INSERT INTO `node` VALUES ('17');
  89. INSERT INTO `node` VALUES ('21');
  90. INSERT INTO `node` VALUES ('23');
  91. INSERT INTO `node` VALUES ('24');
  92. INSERT INTO `node` VALUES ('25');
  93. INSERT INTO `node` VALUES ('26');
  94. INSERT INTO `node` VALUES ('27');
  95. INSERT INTO `node` VALUES ('28');
  96. INSERT INTO `node` VALUES ('29');
  97. INSERT INTO `node` VALUES ('30');
  98. INSERT INTO `node` VALUES ('31');
  99. INSERT INTO `node` VALUES ('32');
  100. INSERT INTO `node` VALUES ('33');
  101. INSERT INTO `node` VALUES ('35');
  102. INSERT INTO `node` VALUES ('36');
  103. INSERT INTO `node` VALUES ('37');
  104. INSERT INTO `node` VALUES ('46');
  105. INSERT INTO `node` VALUES ('47');
  106. INSERT INTO `node` VALUES ('50');
  107. INSERT INTO `node` VALUES ('51');
  108. INSERT INTO `node` VALUES ('52');
  109. INSERT INTO `node` VALUES ('53');
  110. INSERT INTO `node` VALUES ('54');
  111. INSERT INTO `node` VALUES ('55');
  112. INSERT INTO `node` VALUES ('56');
  113. INSERT INTO `node` VALUES ('57');
  114. INSERT INTO `node` VALUES ('58');
  115. INSERT INTO `node` VALUES ('59');
  116. INSERT INTO `node` VALUES ('60');
  117. INSERT INTO `node` VALUES ('61');
  118. INSERT INTO `node` VALUES ('62');
  119. INSERT INTO `node` VALUES ('63');
  120. INSERT INTO `node` VALUES ('64');
  121. INSERT INTO `node` VALUES ('65');
  122. INSERT INTO `node` VALUES ('66');
  123. INSERT INTO `node` VALUES ('67');
  124. INSERT INTO `node` VALUES ('68');
  125. INSERT INTO `node` VALUES ('69');
  126. INSERT INTO `node` VALUES ('70');
  127. INSERT INTO `node` VALUES ('71');
  128. INSERT INTO `node` VALUES ('72');
  129. INSERT INTO `node` VALUES ('73');
  130. INSERT INTO `node` VALUES ('74');
  131. INSERT INTO `node` VALUES ('75');
  132. INSERT INTO `node` VALUES ('76');
  133. INSERT INTO `node` VALUES ('77');
  134. INSERT INTO `node` VALUES ('78');
  135. INSERT INTO `node` VALUES ('79');
  136. INSERT INTO `node` VALUES ('80');
  137. INSERT INTO `node` VALUES ('81');
  138. INSERT INTO `node` VALUES ('82');
  139. INSERT INTO `node` VALUES ('83');
  140. INSERT INTO `node` VALUES ('85');
  141. INSERT INTO `node` VALUES ('86');
  142. INSERT INTO `node` VALUES ('87');
  143. INSERT INTO `node` VALUES ('88');
  144. INSERT INTO `node` VALUES ('89');
  145. INSERT INTO `node` VALUES ('90');
  146. INSERT INTO `node` VALUES ('91');
  147. INSERT INTO `node` VALUES ('92');
  148. INSERT INTO `node` VALUES ('93');
  149. INSERT INTO `node` VALUES ('94');
  150. INSERT INTO `node` VALUES ('95');
  151. INSERT INTO `node` VALUES ('96');
  152. INSERT INTO `node` VALUES ('97');
  153. INSERT INTO `node` VALUES ('98');
  154. INSERT INTO `node` VALUES ('99');
  155. INSERT INTO `node` VALUES ('100');
  156. INSERT INTO `node` VALUES ('101');
  157. INSERT INTO `node` VALUES ('102');
  158. INSERT INTO `node` VALUES ('103');
  159. INSERT INTO `node` VALUES ('104');
  160. INSERT INTO `node` VALUES ('105');
  161. INSERT INTO `node` VALUES ('106');
  162. INSERT INTO `node` VALUES ('107');
  163. INSERT INTO `node` VALUES ('108');
  164. INSERT INTO `node` VALUES ('109');
  165. INSERT INTO `node` VALUES ('110');
  166. INSERT INTO `node` VALUES ('111');
  167. INSERT INTO `node` VALUES ('112');
  168. INSERT INTO `node` VALUES ('113');
  169. INSERT INTO `node` VALUES ('114');
  170. INSERT INTO `node` VALUES ('115');
  171. INSERT INTO `node` VALUES ('116');
  172. INSERT INTO `node` VALUES ('117');
  173. INSERT INTO `node` VALUES ('118');
  174. INSERT INTO `node` VALUES ('119');
  175. INSERT INTO `node` VALUES ('120');
  176. INSERT INTO `node` VALUES ('121');
  177. INSERT INTO `node` VALUES ('122');
  178. INSERT INTO `node` VALUES ('123');
  179. INSERT INTO `node` VALUES ('124');
  180. INSERT INTO `node` VALUES ('125');
  181. INSERT INTO `node` VALUES ('126');
  182. INSERT INTO `node` VALUES ('127');
  183. -- ----------------------------
  184. -- Table structure for node_coordinate
  185. -- ----------------------------
  186. DROP TABLE IF EXISTS `node_coordinate`;
  187. CREATE TABLE `node_coordinate` (
  188. `node` int(10) DEFAULT NULL,
  189. `x` float(10,2) DEFAULT NULL,
  190. `y` float(10,2) DEFAULT NULL
  191. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  192. -- ----------------------------
  193. -- Records of node_coordinate
  194. -- ----------------------------
  195. INSERT INTO `node_coordinate` VALUES ('127', '268.00', '497.00');
  196. INSERT INTO `node_coordinate` VALUES ('126', '16.00', '427.00');
  197. INSERT INTO `node_coordinate` VALUES ('125', '8.00', '497.00');
  198. INSERT INTO `node_coordinate` VALUES ('124', '35.00', '497.00');
  199. INSERT INTO `node_coordinate` VALUES ('123', '67.00', '497.00');
  200. INSERT INTO `node_coordinate` VALUES ('122', '35.00', '661.00');
  201. INSERT INTO `node_coordinate` VALUES ('121', '29.00', '704.00');
  202. INSERT INTO `node_coordinate` VALUES ('120', '116.00', '713.00');
  203. INSERT INTO `node_coordinate` VALUES ('119', '203.00', '728.00');
  204. INSERT INTO `node_coordinate` VALUES ('118', '332.00', '769.00');
  205. INSERT INTO `node_coordinate` VALUES ('117', '260.00', '672.00');
  206. INSERT INTO `node_coordinate` VALUES ('116', '517.00', '519.00');
  207. INSERT INTO `node_coordinate` VALUES ('115', '639.00', '273.00');
  208. INSERT INTO `node_coordinate` VALUES ('114', '616.00', '329.00');
  209. INSERT INTO `node_coordinate` VALUES ('113', '601.00', '511.00');
  210. INSERT INTO `node_coordinate` VALUES ('112', '655.00', '549.00');
  211. INSERT INTO `node_coordinate` VALUES ('111', '603.00', '657.00');
  212. INSERT INTO `node_coordinate` VALUES ('110', '632.00', '755.00');
  213. INSERT INTO `node_coordinate` VALUES ('109', '696.00', '681.00');
  214. INSERT INTO `node_coordinate` VALUES ('108', '667.00', '417.00');
  215. INSERT INTO `node_coordinate` VALUES ('107', '672.00', '376.00');
  216. INSERT INTO `node_coordinate` VALUES ('106', '678.00', '348.00');
  217. INSERT INTO `node_coordinate` VALUES ('105', '679.00', '322.00');
  218. INSERT INTO `node_coordinate` VALUES ('104', '647.00', '309.00');
  219. INSERT INTO `node_coordinate` VALUES ('103', '628.00', '339.00');
  220. INSERT INTO `node_coordinate` VALUES ('102', '621.00', '392.00');
  221. INSERT INTO `node_coordinate` VALUES ('101', '616.00', '430.00');
  222. INSERT INTO `node_coordinate` VALUES ('100', '652.00', '445.00');
  223. INSERT INTO `node_coordinate` VALUES ('85', '1033.50', '390.50');
  224. INSERT INTO `node_coordinate` VALUES ('99', '787.00', '588.00');
  225. INSERT INTO `node_coordinate` VALUES ('98', '796.00', '547.00');
  226. INSERT INTO `node_coordinate` VALUES ('97', '839.00', '559.00');
  227. INSERT INTO `node_coordinate` VALUES ('96', '822.00', '616.00');
  228. INSERT INTO `node_coordinate` VALUES ('95', '806.00', '674.00');
  229. INSERT INTO `node_coordinate` VALUES ('94', '808.00', '733.00');
  230. INSERT INTO `node_coordinate` VALUES ('93', '842.00', '752.00');
  231. INSERT INTO `node_coordinate` VALUES ('92', '950.00', '852.00');
  232. INSERT INTO `node_coordinate` VALUES ('91', '908.00', '759.00');
  233. INSERT INTO `node_coordinate` VALUES ('90', '979.00', '778.00');
  234. INSERT INTO `node_coordinate` VALUES ('89', '996.00', '723.00');
  235. INSERT INTO `node_coordinate` VALUES ('88', '1017.00', '603.00');
  236. INSERT INTO `node_coordinate` VALUES ('87', '1026.00', '562.00');
  237. INSERT INTO `node_coordinate` VALUES ('86', '1019.00', '444.00');
  238. INSERT INTO `node_coordinate` VALUES ('83', '1009.00', '274.00');
  239. INSERT INTO `node_coordinate` VALUES ('82', '943.00', '256.00');
  240. INSERT INTO `node_coordinate` VALUES ('81', '889.00', '242.00');
  241. INSERT INTO `node_coordinate` VALUES ('80', '798.00', '219.00');
  242. INSERT INTO `node_coordinate` VALUES ('79', '806.00', '182.00');
  243. INSERT INTO `node_coordinate` VALUES ('78', '763.00', '81.00');
  244. INSERT INTO `node_coordinate` VALUES ('77', '741.00', '163.00');
  245. INSERT INTO `node_coordinate` VALUES ('76', '868.00', '337.00');
  246. INSERT INTO `node_coordinate` VALUES ('75', '752.00', '738.00');
  247. INSERT INTO `node_coordinate` VALUES ('74', '264.00', '564.00');
  248. INSERT INTO `node_coordinate` VALUES ('73', '199.00', '567.00');
  249. INSERT INTO `node_coordinate` VALUES ('72', '264.00', '605.00');
  250. INSERT INTO `node_coordinate` VALUES ('71', '342.00', '576.00');
  251. INSERT INTO `node_coordinate` VALUES ('70', '324.00', '554.00');
  252. INSERT INTO `node_coordinate` VALUES ('69', '404.00', '506.00');
  253. INSERT INTO `node_coordinate` VALUES ('68', '450.00', '509.00');
  254. INSERT INTO `node_coordinate` VALUES ('67', '481.00', '469.00');
  255. INSERT INTO `node_coordinate` VALUES ('66', '509.00', '468.00');
  256. INSERT INTO `node_coordinate` VALUES ('65', '544.00', '467.00');
  257. INSERT INTO `node_coordinate` VALUES ('64', '573.00', '466.00');
  258. INSERT INTO `node_coordinate` VALUES ('63', '605.00', '461.00');
  259. INSERT INTO `node_coordinate` VALUES ('62', '705.00', '296.00');
  260. INSERT INTO `node_coordinate` VALUES ('61', '743.00', '391.00');
  261. INSERT INTO `node_coordinate` VALUES ('60', '931.00', '339.00');
  262. INSERT INTO `node_coordinate` VALUES ('59', '896.00', '326.00');
  263. INSERT INTO `node_coordinate` VALUES ('58', '881.00', '323.00');
  264. INSERT INTO `node_coordinate` VALUES ('57', '810.00', '321.00');
  265. INSERT INTO `node_coordinate` VALUES ('56', '818.00', '345.00');
  266. INSERT INTO `node_coordinate` VALUES ('55', '807.00', '385.00');
  267. INSERT INTO `node_coordinate` VALUES ('54', '847.00', '398.00');
  268. INSERT INTO `node_coordinate` VALUES ('53', '770.00', '400.00');
  269. INSERT INTO `node_coordinate` VALUES ('52', '915.00', '365.00');
  270. INSERT INTO `node_coordinate` VALUES ('51', '903.00', '408.00');
  271. INSERT INTO `node_coordinate` VALUES ('50', '914.00', '441.00');
  272. INSERT INTO `node_coordinate` VALUES ('47', '946.00', '417.00');
  273. INSERT INTO `node_coordinate` VALUES ('46', '935.00', '434.00');
  274. INSERT INTO `node_coordinate` VALUES ('37', '988.00', '455.00');
  275. INSERT INTO `node_coordinate` VALUES ('36', '932.00', '447.00');
  276. INSERT INTO `node_coordinate` VALUES ('35', '974.00', '490.00');
  277. INSERT INTO `node_coordinate` VALUES ('33', '926.00', '471.00');
  278. INSERT INTO `node_coordinate` VALUES ('32', '893.00', '460.00');
  279. INSERT INTO `node_coordinate` VALUES ('31', '901.00', '438.00');
  280. INSERT INTO `node_coordinate` VALUES ('30', '855.00', '422.00');
  281. INSERT INTO `node_coordinate` VALUES ('29', '855.50', '462.50');
  282. INSERT INTO `node_coordinate` VALUES ('28', '880.00', '490.00');
  283. INSERT INTO `node_coordinate` VALUES ('27', '857.00', '565.00');
  284. INSERT INTO `node_coordinate` VALUES ('26', '894.50', '604.50');
  285. INSERT INTO `node_coordinate` VALUES ('25', '916.50', '559.50');
  286. INSERT INTO `node_coordinate` VALUES ('24', '942.00', '583.00');
  287. INSERT INTO `node_coordinate` VALUES ('23', '981.00', '520.00');
  288. INSERT INTO `node_coordinate` VALUES ('21', '998.00', '550.00');
  289. INSERT INTO `node_coordinate` VALUES ('17', '885.00', '642.00');
  290. INSERT INTO `node_coordinate` VALUES ('16', '872.00', '689.00');
  291. INSERT INTO `node_coordinate` VALUES ('15', '866.00', '730.00');
  292. INSERT INTO `node_coordinate` VALUES ('13', '847.00', '816.00');
  293. INSERT INTO `node_coordinate` VALUES ('12', '625.00', '545.00');
  294. INSERT INTO `node_coordinate` VALUES ('11', '825.00', '808.00');
  295. INSERT INTO `node_coordinate` VALUES ('10', '744.00', '786.00');
  296. INSERT INTO `node_coordinate` VALUES ('9', '773.00', '670.00');
  297. INSERT INTO `node_coordinate` VALUES ('8', '739.00', '659.00');
  298. INSERT INTO `node_coordinate` VALUES ('7', '711.00', '612.00');
  299. INSERT INTO `node_coordinate` VALUES ('6', '677.00', '586.00');
  300. INSERT INTO `node_coordinate` VALUES ('5', '711.00', '529.00');
  301. INSERT INTO `node_coordinate` VALUES ('4', '648.00', '517.00');
  302. INSERT INTO `node_coordinate` VALUES ('3', '664.00', '448.00');
  303. INSERT INTO `node_coordinate` VALUES ('2', '692.00', '375.00');
  304. INSERT INTO `node_coordinate` VALUES ('1', '819.00', '886.00');
  305. -- ----------------------------
  306. -- Table structure for photo
  307. -- ----------------------------
  308. DROP TABLE IF EXISTS `photo`;
  309. CREATE TABLE `photo` (
  310. `click` int(10) DEFAULT '0',
  311. `pid` int(10) NOT NULL AUTO_INCREMENT,
  312. `uid` int(10) DEFAULT NULL,
  313. `panoid` int(10) DEFAULT NULL,
  314. `pname` varchar(255) DEFAULT NULL,
  315. `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  316. PRIMARY KEY (`pid`),
  317. KEY `user_photo_uid` (`uid`),
  318. KEY `panoid_photo_panoid` (`panoid`),
  319. CONSTRAINT `panoid_photo_panoid` FOREIGN KEY (`panoid`) REFERENCES `node` (`nodeid`),
  320. CONSTRAINT `user_photo_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
  321. ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
  322. -- ----------------------------
  323. -- Records of photo
  324. -- ----------------------------
  325. INSERT INTO `photo` VALUES ('1', '19', '7', '6', '146150487028.jpg', '2016-04-24 21:34:30');
  326. INSERT INTO `photo` VALUES ('1', '20', '7', '55', '146150498857.jpg', '2016-04-24 21:36:28');
  327. INSERT INTO `photo` VALUES ('0', '21', '7', '54', '146150503956.jpg', '2016-04-24 21:37:19');
  328. INSERT INTO `photo` VALUES ('0', '22', '7', '57', '146150510469.jpg', '2016-04-24 21:38:24');
  329. INSERT INTO `photo` VALUES ('0', '23', '7', '63', '146150514889.jpg', '2016-04-24 21:39:08');
  330. INSERT INTO `photo` VALUES ('2', '24', '7', '29', '146150528861.jpg', '2016-04-24 21:41:28');
  331. INSERT INTO `photo` VALUES ('0', '25', '7', '73', '146150575368.jpg', '2016-04-24 21:49:13');
  332. INSERT INTO `photo` VALUES ('0', '26', '7', '26', '146150582888.jpg', '2016-04-24 21:50:28');
  333. INSERT INTO `photo` VALUES ('0', '27', '7', '30', '146150593077.jpg', '2016-04-24 21:52:10');
  334. INSERT INTO `photo` VALUES ('0', '28', '7', '30', '146150594536.jpg', '2016-04-24 21:52:25');
  335. INSERT INTO `photo` VALUES ('0', '29', '7', '62', '146150643343.jpg', '2016-04-24 22:00:33');
  336. INSERT INTO `photo` VALUES ('1', '30', '7', '70', '146150648075.jpg', '2016-04-24 22:01:20');
  337. INSERT INTO `photo` VALUES ('0', '31', '7', '118', '146150658637.jpg', '2016-04-24 22:03:06');
  338. INSERT INTO `photo` VALUES ('1', '32', '7', '93', '146150662295.jpg', '2016-04-24 22:03:42');
  339. INSERT INTO `photo` VALUES ('0', '33', '7', '100', '146150666746.jpg', '2016-04-24 22:04:27');
  340. INSERT INTO `photo` VALUES ('0', '34', '7', '115', '146150672989.jpg', '2016-04-24 22:05:29');
  341. INSERT INTO `photo` VALUES ('0', '35', '7', '52', '146150675526.jpg', '2016-04-24 22:05:55');
  342. INSERT INTO `photo` VALUES ('1', '36', '7', '69', '146150678828.jpg', '2016-04-24 22:06:28');
  343. INSERT INTO `photo` VALUES ('0', '37', '7', '15', '146150693227.jpg', '2016-04-24 22:08:52');
  344. INSERT INTO `photo` VALUES ('1', '38', '7', '1', '146150694956.jpg', '2016-04-24 22:09:09');
  345. INSERT INTO `photo` VALUES ('0', '39', '7', '50', '146150813424.jpg', '2016-04-24 22:28:54');
  346. INSERT INTO `photo` VALUES ('1', '40', '7', '66', '146150823721.jpg', '2016-04-24 22:30:37');
  347. INSERT INTO `photo` VALUES ('0', '41', '7', '66', '146150831231.jpg', '2016-04-24 22:31:52');
  348. INSERT INTO `photo` VALUES ('0', '42', '7', '64', '146150837718.jpg', '2016-04-24 22:32:57');
  349. INSERT INTO `photo` VALUES ('0', '43', '7', '12', '146150846130.jpg', '2016-04-24 22:34:21');
  350. INSERT INTO `photo` VALUES ('1', '44', '7', '1', '146150850046.jpg', '2016-04-24 22:35:00');
  351. INSERT INTO `photo` VALUES ('0', '45', '7', '15', '146150863180.jpg', '2016-04-24 22:37:11');
  352. -- ----------------------------
  353. -- Table structure for server
  354. -- ----------------------------
  355. DROP TABLE IF EXISTS `server`;
  356. CREATE TABLE `server` (
  357. `server_name` varchar(255) DEFAULT NULL,
  358. `server_introduce` varchar(255) DEFAULT NULL,
  359. `server_cover` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  360. `server_node` int(10) NOT NULL
  361. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  362. -- ----------------------------
  363. -- Records of server
  364. -- ----------------------------
  365. INSERT INTO `server` VALUES ('图书馆查询', '提供图书馆书籍信息查询功能', 'library.png', '60');
  366. -- ----------------------------
  367. -- Table structure for spot
  368. -- ----------------------------
  369. DROP TABLE IF EXISTS `spot`;
  370. CREATE TABLE `spot` (
  371. `spotid` float(10,1) DEFAULT NULL,
  372. `nodeid` int(10) NOT NULL,
  373. `tonodeid` int(10) DEFAULT NULL,
  374. KEY `spot_node` (`nodeid`),
  375. KEY `to_spot_node` (`tonodeid`),
  376. CONSTRAINT `spot_node` FOREIGN KEY (`nodeid`) REFERENCES `node` (`nodeid`),
  377. CONSTRAINT `to_spot_node` FOREIGN KEY (`tonodeid`) REFERENCES `node` (`nodeid`)
  378. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  379. -- ----------------------------
  380. -- Records of spot
  381. -- ----------------------------
  382. INSERT INTO `spot` VALUES ('1.1', '1', '13');
  383. INSERT INTO `spot` VALUES ('2.2', '13', '11');
  384. INSERT INTO `spot` VALUES ('2.1', '13', '1');
  385. INSERT INTO `spot` VALUES ('2.3', '13', '15');
  386. INSERT INTO `spot` VALUES ('2.4', '13', '92');
  387. INSERT INTO `spot` VALUES ('3.5', '11', '13');
  388. INSERT INTO `spot` VALUES ('3.4', '11', '10');
  389. INSERT INTO `spot` VALUES ('4.1', '15', '13');
  390. INSERT INTO `spot` VALUES ('4.2', '15', '16');
  391. INSERT INTO `spot` VALUES ('4.3', '15', '91');
  392. INSERT INTO `spot` VALUES ('4.4', '15', '93');
  393. INSERT INTO `spot` VALUES ('5.3', '16', '15');
  394. INSERT INTO `spot` VALUES ('5.1', '16', '17');
  395. INSERT INTO `spot` VALUES ('5.2', '16', '95');
  396. INSERT INTO `spot` VALUES ('5.4', '16', '89');
  397. INSERT INTO `spot` VALUES ('6.1', '17', '16');
  398. INSERT INTO `spot` VALUES ('6.2', '17', '26');
  399. INSERT INTO `spot` VALUES ('7.3', '26', '17');
  400. INSERT INTO `spot` VALUES ('7.2', '26', '24');
  401. INSERT INTO `spot` VALUES ('7.1', '26', '25');
  402. INSERT INTO `spot` VALUES ('7.4', '26', '27');
  403. INSERT INTO `spot` VALUES ('8.1', '24', '26');
  404. INSERT INTO `spot` VALUES ('8.2', '24', '25');
  405. INSERT INTO `spot` VALUES ('8.3', '24', '23');
  406. INSERT INTO `spot` VALUES ('8.4', '24', '88');
  407. INSERT INTO `spot` VALUES ('9.1', '10', '11');
  408. INSERT INTO `spot` VALUES ('9.2', '10', '9');
  409. INSERT INTO `spot` VALUES ('10.2', '9', '10');
  410. INSERT INTO `spot` VALUES ('10.1', '9', '95');
  411. INSERT INTO `spot` VALUES ('10.3', '9', '8');
  412. INSERT INTO `spot` VALUES ('10.4', '9', '99');
  413. INSERT INTO `spot` VALUES ('11.1', '8', '9');
  414. INSERT INTO `spot` VALUES ('11.2', '8', '7');
  415. INSERT INTO `spot` VALUES ('11.3', '8', '109');
  416. INSERT INTO `spot` VALUES ('12.1', '25', '26');
  417. INSERT INTO `spot` VALUES ('12.2', '25', '27');
  418. INSERT INTO `spot` VALUES ('12.3', '25', '24');
  419. INSERT INTO `spot` VALUES ('12.4', '25', '33');
  420. INSERT INTO `spot` VALUES ('27.1', '27', '25');
  421. INSERT INTO `spot` VALUES ('27.2', '27', '26');
  422. INSERT INTO `spot` VALUES ('13.4', '27', '28');
  423. INSERT INTO `spot` VALUES ('13.4', '27', '97');
  424. INSERT INTO `spot` VALUES ('14.1', '7', '6');
  425. INSERT INTO `spot` VALUES ('14.2', '7', '8');
  426. INSERT INTO `spot` VALUES ('14.3', '7', '109');
  427. INSERT INTO `spot` VALUES ('15.1', '6', '7');
  428. INSERT INTO `spot` VALUES ('15.2', '6', '5');
  429. INSERT INTO `spot` VALUES ('15.3', '6', '111');
  430. INSERT INTO `spot` VALUES ('15.4', '6', '112');
  431. INSERT INTO `spot` VALUES ('16.1', '5', '6');
  432. INSERT INTO `spot` VALUES ('16.2', '5', '4');
  433. INSERT INTO `spot` VALUES ('16.3', '5', '61');
  434. INSERT INTO `spot` VALUES ('16.4', '5', '98');
  435. INSERT INTO `spot` VALUES ('17.1', '4', '5');
  436. INSERT INTO `spot` VALUES ('17.2', '4', '3');
  437. INSERT INTO `spot` VALUES ('17.3', '4', '63');
  438. INSERT INTO `spot` VALUES ('17.4', '4', '112');
  439. INSERT INTO `spot` VALUES ('17.5', '4', '113');
  440. INSERT INTO `spot` VALUES ('18.2', '3', '2');
  441. INSERT INTO `spot` VALUES ('18.1', '3', '4');
  442. INSERT INTO `spot` VALUES ('18.3', '3', '63');
  443. INSERT INTO `spot` VALUES ('18.4', '3', '100');
  444. INSERT INTO `spot` VALUES ('19.1', '2', '3');
  445. INSERT INTO `spot` VALUES ('19.2', '2', '61');
  446. INSERT INTO `spot` VALUES ('19.3', '2', '62');
  447. INSERT INTO `spot` VALUES ('20.1', '61', '2');
  448. INSERT INTO `spot` VALUES ('20.2', '61', '53');
  449. INSERT INTO `spot` VALUES ('20.3', '61', '5');
  450. INSERT INTO `spot` VALUES ('21.1', '53', '61');
  451. INSERT INTO `spot` VALUES ('21.2', '53', '30');
  452. INSERT INTO `spot` VALUES ('21.3', '53', '55');
  453. INSERT INTO `spot` VALUES ('22.1', '30', '53');
  454. INSERT INTO `spot` VALUES ('22.1', '30', '54');
  455. INSERT INTO `spot` VALUES ('22.3', '30', '29');
  456. INSERT INTO `spot` VALUES ('22.4', '30', '31');
  457. INSERT INTO `spot` VALUES ('23.1', '55', '53');
  458. INSERT INTO `spot` VALUES ('23.2', '55', '54');
  459. INSERT INTO `spot` VALUES ('22.3', '55', '56');
  460. INSERT INTO `spot` VALUES ('24.1', '54', '55');
  461. INSERT INTO `spot` VALUES ('24.2', '54', '30');
  462. INSERT INTO `spot` VALUES ('24.3', '54', '76');
  463. INSERT INTO `spot` VALUES ('25.1', '29', '30');
  464. INSERT INTO `spot` VALUES ('25.2', '29', '28');
  465. INSERT INTO `spot` VALUES ('25.3', '29', '32');
  466. INSERT INTO `spot` VALUES ('25.4', '29', '31');
  467. INSERT INTO `spot` VALUES ('26.1', '28', '29');
  468. INSERT INTO `spot` VALUES ('26.2', '28', '27');
  469. INSERT INTO `spot` VALUES ('26.3', '28', '32');
  470. INSERT INTO `spot` VALUES ('26.4', '28', '23');
  471. INSERT INTO `spot` VALUES ('27.1', '63', '3');
  472. INSERT INTO `spot` VALUES ('27.2', '63', '4');
  473. INSERT INTO `spot` VALUES ('27.3', '63', '100');
  474. INSERT INTO `spot` VALUES ('27.4', '63', '64');
  475. INSERT INTO `spot` VALUES ('27.4', '63', '101');
  476. INSERT INTO `spot` VALUES ('27.6', '63', '114');
  477. INSERT INTO `spot` VALUES ('28.1', '100', '63');
  478. INSERT INTO `spot` VALUES ('28.2', '100', '3');
  479. INSERT INTO `spot` VALUES ('28.4', '100', '101');
  480. INSERT INTO `spot` VALUES ('28.3', '100', '108');
  481. INSERT INTO `spot` VALUES ('29.1', '64', '63');
  482. INSERT INTO `spot` VALUES ('29.2', '64', '65');
  483. INSERT INTO `spot` VALUES ('30.1', '65', '64');
  484. INSERT INTO `spot` VALUES ('30.2', '65', '66');
  485. INSERT INTO `spot` VALUES ('31.1', '66', '65');
  486. INSERT INTO `spot` VALUES ('31.2', '66', '67');
  487. INSERT INTO `spot` VALUES ('32.1', '67', '66');
  488. INSERT INTO `spot` VALUES ('32.2', '67', '68');
  489. INSERT INTO `spot` VALUES ('33.1', '68', '67');
  490. INSERT INTO `spot` VALUES ('33.2', '68', '69');
  491. INSERT INTO `spot` VALUES ('33.3', '68', '70');
  492. INSERT INTO `spot` VALUES ('33.4', '68', '71');
  493. INSERT INTO `spot` VALUES ('33.5', '68', '116');
  494. INSERT INTO `spot` VALUES ('34.1', '69', '68');
  495. INSERT INTO `spot` VALUES ('34.2', '69', '70');
  496. INSERT INTO `spot` VALUES ('34.3', '69', '127');
  497. INSERT INTO `spot` VALUES ('34.4', '69', '71');
  498. INSERT INTO `spot` VALUES ('35.1', '70', '69');
  499. INSERT INTO `spot` VALUES ('35.2', '70', '68');
  500. INSERT INTO `spot` VALUES ('35.3', '70', '71');
  501. INSERT INTO `spot` VALUES ('35.4', '70', '74');
  502. INSERT INTO `spot` VALUES ('36.1', '71', '70');
  503. INSERT INTO `spot` VALUES ('36.2', '71', '68');
  504. INSERT INTO `spot` VALUES ('36.2', '71', '72');
  505. INSERT INTO `spot` VALUES ('36.4', '71', '69');
  506. INSERT INTO `spot` VALUES ('37.1', '72', '71');
  507. INSERT INTO `spot` VALUES ('37.2', '72', '74');
  508. INSERT INTO `spot` VALUES ('37.3', '72', '117');
  509. INSERT INTO `spot` VALUES ('38.1', '74', '70');
  510. INSERT INTO `spot` VALUES ('38.2', '74', '72');
  511. INSERT INTO `spot` VALUES ('38.3', '74', '73');
  512. INSERT INTO `spot` VALUES ('38.4', '74', '127');
  513. INSERT INTO `spot` VALUES ('39.1', '73', '74');
  514. INSERT INTO `spot` VALUES ('40.2', '101', '63');
  515. INSERT INTO `spot` VALUES ('40.1', '101', '100');
  516. INSERT INTO `spot` VALUES ('40.3', '101', '102');
  517. INSERT INTO `spot` VALUES ('41.1', '102', '101');
  518. INSERT INTO `spot` VALUES ('41.2', '102', '103');
  519. INSERT INTO `spot` VALUES ('42.1', '103', '102');
  520. INSERT INTO `spot` VALUES ('42.2', '103', '104');
  521. INSERT INTO `spot` VALUES ('43.1', '104', '103');
  522. INSERT INTO `spot` VALUES ('43.2', '104', '105');
  523. INSERT INTO `spot` VALUES ('44.1', '105', '104');
  524. INSERT INTO `spot` VALUES ('44.2', '105', '106');
  525. INSERT INTO `spot` VALUES ('45.1', '106', '105');
  526. INSERT INTO `spot` VALUES ('45.2', '106', '107');
  527. INSERT INTO `spot` VALUES ('46.1', '107', '106');
  528. INSERT INTO `spot` VALUES ('46.2', '107', '108');
  529. INSERT INTO `spot` VALUES ('47.1', '108', '107');
  530. INSERT INTO `spot` VALUES ('47.2', '108', '100');
  531. INSERT INTO `spot` VALUES ('48.1', '32', '28');
  532. INSERT INTO `spot` VALUES ('48.2', '32', '29');
  533. INSERT INTO `spot` VALUES ('48.3', '32', '33');
  534. INSERT INTO `spot` VALUES ('48.4', '32', '31');
  535. INSERT INTO `spot` VALUES ('49.1', '33', '32');
  536. INSERT INTO `spot` VALUES ('49.2', '33', '36');
  537. INSERT INTO `spot` VALUES ('49.3', '33', '35');
  538. INSERT INTO `spot` VALUES ('49.4', '33', '25');
  539. INSERT INTO `spot` VALUES ('50.1', '46', '50');
  540. INSERT INTO `spot` VALUES ('50.2', '46', '47');
  541. INSERT INTO `spot` VALUES ('50.3', '46', '51');
  542. INSERT INTO `spot` VALUES ('50.4', '46', '37');
  543. INSERT INTO `spot` VALUES ('51.1', '50', '31');
  544. INSERT INTO `spot` VALUES ('51.2', '50', '46');
  545. INSERT INTO `spot` VALUES ('51.3', '50', '36');
  546. INSERT INTO `spot` VALUES ('52.1', '51', '46');
  547. INSERT INTO `spot` VALUES ('52.2', '51', '31');
  548. INSERT INTO `spot` VALUES ('52.3', '51', '52');
  549. INSERT INTO `spot` VALUES ('53.1', '52', '51');
  550. INSERT INTO `spot` VALUES ('53.2', '52', '60');
  551. INSERT INTO `spot` VALUES ('54.1', '47', '46');
  552. INSERT INTO `spot` VALUES ('55.1', '31', '32');
  553. INSERT INTO `spot` VALUES ('55.2', '31', '50');
  554. INSERT INTO `spot` VALUES ('55.3', '31', '51');
  555. INSERT INTO `spot` VALUES ('55.4', '31', '30');
  556. INSERT INTO `spot` VALUES ('55.5', '31', '29');
  557. INSERT INTO `spot` VALUES ('56.1', '36', '50');
  558. INSERT INTO `spot` VALUES ('56.2', '36', '33');
  559. INSERT INTO `spot` VALUES ('56.3', '36', '37');
  560. INSERT INTO `spot` VALUES ('57.1', '37', '36');
  561. INSERT INTO `spot` VALUES ('57.2', '37', '46');
  562. INSERT INTO `spot` VALUES ('57.3', '37', '35');
  563. INSERT INTO `spot` VALUES ('57.4', '37', '86');
  564. INSERT INTO `spot` VALUES ('58.1', '23', '35');
  565. INSERT INTO `spot` VALUES ('58.2', '23', '28');
  566. INSERT INTO `spot` VALUES ('58.3', '23', '24');
  567. INSERT INTO `spot` VALUES ('58.4', '23', '33');
  568. INSERT INTO `spot` VALUES ('58.5', '23', '21');
  569. INSERT INTO `spot` VALUES ('59.1', '21', '23');
  570. INSERT INTO `spot` VALUES ('59.2', '21', '86');
  571. INSERT INTO `spot` VALUES ('59.3', '21', '87');
  572. INSERT INTO `spot` VALUES ('60.1', '35', '37');
  573. INSERT INTO `spot` VALUES ('60.2', '35', '33');
  574. INSERT INTO `spot` VALUES ('60.3', '35', '23');
  575. INSERT INTO `spot` VALUES ('61.1', '60', '52');
  576. INSERT INTO `spot` VALUES ('61.2', '60', '59');
  577. INSERT INTO `spot` VALUES ('62.1', '59', '60');
  578. INSERT INTO `spot` VALUES ('62.2', '59', '58');
  579. INSERT INTO `spot` VALUES ('63.1', '58', '59');
  580. INSERT INTO `spot` VALUES ('63.2', '58', '57');
  581. INSERT INTO `spot` VALUES ('63.3', '58', '76');
  582. INSERT INTO `spot` VALUES ('63.4', '58', '81');
  583. INSERT INTO `spot` VALUES ('64.1', '57', '58');
  584. INSERT INTO `spot` VALUES ('64.2', '57', '56');
  585. INSERT INTO `spot` VALUES ('64.3', '57', '62');
  586. INSERT INTO `spot` VALUES ('65.1', '56', '57');
  587. INSERT INTO `spot` VALUES ('65.2', '56', '55');
  588. INSERT INTO `spot` VALUES ('66.1', '92', '13');
  589. INSERT INTO `spot` VALUES ('66.2', '92', '90');
  590. INSERT INTO `spot` VALUES ('67.1', '90', '92');
  591. INSERT INTO `spot` VALUES ('67.2', '90', '91');
  592. INSERT INTO `spot` VALUES ('67.3', '90', '89');
  593. INSERT INTO `spot` VALUES ('68.1', '91', '90');
  594. INSERT INTO `spot` VALUES ('68.2', '91', '15');
  595. INSERT INTO `spot` VALUES ('69.1', '89', '90');
  596. INSERT INTO `spot` VALUES ('69.2', '89', '16');
  597. INSERT INTO `spot` VALUES ('69.3', '89', '88');
  598. INSERT INTO `spot` VALUES ('70.1', '88', '89');
  599. INSERT INTO `spot` VALUES ('70.2', '88', '24');
  600. INSERT INTO `spot` VALUES ('70.3', '88', '87');
  601. INSERT INTO `spot` VALUES ('71.1', '87', '88');
  602. INSERT INTO `spot` VALUES ('71.2', '87', '21');
  603. INSERT INTO `spot` VALUES ('72.1', '86', '21');
  604. INSERT INTO `spot` VALUES ('72.2', '86', '37');
  605. INSERT INTO `spot` VALUES ('72.3', '86', '85');
  606. INSERT INTO `spot` VALUES ('73.1', '85', '86');
  607. INSERT INTO `spot` VALUES ('74.1', '93', '15');
  608. INSERT INTO `spot` VALUES ('74.2', '93', '11');
  609. INSERT INTO `spot` VALUES ('74.3', '93', '94');
  610. INSERT INTO `spot` VALUES ('75.1', '94', '93');
  611. INSERT INTO `spot` VALUES ('75.2', '94', '75');
  612. INSERT INTO `spot` VALUES ('76.3', '75', '10');
  613. INSERT INTO `spot` VALUES ('76.2', '75', '94');
  614. INSERT INTO `spot` VALUES ('76.1', '75', '9');
  615. INSERT INTO `spot` VALUES ('77.2', '95', '9');
  616. INSERT INTO `spot` VALUES ('77.3', '95', '96');
  617. INSERT INTO `spot` VALUES ('77.1', '95', '16');
  618. INSERT INTO `spot` VALUES ('78.2', '96', '99');
  619. INSERT INTO `spot` VALUES ('78.3', '96', '97');
  620. INSERT INTO `spot` VALUES ('78.1', '96', '95');
  621. INSERT INTO `spot` VALUES ('79.1', '99', '9');
  622. INSERT INTO `spot` VALUES ('79.2', '99', '96');
  623. INSERT INTO `spot` VALUES ('79.3', '99', '98');
  624. INSERT INTO `spot` VALUES ('80.1', '97', '96');
  625. INSERT INTO `spot` VALUES ('80.2', '97', '27');
  626. INSERT INTO `spot` VALUES ('80.3', '97', '98');
  627. INSERT INTO `spot` VALUES ('81.1', '98', '99');
  628. INSERT INTO `spot` VALUES ('81.2', '98', '97');
  629. INSERT INTO `spot` VALUES ('81.3', '98', '5');
  630. INSERT INTO `spot` VALUES ('82.2', '111', '110');
  631. INSERT INTO `spot` VALUES ('82.1', '111', '6');
  632. INSERT INTO `spot` VALUES ('83.3', '109', '110');
  633. INSERT INTO `spot` VALUES ('83.1', '109', '8');
  634. INSERT INTO `spot` VALUES ('83.2', '109', '7');
  635. INSERT INTO `spot` VALUES ('84.1', '110', '109');
  636. INSERT INTO `spot` VALUES ('84.2', '110', '111');
  637. INSERT INTO `spot` VALUES ('85.3', '112', '4');
  638. INSERT INTO `spot` VALUES ('85.2', '112', '5');
  639. INSERT INTO `spot` VALUES ('85.1', '112', '6');
  640. INSERT INTO `spot` VALUES ('85.4', '112', '12');
  641. INSERT INTO `spot` VALUES ('86.1', '113', '4');
  642. INSERT INTO `spot` VALUES ('87.1', '114', '63');
  643. INSERT INTO `spot` VALUES ('87.2', '114', '115');
  644. INSERT INTO `spot` VALUES ('88.1', '115', '114');
  645. INSERT INTO `spot` VALUES ('88.2', '115', '62');
  646. INSERT INTO `spot` VALUES ('89.1', '62', '77');
  647. INSERT INTO `spot` VALUES ('89.2', '62', '115');
  648. INSERT INTO `spot` VALUES ('89.3', '62', '2');
  649. INSERT INTO `spot` VALUES ('89.4', '62', '57');
  650. INSERT INTO `spot` VALUES ('90.3', '77', '78');
  651. INSERT INTO `spot` VALUES ('90.2', '77', '79');
  652. INSERT INTO `spot` VALUES ('90.1', '77', '62');
  653. INSERT INTO `spot` VALUES ('91.1', '79', '77');
  654. INSERT INTO `spot` VALUES ('91.2', '79', '80');
  655. INSERT INTO `spot` VALUES ('92.1', '78', '77');
  656. INSERT INTO `spot` VALUES ('93.1', '80', '79');
  657. INSERT INTO `spot` VALUES ('93.2', '80', '81');
  658. INSERT INTO `spot` VALUES ('94.1', '83', '82');
  659. INSERT INTO `spot` VALUES ('95.1', '81', '76');
  660. INSERT INTO `spot` VALUES ('95.3', '81', '80');
  661. INSERT INTO `spot` VALUES ('95.2', '81', '82');
  662. INSERT INTO `spot` VALUES ('96.1', '82', '81');
  663. INSERT INTO `spot` VALUES ('96.2', '82', '83');
  664. INSERT INTO `spot` VALUES ('97.3', '76', '81');
  665. INSERT INTO `spot` VALUES ('97.4', '76', '58');
  666. INSERT INTO `spot` VALUES ('97.2', '76', '57');
  667. INSERT INTO `spot` VALUES ('97.1', '76', '54');
  668. INSERT INTO `spot` VALUES ('98.1', '116', '68');
  669. INSERT INTO `spot` VALUES ('98.2', '116', '67');
  670. INSERT INTO `spot` VALUES ('99.1', '126', '125');
  671. INSERT INTO `spot` VALUES ('100.2', '127', '74');
  672. INSERT INTO `spot` VALUES ('100.3', '127', '123');
  673. INSERT INTO `spot` VALUES ('100.1', '127', '69');
  674. INSERT INTO `spot` VALUES ('101.1', '117', '72');
  675. INSERT INTO `spot` VALUES ('101.2', '117', '119');
  676. INSERT INTO `spot` VALUES ('101.3', '117', '118');
  677. INSERT INTO `spot` VALUES ('102.1', '118', '119');
  678. INSERT INTO `spot` VALUES ('102.2', '118', '117');
  679. INSERT INTO `spot` VALUES ('103.1', '119', '117');
  680. INSERT INTO `spot` VALUES ('103.2', '119', '120');
  681. INSERT INTO `spot` VALUES ('103.3', '119', '118');
  682. INSERT INTO `spot` VALUES ('104.1', '120', '119');
  683. INSERT INTO `spot` VALUES ('104.2', '120', '121');
  684. INSERT INTO `spot` VALUES ('105.2', '121', '120');
  685. INSERT INTO `spot` VALUES ('105.1', '121', '122');
  686. INSERT INTO `spot` VALUES ('106.2', '122', '123');
  687. INSERT INTO `spot` VALUES ('106.1', '122', '121');
  688. INSERT INTO `spot` VALUES ('107.2', '123', '127');
  689. INSERT INTO `spot` VALUES ('107.1', '123', '122');
  690. INSERT INTO `spot` VALUES ('107.3', '123', '124');
  691. INSERT INTO `spot` VALUES ('108.2', '124', '123');
  692. INSERT INTO `spot` VALUES ('108.1', '124', '125');
  693. INSERT INTO `spot` VALUES ('109.2', '125', '124');
  694. INSERT INTO `spot` VALUES ('109.1', '125', '126');
  695. INSERT INTO `spot` VALUES ('110.1', '12', '112');
  696. -- ----------------------------
  697. -- Table structure for user
  698. -- ----------------------------
  699. DROP TABLE IF EXISTS `user`;
  700. CREATE TABLE `user` (
  701. `uid` int(10) NOT NULL AUTO_INCREMENT,
  702. `username` varchar(255) NOT NULL,
  703. `password` varchar(255) DEFAULT NULL,
  704. `likeid` varchar(255) DEFAULT '0',
  705. `focusid` varchar(255) DEFAULT '0',
  706. PRIMARY KEY (`uid`)
  707. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  708. -- ----------------------------
  709. -- Records of user
  710. -- ----------------------------
  711. INSERT INTO `user` VALUES ('6', 'shitou', '62026aaed5419a1ceaa229bf6886443e', '0,1,32', '0,93,89');
  712. INSERT INTO `user` VALUES ('7', 'jtahstu', '202cb962ac59075b964b07152d234b70', '0,1,20,24,30,19,36,38,40,44', '0,112,12');
  713. INSERT INTO `user` VALUES ('8', '123', '202cb962ac59075b964b07152d234b70', '0,1', '0');
  714. INSERT INTO `user` VALUES ('9', 'admin', '21232f297a57a5a743894a0e4a801fc3', '0,24', '0');
  715. INSERT INTO `user` VALUES ('10', 'test', '202cb962ac59075b964b07152d234b70', '0', '0');