Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- SAMPLE SQL DUMP FROM PHPMYADMIN
- DROP DATABASE IF EXISTS `mytest_database`;
- CREATE DATABASE `mytest_database`;
- USE `mytest_database`;
- --
- -- Table structure for table `test_table_1`
- --
- DROP TABLE IF EXISTS `test_table_1`;
- CREATE TABLE IF NOT EXISTS `test_table_1` (
- `test_row_1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `test_row_2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `test_row_3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `test_row_4` tinyint(2) NOT NULL DEFAULT '0',
- KEY `test_row_1` (`test_row_1`),
- KEY `test_row_4` (`test_row_4`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- --
- -- Dumping data for table `test_table_1`
- --
- INSERT INTO `test_table_1` (`test_row_1`, `test_row_2`, `test_row_3`, `test_row_4`) VALUES
- (1, 0, 85, 0),
- (1, 0, 93, 0),
- (1, 0, 111, 0),
- (7, 0, 0, 23);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement