Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.0.10deb1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Nov 05, 2015 at 06:53 PM
- -- Server version: 5.6.27-0ubuntu0.14.04.1
- -- PHP Version: 5.5.9-1ubuntu4.14
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `test`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `table2`
- --
- CREATE TABLE IF NOT EXISTS `table2` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk` (`fk`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Dumping data for table `table2`
- --
- INSERT INTO `table2` (`id`, `fk`) VALUES
- (1, 1);
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `table2`
- --
- ALTER TABLE `table2`
- ADD CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`fk`) REFERENCES `table1` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement