-- MySQL dump 9.11
--
-- Host: localhost    Database: ghestalt
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10sarge2-log

--
-- Table structure for table `app_userprofile`
--

CREATE TABLE app_userprofile (
  id int(11) NOT NULL auto_increment,
  first_name varchar(30) NOT NULL default '',
  last_name varchar(30) NOT NULL default '',
  user_id int(11) default NULL,
  dob date default NULL,
  email varchar(75) NOT NULL default '',
  role varchar(30) NOT NULL default '',
  notes longtext NOT NULL,
  create_date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id),
  UNIQUE KEY user_id (user_id),
  UNIQUE KEY app_userprofile_user_id (user_id)
) TYPE=MyISAM;

--
-- Dumping data for table `app_userprofile`
--


--
-- Table structure for table `app_wikilog`
--

CREATE TABLE app_wikilog (
  id int(11) NOT NULL auto_increment,
  what varchar(20) NOT NULL default '',
  wiki_data longtext NOT NULL,
  mtime datetime NOT NULL default '0000-00-00 00:00:00',
  muser varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `app_wikilog`
--

INSERT INTO app_wikilog VALUES (1,'HomePage','Testing Unico∂e support in the wiki.','2007-01-04 23:40:05','root');
INSERT INTO app_wikilog VALUES (2,'HomePage','Testing Unico∂e support in the wiki. Also testing support for [Unico∂e] links.','2007-01-04 23:49:50','root');
INSERT INTO app_wikilog VALUES (3,'Unico∂e','This page should have unicode crap in it. ¡™£¢∞§¶•ªºß∂ƒ©˙∆˚¬≈ç√∫˜µ˜≤','2007-01-04 23:51:18','root');
INSERT INTO app_wikilog VALUES (4,'user/raph','This is raph\'s test page.','2007-01-05 02:00:15','raph');

--
-- Table structure for table `auth_group`
--

CREATE TABLE auth_group (
  id int(11) NOT NULL auto_increment,
  name varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE auth_group_permissions (
  id int(11) NOT NULL auto_increment,
  group_id int(11) NOT NULL default '0',
  permission_id int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY group_id (group_id,permission_id)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_message`
--

CREATE TABLE auth_message (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  message longtext NOT NULL,
  PRIMARY KEY  (id),
  KEY auth_message_user_id (user_id)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_message`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE auth_permission (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  content_type_id int(11) NOT NULL default '0',
  codename varchar(100) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY content_type_id (content_type_id,codename),
  KEY auth_permission_content_type_id (content_type_id)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO auth_permission VALUES (1,'Can add message',1,'add_message');
INSERT INTO auth_permission VALUES (2,'Can change message',1,'change_message');
INSERT INTO auth_permission VALUES (3,'Can delete message',1,'delete_message');
INSERT INTO auth_permission VALUES (4,'Can add group',2,'add_group');
INSERT INTO auth_permission VALUES (5,'Can change group',2,'change_group');
INSERT INTO auth_permission VALUES (6,'Can delete group',2,'delete_group');
INSERT INTO auth_permission VALUES (7,'Can add user',3,'add_user');
INSERT INTO auth_permission VALUES (8,'Can change user',3,'change_user');
INSERT INTO auth_permission VALUES (9,'Can delete user',3,'delete_user');
INSERT INTO auth_permission VALUES (10,'Can add permission',4,'add_permission');
INSERT INTO auth_permission VALUES (11,'Can change permission',4,'change_permission');
INSERT INTO auth_permission VALUES (12,'Can delete permission',4,'delete_permission');
INSERT INTO auth_permission VALUES (13,'Can add content type',5,'add_contenttype');
INSERT INTO auth_permission VALUES (14,'Can change content type',5,'change_contenttype');
INSERT INTO auth_permission VALUES (15,'Can delete content type',5,'delete_contenttype');
INSERT INTO auth_permission VALUES (16,'Can add session',6,'add_session');
INSERT INTO auth_permission VALUES (17,'Can change session',6,'change_session');
INSERT INTO auth_permission VALUES (18,'Can delete session',6,'delete_session');
INSERT INTO auth_permission VALUES (19,'Can add site',7,'add_site');
INSERT INTO auth_permission VALUES (20,'Can change site',7,'change_site');
INSERT INTO auth_permission VALUES (21,'Can delete site',7,'delete_site');
INSERT INTO auth_permission VALUES (22,'Can add log entry',8,'add_logentry');
INSERT INTO auth_permission VALUES (23,'Can change log entry',8,'change_logentry');
INSERT INTO auth_permission VALUES (24,'Can delete log entry',8,'delete_logentry');
INSERT INTO auth_permission VALUES (25,'Can add wiki log',9,'add_wikilog');
INSERT INTO auth_permission VALUES (26,'Can change wiki log',9,'change_wikilog');
INSERT INTO auth_permission VALUES (27,'Can delete wiki log',9,'delete_wikilog');
INSERT INTO auth_permission VALUES (28,'Can add user profile',10,'add_userprofile');
INSERT INTO auth_permission VALUES (29,'Can change user profile',10,'change_userprofile');
INSERT INTO auth_permission VALUES (30,'Can delete user profile',10,'delete_userprofile');

--
-- Table structure for table `auth_user`
--

CREATE TABLE auth_user (
  id int(11) NOT NULL auto_increment,
  username varchar(30) NOT NULL default '',
  first_name varchar(30) NOT NULL default '',
  last_name varchar(30) NOT NULL default '',
  email varchar(75) NOT NULL default '',
  password varchar(128) NOT NULL default '',
  is_staff tinyint(1) NOT NULL default '0',
  is_active tinyint(1) NOT NULL default '0',
  is_superuser tinyint(1) NOT NULL default '0',
  last_login datetime NOT NULL default '0000-00-00 00:00:00',
  date_joined datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id),
  UNIQUE KEY username (username)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_user`
--

INSERT INTO auth_user VALUES (1,'root','','','root@ghilbert.org','sha1$c95e8$853b49f1a809b888369af8e77e0824323d6ab1fa',1,1,1,'2007-01-04 23:38:53','2007-01-04 23:38:53');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE auth_user_groups (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  group_id int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY user_id (user_id,group_id)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_user_groups`
--


--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE auth_user_user_permissions (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  permission_id int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY user_id (user_id,permission_id)
) TYPE=MyISAM;

--
-- Dumping data for table `auth_user_user_permissions`
--


--
-- Table structure for table `django_admin_log`
--

CREATE TABLE django_admin_log (
  id int(11) NOT NULL auto_increment,
  action_time datetime NOT NULL default '0000-00-00 00:00:00',
  user_id int(11) NOT NULL default '0',
  content_type_id int(11) default NULL,
  object_id longtext,
  object_repr varchar(200) NOT NULL default '',
  action_flag smallint(5) unsigned NOT NULL default '0',
  change_message longtext NOT NULL,
  PRIMARY KEY  (id),
  KEY django_admin_log_user_id (user_id),
  KEY django_admin_log_content_type_id (content_type_id)
) TYPE=MyISAM;

--
-- Dumping data for table `django_admin_log`
--


--
-- Table structure for table `django_content_type`
--

CREATE TABLE django_content_type (
  id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  app_label varchar(100) NOT NULL default '',
  model varchar(100) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY app_label (app_label,model)
) TYPE=MyISAM;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO django_content_type VALUES (1,'message','auth','message');
INSERT INTO django_content_type VALUES (2,'group','auth','group');
INSERT INTO django_content_type VALUES (3,'user','auth','user');
INSERT INTO django_content_type VALUES (4,'permission','auth','permission');
INSERT INTO django_content_type VALUES (5,'content type','contenttypes','contenttype');
INSERT INTO django_content_type VALUES (6,'session','sessions','session');
INSERT INTO django_content_type VALUES (7,'site','sites','site');
INSERT INTO django_content_type VALUES (8,'log entry','admin','logentry');
INSERT INTO django_content_type VALUES (9,'wiki log','app','wikilog');
INSERT INTO django_content_type VALUES (10,'user profile','app','userprofile');

--
-- Table structure for table `django_session`
--

CREATE TABLE django_session (
  session_key varchar(40) NOT NULL default '',
  session_data longtext NOT NULL,
  expire_date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (session_key)
) TYPE=MyISAM;

--
-- Dumping data for table `django_session`
--

INSERT INTO django_session VALUES ('86356d18754e56c8b4725c551f014f62','KGRwMQpTJ19hdXRoX3VzZXJfYmFja2VuZCcKcDIKUydkamFuZ28uY29udHJpYi5hdXRoLmJhY2tl\nbmRzLk1vZGVsQmFja2VuZCcKcDMKc1MnX2F1dGhfdXNlcl9pZCcKcDQKTDEwTApzLjAyODFkMTRk\nMTEzYmFhYWI4YmFhNDYyMDQ5NDk5ZWUy\n','2007-01-19 01:58:58');

--
-- Table structure for table `django_site`
--

CREATE TABLE django_site (
  id int(11) NOT NULL auto_increment,
  domain varchar(100) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `django_site`
--

INSERT INTO django_site VALUES (1,'example.com','example.com');