Advertisement
Guest User

articles

a guest
Nov 30th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.37 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `articles` (
  2. `id` int(10) unsigned NOT NULL,
  3.   `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  4.   `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  5.   `save_as` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  6.   `search_text` text COLLATE utf8_unicode_ci NOT NULL,
  7.   `ori_descr` text COLLATE utf8_unicode_ci NOT NULL,
  8.   `category` int(10) unsigned NOT NULL DEFAULT '0',
  9.   `added` int(11) NOT NULL,
  10.   `views` int(10) unsigned NOT NULL DEFAULT '0',
  11.   `hits` int(10) unsigned NOT NULL DEFAULT '0',
  12.   `last_action` int(11) NOT NULL,
  13.   `visible` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  14.   `owner` int(10) unsigned NOT NULL DEFAULT '0',
  15.   `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  16.   `anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  17.   `allowid` text COLLATE utf8_unicode_ci NOT NULL
  18. ) ENGINE=MyISAM AUTO_INCREMENT=1364 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  19.  
  20. --
  21. -- Dumping data for table `articles`
  22. --
  23.  
  24. INSERT INTO `articles` (`id`, `info_hash`, `name`, `save_as`, `search_text`, `ori_descr`, `category`, `added`, `views`, `hits`, `last_action`, `visible`, `owner`, `sticky`, `anonymous`, `allowid`) VALUES
  25. (1363, '00456ba9fb928d71042ffca5388f33a7e20761ba', 'Test', 'Test', 'Test', 'Test article', 45, 1512066306, 3, 5, 1512066368, 'no', 1, 'no', 'no', '841,840');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement