alecwh / clean.sql

-- phpMyAdmin SQL Dump
-- version 3.3.2deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 05, 2010 at 07:58 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.2-1ubuntu4.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `web_log`
--

-- --------------------------------------------------------

--
-- Table structure for table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id_` int(5) NOT NULL AUTO_INCREMENT,
  `url_id` varchar(500) NOT NULL,
  `title` varchar(2000) NOT NULL,
  `tags` varchar(2000) NOT NULL,
  `author` varchar(200) NOT NULL,
  `timestamp` varchar(10) NOT NULL,
  `content` text NOT NULL,
  `comment_count` int(5) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `active` int(1) NOT NULL,
  PRIMARY KEY (`id_`),
  UNIQUE KEY `url_id` (`url_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` (`id_`, `url_id`, `title`, `tags`, `author`, `timestamp`, `content`, `comment_count`, `ip`, `active`) VALUES
(1, 'welcome-to-point-blank', 'Welcome to Point-blank', 'announcements, help', '', '1275674040', 'Congrats on getting Point-blank up and running. Now just login (to the right) with the credentials you supplied in `config.rc`. Once logged in, you''ll be able to delete this article and create new ones from this page.\r\n\r\nWhat is Point-blank?\r\n--------------------\r\n\r\nPoint-blank is a content management system written in Python. It uses [web.py](#) for its framework and [Storm](#) for the ORM. It is intentionally minimal. Some of the benefits of Point-blank are:\r\n\r\n1. Simple to setup\r\n2. Simple to use (intuitive, uses Markdown text)\r\n3. Minimalistic, small size\r\n5. In-line, in-your-face administration.\r\n6. Portable (can be used on any WSGI server, selection of database types)\r\n\r\nPoint-blank is essentially an extremely lightweight blog mixed with a very simple wiki system. If you want to add static pages/content to your website, you need to create a page in `static/pages/` with the filename as the name of the page. There is a demo page included: [preview it and delete it if you want](#). Remember that while you can type in HTML, Markdown is also accepted as input. I suggest learning the [Markdown syntax](http://en.wikipedia.org/wiki/Markdown#Syntax_examples) to type faster and easier.\r\n\r\nChanging the default template\r\n-----------------------------\r\n\r\nFirst, you''ll probably going to want to modify the default template. You can find these in the `templates/` directory, and any CSS/JS/images can be edited in the `static/` directory. Before making any serious modifications to these templates, skim through and see how these templates are constructed. For example, it''s important to note that *all paths must include `$site_vars[''base_url'']` before the rest of the location.* This will be replaced with something like `http://example.com/`.\r\n\r\nFor example, this is the template for the login form:\r\n\r\n	<link rel="stylesheet" type="text/css" href="$site_vars[''base_url'']static/css/_main.css" />\r\n\r\nFinally, if you want to be able to use the CSS/JS files as templates, you must place an underscore before its name, like `_main.css`.\r\n\r\n\r\nModifying the configuration\r\n----------------------------\r\n\r\nAny change to `config.rc` will require a server restart, or at least the termination of the WSGI program. This is very easy to overlook, so hopefully this reminder will save you some headaches.\r\n\r\n\r\nPoint-blank is open-source\r\n--------------------------\r\n\r\nPoint-blank is [Free Software](#) and is licensed under the GNU GPL. That means you can change this program and share it easily with your friends or users. You can read more about the GPL at the [FSF](#).\r\n\r\nIf you are a programmer, you can help me out by fixing bugs, cleaning up code, and making things more efficient. I gladly accept community branches into the main codebase at [Bitbucket](#).\r\n\r\n\r\n', 0, 'localhost', 1);

-- --------------------------------------------------------

--
-- Table structure for table `article_tag_assoc`
--

CREATE TABLE IF NOT EXISTS `article_tag_assoc` (
  `id_` int(20) NOT NULL AUTO_INCREMENT,
  `tag` varchar(200) NOT NULL,
  `article` int(20) NOT NULL,
  PRIMARY KEY (`id_`),
  KEY `tag` (`tag`,`article`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `article_tag_assoc`
--

INSERT INTO `article_tag_assoc` (`id_`, `tag`, `article`) VALUES
(1, 'announcements', 1);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id_` int(10) NOT NULL AUTO_INCREMENT,
  `article_id` int(10) NOT NULL,
  `thread_id` int(10) NOT NULL,
  `author` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `text` varchar(10000) NOT NULL,
  `timestamp` varchar(10) NOT NULL,
  PRIMARY KEY (`id_`),
  KEY `article_id` (`article_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `comments`
--


-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE IF NOT EXISTS `tags` (
  `id_` int(10) NOT NULL AUTO_INCREMENT,
  `tag` varchar(20) NOT NULL,
  `timestamp` int(10) NOT NULL,
  PRIMARY KEY (`id_`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id_`, `tag`, `timestamp`) VALUES
(15, 'announcements', 1275674041);
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.