Advertisement
Guest User

Структура

a guest
Feb 1st, 2016
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. CREATE TABLE `books` (
  2.   `qid` INT(11) NOT NULL,
  3.   `name` tinytext NOT NULL,
  4.   `aid` INT(11) NOT NULL,
  5.   `tags` text NOT NULL,
  6.   `url` text NOT NULL
  7. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  8.  
  9. ALTER TABLE `books`
  10.   ADD PRIMARY KEY (`qid`);
  11.  
  12. ALTER TABLE `books`
  13.   MODIFY `qid` INT(11) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement