USE zzh;
DROP TABLE IF EXISTS fm_users;
CREATE TABLE fm_users (
	UserID INT UNSIGNED NOT NULL AUTO_INCREMENT,
	UserFullName CHAR(30),
	UserLoginName CHAR(10) NOT NULL,
	UserPassword CHAR(16) NOT NULL,
	UserEMail CHAR(60) NOT NULL,
	UserROD CHAR(128),
	UserGender CHAR(1),
	UserAge CHAR(5),
	UserPic CHAR(128),
	UserPicS CHAR(128),
	UserSelfInfo Text,
	UJoinDate DATE NOT NULL,
	UserCookie CHAR(32) NOT NULL,
	UCookieDate DATE NOT NULL,
	UserLastIP CHAR(15),
	UserTheadCount SMALLINT UNSIGNED NOT NULL DEFAULT 0,
	UserPostCount SMALLINT UNSIGNED NOT NULL DEFAULT 0,
	UShowEmail ENUM('0','1') NOT NULL DEFAULT '0',
	UUseCookie ENUM('0','1') NOT NULL DEFAULT '1',
	UDisplayOrder ENUM('0','1') NOT NULL DEFAULT '0',
	UTheadWithAnsOnly ENUM('0','1') NOT NULL DEFAULT '0',
	UTheadForDayOnPage TINYINT UNSIGNED DEFAULT 0,
	UTheadInPage TINYINT UNSIGNED DEFAULT 0,
	UPostInPage  TINYINT UNSIGNED DEFAULT 0,
	USendMailWithAns ENUM('0','1') NOT NULL DEFAULT '0',
	UAcceptMailFromUser ENUM('0','1') NOT NULL DEFAULT '0',
	UAcceptMailFromAdmins ENUM('0','1') NOT NULL DEFAULT '0',
	UserStatus TINYINT UNSIGNED NOT NULL DEFAULT 0,
	PRIMARY KEY (UserID),
	UNIQUE INDEX (UserLoginName)
);
#alter table fm_users add UserPicS CHAR(128) AFTER UserPic;

INSERT INTO fm_users(UserFullName,UserLoginName,UserPassword,UserEMail,UJoinDate,UserCookie,UCookieDate) 
VALUES('anonymous','anonymous',PASSWORD('kj2f5hgfd'),'',NOW(),'1',NOW());

INSERT INTO fm_users(UserFullName,UserLoginName,UserPassword,UserEMail,UJoinDate,UserCookie,UCookieDate)
VALUES('admin','admin',PASSWORD('zzh9m7'),'',NOW(),'2',NOW());