safe_dump.sql

# Sequel Pro dump
# Version 254
# http://code.google.com/p/sequel-pro
#
# Host: localhost (MySQL 5.1.35)
# Database: unl_social
# Generation Time: 2009-08-21 15:15:31 -0500
# ************************************************************

# Dump of table elggaccess_collection_membership
# ------------------------------------------------------------

CREATE TABLE `elggaccess_collection_membership` (
  `user_guid` int(11) NOT NULL,
  `access_collection_id` int(11) NOT NULL,
  PRIMARY KEY (`user_guid`,`access_collection_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `elggaccess_collection_membership` (`user_guid`,`access_collection_id`)
VALUES
	(13,4),
	(15,3);



# Dump of table elggaccess_collections
# ------------------------------------------------------------

CREATE TABLE `elggaccess_collections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `owner_guid` bigint(20) unsigned NOT NULL,
  `site_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `owner_guid` (`owner_guid`),
  KEY `site_guid` (`site_guid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

INSERT INTO `elggaccess_collections` (`id`,`name`,`owner_guid`,`site_guid`)
VALUES
	(3,'Group: Testing Group',15,1),
	(4,'Group: Californians for Nebraska',13,1);



# Dump of table elggannotations
# ------------------------------------------------------------

CREATE TABLE `elggannotations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_guid` bigint(20) unsigned NOT NULL,
  `name_id` int(11) NOT NULL,
  `value_id` int(11) NOT NULL,
  `value_type` enum('integer','text') NOT NULL,
  `owner_guid` bigint(20) unsigned NOT NULL,
  `access_id` int(11) NOT NULL,
  `time_created` int(11) NOT NULL,
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `entity_guid` (`entity_guid`),
  KEY `name_id` (`name_id`),
  KEY `value_id` (`value_id`),
  KEY `owner_guid` (`owner_guid`),
  KEY `access_id` (`access_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO `elggannotations` (`id`,`entity_guid`,`name_id`,`value_id`,`value_type`,`owner_guid`,`access_id`,`time_created`,`enabled`)
VALUES
	(1,76,159,158,'text',13,4,1245362592,'yes'),
	(2,76,159,173,'text',13,4,1245946220,'yes');