priorities.sql 629 B

1234567891011121314151617181920212223242526272829
  1. -- --------------------------------------------------------
  2. --
  3. -- Table structure for table `priorities`
  4. --
  5. -- Creation: Aug 20, 2015 at 12:10 AM
  6. --
  7. DROP TABLE IF EXISTS `priorities`;
  8. CREATE TABLE IF NOT EXISTS `priorities` (
  9. `id` int(10) NOT NULL,
  10. `name` varchar(50) COLLATE utf8_bin NOT NULL
  11. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  12. --
  13. -- RELATIONS FOR TABLE `priorities`:
  14. --
  15. --
  16. -- Indexes for table `priorities`
  17. --
  18. ALTER TABLE `priorities`
  19. ADD PRIMARY KEY (`id`);
  20. --
  21. -- AUTO_INCREMENT for table `priorities`
  22. --
  23. ALTER TABLE `priorities`
  24. MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;