From 269c58d56242a9c4bf4cac067efdbc6774424a32 Mon Sep 17 00:00:00 2001
From: ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 14 Feb 2008 16:32:36 +0000
Subject: Actions, .htaccess, and the database schema

git-svn-id: https://code.elgg.org/elgg/trunk@31 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 177 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 177 insertions(+)
 create mode 100644 engine/schema/mysql.sql

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
new file mode 100644
index 000000000..9b8304b80
--- /dev/null
+++ b/engine/schema/mysql.sql
@@ -0,0 +1,177 @@
+--
+-- Main Elgg database
+-- 
+-- @link http://elgg.org/
+-- @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU Public License version 2
+-- @author Curverider Ltd
+-- @copyright Curverider Ltd 2008
+-- @link http://elgg.org/
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `access_groups`
+--
+
+CREATE TABLE `access_groups` (
+  `id` int(11) NOT NULL,
+  `name` varchar(16) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `name` (`name`)
+) ENGINE=MyISAM ;
+
+--
+-- Dumping data for table `access_groups`
+--
+
+INSERT INTO `access_groups` (`id`, `name`) VALUES
+(0, 'PRIVATE'),
+(1, 'LOGGED_IN'),
+(2, 'PUBLIC');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `access_group_membership`
+--
+
+CREATE TABLE `access_group_membership` (
+  `user_id` int(11) NOT NULL,
+  `access_group_id` int(11) NOT NULL,
+  PRIMARY KEY  (`user_id`,`access_group_id`)
+) ENGINE=MyISAM ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configuration`
+--
+
+CREATE TABLE `configuration` (
+  `id` int(11) NOT NULL,
+  `name` varchar(32) NOT NULL,
+  `value` text NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `name` (`name`)
+) ENGINE=MyISAM ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `metadata_type`
+--
+
+CREATE TABLE `metadata_type` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(32) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `name` (`name`)
+) ENGINE=MyISAM ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `metadata_value`
+--
+
+CREATE TABLE `metadata_value` (
+  `id` int(11) NOT NULL auto_increment,
+  `value` text NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `objects`
+--
+
+CREATE TABLE `objects` (
+  `id` int(11) NOT NULL auto_increment,
+  `owner_id` int(11) NOT NULL,
+  `site_id` int(11) NOT NULL,
+  `type_id` int(11) NOT NULL,
+  `title` text NOT NULL,
+  `description` text NOT NULL,
+  `time_created` int(11) NOT NULL,
+  `time_updated` int(11) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `time_created` (`time_created`,`time_updated`)
+) ENGINE=MyISAM ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `object_metadata`
+--
+
+CREATE TABLE `object_metadata` (
+  `id` int(11) NOT NULL auto_increment,
+  `object_id` int(11) NOT NULL,
+  `metadata_type_id` int(11) NOT NULL,
+  `value_id` int(11) NOT NULL,
+  `access_id` int(11) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `object_id` (`object_id`,`metadata_type_id`,`value_id`),
+  KEY `access_id` (`access_id`)
+) ENGINE=MyISAM ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `object_types`
+--
+
+CREATE TABLE `object_types` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(16) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `name` (`name`)
+) ENGINE=MyISAM ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE `users` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` text NOT NULL,
+  `username` varchar(12) NOT NULL default '',
+  `password` varchar(32) NOT NULL default '',
+  `email` text NOT NULL,
+  `code` varchar(32) NOT NULL default '',
+  `last_updated` int(11) NOT NULL default '0',
+  `registered` int(11) NOT NULL default '0',
+  `enabled` enum('yes','no') NOT NULL default 'no',
+  `last_action` int(11) NOT NULL default '0',
+  `prev_last_action` int(11) NOT NULL default '0',
+  `last_login` int(11) NOT NULL default '0',
+  `prev_last_login` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`id`),
+  KEY `password` (`password`),
+  FULLTEXT KEY `name` (`name`)
+) ENGINE=MyISAM ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `user_metadata`
+--
+
+CREATE TABLE `user_metadata` (
+  `id` int(11) NOT NULL auto_increment,
+  `user_id` int(11) NOT NULL,
+  `metadata_type_id` int(11) NOT NULL,
+  `value_id` int(11) NOT NULL,
+  `access_id` int(11) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `user_id` (`user_id`,`metadata_type_id`,`value_id`),
+  KEY `access_id` (`access_id`)
+) ENGINE=MyISAM ;
-- 
cgit v1.2.3

