Log of /fenglin/TODO/sql/db_stru.sql

---

Revision 1.24 - (view) (annotate) - [selected]
Tue Dec 23 09:23:10 2025 UTC (2 months, 3 weeks ago) by sysadm
Branch: MAIN
CVS Tags: HEAD
Changes since 1.23: +1 -1 lines
Diff to previous 1.23

Use encrypted text instead plain text for temp_password

---

Revision 1.23 - (view) (annotate) - [select for diffs]
Tue Nov 11 00:57:02 2025 UTC (4 months ago) by sysadm
Branch: MAIN
Changes since 1.22: +563 -563 lines
Diff to previous 1.22 , to selected 1.24

Convert CRLF to LF

---

Revision 1.22 - (view) (annotate) - [select for diffs]
Thu Oct 16 03:56:59 2025 UTC (5 months ago) by sysadm
Branch: MAIN
Changes since 1.21: +1 -0 lines
Diff to previous 1.21 , to selected 1.24

Add exp gain for stay online

---

Revision 1.21 - (view) (annotate) - [select for diffs]
Sat Oct 11 02:34:05 2025 UTC (5 months ago) by sysadm
Branch: MAIN
Changes since 1.20: +9 -0 lines
Diff to previous 1.20 , to selected 1.24

Add table schema for user favorite topic

---

Revision 1.20 - (view) (annotate) - [select for diffs]
Tue Jun 24 09:15:26 2025 UTC (8 months, 3 weeks ago) by sysadm
Branch: MAIN
Changes since 1.19: +2 -0 lines
Diff to previous 1.19 , to selected 1.24

DB schema and configuration change to support gen_ex feature in telnet version

---

Revision 1.19 - (view) (annotate) - [select for diffs]
Sat Jun 7 12:06:12 2025 UTC (9 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.18: +1 -0 lines
Diff to previous 1.18 , to selected 1.24

Add index to support article_view_log feature in Telnet version

---

Revision 1.18 - (view) (annotate) - [select for diffs]
Sat May 31 13:39:43 2025 UTC (9 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.17: +3 -1 lines
Diff to previous 1.17 , to selected 1.24

Update SQL

---

Revision 1.17 - (view) (annotate) - [select for diffs]
Sat Apr 19 06:55:53 2025 UTC (10 months, 4 weeks ago) by sysadm
Branch: MAIN
Changes since 1.16: +0 -18 lines
Diff to previous 1.16 , to selected 1.24

Remove legacy table

---

Revision 1.16 - (view) (annotate) - [select for diffs]
Sun Apr 13 05:09:37 2025 UTC (11 months ago) by sysadm
Branch: MAIN
Changes since 1.15: +0 -28 lines
Diff to previous 1.15 , to selected 1.24

Remove legacy tables

---

Revision 1.15 - (view) (annotate) - [select for diffs]
Fri Apr 11 04:25:34 2025 UTC (11 months ago) by sysadm
Branch: MAIN
Changes since 1.14: +0 -19 lines
Diff to previous 1.14 , to selected 1.24

Remove section class master

---

Revision 1.14 - (view) (annotate) - [select for diffs]
Fri Apr 11 04:06:44 2025 UTC (11 months ago) by sysadm
Branch: MAIN
Changes since 1.13: +0 -11 lines
Diff to previous 1.13 , to selected 1.24

Remove section level user privilege control

---

Revision 1.13 - (view) (annotate) - [select for diffs]
Fri Apr 11 02:24:56 2025 UTC (11 months ago) by sysadm
Branch: MAIN
Changes since 1.12: +0 -12 lines
Diff to previous 1.12 , to selected 1.24

Remove legacy table

---

Revision 1.12 - (view) (annotate) - [select for diffs]
Wed Apr 9 09:58:54 2025 UTC (11 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.11: +0 -67 lines
Diff to previous 1.11 , to selected 1.24

Remove legacy tables

---

Revision 1.11 - (view) (annotate) - [select for diffs]
Wed Apr 9 06:15:33 2025 UTC (11 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.10: +0 -34 lines
Diff to previous 1.10 , to selected 1.24

Remove legacy tables

---

Revision 1.10 - (view) (annotate) - [select for diffs]
Tue Apr 1 10:46:40 2025 UTC (11 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.9: +45 -46 lines
Diff to previous 1.9 , to selected 1.24

Convert to InnoDB

---

Revision 1.9 - (view) (annotate) - [select for diffs]
Mon Mar 31 14:18:20 2025 UTC (11 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.8: +0 -61 lines
Diff to previous 1.8 , to selected 1.24

Update table

---

Revision 1.8 - (view) (annotate) - [select for diffs]
Fri Mar 28 12:04:46 2025 UTC (11 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.7: +8 -61 lines
Diff to previous 1.7 , to selected 1.24

Remove legacy tables

---

Revision 1.7 - (view) (annotate) - [select for diffs]
Sat Mar 8 03:32:32 2025 UTC (12 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.6: +0 -19 lines
Diff to previous 1.6 , to selected 1.24

Remove BBS prize feature

---

Revision 1.6 - (view) (annotate) - [select for diffs]
Sat Mar 8 03:30:08 2025 UTC (12 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.5: +0 -15 lines
Diff to previous 1.5 , to selected 1.24

Remove BBS prize feature

---

Revision 1.5 - (view) (annotate) - [select for diffs]
Sat Mar 8 02:58:02 2025 UTC (12 months, 1 week ago) by sysadm
Branch: MAIN
Changes since 1.4: +0 -67 lines
Diff to previous 1.4 , to selected 1.24

Remove bbs vote feature

---

Revision 1.4 - (view) (annotate) - [select for diffs]
Mon Mar 3 06:43:40 2025 UTC (12 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.3: +897 -1029 lines
Diff to previous 1.3 , to selected 1.24

Update SQL statements for creating tables

---

Revision 1.3 - (view) (annotate) - [select for diffs]
Sat Mar 1 08:51:25 2025 UTC (12 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.2: +1085 -1216 lines
Diff to previous 1.2 , to selected 1.24

Remove unused tables

---

Revision 1.2 - (view) (annotate) - [select for diffs]
Tue Sep 27 15:08:12 2005 UTC (20 years, 5 months ago) by sysadm
Branch: MAIN
CVS Tags: fenglin_1-0-0-0_MIL
Changes since 1.1: +139 -224 lines
Diff to previous 1.1 , to selected 1.24

no message

---

Revision 1.1 - (view) (annotate) - [select for diffs]
Sun Jun 20 06:59:41 2004 UTC (21 years, 9 months ago) by sysadm
Branch: MAIN
Diff to selected 1.24

Add database structure for new installation