settings.sql 505 B

1234567891011121314151617181920212223
  1. -- --------------------------------------------------------
  2. --
  3. -- Table structure for table `settings`
  4. --
  5. -- Creation: Sep 02, 2015 at 11:35 AM
  6. --
  7. DROP TABLE IF EXISTS `settings`;
  8. CREATE TABLE IF NOT EXISTS `settings` (
  9. `name` varchar(50) COLLATE utf8_bin NOT NULL,
  10. `value` varchar(100) COLLATE utf8_bin NOT NULL
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  12. --
  13. -- RELATIONS FOR TABLE `settings`:
  14. --
  15. --
  16. -- Indexes for table `settings`
  17. --
  18. ALTER TABLE `settings`
  19. ADD PRIMARY KEY (`name`);