Newsclasses table
ClassIDClassNameClassType
News table
NewsPathmsgid -> NewsIDimportant -> ClassIDusername -> UserIDname -> UserNameadddate -> AddTimeedate / month / year1 -> BDateedate / month / year2 -> EDatesubject -> NewsTitlemessage -> NewsBodyip -> IPmsgsn - -> Newssn
Upfiles table
MSGID -> NewsIdfilesn -> FilesnID -> FileID ...
UserS table
UserName -> UseridPassword -> PasswordName -> UserNameUsertype -> UserTypeuserinfo -> (DEL) User_ID -> Id} -> NewsPowerPackage -> packagepower
1. User password encryption with MD5
2. The information validity period is set optionally, the method: does not set, the field is empty, and does not write to the page. Alternatively, it can be considered to identify the validity period information in the directory.
3. About permission settings. Just use the newsclasses.classid with published privileges to be recorded in users.newspower, implementation methods such as the behavior 1, 3, 11, the user login page in Users.Newspower, "DIM CLASSID STRCLASSID = Class (1) 'Class ( 1) = 3Str = Class & ClassIDSession (STR) = 1 ...%> can be judged by session
