Version 1, last updated by sinus at March 22, 2008 03:03 UTC

Decrease font size Decrease font size

Increase font size Increase font size

Print this page Print this page

Skeedl Database Schema with Sample Data 

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 22, 2008 at 11:01 AM
-- Server version: 5.0.19
-- PHP Version: 5.1.6
-- 
-- Database: `skeedl`
-- 

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

-- 
-- Table structure for table `skeedl_acl`
-- 

CREATE TABLE `skeedl_acl` (
  `skeedl_acl_id` int(11) NOT NULL auto_increment,
  `role` varchar(50) NOT NULL,
  `controller` varchar(255) default NULL,
  `action` varchar(255) default NULL,
  `parent_role` varchar(50) default NULL,
  `access` enum('allow','deny') NOT NULL default 'allow',
  PRIMARY KEY  (`skeedl_acl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `skeedl_acl`
-- 

INSERT INTO `skeedl_acl` VALUES (1, 'guest', 'index', NULL, NULL, 'allow');
INSERT INTO `skeedl_acl` VALUES (2, 'member', 'index', NULL, 'guest', 'allow');
INSERT INTO `skeedl_acl` VALUES (3, 'moderator', 'index', NULL, 'member', 'allow');
INSERT INTO `skeedl_acl` VALUES (4, 'admin', NULL, NULL, NULL, 'allow');
INSERT INTO `skeedl_acl` VALUES (5, 'guest', 'dummy', NULL, NULL, 'deny');
INSERT INTO `skeedl_acl` VALUES (8, 'member', 'notes', NULL, 'guest', 'allow');

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

-- 
-- Table structure for table `skeedl_notes`
-- 

CREATE TABLE `skeedl_notes` (
  `skeedl_notes_id` bigint(20) NOT NULL auto_increment,
  `notes` text NOT NULL,
  `datetime_posted` datetime NOT NULL,
  `parent_id` bigint(20) NOT NULL default '0',
  `revision_number` int(11) NOT NULL default '1',
  `tags` varchar(255) default NULL,
  `status` enum('on','off') NOT NULL default 'on',
  PRIMARY KEY  (`skeedl_notes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

-- 
-- Dumping data for table `skeedl_notes`
-- 

INSERT INTO `skeedl_notes` VALUES (1, 'this is a test', '2008-03-21 12:05:04', 0, 1, 'urgent stuff', 'on');
INSERT INTO `skeedl_notes` VALUES (10, 'test', '2008-03-21 12:43:03', 0, 1, 'password', 'on');
INSERT INTO `skeedl_notes` VALUES (26, 'test', '2008-03-21 19:03:17', 0, 1, 'reminder', 'on');
INSERT INTO `skeedl_notes` VALUES (25, 'testsfa', '2008-03-21 18:59:43', 0, 1, 'bookmark', 'on');
INSERT INTO `skeedl_notes` VALUES (15, 'test', '2008-03-21 13:05:12', 0, 1, '', 'on');
INSERT INTO `skeedl_notes` VALUES (27, 'tadfasfdfs', '2008-03-21 19:04:11', 0, 1, 'urgent stuff', 'on');
INSERT INTO `skeedl_notes` VALUES (21, 'test', '2008-03-21 16:20:24', 0, 1, 'dsd', 'on');
INSERT INTO `skeedl_notes` VALUES (18, 'dfgdfgsfad', '2008-03-21 13:14:29', 0, 1, 'sdfsdf', 'on');
INSERT INTO `skeedl_notes` VALUES (19, 'TEST', '2008-03-21 13:15:52', 0, 1, 'bookmark, password', 'on');
INSERT INTO `skeedl_notes` VALUES (22, 'Making your online life easier thru notes. Just paste anything.\nYou can browse your notes using the timeline or with tags.', '2008-03-21 16:22:09', 0, 1, 'bookmark', 'on');
INSERT INTO `skeedl_notes` VALUES (28, 'test', '2008-03-21 19:04:32', 0, 1, 'dd', 'on');
INSERT INTO `skeedl_notes` VALUES (29, 'tsafd', '2008-03-21 19:05:09', 0, 1, 'sadf', 'on');
INSERT INTO `skeedl_notes` VALUES (30, 'testsfa this was updated', '2008-03-21 19:06:06', 0, 1, 'bookmark', 'on');
INSERT INTO `skeedl_notes` VALUES (31, 'EDUT!', '2008-03-21 19:57:49', 25, 1, 'bookmark', 'on');
INSERT INTO `skeedl_notes` VALUES (32, 'TEST', '2008-03-21 19:58:19', 25, 1, 'TEST', 'on');
INSERT INTO `skeedl_notes` VALUES (33, 'My test', '2008-03-21 20:00:42', 0, 1, 'my test', 'on');
INSERT INTO `skeedl_notes` VALUES (34, 'My test Editted', '2008-03-21 20:01:07', 33, 1, 'my test', 'on');
INSERT INTO `skeedl_notes` VALUES (35, 'New post', '2008-03-21 20:01:22', 0, 1, 'new', 'on');

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

-- 
-- Table structure for table `skeedl_users`
-- 

CREATE TABLE `skeedl_users` (
  `skeedl_users_id` bigint(20) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `role` varchar(50) NOT NULL default 'member',
  `mydateformat` varchar(50) NOT NULL default 'M-d-Y',
  `mytimelinedateformat` varchar(50) NOT NULL default 'Y-m-d H:i:s',
  `user_status` enum('active','inactive') NOT NULL default 'active',
  PRIMARY KEY  (`skeedl_users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `skeedl_users`
-- 

INSERT INTO `skeedl_users` VALUES (1, 'admin', 'ca1e17020192dd61de2864b62d263772ae758ada80d492ab25904c0e9de8650e', 'wenbert@ekini.net', 'admin', 'M-d-Y', 'Y-m-d', 'active');
INSERT INTO `skeedl_users` VALUES (2, 'member', 'ca1e17020192dd61de2864b62d263772ae758ada80d492ab25904c0e9de8650e', 'wenbertdelrosario@yahoo.com', 'member', 'M-d-Y', 'Y-m-d', 'active');
INSERT INTO `skeedl_users` VALUES (3, 'moderator', 'ca1e17020192dd61de2864b62d263772ae758ada80d492ab25904c0e9de8650e', 'wenbertdelrosario@yahoo.com', 'member', 'M-d-Y', 'Y-m-d', 'active');

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

-- 
-- Table structure for table `skeedl_users_notes`
-- 

CREATE TABLE `skeedl_users_notes` (
  `skeedl_users_notes_id` bigint(20) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `notes_id` bigint(20) NOT NULL,
  `is_owner` enum('yes','no') NOT NULL,
  `is_shared_editable` enum('yes','no') NOT NULL default 'no',
  `is_public` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`skeedl_users_notes_id`),
  KEY `notes_id` (`notes_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

-- 
-- Dumping data for table `skeedl_users_notes`
-- 

INSERT INTO `skeedl_users_notes` VALUES (1, 'admin', 1, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (26, 'admin', 26, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (10, 'admin', 10, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (25, 'admin', 25, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (15, 'member', 15, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (27, 'admin', 27, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (19, 'member', 19, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (18, 'member', 18, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (21, 'admin', 21, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (22, 'admin', 22, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (28, 'admin', 28, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (29, 'admin', 29, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (30, 'admin', 30, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (31, 'admin', 31, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (32, 'admin', 32, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (33, 'admin', 33, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (34, 'admin', 34, 'yes', 'no', 'no');
INSERT INTO `skeedl_users_notes` VALUES (35, 'admin', 35, 'yes', 'no', 'no');

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

-- 
-- Table structure for table `skeedl_users_tags`
-- 

CREATE TABLE `skeedl_users_tags` (
  `skeedl_users_tags` bigint(20) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `notes_id` bigint(20) NOT NULL,
  `status` enum('on','off') NOT NULL default 'on',
  PRIMARY KEY  (`skeedl_users_tags`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `skeedl_users_tags`
--