|ok|
\n',1215907490,',1,',0); INSERT INTO `bsc_articles` VALUES (2,'tech-2','Daniel','tech','tech','well, lol _ok_','well, lol ok
\n',1215856800,',2,7,',0); INSERT INTO `bsc_articles` VALUES (3,'well','Richard','Wellity','Wellity','Well well well. ','Well well well.
\n',1215893879,',2,6,',0); INSERT INTO `bsc_articles` VALUES (13,'righto','Daniel','righto','righto','time set EDIT','time set EDIT
\n',1216002095,',2,5,',0); INSERT INTO `bsc_articles` VALUES (10,'ok-terrific','Daniel','ok terrific','ok terrific','here we go','here we go
\n',1216000969,',1,5,',0); INSERT INTO `bsc_articles` VALUES (11,'ok-terrific-2','Daniel','ok terrific','ok terrific','here we go 2','here we go 2
\n',1216000973,',1,5,',0); INSERT INTO `bsc_articles` VALUES (12,'testing-time','Daniel','testing time','testing time','ooookagain then here goes AGAIN and again','ooookagain then here goes AGAIN and again
\n',1216001950,',10,',0); INSERT INTO `bsc_articles` VALUES (14,'yehaw','bob','yehaw','yehaw','hello world again','hello world again
\n',1216044000,',2,5,',0); INSERT INTO `bsc_articles` VALUES (18,'testing-again','Daniel','testing again','testing again','ok again','ok again
\n',1184428802,',6,',0); INSERT INTO `bsc_articles` VALUES (17,'testing','Daniel','testing','testing','ok','ok
\n',1184428800,',6,',0); INSERT INTO `bsc_articles` VALUES (19,'sfwg','Daniel','sfwg','sfwg','w45hw46h','w45hw46h
\n',1216054800,',10,8,',0); INSERT INTO `bsc_articles` VALUES (20,'is-this-the-box-the-the-adress','Richard','A Short Ode','A Short Ode','This is Bluesuncorp, I am Richard,\n\nI am great for all to see,\n\nand though \'tis clear I am no bard,\n\nmy poetry surely impresses thee?\n','This is Bluesuncorp, I am Richard,
\n\nI am great for all to see,
\n\nand though \'tis clear I am no bard,
\n\nmy poetry surely impresses thee?
\n',1216087202,',2,5,6,7,',0); INSERT INTO `bsc_articles` VALUES (21,'markdown-example','Daniel','Markdown Example','Markdown Example','This is a Header\n----------------\n\n**This is bold** and _this is italic_.\n\nThis is a [link](http://bluesuncorp.co.uk).\n\n> This is a quote.\n>\n> It contains multiple paragraphs.\n\n* This\n* Is\n* An\n* Unordered\n* List\n\n1. This\n2. Is\n3. An\n4. Ordered\n5. List\n\nThis is a line break:\n\n-----\n\n This is a\n\nThis is another link: ','This is a Header
\n\nThis is bold and this is italic.
\n\nThis is a link.
\n\n\n This is a quote.
\n \n It contains multiple paragraphs.
\n
\n\n\n- This
\n- Is
\n- An
\n- Unordered
\n- List
\n
\n\n\n- This
\n- Is
\n- An
\n- Ordered
\n- List
\n
\n\nThis is a line break:
\n\n
\n\nThis is a <code block>\n
\n\nThis is another link: http://bluesuncorp.co.uk
\n',1216087201,',8,9,',0);
INSERT INTO `bsc_articles` VALUES (24,'i-am-the-author','bob','I am the author','I am the author','of this post\n\n* ok','of this post
\n\n\n- ok
\n
\n',1216170001,',6,',0);
INSERT INTO `bsc_articles` VALUES (25,'list-test','Daniel','List Test','List Test','* this\n* is\n * a\n * sublist?\n * moar\n * levels?\n * hello\n * world\n\n\n\n\nparagraph 2','\n- this
\n- is\n\n
\n- a
\n- sublist?\n\n
\n- moar
\n- levels?\n\n
\n- hello
\n- world
\n
\n
\n
\n
\n\nparagraph 2
\n',1216908008,',8,9,',0);
--
-- Table structure for table `bsc_categories`
--
CREATE TABLE `bsc_categories` (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
`title` varchar(128) NOT NULL,
`parent` mediumint(9) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11;
--
-- Dumping data for table `bsc_categories`
--
INSERT INTO `bsc_categories` VALUES (1,'announcements','Announcements',0);
INSERT INTO `bsc_categories` VALUES (2,'entertainment','Entertainment',0);
INSERT INTO `bsc_categories` VALUES (3,'films-and-tv','Films and TV',2);
INSERT INTO `bsc_categories` VALUES (4,'games','Games',2);
INSERT INTO `bsc_categories` VALUES (5,'literature','Literature',2);
INSERT INTO `bsc_categories` VALUES (6,'humour','Humour',0);
INSERT INTO `bsc_categories` VALUES (7,'media','Media',0);
INSERT INTO `bsc_categories` VALUES (8,'tech','Tech',0);
INSERT INTO `bsc_categories` VALUES (9,'code','Code',8);
INSERT INTO `bsc_categories` VALUES (10,'computing','Computing',8);
--
-- Table structure for table `bsc_comments`
--
CREATE TABLE `bsc_comments` (
`id` mediumint(9) NOT NULL auto_increment,
`postid` mediumint(9) NOT NULL,
`author` varchar(128) NOT NULL,
`rawcontent` text NOT NULL,
`content` text NOT NULL,
`time` bigint(20) NOT NULL,
`account` mediumint(9) NOT NULL,
`notify` mediumint(9) NOT NULL,
`editid` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=68;
--
-- Dumping data for table `bsc_comments`
--
INSERT INTO `bsc_comments` VALUES (67,25,'http://bluesuncorp.co.uk/test/','http://bluesuncorp.co.uk/test/
\n',1219861918,0,0,70006025);
INSERT INTO `bsc_comments` VALUES (66,25,'dddd','http://bluesuncorp.co.uk/test/','http://bluesuncorp.co.uk/test/
\n',1219861909,0,0,36356028);
INSERT INTO `bsc_comments` VALUES (65,25,'ff','','\n',1219711441,0,0,54777069);
INSERT INTO `bsc_comments` VALUES (64,25,'heheh','chun@gmail.com','chun@gmail.com
\n',1219711424,0,0,29890990);
INSERT INTO `bsc_comments` VALUES (62,25,'Daniel','* lol','\n- lol
\n
\n',1216909144,1,0,0);
INSERT INTO `bsc_comments` VALUES (63,25,'Daniel','','\n',1218415075,1,0,0);
--
-- Table structure for table `bsc_settings`
--
CREATE TABLE `bsc_settings` (
`var` varchar(30) NOT NULL,
`val` varchar(100) NOT NULL,
UNIQUE KEY `var` (`var`)
) TYPE=MyISAM;
--
-- Dumping data for table `bsc_settings`
--
INSERT INTO `bsc_settings` VALUES ('title','BlueSunCorp');
INSERT INTO `bsc_settings` VALUES ('tagline','Two By Two, Hands Of Blue');
INSERT INTO `bsc_settings` VALUES ('theme','basic');
--
-- Table structure for table `bsc_users`
--
CREATE TABLE `bsc_users` (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`pass` varchar(128) NOT NULL,
`admin` tinyint(1) NOT NULL,
`writer` tinyint(1) NOT NULL,
`notify` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `email` (`email`)
) TYPE=MyISAM AUTO_INCREMENT=23;
--
-- Dumping data for table `bsc_users`
--
INSERT INTO `bsc_users` VALUES (1,'Daniel','chuntheunavoidable@gmail.com','4uUzRISfgUp3HCC0dOkEPv5nkMkodmLvQEYJo1nsfvlfAsXXL3ojnBIYOLYV2wCK+hFkqWWFnYO2IdH7vfxSjg==',1,1,1);
INSERT INTO `bsc_users` VALUES (2,'Richard','richardchdavidson@gmail.com','8FQmJPRmqq+N3JIyIzm2SffAqdlamv8o6CaI/4URQO3/1MP+xnq6MZsF2GYCO+YPqwHu0nOrl5PYyA7r4olUbw==',1,1,0);
INSERT INTO `bsc_users` VALUES (3,'bob','a@b.com','ZmGWkVJ674mUPipnnByQTDBaETZ4W7sKtMbbepk8oL9VxcSKwMqnR2d/0huBfgvOwyrxRkS8NhaYvbS5cCDbGA==',0,1,0);
INSERT INTO `bsc_users` VALUES (5,'user','arf@barf.com','miOGm89lgCfNkAOHT8XSHa6/IVU9LOdCVufHDfu2i0d3vQQ5BsmI40h4RCYlRy793kP8O2DLZ32xrUeGToI9BQ==',0,0,1);
INSERT INTO `bsc_users` VALUES (22,'email','chuntehunavoidable@gmail.com','IoXleAOfsQwppddhDxzE35gcZj+hEBsfP2NfXIyw4FbIxOkwgChgDlrNdUvl/OjzrFSy4NFELRpM8RglNVygXg==',0,0,1);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2008-09-13 18:35:20