From 8951334b228c72a6310161a7c324f446b3bcea78 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Tue, 21 Aug 2007 17:28:03 -0400 Subject: [PATCH] Remote user and session database tables. --- install/sql/ispconfig3.sql | 40 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 40 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index d379671..d96333f 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -416,6 +416,46 @@ -- -------------------------------------------------------- -- +-- 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 `server` -- -- Gitblit v1.9.1