FamiHug

sampledb.sql

Jul 17th, 2012
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.4.5
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jul 17, 2012 at 08:05 AM
  7. -- Server version: 5.5.16
  8. -- PHP Version: 5.3.8
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `restful`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `hvnjoin`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `hvnjoin` (
  30. `_id` int(11) NOT NULL,
  31. `level` int(11) NOT NULL
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  33.  
  34. --
  35. -- Dumping data for table `hvnjoin`
  36. --
  37.  
  38. INSERT INTO `hvnjoin` (`_id`, `level`) VALUES
  39. (1, 5),
  40. (1, 3);
  41.  
  42. -- --------------------------------------------------------
  43.  
  44. --
  45. -- Table structure for table `hvnleft`
  46. --
  47.  
  48. CREATE TABLE IF NOT EXISTS `hvnleft` (
  49. `_id` int(11) NOT NULL AUTO_INCREMENT,
  50. `_name` varchar(20) NOT NULL,
  51. PRIMARY KEY (`_id`)
  52. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
  53.  
  54. --
  55. -- Dumping data for table `hvnleft`
  56. --
  57.  
  58. INSERT INTO `hvnleft` (`_id`, `_name`) VALUES
  59. (1, 'HVN'),
  60. (2, 'Cici');
  61.  
  62. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  63. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  64. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment