par
Dilidim » 02 juin 2015, 17:46
L' id_client doit correspondre à l'id de la table client_tb. Si je met en NULL l'inter ne va être attribué a personne =/
CREATE TABLE IF NOT EXISTS `client_tb` (
`id` smallint(5) NOT NULL,
`nom_e` varchar(30) NOT NULL,
`nom_cl` varchar(30) NOT NULL,
`fixe` varchar(20) NOT NULL,
`fonc` varchar(30) NOT NULL,
`civ` varchar(20) NOT NULL,
`groupe` varchar(20) NOT NULL,
`contrat` varchar(20) NOT NULL,
`fax` varchar(20) NOT NULL,
`mob` varchar(20) NOT NULL,
`mail` varchar(30) NOT NULL,
`web` varchar(30) NOT NULL,
`adr` varchar(30) NOT NULL,
`ville` varchar(30) NOT NULL,
`cp` char(5) NOT NULL,
`infos` longblob NOT NULL
CREATE TABLE IF NOT EXISTS `inter` (
`id` smallint(5) NOT NULL,
`id_client` smallint(5) NOT NULL,
`date` date NOT NULL,
`inter` varchar(20) NOT NULL,
`tech` varchar(20) NOT NULL,
`comm` text NOT NULL,
`temps` decimal(10,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `client_tb`
ADD PRIMARY KEY (`id`);
ALTER TABLE `inter`
ADD PRIMARY KEY (`id`),
ADD KEY `id_client` (`id_client`);
ALTER TABLE `client_tb`
MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
ALTER TABLE `inter`
MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT;
ALTER TABLE `inter`
ADD CONSTRAINT `inter_ibfk_1` FOREIGN KEY (`id_client`) REFERENCES `client_tb` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
L' id_client doit correspondre à l'id de la table client_tb. Si je met en NULL l'inter ne va être attribué a personne =/
[PHP]CREATE TABLE IF NOT EXISTS `client_tb` (
`id` smallint(5) NOT NULL,
`nom_e` varchar(30) NOT NULL,
`nom_cl` varchar(30) NOT NULL,
`fixe` varchar(20) NOT NULL,
`fonc` varchar(30) NOT NULL,
`civ` varchar(20) NOT NULL,
`groupe` varchar(20) NOT NULL,
`contrat` varchar(20) NOT NULL,
`fax` varchar(20) NOT NULL,
`mob` varchar(20) NOT NULL,
`mail` varchar(30) NOT NULL,
`web` varchar(30) NOT NULL,
`adr` varchar(30) NOT NULL,
`ville` varchar(30) NOT NULL,
`cp` char(5) NOT NULL,
`infos` longblob NOT NULL
CREATE TABLE IF NOT EXISTS `inter` (
`id` smallint(5) NOT NULL,
`id_client` smallint(5) NOT NULL,
`date` date NOT NULL,
`inter` varchar(20) NOT NULL,
`tech` varchar(20) NOT NULL,
`comm` text NOT NULL,
`temps` decimal(10,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `client_tb`
ADD PRIMARY KEY (`id`);
ALTER TABLE `inter`
ADD PRIMARY KEY (`id`),
ADD KEY `id_client` (`id_client`);
ALTER TABLE `client_tb`
MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
ALTER TABLE `inter`
MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT;
ALTER TABLE `inter`
ADD CONSTRAINT `inter_ibfk_1` FOREIGN KEY (`id_client`) REFERENCES `client_tb` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;