Skeedl

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 21, 2008 at 04:57 PM
-- 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 ;

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

--
-- 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=25 ;

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

--
-- 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 ;

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

--
-- 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=25 ;