| | |
| | | -- Daten für Tabelle `mail_mailman_domain` |
| | | -- |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `mail_traffic` |
| | | -- |
| | | |
| | | CREATE TABLE `mail_traffic` ( |
| | | `traffic_id` int(10) unsigned NOT NULL auto_increment, |
| | | `mailuser_id` int(10) unsigned NOT NULL, |
| | | `month` char(7) NOT NULL, |
| | | `traffic` bigint(20) unsigned NOT NULL, |
| | | PRIMARY KEY (`traffic_id`), |
| | | KEY `mailuser_id` (`mailuser_id`,`month`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `mail_traffic` |
| | | -- |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | |
| | | -- |
| | | -- Daten für Tabelle `mail_user` |
| | | -- |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `remote_session` |
| | | -- |
| | | |
| | | CREATE TABLE `remote_session` ( |
| | | `remote_session` varchar(50) NOT NULL, |
| | | `remote_userid` int(11) NOT NULL, |
| | | `remote_functions` text NOT NULL, |
| | | `tstamp` int(10) unsigned NOT NULL, |
| | | PRIMARY KEY (`remote_session`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `remote_session` |
| | | -- |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `remote_user` |
| | | -- |
| | | |
| | | CREATE TABLE `remote_user` ( |
| | | `remote_userid` int(11) NOT NULL auto_increment, |
| | | `remote_username` varchar(255) NOT NULL, |
| | | `remote_password` varchar(255) NOT NULL, |
| | | `remote_functions` text NOT NULL, |
| | | PRIMARY KEY (`remote_userid`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `remote_user` |
| | | -- |
| | | |
| | | |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `support_message` |
| | | -- |
| | | |
| | | CREATE TABLE `support_message` ( |
| | | `support_message_id` bigint(20) NOT NULL auto_increment, |
| | | `sys_userid` int(11) NOT NULL default '0', |
| | | `sys_groupid` int(11) 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, |
| | | `recipient_id` int(11) NOT NULL default '0', |
| | | `sender_id` int(11) NOT NULL default '0', |
| | | `subject` varchar(255) default NULL, |
| | | `message` varchar(255) default NULL, |
| | | `tstamp` int(11) NOT NULL default '1187707778', |
| | | PRIMARY KEY (`support_message_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `sys_datalog` |
| | | -- |
| | | |