208
-- ----------------------------
209
-- Records of UploadFile
210
-- ----------------------------
211
212
-- ----------------------------
213 www.2cto.com
-- Table structure for `UserList`
214
-- ----------------------------
215
DROP TABLE IF EXISTS `UserList`;
216
CREATE TABLE `UserList` (
217
`UserID` bigint(20) NOT NULL auto_increment COMMENT '用户编号',
218
`DepartID` bigint(20) default NULL COMMENT '设备编号',
219
`UserName` varchar(20) default NULL COMMENT '用户名',
220
`UserPWD` varchar(200) default NULL COMMENT '用户密码',
221
`FullName` varchar(100) default NULL COMMENT '用户姓名',
222
`UserDesc` varchar(50) default NULL COMMENT '用户描述信息',
223
`
IDCard` varchar(40) default NULL COMMENT '身份证号',
224
`UserPopedom` int(20) default '0' COMMENT '用户权限值',
225
PRIMARY KEY (`UserID`)
226
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户信息表';
227
228
-- ----------------------------
229
-- Records of UserList
230
-- ----------------------------
231
232
INSERT INTO UserList VALUES ('1', concat(@Prov_Code,'000000') , 'styh', '698d51a19d8a121ce581499d7b701668', 'styh', @Prov_Name, '123456789987654', '63');
233
INSERT INTO UserList VALUES ('2', concat(@Area_Code,'0000') , 'admin', '698d51a19d8a121ce581499d7b701668', 'sjyh', @Area_Name, '123456789987654', '63');
234
235
-- ----------------------------
236
-- Table structure for `UserAuthenticate`
237
-- ----------------------------
238
DROP TABLE IF EXISTS `UserAuthenticate`;
239
CREATE TABLE `UserAuthenticate` (
240
`AuthID` bigint(20) NOT NULL auto_increment COMMENT '授权编号',
241
`UserID` bigint(20) default NULL COMMENT '用户编号',
242
`ManageDepartID` bigint(20) default NULL COMMENT '授权给该用户的可以访问的单位的编号',
243
PRIMARY KEY (`AuthID`) www.2cto.com
244
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户权限信息表';
245
246
-- ----------------------------
247
-- Records of UserAuthenticate
248
-- ----------------------------
249
INSERT INTO UserAuthenticate VALUES ('1', '1', concat(@Prov_Code,'000000'));
250
INSERT INTO UserAuthenticate VALUES ('2', '2', concat(@Area_Code,'0000'));
251
252
-- ----------------------------
253
-- Table structure for `UserLog`
254
-- ----------------------------
255
DROP TABLE IF EXISTS `UserLog`;
256
CREATE TABLE `UserLog` (
257
`LogID` bigint(16) NOT NULL auto_increment COMMENT '登录编号',
258
`UserID` bigint(16) NOT NULL COMMENT '用户编号',
259
`IPAddr` varchar(50) default NULL COMMENT '用户登录时使用的IP地址',
260
`LogINTime` datetime default NULL COMMENT '登录时间',
261
`LogOUTTime` datetime default NULL COMMENT '注销时间',
262
PRIMARY KEY (`LogID`) www.2cto.com
263
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='用户登录记录表';
264
265
-- ----------------------------
266
-- Records of UserLog
267
-- ----------------------------
268
269
-- ----------------------------
270
-- Table structure for `VoiceFileList`
271
-- ----------------------------
272
DROP TABLE IF EXISTS `VoiceFileList`;
273
CREATE TABLE `VoiceFileList` (
274
`FileID`