Advertisement
Guest User

Untitled

a guest
Nov 9th, 2015
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1.  
  2. --
  3. -- Структура таблицы `payment_statuses`
  4. --
  5.  
  6. CREATE TABLE IF NOT EXISTS `payment_statuses` (
  7. `id` int(10) unsigned NOT NULL,
  8. `name` varchar(32) NOT NULL,
  9. `title` varchar(32) NOT NULL
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  11.  
  12. --
  13. -- Индексы сохранённых таблиц
  14. --
  15.  
  16. --
  17. -- Индексы таблицы `payment_statuses`
  18. --
  19. ALTER TABLE `payment_statuses`
  20. ADD PRIMARY KEY (`id`);
  21.  
  22. --
  23. -- AUTO_INCREMENT для сохранённых таблиц
  24. --
  25.  
  26. --
  27. -- AUTO_INCREMENT для таблицы `payment_statuses`
  28. --
  29. ALTER TABLE `payment_statuses`
  30. MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement