ok voici la table Cabinet:
Citation:
CREATE TABLE `Cabinet` (\n `IDcabinet` int(18) NOT NULL auto_increment,\n `RaisonCabinet` varchar(100) NOT NULL,\n `LoginAdmin` varchar(50) NOT NULL,\n `PwdAdmin` varchar(50) NOT NULL,\n `LoginSite` varchar(50) NOT NULL,\n `PwdSite` varchar(50) NOT NULL,\n `ModifActSoc` int(11) NOT NULL,\n `ModifNotSoc` int(4) NOT NULL,\n `ModifActCan` int(4) NOT NULL,\n `ModiNotCan` int(4) NOT NULL,\n `intervalleMis1` int(4) NOT NULL,\n `intervalleMis2` int(4) NOT NULL,\n `ModifActCandidat` int(4) NOT NULL,\n `ModifNotCandidat` int(4) NOT NULL,\n PRIMARY KEY (`IDcabinet`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
Voici un petit jeu d'enregistrement pour la table Cabinet:
Citation:
"1";"Societe X";"toto";"toto";"gototo";"toto2009";"365";"30";"365";"30";"45";"90";"365";"30"
Voici la table Typesociete:
Citation:
CREATE TABLE `Typesociete` (\n `IDtype` int(18) NOT NULL,\n `IDcabinet` int(18) NOT NULL,\n `type` varchar(200) NOT NULL,\n `dateCrea` date NOT NULL,\n `dateModif` date NOT NULL,\n `UserCrea` varchar(200) NOT NULL,\n `UserModif` varchar(200) NOT NULL,\n PRIMARY KEY (`IDtype`),\n KEY `IDcabinet` (`IDcabinet`),\n CONSTRAINT `Typesociete_ibfk_1` FOREIGN KEY (`IDcabinet`) REFERENCES `Cabinet` (`IDcabinet`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=latin1
Voici son jeu d'enregistrement:
Citation:
(1, 1, 'Client Societe X', '2002-02-27', '2004-11-05', 'Toto Toto', 'Toto Toto');
Et je redonne la table Société:
Citation:
CREATE TABLE `Societe` (\n `IDsociete` int(20) NOT NULL,\n `IDcabinet` int(18) NOT NULL,\n `RaisonSociale` varchar(200) NOT NULL,\n `IDtype` int(18) NOT NULL,\n `Statut` int(11) NOT NULL,\n `adresse1` varchar(200) NOT NULL,\n `adresse2` varchar(200) NOT NULL,\n `codepostal` varchar(50) NOT NULL,\n `Ville` varchar(100) NOT NULL,\n `Pays` varchar(100) NOT NULL,\n `telephone` varchar(50) NOT NULL,\n `fax` varchar(50) NOT NULL,\n `site` varchar(100) NOT NULL,\n `mail` varchar(100) NOT NULL,\n `info1` varchar(4000) NOT NULL,\n `info2` varchar(100) NOT NULL,\n `info3` varchar(100) NOT NULL,\n `DateCrea` date NOT NULL,\n `UserCrea` varchar(200) NOT NULL,\n `DateModif` date NOT NULL,\n `UserModif` varchar(200) NOT NULL,\n `raison2` varchar(200) NOT NULL,\n `adresse3` varchar(200) NOT NULL,\n `InfosSoc2` varchar(4000) NOT NULL,\n PRIMARY KEY (`IDsociete`),\n KEY `IDcabinet` (`IDcabinet`),\n KEY `IDtype` (`IDtype`),\n CONSTRAINT `Societe_ibfk_3` FOREIGN KEY (`IDcabinet`) REFERENCES `Cabinet` (`IDcabinet`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `Societe_ibfk_4` FOREIGN KEY (`IDtype`) REFERENCES `Typesociete` (`IDtype`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=latin1
avec son jeu d'enregistrement:
Citation:
(13150, 1, 'masociete', 37, 1, '15 rue des roses', '', '68100', 'Mulhouse', 'France', '389456318', '', 'www.test.fr', 'test@test.fr', 'tets', '208203774813150.txt', 'fulltext.txt', '2009-01-29', 'Franck Frémont', '2009-01-29', 'Franck Frémont', 'masociete', '', 'tets');