| | |
| | | `usertheme` varchar(32) NOT NULL default 'default', |
| | | `template_master` int(11) unsigned NOT NULL default '0', |
| | | `template_additional` varchar(255) NOT NULL default '', |
| | | `created_at` datetime default NULL, |
| | | `created_at` bigint(20) DEFAULT NULL, |
| | | PRIMARY KEY (`client_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | |
| | | `uid` int(11) unsigned NOT NULL default '5000', |
| | | `gid` int(11) unsigned NOT NULL default '5000', |
| | | `maildir` varchar(255) NOT NULL default '', |
| | | `quota` int(11) NOT NULL default '0', |
| | | `quota` int(11) NOT NULL default '-1', |
| | | `homedir` varchar(255) NOT NULL, |
| | | `autoresponder` enum('n','y') NOT NULL default 'n', |
| | | `autoresponder_text` mediumtext NULL, |
| | |
| | | |
| | | CREATE TABLE `remote_user` ( |
| | | `remote_userid` int(11) unsigned NOT NULL auto_increment, |
| | | `sys_userid` int(11) unsigned NOT NULL default '0', |
| | | `sys_groupid` int(11) unsigned NOT NULL default '0', |
| | | `sys_perm_user` varchar(5) default NULL, |
| | | `sys_perm_group` varchar(5) default NULL, |
| | | `sys_perm_other` varchar(5) default NULL, |
| | | `remote_username` varchar(64) NOT NULL, |
| | | `remote_password` varchar(64) NOT NULL, |
| | | `remote_functions` text NOT NULL, |