test/schema.sql at 9ca69342f89d90e078b6391a1ecac62b2fa6d034 from tedkulp's cmsmadesimple-2-0

tedkulp / cmsmadesimple-2-0

Description:	Git mirror of the CMS Made Simple 2.0 rewrite
Homepage:	http://cmsmadesimple.org
Clone URL:	git://github.com/tedkulp/cmsmadesimple-2-0.git Give this clone URL to anyone. `git clone git://github.com/tedkulp/cmsmadesimple-2-0.git`

Install cleanup.  Should be able to get a base site up and running 
quickly, so there are no more excuses.  :)

tedkulp (author)

Sat Nov 17 12:47:00 -0800 2007

commit 9ca69342f89d90e078b6391a1ecac62b2fa6d034
tree 4b658bbf71da41c9aefc4b2a9cadd4a8d2aa3690
parent ae8c45928232f690aa8713853d66df8b74759bf0

cmsmadesimple-2-0 / test / schema.sql

100644 948 lines (792 sloc) 46.797 kb

raw blame history

-- MySQL dump 10.9
--
-- Host: localhost    Database: cms3
-- ------------------------------------------------------
-- Server version  4.1.22-log
 
/*!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 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
--
-- Table structure for table `cms2_additional_htmlblob_users`
--
 
DROP TABLE IF EXISTS `cms2_additional_htmlblob_users`;
CREATE TABLE `cms2_additional_htmlblob_users` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `htmlblob_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_additional_htmlblob_users`
--
 
LOCK TABLES `cms2_additional_htmlblob_users` WRITE;
/*!40000 ALTER TABLE `cms2_additional_htmlblob_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms2_additional_htmlblob_users` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `cms2_additional_users`
--
 
DROP TABLE IF EXISTS `cms2_additional_users`;
CREATE TABLE `cms2_additional_users` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `page_id` int(11) default NULL,
  `content_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_additional_users`
--
 
LOCK TABLES `cms2_additional_users` WRITE;
/*!40000 ALTER TABLE `cms2_additional_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms2_additional_users` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `cms2_admin_bookmarks`
--
 
DROP TABLE IF EXISTS `cms2_admin_bookmarks`;
CREATE TABLE `cms2_admin_bookmarks` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_admin_bookmarks`
--
 
LOCK TABLES `cms2_admin_bookmarks` WRITE;
/*!40000 ALTER TABLE `cms2_admin_bookmarks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms2_admin_bookmarks` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `cms2_admin_recent_pages`
--
 
DROP TABLE IF EXISTS `cms2_admin_recent_pages`;
CREATE TABLE `cms2_admin_recent_pages` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `access_time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_admin_recent_pages`
--
 
LOCK TABLES `cms2_admin_recent_pages` WRITE;
/*!40000 ALTER TABLE `cms2_admin_recent_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms2_admin_recent_pages` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `cms2_adminlog`
--
 
DROP TABLE IF EXISTS `cms2_adminlog`;
CREATE TABLE `cms2_adminlog` (
  `timestamp` int(11) default NULL,
  `user_id` int(11) default NULL,
  `username` varchar(25) default NULL,
  `item_id` int(11) default NULL,
  `item_name` varchar(50) default NULL,
  `action` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_adminlog`
--
 
LOCK TABLES `cms2_adminlog` WRITE;
/*!40000 ALTER TABLE `cms2_adminlog` DISABLE KEYS */;
INSERT INTO `cms2_adminlog` VALUES (1181419145,1,'',1,'admin','User Login'),(1181695156,1,'',1,'admin','User Login'),(1181695198,1,'',1,'Test','Added Content'),(1181696251,1,'',2,'Test','Added Content'),(1181696359,1,'',3,'Test 2','Added Content'),(1181696801,1,'',4,'Test','Added Content'),(1181696817,1,'',5,'Test 2','Added Content'),(1181698196,1,'',6,'Test','Added Content'),(1181698336,1,'',7,'Test 2','Added Content'),(1181698376,1,'',8,'Test 3','Added Content'),(1181698799,1,'',9,'Test','Added Content'),(1181698809,1,'',10,'Test 2','Added Content'),(1181698879,1,'',11,'Test','Added Content'),(1181698888,1,'',12,'Test 2','Added Content'),(1181699277,1,'',13,'Test','Added Content'),(1181699293,1,'',14,'Test 2','Added Content'),(1181699533,1,'',15,'Test','Added Content'),(1181699581,1,'',16,'Test','Added Content'),(1181699907,1,'',16,'Test 2','Added Content'),(1181702287,1,'',16,'Test','Added Content'),(1181702295,1,'',16,'Test 2','Added Content'),(1181702320,1,'',17,'Test','Added Content'),(1181702337,1,'',18,'Test 2','Added Content'),(1181702374,1,'',19,'Test 1.1','Added Content'),(1181702514,1,'',20,'Test 1.1 2','Added Content'),(1181702552,1,'',21,'Test 2.1','Added Content'),(1181703334,1,'',22,'Test','Added Content'),(1181703408,1,'',23,'Test','Added Content'),(1181703427,1,'',24,'Test','Added Content'),(1181704047,1,'',25,'Test 2.1','Added Content'),(1181705155,1,'',26,'Test','Added Content'),(1181705174,1,'',27,'Test 2','Added Content'),(1181705204,1,'',28,'Test 2.1','Added Content'),(1181705704,1,'',29,'Test 2.1.1','Added Content'),(1181705891,1,'',30,'Test','Added Content'),(1181705978,1,'',31,'Test','Added Content'),(1181706093,1,'',32,'Test','Added Content'),(1181706239,1,'',33,'Test','Added Content'),(1181706305,1,'',34,'Test','Added Content'),(1181706444,1,'',35,'Test','Added Content'),(1181706480,1,'',36,'Test','Added Content'),(1181706559,1,'',37,'Test','Added Content'),(1181706652,1,'',37,'Test','Added Content'),(1181706667,1,'',38,'Test','Added Content'),(1181706710,1,'',39,'Test','Added Content'),(1181706770,1,'',40,'Test','Added Content'),(1181706792,1,'',41,'Test','Added Content'),(1181706818,1,'',42,'Test','Added Content'),(1181728438,1,'',1,'Test','Edited Template'),(1183141629,1,'',1,'admin','User Login'),(1183322968,1,'',1,'Test','Edited Template'),(1183323816,1,'',1,'Test','Edited Template'),(1183323913,1,'',1,'Test','Added CSS'),(1183324188,1,'',1,'Test','Added Stylesheet Association'),(1183926387,1,'',1,'admin','User Login'),(1183926639,1,'',43,'Testing Again','Added Content'),(1183926737,1,'',43,'Testing Again','Edited Content'),(1183926774,1,'',43,'Testing Again','Edited Content'),(1183927092,1,'',43,'Testing Again','Edited Content'),(1183927418,1,'',43,'Testing Again','Edited Content'),(1183927436,1,'',43,'Testing Again','Edited Content'),(1183927456,1,'',43,'Testing Again','Edited Content'),(1183928326,1,'',27,'Test 2','Edited Content'),(1183928380,1,'',27,'Test 2','Edited Content'),(1183946249,1,'',28,'Test 2.1','Edited Content'),(1183946470,1,'',28,'Test 2.1','Edited Content'),(1183946596,1,'',28,'Test 2.1','Edited Content'),(1183946709,1,'',28,'Test 2.1','Edited Content'),(1183946744,1,'',27,'Test 2','Edited Content'),(1184029279,1,'',28,'Test 2.1','Edited Content'),(1184069263,1,'',1,'admin','User Login'),(1185058118,1,'',1,'admin','User Login'),(1185058997,1,'',1,'Test','Edited Template'),(1185062394,1,'',1,'admin','User Login'),(1185238159,1,'',1,'admin','User Login'),(1185270421,1,'',44,'Yet Another Test','Added Content'),(1185270467,1,'',44,'Yet Another Test','Edited Content'),(1185760350,1,'',1,'admin','User Login'),(1185798171,1,'',1,'','User Logout'),(1185798179,1,'',1,'admin','User Login'),(1185798200,1,'',1,'','User Logout'),(1185798543,1,'',1,'admin','User Login'),(1185798615,1,'',1,'','User Logout'),(1185798622,1,'',1,'admin','User Login'),(1185798650,1,'',1,'','User Logout'),(1185798677,1,'',1,'admin','User Login'),(1185799504,1,'',1,'','User Logout'),(1185806971,1,'',1,'admin','User Login'),(1185807323,1,'',1,'','User Logout'),(1185808557,1,'',1,'admin','User Login'),(1185812006,1,'',1,'','User Logout'),(1185886374,1,'',1,'admin','User Login'),(1185886640,1,'',2,'Test','Added Content'),(1185887165,1,'',2,'Test','Edited Content'),(1185887270,1,'',3,'Test 2','Added Content'),(1185887344,1,'',3,'Test 2','Edited Content'),(1185887553,1,'',1,'','User Logout'),(1185888560,1,'',1,'admin','User Login'),(1186073410,1,'',1,'admin','User Login'),(1186073457,1,'',4,'Test 1.2','Added Content'),(1186073484,1,'',5,'Test 1.2.1','Added Content'),(1186073509,1,'',6,'Test 1.2.2','Added Content'),(1186073543,1,'',3,'Test 1.1','Edited Content'),(1186073564,1,'',2,'Test 1','Edited Content'),(1186073615,1,'',7,'Test 2','Added Content'),(1186073640,1,'',8,'Test 2.1','Added Content'),(1186073743,1,'',9,'Test 2.2','Added Content'),(1186073761,1,'',10,'Test 3','Added Content'),(1186073785,1,'',11,'Test 4','Added Content'),(1186073835,1,'',12,'Test 4.1','Added Content'),(1186073871,1,'',13,'Test 4.2','Added Content'),(1186073926,1,'',14,'Test 4.2.1','Added Content'),(1186073951,1,'',15,'Test 4.2.2','Added Content'),(1186073977,1,'',16,'Test 4.2.2.1','Added Content'),(1186074510,1,'',1,'','User Logout'),(1186079258,1,'',1,'admin','User Login'),(1186079374,1,'',1,'','User Logout');
/*!40000 ALTER TABLE `cms2_adminlog` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `cms2_content`
--
 
DROP TABLE IF EXISTS `cms2_content`;
CREATE TABLE `cms2_content` (
  `id` int(11) NOT NULL auto_increment,
  `content_name` varchar(255) default NULL,
  `type` varchar(25) default NULL,
  `owner_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `template_id` int(11) default NULL,
  `item_order` int(11) default NULL,
  `hierarchy` varchar(255) default NULL,
  `default_content` tinyint(4) default NULL,
  `menu_text` varchar(255) default NULL,
  `content_alias` varchar(255) default NULL,
  `show_in_menu` tinyint(4) default NULL,
  `collapsed` tinyint(4) default NULL,
  `markup` varchar(25) default NULL,
  `active` tinyint(4) default NULL,
  `cachable` tinyint(4) default NULL,
  `id_hierarchy` varchar(255) default NULL,
  `hierarchy_path` text,
  `prop_names` text,
  `metadata` text,
  `titleattribute` varchar(255) default NULL,
  `tabindex` varchar(10) default NULL,
  `accesskey` varchar(5) default NULL,
  `last_modified_by` int(11) default NULL,
  `create_date` datetime default NULL,
  `modified_date` datetime default NULL,
  `lft` int(11) default NULL,
  `rgt` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `alias_and_active` (`content_alias`,`active`),
  KEY `default_content` (`default_content`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `cms2_content`
--
 
LOCK TABLES `cms2_content` WRITE;
/*!40000 ALTER TABLE `cms2_content` DISABLE KEYS */;
INSERT INTO `cms2_content` VALUES (1,'__root_node__','root',1,-1,-1,1,'',0,'__root_node__','__root_node__',0,0,'none',1,0,'','__root_node__','','','','','',1,NULL,NULL,1,32),(2,'Test 1','content',1,1,1,1,'1',1,'Test 1','test',1,0,'',1,0,'2','test','default-block-type,default-content,content_block_2-block-type,content_block_2-content','','','','',1,'2007-07-31 12:57:20','2007-08-02 16:52:44',2,11),(3,'Test 1.1','content',1,2,1,1,'1.1',0,'Test 1.1','test-2',1,0,'',1,0,'2.3','test/test-2','default-block-type,default-content,content_block_2-block-type,content_block_2-content','','','','',1,'2007-07-31 13:07:50','2007-08-02 16:52:23',3,4),(4,'Test 1.2','content',1,2,1,2,'1.2',0,'Test 1.2','test-1-2',1,0,'',1,0,'2.4','test/test-1-2','default-block-type,default-content,content_block_2-block-type,content_block_2-content','','','','',1,'2007-08-02 16:50:57','2007-08-02 16:50:57',5,10),(5,'Test 1.2.1','content',1,4,1,1,'1.2.1',0,'Test 1.2.1','test-1-2-1',1,0,'',1,0,'2.4.5','test/test-1-2/test-1-2-1','default-block-type,default-content,content_block_2-block-type,content_block_2-content','','','','',1,'2007-08-02 16:51:24','2007-08-02 16:51:24',6,7),(6,'Test 1.2.2','content',1,4,1,2,'1.2.2',0,'Test 1.2.2','test-1-2-2',1,0,'',1,0,'2.4.6','test/test-1-2/test-1-2-2','default-block-type,default-content,content_block_2-block-type,content_block_2-content','','','','',1,'2007-08-02 16:51:49','2007-08-02 16:51:49',8,9),(7,'Test 2','content',1,1,1,2,'2'