1
0

stat_table_building.sql 464 B

123456789101112131415161718192021222324
  1. -- --------------------------------------------------------
  2. --
  3. -- Table structure for table `building`
  4. --
  5. CREATE TABLE `building` (
  6. `id` int(11) NOT NULL,
  7. `name` varchar(50) NOT NULL,
  8. `comment` text DEFAULT NULL
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  10. --
  11. -- Truncate table before insert `building`
  12. --
  13. TRUNCATE TABLE `building`;
  14. --
  15. -- Dumping data for table `building`
  16. --
  17. INSERT INTO `building` (`id`, `name`, `comment`) VALUES
  18. (1, 'Earth', 'Somewhere');