Advertisement
Guest User

SQL_PHPMYADMIN

a guest
Apr 1st, 2013
47
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.82 KB | None
  1. -- SAMPLE SQL DUMP FROM PHPMYADMIN
  2.  
  3. DROP DATABASE IF EXISTS `mytest_database`;
  4. CREATE DATABASE `mytest_database`;
  5. USE `mytest_database`;
  6.  
  7. --
  8. -- Table structure for table `test_table_1`
  9. --
  10. DROP TABLE IF EXISTS `test_table_1`;
  11. CREATE TABLE IF NOT EXISTS `test_table_1` (
  12.   `test_row_1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  13.   `test_row_2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  14.   `test_row_3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  15.   `test_row_4` tinyint(2) NOT NULL DEFAULT '0',
  16.   KEY `test_row_1` (`test_row_1`),
  17.   KEY `test_row_4` (`test_row_4`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  19.  
  20. --
  21. -- Dumping data for table `test_table_1`
  22. --
  23. INSERT INTO `test_table_1` (`test_row_1`, `test_row_2`, `test_row_3`, `test_row_4`) VALUES
  24. (1, 0, 85, 0),
  25. (1, 0, 93, 0),
  26. (1, 0, 111, 0),
  27. (7, 0, 0, 23);
Advertisement
RAW Paste Data Copied
Advertisement