-- -- Database: `qoob` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `admin_id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`admin_id`, `name`, `username`, `password`, `email`) VALUES (1, 'qoob user', 'qoob', 'gAAJoQ;zoC2oBgi;Ll5cD63H3Yn9vBLzfB+/j1K9iw4=', 'open@qoob.nu'); -- password is: openqoob! -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE IF NOT EXISTS `blog_categories` ( `qoob_cat_id` int(255) NOT NULL AUTO_INCREMENT, `blog_cat_id` double NOT NULL, `name` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, PRIMARY KEY (`qoob_cat_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `blog_meta` -- CREATE TABLE IF NOT EXISTS `blog_meta` ( `meta_id` int(255) NOT NULL AUTO_INCREMENT, `blog_id` int(255) NOT NULL, `meta_key` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `meta_val` varchar(1000) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`meta_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `blog_posts` -- CREATE TABLE IF NOT EXISTS `blog_posts` ( `post_id` int(255) NOT NULL AUTO_INCREMENT, `url` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `subtitle` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `excerpt` varchar(2000) COLLATE utf8_unicode_ci NOT NULL, `content` longtext COLLATE utf8_unicode_ci NOT NULL, `comments` int(255) NOT NULL, `date` int(255) NOT NULL, `live` int(1) NOT NULL, PRIMARY KEY (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `blog_tags` -- CREATE TABLE IF NOT EXISTS `blog_tags` ( `tag_id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `url` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `tag_count` int(255) NOT NULL DEFAULT '0', PRIMARY KEY (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `code` -- CREATE TABLE IF NOT EXISTS `code` ( `git_id` int(255) NOT NULL AUTO_INCREMENT, `repo` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, `name` varchar(300) NOT NULL, `subtitle` varchar(300) NOT NULL, `description` varchar(1000) NOT NULL, `readme` longtext NOT NULL, PRIMARY KEY (`git_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gallery_categories` -- CREATE TABLE IF NOT EXISTS `gallery_categories` ( `qoob_cat_id` int(255) NOT NULL AUTO_INCREMENT, `gallery_cat_id` double NOT NULL, `name` varchar(50) NOT NULL, `url` varchar(50) NOT NULL, `title` varchar(300) NOT NULL, `excerpt` varchar(1000) NOT NULL, `description` longtext NOT NULL, `mainImg` int(255) NOT NULL, `live` int(1) NOT NULL, PRIMARY KEY (`qoob_cat_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gallery_images` -- CREATE TABLE IF NOT EXISTS `gallery_images` ( `image_id` int(255) NOT NULL AUTO_INCREMENT, `url` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `filename` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `subtitle` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `excerpt` varchar(1000) COLLATE utf8_unicode_ci NOT NULL, `description` longtext COLLATE utf8_unicode_ci NOT NULL, `comments` int(255) NOT NULL, `date` int(255) NOT NULL, `live` int(1) NOT NULL, PRIMARY KEY (`image_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gallery_meta` -- CREATE TABLE IF NOT EXISTS `gallery_meta` ( `meta_id` int(255) NOT NULL AUTO_INCREMENT, `gallery_id` int(255) NOT NULL, `meta_key` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `meta_val` varchar(1000) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`meta_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE IF NOT EXISTS `pages` ( `id` int(255) NOT NULL AUTO_INCREMENT, `url` varchar(30) NOT NULL, `title` varchar(100) NOT NULL, `subtitle` varchar(500) NOT NULL, `body` longtext NOT NULL, `script` longtext, `mainCat` varchar(50) DEFAULT NULL, `meta` varchar(1000) DEFAULT NULL, `sidebar` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `url`, `title`, `subtitle`, `body`, `script`, `mainCat`, `meta`, `sidebar`) VALUES (1, 'index', 'open qoob', 'The default page', 'hello world!', '', 'about', '', ''), (4, 'contact', 'Contact', 'Get in touch', '
', ' function validate() { var error = false; var errMsg = '