aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-07 18:23:10 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-07 18:23:10 +0000
commit6bbeab62150bd2e3d4ee79018608be2dcc591d2c (patch)
tree838ba0cccbe8cbad516b4e55aac68c2dde3a8783 /engine/schema
parent9fa6b70a24617eeff1c01b8ea648b05dcde47708 (diff)
downloadelgg-6bbeab62150bd2e3d4ee79018608be2dcc591d2c.tar.gz
elgg-6bbeab62150bd2e3d4ee79018608be2dcc591d2c.tar.bz2
Users and friends
git-svn-id: https://code.elgg.org/elgg/trunk@108 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql28
1 files changed, 25 insertions, 3 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 2ce3f71e4..5ba16d344 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -106,10 +106,9 @@ CREATE TABLE `prefix_users` (
`username` varchar(12) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` text NOT NULL,
+ `language` varchar(6) NOT NULL default '',
`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',
+ `created` int(11) NOT NULL default '0',
`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',
@@ -141,6 +140,29 @@ CREATE TABLE `prefix_sites` (
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
+--
+-- Link table between users and sites
+--
+
+CREATE TABLE `prefix_users_sites` (
+ `user_id` int(11) NOT NULL,
+ `site_id` int(11) NOT NULL,
+ PRIMARY KEY (`user_id`,`site_id`)
+) ENGINE=MyISAM ;
+
+--
+-- Table structure for friends
+--
+
+CREATE TABLE `prefix_friends` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) NOT NULL,
+ `friend_id` int(11) NOT NULL,
+ `site_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `user_id` (`user_id`),
+ KEY `friend_id` (`friend_id`)
+) ENGINE=MyISAM;
--
-- Table structure for annotations