TechOverview: cakePHP.imc.sql

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

CREATE TABLE IF NOT EXISTS `articles` (
  `id` int(11) NOT NULL auto_increment,
  `author` varchar(100) default NULL,
  `contact` varchar(255) default NULL,
  `title` varchar(255) NOT NULL,
  `summary` text,
  `body` text,
  `created` datetime NOT NULL,
  `hidden` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

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

INSERT INTO `articles` (`id`, `author`, `contact`, `title`, `summary`, `body`, `created`, `hidden`) VALUES
(1, 'Simon', 'http://shine.eu.org/', 'Lorem Ipsum', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus pulvinar quam vitae nunc luctus mattis. Curabitur eget est. Sed id orci eu nulla pharetra porta. Nulla elementum, metus in aliquam porta, erat ligula malesuada lacus, sit amet ornare elit orci et arcu. Ut nibh. Proin eget neque. Nam metus neque, congue ut, ornare id, lobortis non, justo. Quisque eget nulla sit amet quam sodales consectetuer. Pellentesque varius ultricies dui. Aliquam interdum mattis tellus. Praesent at justo sit amet enim vehicula vehicula. Phasellus sodales, ante in molestie malesuada, tortor odio blandit eros, vitae facilisis quam nibh viverra orci. Quisque non nunc.', 'In eu leo. Vivamus dapibus felis in purus fermentum pellentesque. Vivamus tristique adipiscing elit. Aliquam accumsan justo non sem. Nulla aliquet, arcu non varius dignissim, ante pede ultricies turpis, eu elementum leo tortor quis odio. Phasellus venenatis nibh non ipsum. Duis imperdiet tempor magna. Fusce varius, pede dictum feugiat porttitor, sapien massa lobortis diam, a luctus enim sem nec augue. Vestibulum vitae tortor ac eros posuere euismod. Suspendisse vel orci. Sed eu sapien. Fusce ultricies viverra mi. Donec et purus. Suspendisse hendrerit sapien at elit. Quisque pharetra orci. Fusce ullamcorper purus ac nisl.\r\n\r\nAenean non sem eu libero accumsan volutpat. Donec dictum. Sed nisl enim, aliquet faucibus, consectetuer a, dictum non, purus. Aenean vitae quam. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Morbi suscipit erat non diam. Vivamus tellus lacus, aliquet sed, viverra at, consequat vitae, metus. Curabitur gravida. Etiam congue justo nec dui tempor ornare. Nulla rutrum tellus in lorem. Etiam velit risus, vehicula vitae, aliquam ut, elementum consectetuer, sem. Phasellus tincidunt eros sit amet nisl. Nunc in mauris. Suspendisse facilisis placerat dui. Donec molestie, sem eu dignissim molestie, dolor justo aliquet enim, malesuada congue velit felis ut mauris. Aenean varius. Donec nibh ipsum, bibendum non, feugiat vel, accumsan non, velit. Fusce in elit. Vestibulum pellentesque, nibh eu volutpat luctus, tellus ligula pulvinar metus, ac mattis libero massa eu risus.\r\n\r\nPellentesque iaculis fermentum urna. Duis eros nunc, lobortis sit amet, tristique a, tincidunt vel, arcu. Cras sodales dolor. Pellentesque purus massa, vestibulum in, consequat eget, sodales vitae, mauris. Ut vitae mi. Aliquam eu nisi. Mauris a nulla. Donec lacinia enim porta libero. Sed sit amet nisi. Morbi consequat tortor a enim. Praesent pede. Suspendisse nonummy placerat justo. Integer mollis, risus non vestibulum aliquet, pede quam consectetuer elit, ac fermentum massa diam at nibh.\r\n\r\nFusce lobortis ultricies libero. Nulla purus. Suspendisse potenti. In mollis iaculis nisl. Sed in arcu rhoncus felis convallis facilisis. Aliquam blandit, est sagittis gravida ultrices, diam justo vestibulum sem, ut varius pede libero a massa. Aliquam sit amet nisi et quam egestas aliquam. Vivamus ut leo sit amet eros ultricies posuere. Sed tincidunt tellus vel nulla. Proin molestie accumsan augue. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Curabitur sagittis purus id dui. Nunc varius gravida mi.', '2007-12-27 08:06:00', 0),
(2, 'Simon', '', 'Second Post', 'Det her er andet indlÊg i det CakePHP-baserede IndyCMS... yay.\r\n\r\nw00t w00t!', 'I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana. I''m a blue banana.', '2007-12-27 13:13:58', 0),
(3, 'Grimnir', 'densorteravn@gmail.com', 'Testing', 'Jeg tester bare lige', 'Aoeu asonetuhid huditonesta ho net hit tsne ntho ethu stnaho tehu.', '2007-12-27 13:16:19', 0),
(16, 'Simon', 'http://shine.eu.org/', 'Progress report', 'This is yet another entry. I''m really tired and thinking of going to bed now... So instead of filling the random entry up with garbage, I''m going to write a progress report.', '1) The layout of this page: I know, garbage. Someone else better than me needs to draw and cut up a real layout. Base it off www.indymedia.org.uk or www.de.indymedia.org.\r\n\r\n2) Comments and tags work quite well. Right now, only admins can add tags to existing articles (although the admin section isn''t restricted). In this setup they should also be the only ones who can add new tags, but I haven''t turned off scaffolding for Tag since most of their handling happens through Article. Also, right now tags are one-dimensional (e.g. only one type of tags, you can''t separate types of tags, such as geographical tags, article type tags and topic tags) because I want to discuss how to best implement a more refined version before I go ahead.', '2007-12-29 08:31:55', 0);

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

--
-- Table structure for table `articles_comments`
--

CREATE TABLE IF NOT EXISTS `articles_comments` (
  `article_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  PRIMARY KEY  (`article_id`,`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `articles_comments`
--

INSERT INTO `articles_comments` (`article_id`, `comment_id`) VALUES
(1, 1),
(1, 5),
(2, 13),
(3, 3),
(16, 8),
(16, 9),
(16, 10),
(16, 11);

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

--
-- Table structure for table `articles_tags`
--

CREATE TABLE IF NOT EXISTS `articles_tags` (
  `article_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`article_id`,`tag_id`),
  UNIQUE KEY `article_id` (`article_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `articles_tags`
--

INSERT INTO `articles_tags` (`article_id`, `tag_id`) VALUES
(2, 6),
(2, 12),
(2, 21),
(3, 1),
(3, 2),
(3, 10),
(3, 15),
(16, 10),
(16, 21);

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

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

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL auto_increment,
  `author` varchar(100) default 'Anonym',
  `contact` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `body` text,
  `created` datetime NOT NULL,
  `hidden` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

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

INSERT INTO `comments` (`id`, `author`, `contact`, `title`, `body`, `created`, `hidden`) VALUES
(1, 'Simon', 'shreddedglory@gmail.com', 'This article sucks!', 'I totally hate this article.\r\n\r\nI don''t know why you keep up with this effort.', '2007-12-30 00:28:41', 0),
(3, 'Anonym', NULL, '^_^', 'Jeg er totalt sej. Nu virker kommentarer vistnok også.', '2007-12-29 02:54:48', 0),
(5, 'Anonym', NULL, 'OMG FTW', 'Den her kommentar skal totalt virke!!!', '2007-12-29 03:48:55', 0),
(16, 'Anonym', NULL, NULL, NULL, '2007-12-30 06:04:30', 1),
(17, 'Anonym', NULL, NULL, NULL, '2007-12-30 06:04:45', 1),
(8, 'Anonym', 'scout', 'does comments work?', 'Nice one! Nice one! Nice one! Nice one! Nice one! Nice one! Nice one! Nice one! ', '2007-12-29 09:33:37', 0),
(9, 'Anonym', 'scout', 'But i didn''t comment as simon?', 'I just smashed a comment in. with my name (scout) as the "author", but it showed up as simon?', '2007-12-29 09:34:40', 0),
(10, 'scout', 'scout@revolt-it.com', 'hmm', '......................................................................', '2007-12-29 09:35:32', 0),
(11, 'asdfasdasdfasdf', 'asdfa', 'asdf', 'asdfszadfadfasdfasdfasdfasdf', '2007-12-29 10:56:36', 0),
(13, '^_^', 'hellowiez', 'omgz0r', 'You''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\nYou''re a blue banana.\r\n', '2007-12-29 11:01:41', 0),
(14, 'Anonym', NULL, NULL, 'Bah, det du skriver er jo noget hÞ!', '2007-12-30 05:33:05', 0),
(15, 'Gud', NULL, '^_^', 'Ja, det er virkelig noget hÞ.', '2007-12-30 05:33:27', 0);

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

--
-- Table structure for table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `ancestor_id` int(11) default NULL,
  `author` varchar(255) default 'Anonym',
  `contact` varchar(255) default NULL,
  `subject` varchar(255) default NULL,
  `message` text,
  `created` datetime default NULL,
  `ip_address` varchar(15) default NULL,
  `score` int(11) default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `parent_id`, `ancestor_id`, `author`, `contact`, `subject`, `message`, `created`, `ip_address`, `score`) VALUES
(85, NULL, NULL, 'Simon', NULL, 'Lorem Ipsum', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus pulvinar quam vitae nunc luctus mattis. Curabitur eget est. Sed id orci eu nulla pharetra porta. Nulla elementum, metus in aliquam porta, erat ligula malesuada lacus, sit amet ornare elit orci et arcu. Ut nibh. Proin eget neque. Nam metus neque, congue ut, ornare id, lobortis non, justo. Quisque eget nulla sit amet quam sodales consectetuer. Pellentesque varius ultricies dui. Aliquam interdum mattis tellus. Praesent at justo sit amet enim vehicula vehicula. Phasellus sodales, ante in molestie malesuada, tortor odio blandit eros, vitae facilisis quam nibh viverra orci. Quisque non nunc.\r\n\r\nIn eu leo. Vivamus dapibus felis in purus fermentum pellentesque. Vivamus tristique adipiscing elit. Aliquam accumsan justo non sem. Nulla aliquet, arcu non varius dignissim, ante pede ultricies turpis, eu elementum leo tortor quis odio. Phasellus venenatis nibh non ipsum. Duis imperdiet tempor magna. Fusce varius, pede dictum feugiat porttitor, sapien massa lobortis diam, a luctus enim sem nec augue. Vestibulum vitae tortor ac eros posuere euismod. Suspendisse vel orci. Sed eu sapien. Fusce ultricies viverra mi. Donec et purus. Suspendisse hendrerit sapien at elit. Quisque pharetra orci. Fusce ullamcorper purus ac nisl.\r\n\r\nAenean non sem eu libero accumsan volutpat. Donec dictum. Sed nisl enim, aliquet faucibus, consectetuer a, dictum non, purus. Aenean vitae quam. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Morbi suscipit erat non diam. Vivamus tellus lacus, aliquet sed, viverra at, consequat vitae, metus. Curabitur gravida. Etiam congue justo nec dui tempor ornare. Nulla rutrum tellus in lorem. Etiam velit risus, vehicula vitae, aliquam ut, elementum consectetuer, sem. Phasellus tincidunt eros sit amet nisl. Nunc in mauris. Suspendisse facilisis placerat dui. Donec molestie, sem eu dignissim molestie, dolor justo aliquet enim, malesuada congue velit felis ut mauris. Aenean varius. Donec nibh ipsum, bibendum non, feugiat vel, accumsan non, velit. Fusce in elit. Vestibulum pellentesque, nibh eu volutpat luctus, tellus ligula pulvinar metus, ac mattis libero massa eu risus.\r\n\r\nPellentesque iaculis fermentum urna. Duis eros nunc, lobortis sit amet, tristique a, tincidunt vel, arcu. Cras sodales dolor. Pellentesque purus massa, vestibulum in, consequat eget, sodales vitae, mauris. Ut vitae mi. Aliquam eu nisi. Mauris a nulla. Donec lacinia enim porta libero. Sed sit amet nisi. Morbi consequat tortor a enim. Praesent pede. Suspendisse nonummy placerat justo. Integer mollis, risus non vestibulum aliquet, pede quam consectetuer elit, ac fermentum massa diam at nibh.\r\n\r\nFusce lobortis ultricies libero. Nulla purus. Suspendisse potenti. In mollis iaculis nisl. Sed in arcu rhoncus felis convallis facilisis. Aliquam blandit, est sagittis gravida ultrices, diam justo vestibulum sem, ut varius pede libero a massa. Aliquam sit amet nisi et quam egestas aliquam. Vivamus ut leo sit amet eros ultricies posuere. Sed tincidunt tellus vel nulla. Proin molestie accumsan augue. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Curabitur sagittis purus id dui. Nunc varius gravida mi.\r\n', '2007-12-27 07:50:20', '83.93.102.110', 1),
(86, 85, 85, 'Simon', NULL, 'Rettelse', 'Hmmm', '2007-12-27 07:52:15', '83.93.102.110', 0),
(87, 86, 85, 'scout', NULL, 'hvordan går det med udviklingen? (nm)', 'NO MORE FOR HELVEDE!!!', '2007-12-27 17:27:24', '87.48.121.244', 1);

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

--
-- Table structure for table `posts_tags`
--

CREATE TABLE IF NOT EXISTS `posts_tags` (
  `post_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`post_id`,`tag_id`),
  UNIQUE KEY `post_id` (`post_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `posts_tags`
--

INSERT INTO `posts_tags` (`post_id`, `tag_id`) VALUES
(85, 3);

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

--
-- Table structure for table `snotes`
--

CREATE TABLE IF NOT EXISTS `snotes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `body` text,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `snotes`
--

INSERT INTO `snotes` (`id`, `title`, `body`, `created`, `modified`) VALUES
(10, 'GÆSTELISTE', 'hans +45', '2007-11-09 23:43:51', '2007-11-11 02:47:27'),
(9, 'LMI', 'philip clarke + 10 + bord + 3 flasker gratis\r\ncasper talbro + 30 (id ok) bord ved siden af philip clarke.\r\n', '2007-11-09 16:03:00', '2007-11-09 20:21:11');

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

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

CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(11) NOT NULL auto_increment,
  `tag` varchar(40) NOT NULL,
  `restricted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `tag` (`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

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

INSERT INTO `tags` (`id`, `tag`, `restricted`) VALUES
(1, 'syndikalisme', 0),
(2, 'feminisme', 0),
(23, 'analyse', 0),
(5, 'dyrevelfÊrd', 0),
(6, 'uddannelse', 0),
(7, 'fagligt arbejde', 0),
(8, 'internet', 0),
(9, 'global retfÊrdighed', 0),
(10, 'aktivisme', 0),
(11, 'anarkisme', 0),
(12, 'fristeder', 0),
(13, 'autonom infoservice', 0),
(14, 'kÞn og seksualitet', 0),
(15, 'boliger', 0),
(21, 'feature', 1),
(22, 'indymedia', 0),
(24, 'pressemeddelelse', 0);