/[LeafOK_CVS]/lbbs-combo/sql/db_import.sql
ViewVC logotype

Contents of /lbbs-combo/sql/db_import.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.1 - (show annotations)
Thu Jan 8 03:27:09 2026 UTC (2 months, 1 week ago) by sysadm
Branch: MAIN
CVS Tags: HEAD
Content type: application/sql 
Initial commit
1 -- MySQL dump 10.13 Distrib 8.4.7, for Linux (x86_64)
2 --
3 -- Host: 192.168.2.14 Database: lbbs
4 -- ------------------------------------------------------
5 -- Server version 8.4.7
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!50503 SET NAMES utf8mb4 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18 --
19 -- Table structure for table `admin_config`
20 --
21
22 DROP TABLE IF EXISTS `admin_config`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!50503 SET character_set_client = utf8mb4 */;
25 CREATE TABLE `admin_config` (
26 `AID` smallint NOT NULL AUTO_INCREMENT,
27 `UID` mediumint NOT NULL DEFAULT '0',
28 `begin_dt` datetime DEFAULT NULL,
29 `end_dt` datetime DEFAULT NULL,
30 `enable` tinyint unsigned NOT NULL DEFAULT '1',
31 `major` tinyint unsigned NOT NULL DEFAULT '0',
32 PRIMARY KEY (`AID`),
33 KEY `UID` (`UID`)
34 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
35 /*!40101 SET character_set_client = @saved_cs_client */;
36
37 --
38 -- Dumping data for table `admin_config`
39 --
40
41 LOCK TABLES `admin_config` WRITE;
42 /*!40000 ALTER TABLE `admin_config` DISABLE KEYS */;
43 INSERT INTO `admin_config` VALUES (1,1,'2026-01-01 00:00:00','2036-01-01 00:00:00',1,1);
44 /*!40000 ALTER TABLE `admin_config` ENABLE KEYS */;
45 UNLOCK TABLES;
46
47 --
48 -- Table structure for table `article_favorite`
49 --
50
51 DROP TABLE IF EXISTS `article_favorite`;
52 /*!40101 SET @saved_cs_client = @@character_set_client */;
53 /*!50503 SET character_set_client = utf8mb4 */;
54 CREATE TABLE `article_favorite` (
55 `UID` mediumint NOT NULL,
56 `AID` int NOT NULL,
57 PRIMARY KEY (`UID`,`AID`),
58 KEY `AID` (`AID`)
59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
60 /*!40101 SET character_set_client = @saved_cs_client */;
61
62 --
63 -- Dumping data for table `article_favorite`
64 --
65
66 LOCK TABLES `article_favorite` WRITE;
67 /*!40000 ALTER TABLE `article_favorite` DISABLE KEYS */;
68 /*!40000 ALTER TABLE `article_favorite` ENABLE KEYS */;
69 UNLOCK TABLES;
70
71 --
72 -- Table structure for table `ban_user_list`
73 --
74
75 DROP TABLE IF EXISTS `ban_user_list`;
76 /*!40101 SET @saved_cs_client = @@character_set_client */;
77 /*!50503 SET character_set_client = utf8mb4 */;
78 CREATE TABLE `ban_user_list` (
79 `BID` smallint NOT NULL AUTO_INCREMENT,
80 `SID` smallint NOT NULL DEFAULT '0',
81 `UID` mediumint NOT NULL DEFAULT '0',
82 `day` smallint NOT NULL DEFAULT '0',
83 `ban_UID` mediumint NOT NULL DEFAULT '0',
84 `ban_dt` datetime DEFAULT NULL,
85 `ban_ip` varchar(20) DEFAULT NULL,
86 `unban_UID` mediumint NOT NULL DEFAULT '0',
87 `unban_dt` datetime DEFAULT NULL,
88 `unban_ip` varchar(20) DEFAULT NULL,
89 `enable` tinyint unsigned NOT NULL DEFAULT '1',
90 `reason` mediumtext,
91 PRIMARY KEY (`BID`),
92 KEY `ban_UID` (`ban_UID`),
93 KEY `SID` (`SID`),
94 KEY `day` (`day`),
95 KEY `UID` (`UID`)
96 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
97 /*!40101 SET character_set_client = @saved_cs_client */;
98
99 --
100 -- Dumping data for table `ban_user_list`
101 --
102
103 LOCK TABLES `ban_user_list` WRITE;
104 /*!40000 ALTER TABLE `ban_user_list` DISABLE KEYS */;
105 /*!40000 ALTER TABLE `ban_user_list` ENABLE KEYS */;
106 UNLOCK TABLES;
107
108 --
109 -- Table structure for table `bbs`
110 --
111
112 DROP TABLE IF EXISTS `bbs`;
113 /*!40101 SET @saved_cs_client = @@character_set_client */;
114 /*!50503 SET character_set_client = utf8mb4 */;
115 CREATE TABLE `bbs` (
116 `AID` int NOT NULL AUTO_INCREMENT,
117 `SID` smallint NOT NULL DEFAULT '0',
118 `TID` mediumint NOT NULL DEFAULT '0',
119 `UID` mediumint NOT NULL DEFAULT '0',
120 `username` varchar(20) DEFAULT NULL,
121 `nickname` varchar(20) DEFAULT NULL,
122 `title` varchar(80) DEFAULT NULL,
123 `CID` mediumint NOT NULL DEFAULT '0',
124 `sub_dt` datetime DEFAULT NULL,
125 `sub_ip` varchar(20) DEFAULT NULL,
126 `reply_note` tinyint unsigned NOT NULL DEFAULT '0',
127 `visible` tinyint unsigned NOT NULL DEFAULT '1',
128 `view_count` smallint NOT NULL DEFAULT '0',
129 `exp` mediumint NOT NULL DEFAULT '0',
130 `last_reply_dt` datetime DEFAULT NULL,
131 `last_reply_UID` mediumint NOT NULL DEFAULT '0',
132 `last_reply_username` varchar(20) DEFAULT NULL,
133 `last_reply_nickname` varchar(20) DEFAULT NULL,
134 `transship` tinyint unsigned NOT NULL DEFAULT '0',
135 `lock` tinyint unsigned NOT NULL DEFAULT '0',
136 `reply_count` smallint NOT NULL DEFAULT '0',
137 `icon` smallint DEFAULT NULL,
138 `length` mediumint NOT NULL DEFAULT '0',
139 `excerption` tinyint unsigned NOT NULL DEFAULT '0',
140 `ontop` tinyint unsigned NOT NULL DEFAULT '0',
141 `static` tinyint unsigned NOT NULL DEFAULT '0',
142 `gen_ex` tinyint unsigned NOT NULL DEFAULT '0',
143 `m_del` tinyint unsigned NOT NULL DEFAULT '0',
144 `old_SID` smallint NOT NULL DEFAULT '0',
145 PRIMARY KEY (`AID`),
146 UNIQUE KEY `CID` (`CID`),
147 KEY `UID` (`UID`),
148 KEY `reply_count` (`reply_count`),
149 KEY `last_reply_dt` (`last_reply_dt`),
150 KEY `view_count` (`view_count`),
151 KEY `sub_dt` (`sub_dt`),
152 KEY `title` (`title`(10)),
153 KEY `old_SID` (`old_SID`),
154 KEY `SID` (`SID`),
155 KEY `TID` (`TID`),
156 KEY `last_reply_UID` (`last_reply_UID`)
157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
158 /*!40101 SET character_set_client = @saved_cs_client */;
159
160 --
161 -- Dumping data for table `bbs`
162 --
163
164 LOCK TABLES `bbs` WRITE;
165 /*!40000 ALTER TABLE `bbs` DISABLE KEYS */;
166 /*!40000 ALTER TABLE `bbs` ENABLE KEYS */;
167 UNLOCK TABLES;
168
169 --
170 -- Table structure for table `bbs_article_op`
171 --
172
173 DROP TABLE IF EXISTS `bbs_article_op`;
174 /*!40101 SET @saved_cs_client = @@character_set_client */;
175 /*!50503 SET character_set_client = utf8mb4 */;
176 CREATE TABLE `bbs_article_op` (
177 `MID` int NOT NULL AUTO_INCREMENT,
178 `AID` int NOT NULL DEFAULT '0',
179 `UID` mediumint NOT NULL DEFAULT '0',
180 `type` char(1) NOT NULL DEFAULT '',
181 `op_dt` datetime DEFAULT NULL,
182 `op_ip` varchar(20) DEFAULT NULL,
183 `complete` tinyint unsigned NOT NULL DEFAULT '1',
184 PRIMARY KEY (`MID`),
185 KEY `AID` (`AID`),
186 KEY `UID` (`UID`),
187 KEY `type` (`type`)
188 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
189 /*!40101 SET character_set_client = @saved_cs_client */;
190
191 --
192 -- Dumping data for table `bbs_article_op`
193 --
194
195 LOCK TABLES `bbs_article_op` WRITE;
196 /*!40000 ALTER TABLE `bbs_article_op` DISABLE KEYS */;
197 /*!40000 ALTER TABLE `bbs_article_op` ENABLE KEYS */;
198 UNLOCK TABLES;
199
200 --
201 -- Table structure for table `bbs_content`
202 --
203
204 DROP TABLE IF EXISTS `bbs_content`;
205 /*!40101 SET @saved_cs_client = @@character_set_client */;
206 /*!50503 SET character_set_client = utf8mb4 */;
207 CREATE TABLE `bbs_content` (
208 `CID` int NOT NULL AUTO_INCREMENT,
209 `AID` int NOT NULL DEFAULT '0',
210 `content` longtext,
211 PRIMARY KEY (`CID`),
212 KEY `AID` (`AID`)
213 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
214 /*!40101 SET character_set_client = @saved_cs_client */;
215
216 --
217 -- Dumping data for table `bbs_content`
218 --
219
220 LOCK TABLES `bbs_content` WRITE;
221 /*!40000 ALTER TABLE `bbs_content` DISABLE KEYS */;
222 /*!40000 ALTER TABLE `bbs_content` ENABLE KEYS */;
223 UNLOCK TABLES;
224
225 --
226 -- Table structure for table `bbs_msg`
227 --
228
229 DROP TABLE IF EXISTS `bbs_msg`;
230 /*!40101 SET @saved_cs_client = @@character_set_client */;
231 /*!50503 SET character_set_client = utf8mb4 */;
232 CREATE TABLE `bbs_msg` (
233 `MID` int NOT NULL AUTO_INCREMENT,
234 `fromUID` mediumint NOT NULL DEFAULT '0',
235 `toUID` mediumint NOT NULL DEFAULT '0',
236 `content` longtext,
237 `send_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
238 `send_ip` varchar(20) NOT NULL DEFAULT '',
239 `new` tinyint unsigned NOT NULL DEFAULT '1',
240 `deleted` tinyint unsigned NOT NULL DEFAULT '0',
241 `s_deleted` tinyint unsigned NOT NULL DEFAULT '0',
242 PRIMARY KEY (`MID`),
243 KEY `fromUID` (`fromUID`),
244 KEY `toUID` (`toUID`)
245 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
246 /*!40101 SET character_set_client = @saved_cs_client */;
247
248 --
249 -- Dumping data for table `bbs_msg`
250 --
251
252 LOCK TABLES `bbs_msg` WRITE;
253 /*!40000 ALTER TABLE `bbs_msg` DISABLE KEYS */;
254 /*!40000 ALTER TABLE `bbs_msg` ENABLE KEYS */;
255 UNLOCK TABLES;
256
257 --
258 -- Table structure for table `email`
259 --
260
261 DROP TABLE IF EXISTS `email`;
262 /*!40101 SET @saved_cs_client = @@character_set_client */;
263 /*!50503 SET character_set_client = utf8mb4 */;
264 CREATE TABLE `email` (
265 `ID` int NOT NULL AUTO_INCREMENT,
266 `fromemail` varchar(30) DEFAULT NULL,
267 `fromname` varchar(30) DEFAULT NULL,
268 `toemail` varchar(30) DEFAULT NULL,
269 `toname` varchar(30) DEFAULT NULL,
270 `subject` varchar(80) DEFAULT NULL,
271 `body` longtext,
272 `set_dt` datetime DEFAULT NULL,
273 `send_dt` datetime DEFAULT NULL,
274 `complete` tinyint unsigned NOT NULL DEFAULT '0',
275 `error` tinyint unsigned NOT NULL DEFAULT '0',
276 `error_msg` varchar(255) DEFAULT NULL,
277 PRIMARY KEY (`ID`),
278 KEY `complete` (`complete`)
279 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
280 /*!40101 SET character_set_client = @saved_cs_client */;
281
282 --
283 -- Dumping data for table `email`
284 --
285
286 LOCK TABLES `email` WRITE;
287 /*!40000 ALTER TABLE `email` DISABLE KEYS */;
288 /*!40000 ALTER TABLE `email` ENABLE KEYS */;
289 UNLOCK TABLES;
290
291 --
292 -- Table structure for table `ex_dir`
293 --
294
295 DROP TABLE IF EXISTS `ex_dir`;
296 /*!40101 SET @saved_cs_client = @@character_set_client */;
297 /*!50503 SET character_set_client = utf8mb4 */;
298 CREATE TABLE `ex_dir` (
299 `FID` mediumint NOT NULL AUTO_INCREMENT,
300 `dir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
301 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
302 `SID` smallint NOT NULL DEFAULT '0',
303 `enable` tinyint unsigned NOT NULL DEFAULT '0',
304 `dt` datetime DEFAULT NULL,
305 PRIMARY KEY (`FID`),
306 KEY `SID` (`SID`),
307 KEY `dir` (`dir`(50))
308 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
309 /*!40101 SET character_set_client = @saved_cs_client */;
310
311 --
312 -- Dumping data for table `ex_dir`
313 --
314
315 LOCK TABLES `ex_dir` WRITE;
316 /*!40000 ALTER TABLE `ex_dir` DISABLE KEYS */;
317 /*!40000 ALTER TABLE `ex_dir` ENABLE KEYS */;
318 UNLOCK TABLES;
319
320 --
321 -- Table structure for table `ex_file`
322 --
323
324 DROP TABLE IF EXISTS `ex_file`;
325 /*!40101 SET @saved_cs_client = @@character_set_client */;
326 /*!50503 SET character_set_client = utf8mb4 */;
327 CREATE TABLE `ex_file` (
328 `AID` int NOT NULL DEFAULT '0',
329 `FID` smallint NOT NULL DEFAULT '0',
330 PRIMARY KEY (`AID`),
331 KEY `FID` (`FID`)
332 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
333 /*!40101 SET character_set_client = @saved_cs_client */;
334
335 --
336 -- Dumping data for table `ex_file`
337 --
338
339 LOCK TABLES `ex_file` WRITE;
340 /*!40000 ALTER TABLE `ex_file` DISABLE KEYS */;
341 /*!40000 ALTER TABLE `ex_file` ENABLE KEYS */;
342 UNLOCK TABLES;
343
344 --
345 -- Table structure for table `friend_list`
346 --
347
348 DROP TABLE IF EXISTS `friend_list`;
349 /*!40101 SET @saved_cs_client = @@character_set_client */;
350 /*!50503 SET character_set_client = utf8mb4 */;
351 CREATE TABLE `friend_list` (
352 `ID` mediumint NOT NULL AUTO_INCREMENT,
353 `UID` mediumint NOT NULL DEFAULT '0',
354 `fUID` mediumint NOT NULL DEFAULT '0',
355 PRIMARY KEY (`ID`),
356 KEY `fUID` (`fUID`),
357 KEY `UID` (`UID`)
358 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
359 /*!40101 SET character_set_client = @saved_cs_client */;
360
361 --
362 -- Dumping data for table `friend_list`
363 --
364
365 LOCK TABLES `friend_list` WRITE;
366 /*!40000 ALTER TABLE `friend_list` DISABLE KEYS */;
367 /*!40000 ALTER TABLE `friend_list` ENABLE KEYS */;
368 UNLOCK TABLES;
369
370 --
371 -- Table structure for table `section_class`
372 --
373
374 DROP TABLE IF EXISTS `section_class`;
375 /*!40101 SET @saved_cs_client = @@character_set_client */;
376 /*!50503 SET character_set_client = utf8mb4 */;
377 CREATE TABLE `section_class` (
378 `CID` smallint NOT NULL AUTO_INCREMENT,
379 `cname` varchar(20) DEFAULT NULL,
380 `title` varchar(20) DEFAULT NULL,
381 `enable` tinyint unsigned NOT NULL DEFAULT '1',
382 `sort_order` smallint NOT NULL DEFAULT '10',
383 PRIMARY KEY (`CID`),
384 KEY `sort_order` (`sort_order`)
385 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
386 /*!40101 SET character_set_client = @saved_cs_client */;
387
388 --
389 -- Dumping data for table `section_class`
390 --
391
392 LOCK TABLES `section_class` WRITE;
393 /*!40000 ALTER TABLE `section_class` DISABLE KEYS */;
394 INSERT INTO `section_class` VALUES (1,'SYS','系统管理',1,10);
395 /*!40000 ALTER TABLE `section_class` ENABLE KEYS */;
396 UNLOCK TABLES;
397
398 --
399 -- Table structure for table `section_config`
400 --
401
402 DROP TABLE IF EXISTS `section_config`;
403 /*!40101 SET @saved_cs_client = @@character_set_client */;
404 /*!50503 SET character_set_client = utf8mb4 */;
405 CREATE TABLE `section_config` (
406 `SID` smallint NOT NULL AUTO_INCREMENT,
407 `sname` varchar(20) DEFAULT NULL,
408 `CID` smallint NOT NULL DEFAULT '0',
409 `title` varchar(20) DEFAULT NULL,
410 `comment` varchar(255) DEFAULT NULL,
411 `topic_retention` smallint NOT NULL DEFAULT '0',
412 `announcement` longtext,
413 `enable` tinyint unsigned NOT NULL DEFAULT '1',
414 `exp_get` tinyint unsigned NOT NULL DEFAULT '0',
415 `recommend` tinyint unsigned NOT NULL DEFAULT '0',
416 `set_UID` mediumint DEFAULT '0',
417 `set_dt` datetime DEFAULT NULL,
418 `set_ip` varchar(20) DEFAULT NULL,
419 `sort_order` smallint NOT NULL DEFAULT '10',
420 `ex_gen_tm` datetime DEFAULT NULL,
421 `ex_update` tinyint unsigned NOT NULL DEFAULT '0',
422 `ex_menu_tm` datetime DEFAULT NULL,
423 `ex_menu_update` tinyint NOT NULL DEFAULT '0',
424 `read_user_level` smallint NOT NULL DEFAULT '0',
425 `write_user_level` smallint NOT NULL DEFAULT '0',
426 PRIMARY KEY (`SID`),
427 KEY `CID` (`CID`),
428 KEY `write_user_level` (`write_user_level`),
429 KEY `sort_order` (`sort_order`),
430 KEY `read_user_level` (`read_user_level`),
431 KEY `sname` (`sname`)
432 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
433 /*!40101 SET character_set_client = @saved_cs_client */;
434
435 --
436 -- Dumping data for table `section_config`
437 --
438
439 LOCK TABLES `section_config` WRITE;
440 /*!40000 ALTER TABLE `section_config` DISABLE KEYS */;
441 INSERT INTO `section_config` VALUES (1,'SYSOP',1,'论坛管理','',0,'',1,1,1,1,'2026-01-01 00:00:00','127.0.0.1',1,NULL,1,NULL,1,0,1),(2,'Test',1,'测试区','',0,'',1,0,0,1,'2026-01-01 00:00:00','127.0.0.1',2,NULL,1,NULL,1,1,1);
442 /*!40000 ALTER TABLE `section_config` ENABLE KEYS */;
443 UNLOCK TABLES;
444
445 --
446 -- Table structure for table `section_favorite`
447 --
448
449 DROP TABLE IF EXISTS `section_favorite`;
450 /*!40101 SET @saved_cs_client = @@character_set_client */;
451 /*!50503 SET character_set_client = utf8mb4 */;
452 CREATE TABLE `section_favorite` (
453 `ID` int NOT NULL AUTO_INCREMENT,
454 `UID` mediumint NOT NULL DEFAULT '0',
455 `SID` smallint NOT NULL DEFAULT '0',
456 PRIMARY KEY (`ID`),
457 KEY `UID` (`UID`)
458 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
459 /*!40101 SET character_set_client = @saved_cs_client */;
460
461 --
462 -- Dumping data for table `section_favorite`
463 --
464
465 LOCK TABLES `section_favorite` WRITE;
466 /*!40000 ALTER TABLE `section_favorite` DISABLE KEYS */;
467 INSERT INTO `section_favorite` VALUES (3,1,1);
468 /*!40000 ALTER TABLE `section_favorite` ENABLE KEYS */;
469 UNLOCK TABLES;
470
471 --
472 -- Table structure for table `section_master`
473 --
474
475 DROP TABLE IF EXISTS `section_master`;
476 /*!40101 SET @saved_cs_client = @@character_set_client */;
477 /*!50503 SET character_set_client = utf8mb4 */;
478 CREATE TABLE `section_master` (
479 `MID` smallint NOT NULL AUTO_INCREMENT,
480 `SID` smallint NOT NULL DEFAULT '0',
481 `UID` mediumint NOT NULL DEFAULT '0',
482 `begin_dt` datetime DEFAULT NULL,
483 `end_dt` datetime DEFAULT NULL,
484 `enable` tinyint unsigned NOT NULL DEFAULT '1',
485 `major` tinyint unsigned NOT NULL DEFAULT '0',
486 `memo` text,
487 PRIMARY KEY (`MID`),
488 KEY `SID` (`SID`),
489 KEY `UID` (`UID`)
490 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
491 /*!40101 SET character_set_client = @saved_cs_client */;
492
493 --
494 -- Dumping data for table `section_master`
495 --
496
497 LOCK TABLES `section_master` WRITE;
498 /*!40000 ALTER TABLE `section_master` DISABLE KEYS */;
499 INSERT INTO `section_master` VALUES (1,1,1,'2026-01-01 00:00:00','2036-01-01 00:00:00',1,1,NULL);
500 /*!40000 ALTER TABLE `section_master` ENABLE KEYS */;
501 UNLOCK TABLES;
502
503 --
504 -- Table structure for table `send_pass_log`
505 --
506
507 DROP TABLE IF EXISTS `send_pass_log`;
508 /*!40101 SET @saved_cs_client = @@character_set_client */;
509 /*!50503 SET character_set_client = utf8mb4 */;
510 CREATE TABLE `send_pass_log` (
511 `ID` mediumint NOT NULL AUTO_INCREMENT,
512 `UID` mediumint NOT NULL DEFAULT '0',
513 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
514 `ip` varchar(20) NOT NULL DEFAULT '',
515 PRIMARY KEY (`ID`),
516 KEY `UID` (`UID`)
517 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
518 /*!40101 SET character_set_client = @saved_cs_client */;
519
520 --
521 -- Dumping data for table `send_pass_log`
522 --
523
524 LOCK TABLES `send_pass_log` WRITE;
525 /*!40000 ALTER TABLE `send_pass_log` DISABLE KEYS */;
526 /*!40000 ALTER TABLE `send_pass_log` ENABLE KEYS */;
527 UNLOCK TABLES;
528
529 --
530 -- Table structure for table `upload_file`
531 --
532
533 DROP TABLE IF EXISTS `upload_file`;
534 /*!40101 SET @saved_cs_client = @@character_set_client */;
535 /*!50503 SET character_set_client = utf8mb4 */;
536 CREATE TABLE `upload_file` (
537 `AID` mediumint NOT NULL AUTO_INCREMENT,
538 `ref_AID` mediumint NOT NULL DEFAULT '0',
539 `UID` mediumint NOT NULL DEFAULT '0',
540 `size` mediumint NOT NULL DEFAULT '0',
541 `filename` varchar(255) NOT NULL DEFAULT '',
542 `check` tinyint unsigned NOT NULL DEFAULT '0',
543 `deny` tinyint unsigned NOT NULL DEFAULT '0',
544 `deleted` tinyint unsigned NOT NULL DEFAULT '0',
545 PRIMARY KEY (`AID`),
546 KEY `check` (`check`),
547 KEY `UID` (`UID`),
548 KEY `ref_AID` (`ref_AID`)
549 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
550 /*!40101 SET character_set_client = @saved_cs_client */;
551
552 --
553 -- Dumping data for table `upload_file`
554 --
555
556 LOCK TABLES `upload_file` WRITE;
557 /*!40000 ALTER TABLE `upload_file` DISABLE KEYS */;
558 /*!40000 ALTER TABLE `upload_file` ENABLE KEYS */;
559 UNLOCK TABLES;
560
561 --
562 -- Table structure for table `user_err_login_log`
563 --
564
565 DROP TABLE IF EXISTS `user_err_login_log`;
566 /*!40101 SET @saved_cs_client = @@character_set_client */;
567 /*!50503 SET character_set_client = utf8mb4 */;
568 CREATE TABLE `user_err_login_log` (
569 `ID` int NOT NULL AUTO_INCREMENT,
570 `username` varchar(14) DEFAULT NULL,
571 `password` varchar(12) DEFAULT NULL,
572 `login_dt` datetime DEFAULT NULL,
573 `login_ip` varchar(20) DEFAULT NULL,
574 PRIMARY KEY (`ID`),
575 KEY `login_dt` (`login_dt`,`login_ip`)
576 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
577 /*!40101 SET character_set_client = @saved_cs_client */;
578
579 --
580 -- Dumping data for table `user_err_login_log`
581 --
582
583 LOCK TABLES `user_err_login_log` WRITE;
584 /*!40000 ALTER TABLE `user_err_login_log` DISABLE KEYS */;
585 /*!40000 ALTER TABLE `user_err_login_log` ENABLE KEYS */;
586 UNLOCK TABLES;
587
588 --
589 -- Table structure for table `user_life_log`
590 --
591
592 DROP TABLE IF EXISTS `user_life_log`;
593 /*!40101 SET @saved_cs_client = @@character_set_client */;
594 /*!50503 SET character_set_client = utf8mb4 */;
595 CREATE TABLE `user_life_log` (
596 `ID` mediumint NOT NULL AUTO_INCREMENT,
597 `UID` mediumint NOT NULL DEFAULT '0',
598 `set_UID` mediumint NOT NULL DEFAULT '0',
599 `life` smallint NOT NULL DEFAULT '0',
600 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
601 `ip` varchar(20) NOT NULL DEFAULT '',
602 PRIMARY KEY (`ID`),
603 KEY `set_UID` (`set_UID`),
604 KEY `UID` (`UID`)
605 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
606 /*!40101 SET character_set_client = @saved_cs_client */;
607
608 --
609 -- Dumping data for table `user_life_log`
610 --
611
612 LOCK TABLES `user_life_log` WRITE;
613 /*!40000 ALTER TABLE `user_life_log` DISABLE KEYS */;
614 /*!40000 ALTER TABLE `user_life_log` ENABLE KEYS */;
615 UNLOCK TABLES;
616
617 --
618 -- Table structure for table `user_list`
619 --
620
621 DROP TABLE IF EXISTS `user_list`;
622 /*!40101 SET @saved_cs_client = @@character_set_client */;
623 /*!50503 SET character_set_client = utf8mb4 */;
624 CREATE TABLE `user_list` (
625 `UID` mediumint NOT NULL AUTO_INCREMENT,
626 `username` varchar(20) NOT NULL DEFAULT '',
627 `password` varchar(64) NOT NULL DEFAULT '',
628 `temp_password` varchar(64) NOT NULL DEFAULT '',
629 `enable` tinyint unsigned NOT NULL DEFAULT '1',
630 `verified` tinyint unsigned NOT NULL DEFAULT '0',
631 `p_login` tinyint unsigned NOT NULL DEFAULT '1',
632 `p_post` tinyint unsigned NOT NULL DEFAULT '1',
633 `p_msg` tinyint unsigned NOT NULL DEFAULT '1',
634 PRIMARY KEY (`UID`),
635 UNIQUE KEY `username` (`username`),
636 KEY `verified` (`verified`),
637 KEY `enable` (`enable`)
638 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
639 /*!40101 SET character_set_client = @saved_cs_client */;
640
641 --
642 -- Dumping data for table `user_list`
643 --
644
645 LOCK TABLES `user_list` WRITE;
646 /*!40000 ALTER TABLE `user_list` DISABLE KEYS */;
647 INSERT INTO `user_list` VALUES (1,'sysop','','55b8624bb2d098bf1c01a7ad884f0037244ac4bd08b447462cb8b00000e954ba',1,1,1,1,1);
648 /*!40000 ALTER TABLE `user_list` ENABLE KEYS */;
649 UNLOCK TABLES;
650
651 --
652 -- Table structure for table `user_login_log`
653 --
654
655 DROP TABLE IF EXISTS `user_login_log`;
656 /*!40101 SET @saved_cs_client = @@character_set_client */;
657 /*!50503 SET character_set_client = utf8mb4 */;
658 CREATE TABLE `user_login_log` (
659 `ID` int NOT NULL AUTO_INCREMENT,
660 `UID` mediumint NOT NULL DEFAULT '0',
661 `login_dt` datetime DEFAULT NULL,
662 `login_ip` varchar(20) DEFAULT NULL,
663 PRIMARY KEY (`ID`),
664 KEY `UID` (`UID`),
665 KEY `login_dt` (`login_dt`)
666 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
667 /*!40101 SET character_set_client = @saved_cs_client */;
668
669 --
670 -- Dumping data for table `user_login_log`
671 --
672
673 LOCK TABLES `user_login_log` WRITE;
674 /*!40000 ALTER TABLE `user_login_log` DISABLE KEYS */;
675 /*!40000 ALTER TABLE `user_login_log` ENABLE KEYS */;
676 UNLOCK TABLES;
677
678 --
679 -- Table structure for table `user_modify_email_verify`
680 --
681
682 DROP TABLE IF EXISTS `user_modify_email_verify`;
683 /*!40101 SET @saved_cs_client = @@character_set_client */;
684 /*!50503 SET character_set_client = utf8mb4 */;
685 CREATE TABLE `user_modify_email_verify` (
686 `MID` mediumint NOT NULL AUTO_INCREMENT,
687 `UID` mediumint NOT NULL DEFAULT '0',
688 `email` varchar(30) DEFAULT NULL,
689 `verify_code` varchar(10) NOT NULL DEFAULT '',
690 `complete` tinyint unsigned NOT NULL DEFAULT '0',
691 `dt` datetime DEFAULT NULL,
692 `ip` varchar(20) DEFAULT NULL,
693 PRIMARY KEY (`MID`),
694 UNIQUE KEY `verify_code` (`verify_code`),
695 KEY `UID` (`UID`),
696 KEY `complete` (`complete`)
697 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
698 /*!40101 SET character_set_client = @saved_cs_client */;
699
700 --
701 -- Dumping data for table `user_modify_email_verify`
702 --
703
704 LOCK TABLES `user_modify_email_verify` WRITE;
705 /*!40000 ALTER TABLE `user_modify_email_verify` DISABLE KEYS */;
706 /*!40000 ALTER TABLE `user_modify_email_verify` ENABLE KEYS */;
707 UNLOCK TABLES;
708
709 --
710 -- Table structure for table `user_modify_log`
711 --
712
713 DROP TABLE IF EXISTS `user_modify_log`;
714 /*!40101 SET @saved_cs_client = @@character_set_client */;
715 /*!50503 SET character_set_client = utf8mb4 */;
716 CREATE TABLE `user_modify_log` (
717 `MID` mediumint NOT NULL AUTO_INCREMENT,
718 `UID` mediumint NOT NULL DEFAULT '0',
719 `modify_dt` datetime DEFAULT NULL,
720 `modify_ip` varchar(20) DEFAULT NULL,
721 `complete` tinyint unsigned NOT NULL DEFAULT '0',
722 PRIMARY KEY (`MID`),
723 KEY `UID` (`UID`)
724 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
725 /*!40101 SET character_set_client = @saved_cs_client */;
726
727 --
728 -- Dumping data for table `user_modify_log`
729 --
730
731 LOCK TABLES `user_modify_log` WRITE;
732 /*!40000 ALTER TABLE `user_modify_log` DISABLE KEYS */;
733 /*!40000 ALTER TABLE `user_modify_log` ENABLE KEYS */;
734 UNLOCK TABLES;
735
736 --
737 -- Table structure for table `user_nickname`
738 --
739
740 DROP TABLE IF EXISTS `user_nickname`;
741 /*!40101 SET @saved_cs_client = @@character_set_client */;
742 /*!50503 SET character_set_client = utf8mb4 */;
743 CREATE TABLE `user_nickname` (
744 `NID` mediumint NOT NULL AUTO_INCREMENT,
745 `UID` mediumint NOT NULL DEFAULT '0',
746 `nickname` varchar(20) NOT NULL DEFAULT '',
747 `begin_dt` datetime DEFAULT NULL,
748 `begin_reason` char(1) DEFAULT NULL,
749 `end_dt` datetime DEFAULT NULL,
750 `end_reason` char(1) DEFAULT NULL,
751 PRIMARY KEY (`NID`),
752 KEY `UID` (`UID`),
753 KEY `nickname` (`nickname`),
754 KEY `begin_dt` (`begin_dt`),
755 KEY `end_dt` (`end_dt`)
756 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
757 /*!40101 SET character_set_client = @saved_cs_client */;
758
759 --
760 -- Dumping data for table `user_nickname`
761 --
762
763 LOCK TABLES `user_nickname` WRITE;
764 /*!40000 ALTER TABLE `user_nickname` DISABLE KEYS */;
765 INSERT INTO `user_nickname` VALUES (1,1,'懂王','2026-01-01 00:00:00','R',NULL,NULL);
766 /*!40000 ALTER TABLE `user_nickname` ENABLE KEYS */;
767 UNLOCK TABLES;
768
769 --
770 -- Table structure for table `user_online`
771 --
772
773 DROP TABLE IF EXISTS `user_online`;
774 /*!40101 SET @saved_cs_client = @@character_set_client */;
775 /*!50503 SET character_set_client = utf8mb4 */;
776 CREATE TABLE `user_online` (
777 `SID` varchar(32) NOT NULL DEFAULT '',
778 `UID` mediumint NOT NULL DEFAULT '0',
779 `ip` varchar(20) NOT NULL DEFAULT '',
780 `current_action` varchar(20) NOT NULL DEFAULT '',
781 `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
782 `last_tm` datetime DEFAULT NULL,
783 PRIMARY KEY (`SID`) USING BTREE,
784 KEY `login_tm` (`login_tm`),
785 KEY `UID` (`UID`),
786 KEY `last_tm` (`last_tm`)
787 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
788 /*!40101 SET character_set_client = @saved_cs_client */;
789
790 --
791 -- Dumping data for table `user_online`
792 --
793
794 LOCK TABLES `user_online` WRITE;
795 /*!40000 ALTER TABLE `user_online` DISABLE KEYS */;
796 INSERT INTO `user_online` VALUES ('ffd4a4758caf718d736a4c9143fd429c',0,'172.19.0.1','WWW','2026-01-06 19:23:59','2026-01-06 19:30:01');
797 /*!40000 ALTER TABLE `user_online` ENABLE KEYS */;
798 UNLOCK TABLES;
799
800 --
801 -- Table structure for table `user_pubinfo`
802 --
803
804 DROP TABLE IF EXISTS `user_pubinfo`;
805 /*!40101 SET @saved_cs_client = @@character_set_client */;
806 /*!50503 SET character_set_client = utf8mb4 */;
807 CREATE TABLE `user_pubinfo` (
808 `UID` mediumint NOT NULL DEFAULT '0',
809 `nickname` varchar(20) DEFAULT NULL,
810 `email` varchar(30) DEFAULT NULL,
811 `gender` char(1) NOT NULL DEFAULT 'M',
812 `qq` varchar(10) DEFAULT NULL,
813 `introduction` mediumtext,
814 `photo` smallint DEFAULT '0',
815 `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
816 `photo_ext` varchar(5) NOT NULL DEFAULT '',
817 `life` smallint NOT NULL DEFAULT '15',
818 `exp` mediumint DEFAULT '0',
819 `visit_count` mediumint NOT NULL DEFAULT '0',
820 `gender_pub` tinyint unsigned NOT NULL DEFAULT '0',
821 `last_login_dt` datetime DEFAULT NULL,
822 `last_logout_dt` datetime DEFAULT NULL,
823 `sign_1` mediumtext,
824 `sign_2` mediumtext,
825 `sign_3` mediumtext,
826 `upload_limit` int NOT NULL DEFAULT '1048576',
827 `login_notify_dt` datetime DEFAULT NULL,
828 `user_timezone` varchar(50) NOT NULL DEFAULT '',
829 `game_money` int NOT NULL DEFAULT '0',
830 PRIMARY KEY (`UID`),
831 UNIQUE KEY `nickname` (`nickname`),
832 KEY `life` (`life`),
833 KEY `login_notify_dt` (`login_notify_dt`),
834 KEY `exp` (`exp`),
835 KEY `last_login_dt` (`last_login_dt`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
837 /*!40101 SET character_set_client = @saved_cs_client */;
838
839 --
840 -- Dumping data for table `user_pubinfo`
841 --
842
843 LOCK TABLES `user_pubinfo` WRITE;
844 /*!40000 ALTER TABLE `user_pubinfo` DISABLE KEYS */;
845 INSERT INTO `user_pubinfo` VALUES (1,'懂王','zhangsan@example.com','M','','',0,0,'',150,0,4,1,'2026-01-01 00:00:00','2026-01-01 00:00:00','','','',1048576,NULL,'Asia/Shanghai',0);
846 /*!40000 ALTER TABLE `user_pubinfo` ENABLE KEYS */;
847 UNLOCK TABLES;
848
849 --
850 -- Table structure for table `user_reginfo`
851 --
852
853 DROP TABLE IF EXISTS `user_reginfo`;
854 /*!40101 SET @saved_cs_client = @@character_set_client */;
855 /*!50503 SET character_set_client = utf8mb4 */;
856 CREATE TABLE `user_reginfo` (
857 `UID` mediumint NOT NULL DEFAULT '0',
858 `name` varchar(10) DEFAULT NULL,
859 `birthday` datetime DEFAULT NULL,
860 `signup_dt` datetime DEFAULT NULL,
861 `signup_ip` varchar(20) DEFAULT NULL,
862 `memo` mediumtext,
863 PRIMARY KEY (`UID`)
864 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
865 /*!40101 SET character_set_client = @saved_cs_client */;
866
867 --
868 -- Dumping data for table `user_reginfo`
869 --
870
871 LOCK TABLES `user_reginfo` WRITE;
872 /*!40000 ALTER TABLE `user_reginfo` DISABLE KEYS */;
873 INSERT INTO `user_reginfo` VALUES (1,'张三','1995-09-01 00:00:00','2026-01-01 00:00:00','127.0.0.1',NULL);
874 /*!40000 ALTER TABLE `user_reginfo` ENABLE KEYS */;
875 UNLOCK TABLES;
876
877 --
878 -- Table structure for table `user_score`
879 --
880
881 DROP TABLE IF EXISTS `user_score`;
882 /*!40101 SET @saved_cs_client = @@character_set_client */;
883 /*!50503 SET character_set_client = utf8mb4 */;
884 CREATE TABLE `user_score` (
885 `UID` mediumint NOT NULL DEFAULT '0',
886 `score` mediumint NOT NULL DEFAULT '0',
887 `last_exp` mediumint NOT NULL DEFAULT '0',
888 `exp_left` mediumint NOT NULL DEFAULT '0',
889 PRIMARY KEY (`UID`),
890 KEY `score` (`score`)
891 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
892 /*!40101 SET character_set_client = @saved_cs_client */;
893
894 --
895 -- Dumping data for table `user_score`
896 --
897
898 LOCK TABLES `user_score` WRITE;
899 /*!40000 ALTER TABLE `user_score` DISABLE KEYS */;
900 /*!40000 ALTER TABLE `user_score` ENABLE KEYS */;
901 UNLOCK TABLES;
902
903 --
904 -- Table structure for table `user_score_log`
905 --
906
907 DROP TABLE IF EXISTS `user_score_log`;
908 /*!40101 SET @saved_cs_client = @@character_set_client */;
909 /*!50503 SET character_set_client = utf8mb4 */;
910 CREATE TABLE `user_score_log` (
911 `ID` mediumint NOT NULL AUTO_INCREMENT,
912 `UID` mediumint NOT NULL DEFAULT '0',
913 `score_change` mediumint NOT NULL DEFAULT '0',
914 `reason` varchar(50) DEFAULT NULL,
915 `dt` datetime DEFAULT NULL,
916 PRIMARY KEY (`ID`),
917 KEY `UID` (`UID`)
918 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
919 /*!40101 SET character_set_client = @saved_cs_client */;
920
921 --
922 -- Dumping data for table `user_score_log`
923 --
924
925 LOCK TABLES `user_score_log` WRITE;
926 /*!40000 ALTER TABLE `user_score_log` DISABLE KEYS */;
927 /*!40000 ALTER TABLE `user_score_log` ENABLE KEYS */;
928 UNLOCK TABLES;
929
930 --
931 -- Table structure for table `view_article_log`
932 --
933
934 DROP TABLE IF EXISTS `view_article_log`;
935 /*!40101 SET @saved_cs_client = @@character_set_client */;
936 /*!50503 SET character_set_client = utf8mb4 */;
937 CREATE TABLE `view_article_log` (
938 `AID` int NOT NULL DEFAULT '0',
939 `UID` mediumint NOT NULL DEFAULT '0',
940 `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
941 PRIMARY KEY (`AID`,`UID`),
942 UNIQUE KEY `UID` (`UID`,`AID`),
943 KEY `dt` (`dt`)
944 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
945 /*!40101 SET character_set_client = @saved_cs_client */;
946
947 --
948 -- Dumping data for table `view_article_log`
949 --
950
951 LOCK TABLES `view_article_log` WRITE;
952 /*!40000 ALTER TABLE `view_article_log` DISABLE KEYS */;
953 /*!40000 ALTER TABLE `view_article_log` ENABLE KEYS */;
954 UNLOCK TABLES;
955
956 --
957 -- Table structure for table `visit_log`
958 --
959
960 DROP TABLE IF EXISTS `visit_log`;
961 /*!40101 SET @saved_cs_client = @@character_set_client */;
962 /*!50503 SET character_set_client = utf8mb4 */;
963 CREATE TABLE `visit_log` (
964 `VID` int NOT NULL AUTO_INCREMENT,
965 `dt` datetime DEFAULT NULL,
966 `ip` varchar(20) DEFAULT NULL,
967 PRIMARY KEY (`VID`)
968 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
969 /*!40101 SET character_set_client = @saved_cs_client */;
970
971 --
972 -- Dumping data for table `visit_log`
973 --
974
975 LOCK TABLES `visit_log` WRITE;
976 /*!40000 ALTER TABLE `visit_log` DISABLE KEYS */;
977 INSERT INTO `visit_log` VALUES (1,'2026-01-06 19:23:59','172.19.0.1');
978 /*!40000 ALTER TABLE `visit_log` ENABLE KEYS */;
979 UNLOCK TABLES;
980 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
981
982 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
983 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
984 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
985 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
986 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
987 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
988 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
989
990 -- Dump completed on 2026-01-06 19:36:53
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1