1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| <?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 3.4.5
- http://www.phpmyadmin.net
-
- Client: localhost
- Généré le : Lun 27 Janvier 2014 à 20:41
- Version du serveur: 5.5.16
- Version de PHP: 5.3.8
-->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="bdmanip" collation="latin1_swedish_ci" charset="latin1">
<pma:table name="contact">
CREATE TABLE `contact` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tel` varchar(255) CHARACTER SET utf8 NOT NULL,
`mail` varchar(255) CHARACTER SET utf8 NOT NULL,
`meuble` varchar(255) CHARACTER SET utf8 NOT NULL,
`materiel` varchar(255) CHARACTER SET utf8 NOT NULL,
`userid` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userid` (`userid`),
KEY `userid_2` (`userid`),
KEY `userid_3` (`userid`),
CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
</pma:table>
<pma:table name="user">
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`contact_id` int(11) NOT NULL,
`nom` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
</pma:table>
</pma:database>
</pma:structure_schemas> |
Partager