7 lines
694 B
MySQL
7 lines
694 B
MySQL
|
drop table mailuser;
|
||
|
|
create table mailuser (uid integer autoincrement primary key,login varchar(20), pwd varchar(50), gid varchar(6), email varchar(50), home varchar(30), shell varchar(20), domain varchar(50));
|
||
|
|
insert into mailuser (uid,login) values ('1999','removeme');
|
||
|
|
insert into mailuser (login,pwd,gid,email,home,shell,domain) VALUES ('acolzi','$1$UpIUL6My$C7avkcfhNKD2zIG5.MA0q.','2000','acolzi@ablia.com','/home/acolzi','/bin/tcsh','ablia.com');
|
||
|
|
insert into mailuser (login,pwd,gid,email,home,shell,domain) VALUES ('pippolo','$1$kJ7tj8Ku$bOCBleY1asCVbgvX.T1xV/','2000','pippolo@ablia.com','/home/mailusers/pippolo','/sbin/nologin','ablia.com');
|
||
|
|
delete from mailuser where uid = '1999';
|