Pan2020

Untitled

Feb 13th, 2019
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.74 KB | None | 0 0
  1. CREATE TABLE `products_description` (
  2.   `products_id` int(11) NOT NULL,
  3.   `language_id` int(11) NOT NULL DEFAULT '1',
  4.   `products_name` varchar(255) NOT NULL DEFAULT '',
  5.   `products_description` mediumtext,
  6.   `products_url` varchar(255) DEFAULT NULL,
  7.   `products_viewed` int(5) DEFAULT '0',
  8.   PRIMARY KEY (`products_id`,`language_id`),
  9.   KEY `idx_products_name_zen` (`products_name`),
  10.   FULLTEXT KEY `products_description` (`products_description`),
  11.   FULLTEXT KEY `products_name` (`products_name`),
  12.   FULLTEXT KEY `products_description_2` (`products_description`),
  13.   FULLTEXT KEY `products_name_2` (`products_name`),
  14.   FULLTEXT KEY `products_description_3` (`products_description`)
  15. ) ENGINE=MyISAM AUTO_INCREMENT=1194 DEFAULT CHARSET=utf8;
Add Comment
Please, Sign In to add comment