Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

novaCMS - MySQL Queries

By: a guest on Jul 19th, 2012  |  syntax: SQL  |  size: 2.47 KB  |  views: 3,342  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server version:               5.5.16 - MySQL Community Server (GPL)
  4. -- Server OS:                    Win32
  5. -- HeidiSQL version:             7.0.0.4053
  6. -- Date/time:                    2012-07-15 09:53:02
  7. -- --------------------------------------------------------
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
  12.  
  13. -- Dumping structure for table phx381.ranks
  14. CREATE TABLE IF NOT EXISTS `ranks` (
  15.   `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  16.   `name` VARCHAR(50) NOT NULL,
  17.   `badgeid` VARCHAR(5) DEFAULT NULL,
  18.   `colour` VARCHAR(50) DEFAULT 'blue',
  19.   `staff_page` enum('1','0') DEFAULT '0',
  20.   PRIMARY KEY (`id`)
  21. ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
  22.  
  23. -- Dumping data for table phx381.ranks: 9 rows
  24. /*!40000 ALTER TABLE `ranks` DISABLE KEYS */;
  25. INSERT INTO `ranks` (`id`, `name`, `badgeid`, `colour`, `staff_page`) VALUES
  26.         (1, 'User', NULL, NULL, NULL),
  27.         (2, 'VIP', 'VIP', NULL, NULL),
  28.         (3, 'Silver Hobba', 'NWB', NULL, NULL),
  29.         (4, 'Gold Hobba', 'HBA', NULL, NULL),
  30.         (5, 'Trial Moderator', 'HBA', 'green', '1'),
  31.         (6, 'Moderator', 'ADM', 'orange', '1'),
  32.         (7, 'Administrator', 'ADM', 'blue', '1'),
  33.         (8, 'Manager', 'NHM', 'blue2', '1'),
  34.         (9, 'Overlord', 'NHF', 'black', '1');
  35. /*!40000 ALTER TABLE `ranks` ENABLE KEYS */;
  36. /*!40014 SET FOREIGN_KEY_CHECKS=1 */;
  37. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  38.  
  39. -- Dumping structure for table phx381.cms_news
  40. CREATE TABLE IF NOT EXISTS `cms_news` (
  41.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  42.   `title` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
  43.   `shortstory` text COLLATE latin1_general_ci,
  44.   `longstory` text COLLATE latin1_general_ci,
  45.   `published` VARCHAR(30) COLLATE latin1_general_ci NOT NULL DEFAULT 'Unspecified',
  46.   `author` INT(255) NOT NULL DEFAULT '1',
  47.   `image_position` VARCHAR(50) COLLATE latin1_general_ci NOT NULL DEFAULT '0px 0px',
  48.   `image` VARCHAR(500) COLLATE latin1_general_ci DEFAULT 'public/images/hotelview_banzai.png',
  49.   PRIMARY KEY (`id`)
  50. ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  51.  
  52. -- Dumping data for table phx381.cms_news: 3 rows
  53. /*!40000 ALTER TABLE `cms_news` DISABLE KEYS */;
  54. /*!40000 ALTER TABLE `cms_news` ENABLE KEYS */;
  55. /*!40014 SET FOREIGN_KEY_CHECKS=1 */;
  56. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;