[sshproxy-dev] Changes to sshproxy/sql/sshproxy.sql

[Pierre-Yves Rofes]

Index: sshproxy/sql/sshproxy.sql
diff -u sshproxy/sql/sshproxy.sql:1.2 sshproxy/sql/sshproxy.sql:1.3
--- sshproxy/sql/sshproxy.sql:1.2       Fri Sep 23 15:35:45 2005
+++ sshproxy/sql/sshproxy.sql   Fri Nov 18 09:39:36 2005
@@ -1,20 +1,20 @@
 -- phpMyAdmin SQL Dump
 -- version 2.6.1-rc1
 -- http://www.phpmyadmin.net
--- 
+--
 -- Serveur: localhost
 -- Généré le : Mercredi 15 Juin 2005 à 17:47
 -- Version du serveur: 4.0.24
 -- Version de PHP: 4.3.10
--- 
+--
 -- Base de données: `sshproxy`
--- 
+--
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `login`
--- 
+--
 
 CREATE TABLE `login` (
   `id` mediumint(10) unsigned NOT NULL auto_increment,
@@ -24,19 +24,11 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
--- 
--- Contenu de la table `login`
--- 
-
-INSERT INTO `login` VALUES (1, 'david', 'david', '');
-INSERT INTO `login` VALUES (3, 'py', 'test', 1);
-
-
 -- --------------------------------------------------------
 
 --
 -- Structure de la table `login_profile`
--- 
+--
 
 CREATE TABLE `login_profile` (
   `login_id` int(10) unsigned NOT NULL default '0',
@@ -44,15 +36,11 @@
   PRIMARY KEY (`login_id`,`profile_id`)
 ) TYPE=MyISAM COMMENT='login profil link';
 
---
--- Contnu de la table `login_profile`
---
-
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `profile`
--- 
+--
 
 CREATE TABLE `profile` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -60,16 +48,11 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM COMMENT='User groups' AUTO_INCREMENT=1 ;
 
--- 
--- Contenu de la table `profile`
--- 
-
-
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `profile_sgroup`
--- 
+--
 
 CREATE TABLE `profile_sgroup` (
   `profile_id` int(10) unsigned NOT NULL default '0',
@@ -77,16 +60,11 @@
   PRIMARY KEY  (`profile_id`,`sgroup_id`)
 ) TYPE=MyISAM COMMENT='profile sitegroup link';
 
--- 
--- Contenu de la table `profile_sgroup`
--- 
-
-
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `sgroup`
--- 
+--
 
 CREATE TABLE `sgroup` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -94,16 +72,12 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM COMMENT='Site groups' AUTO_INCREMENT=1 ;
 
--- 
--- Contenu de la table `sgroup`
--- 
-
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `sgroup_site`
--- 
+--
 
 CREATE TABLE `sgroup_site` (
   `sgroup_id` int(10) unsigned NOT NULL default '0',
@@ -111,16 +85,11 @@
   PRIMARY KEY  (`sgroup_id`,`site_id`)
 ) TYPE=MyISAM;
 
--- 
--- Contenu de la table `sgroup_site`
--- 
-
-
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `site`
--- 
+--
 
 CREATE TABLE `site` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -131,18 +100,11 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
 
--- 
--- Contenu de la table `site`
--- 
-
-INSERT INTO `site` VALUES (1, 'pong', '192.168.10.24', 22, 'Office');
-INSERT INTO `site` VALUES (2, 'winxp', '192.168.10.6', 22, 'Office');
-
 -- --------------------------------------------------------
 
--- 
+--
 -- Structure de la table `user`
--- 
+--
 
 CREATE TABLE `user` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -153,10 +115,3 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
 
--- 
--- Contenu de la table `user`
--- 
-
-INSERT INTO `user` VALUES (1, 1, 'romain', 'rom', 1);
-INSERT INTO `user` VALUES (2, 2, 'david', 'dav', 1);
-INSERT INTO `user` VALUES (3, 3, 'py', 'test', 1);