-- phpMyAdmin SQL Dump

-- version 3.1.1

-- http://www.phpmyadmin.net

--

-- Serveur: localhost

-- Gnr le : Ven 09 Janvier 2009  01:03

-- Version du serveur: 5.1.30

-- Version de PHP: 5.2.8

--

-- Base de donnes: `joomunity`

--



-- --------------------------------------------------------



--

-- Structure de la table `joom_albums`

--

DROP TABLE IF EXISTS `#__joomm_albums`;

CREATE TABLE IF NOT EXISTS `#__joom_albums` (

  `album_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `album_name` mediumtext NOT NULL,

  `album_descr` text,

  `album_published` int(5) NOT NULL DEFAULT '0',

  `album_create_date` datetime NOT NULL COMMENT 'date the album was created\r\n',

  `album_ordering` int(11) DEFAULT NULL,

  `album_views` int(11) NOT NULL DEFAULT '0',

  `album_user_id` int(11) NOT NULL,

  `album_permissions` varchar(20) NOT NULL,

  `album_thumb` varchar(255) NOT NULL DEFAULT 'no_thumb.jpg',

  `album_rating` int(11) NOT NULL DEFAULT '0',

  `album_img_count` int(11) NOT NULL DEFAULT '0',

  `album_votes` int(11) NOT NULL DEFAULT '0',

  `album_comments` int(11) NOT NULL DEFAULT '0',

  `album_params` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`album_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_albums_pics`

--

DROP TABLE IF EXISTS `#__joom_albums_pics`;

CREATE TABLE IF NOT EXISTS `#__joom_albums_pics` (

  `pic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `pic_name` text NOT NULL,

  `pic_descr` text,

  `pic_album_id` int(11) NOT NULL,

  `pic_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `pic_user_id` int(11) NOT NULL,

  `pic_title` text NOT NULL,

  `pic_status` int(11) NOT NULL DEFAULT '0' COMMENT '0=unpublished, 1=published, 2=in moderation qeue',

  `pic_views` int(11) NOT NULL DEFAULT '0',

  `pic_rating` int(11) NOT NULL DEFAULT '0',

  `pic_votes` int(11) NOT NULL DEFAULT '0',

  `pic_comments` int(11) DEFAULT '0',

  `pic_params` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`pic_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_albums_pics_comments`

--

DROP TABLE IF EXISTS `#__joom_albums_pics_comments`;

CREATE TABLE IF NOT EXISTS `#__joom_albums_pics_comments` (

  `cmt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `cmt_pic_id` int(11) NOT NULL,

  `cmt_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `cmt_user_id` int(11) NOT NULL,

  `cmt_status` int(11) NOT NULL DEFAULT '0' COMMENT '0=unpublished, 1=published, 2=in moderation qeue',

  `cmt_body` text NOT NULL,

  PRIMARY KEY (`cmt_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;





-- --------------------------------------------------------



--

-- Structure de la table `joom_chat`

--

DROP TABLE IF EXISTS `#__joom_chat`;

CREATE TABLE IF NOT EXISTS `#__joom_chat` (

  `crid` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `crname` varchar(100) NOT NULL,

  `crstart_time` int(11) NOT NULL,

  `crownerid` tinyint(4) NOT NULL,

  `crpermission` enum('0','1','2','3') NOT NULL DEFAULT '0',

  `crmember_count` int(11) NOT NULL DEFAULT '0' COMMENT 'members in room now!',

  `crwelcome_msg` text,

  `crbanned_msg` text,

  `crtype` enum('0','1','2') NOT NULL COMMENT '0 = 1 on 1, 1 = 1 is to many, 3 => Admin moderated',

  `crparams` text NOT NULL,

  `crdescr` text,

  `crmemberid` int(11) DEFAULT NULL,

  PRIMARY KEY (`crid`,`crname`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_chat_members`

--

DROP TABLE IF EXISTS `#__joom_chat_members`;

CREATE TABLE IF NOT EXISTS `#__joom_chat_members` (

  `cmid` int(10) unsigned NOT NULL,

  `crid` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `cmjointime` int(10) unsigned NOT NULL,

  `cmpermission` enum('0','1','2') NOT NULL,

  `cmlastmsgtime` int(10) unsigned NOT NULL,

  `cmmsgcount` tinyint(3) unsigned NOT NULL,

  `cmsesskey` varchar(120) NOT NULL,

  `cmroomid` int(10) unsigned NOT NULL,

  `cmusername` varchar(60) NOT NULL,

  PRIMARY KEY (`crid`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



--

-- Contenu de la table `joom_chat_members`

--





-- --------------------------------------------------------



--

-- Structure de la table `joom_chat_message`

--

DROP TABLE IF EXISTS `#__joom_chat_message`;

CREATE TABLE IF NOT EXISTS `#__joom_chat_message` (

  `msgid` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `msgcrid` varchar(45) NOT NULL,

  `msguid` tinyint(3) unsigned NOT NULL,

  `msguname` varchar(60) NOT NULL,

  `msgbody` text,

  `msgposttime` int(10) unsigned NOT NULL,

  `msgstatus` varchar(45) NOT NULL,

  PRIMARY KEY (`msgid`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_contacts`

--

DROP TABLE IF EXISTS `#__joom_contacts`;

CREATE TABLE IF NOT EXISTS `#__joom_contacts` (

  `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `user_title` varchar(20) NOT NULL,

  `user_suffix` varchar(20) DEFAULT NULL,

  `user_home_address` varchar(155) DEFAULT NULL,

  `user_city` text,

  `user_region` text,

  `user_postal_code` text,

  `user_country` varchar(100) DEFAULT NULL,

  `user_phone` varchar(60) DEFAULT NULL,

  `user_mobile` varchar(60) DEFAULT NULL,

  `user_fax` varchar(60) DEFAULT NULL,

  `user_im` text,

  `user_notes` text,

  `user_jobtitle` text,

  `user_department` text,

  `user_profession` text,

  `user_workaddress` text,

  `user_website` varchar(100) DEFAULT NULL,

  `user_ICQ` varchar(50) DEFAULT NULL,

  `user_AIM` varchar(50) DEFAULT NULL,

  `user_YIM` varchar(50) DEFAULT NULL,

  `user_MSN` varchar(50) DEFAULT NULL,

  `user_skype` varchar(50) DEFAULT NULL,

  `user_GTALK` varchar(50) DEFAULT NULL,

  `user_company` text,

  PRIMARY KEY (`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



--

-- Contenu de la table `joom_contacts`

--





-- --------------------------------------------------------



--

-- Structure de la table `joom_feeds`

--

DROP TABLE IF EXISTS `#__joom_feeds`;

CREATE TABLE IF NOT EXISTS `#__joom_feeds` (

  `feed_id` int(5) unsigned NOT NULL AUTO_INCREMENT,

  `feed_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `feed_this_user` varchar(60) NOT NULL,

  `feed_this_userid` int(10) NOT NULL,

  `feed_that_user` varchar(62) NOT NULL,

  `feed_that_userid` int(10) NOT NULL,

  `feed_status` enum('0','1','2','3') NOT NULL DEFAULT '0',

  `feed_link` varchar(255) NOT NULL DEFAULT '#',

  `feed_output` varchar(255) NOT NULL,

  `feed_notes` text CHARACTER SET latin1,

  `feed_app` varchar(50) NOT NULL,

  `feed_attachment` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`feed_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_notifications`

--

DROP TABLE IF EXISTS `#__joom_notifications`;

CREATE TABLE IF NOT EXISTS `#__joom_notifications` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `title` text CHARACTER SET latin1 NOT NULL,

  `body` text CHARACTER SET latin1,

  `link` varchar(100) NOT NULL,

  `application` varchar(50) NOT NULL DEFAULT 'Profile',

  `status` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0 = unread, 1= read , 2=solved if in moderation que',

  `type` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0= default, 1=moderation',

  `userid` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_params`

--

DROP TABLE IF EXISTS `#__joom_params`; 

CREATE TABLE IF NOT EXISTS `#__joom_params` (

  `album_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `album_name` mediumtext NOT NULL,

  `album_descr` text,

  `album_published` int(5) NOT NULL DEFAULT '0',

  PRIMARY KEY (`album_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



--

-- Contenu de la table `joom_params`

--





-- --------------------------------------------------------



--

-- Structure de la table `joom_plg`

--

DROP TABLE IF EXISTS `#__joom_plg`;

CREATE TABLE IF NOT EXISTS `#__joom_plg` (

  `plg_id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `plg_name` varchar(200) NOT NULL,

  `plg_title` varchar(200) NOT NULL,

  `plg_icon` varchar(255) NOT NULL,

  `plg_type` varchar(100) NOT NULL,

  `plg_published` enum('0','1','2','3') NOT NULL DEFAULT '0',

  `plg_author` varchar(100) NOT NULL DEFAULT 'Unknown',

  `plg_date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `plg_params` varchar(255) DEFAULT NULL,

  `plg_action` varchar(150) DEFAULT NULL,

  `plg_actionlink` varchar(150) DEFAULT NULL,

  PRIMARY KEY (`plg_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;



--

-- Contenu de la table `joom_plg`

--



INSERT INTO `#__joom_plg` (`plg_id`, `plg_name`, `plg_title`, `plg_icon`, `plg_type`, `plg_published`, `plg_author`, `plg_date_added`, `plg_params`, `plg_action`, `plg_actionlink`) VALUES

(2, 'Friends', 'Friends', 'applications/Friends/views/img/friends_xsmall.png', 'application', '1', 'The Joomunity Project', '0001-01-01 00:00:00', '_friends_widget', 'VIEW_ALL_MY_FRIENDS', NULL),

(3, 'Users', 'Users', 'applications/Users/views/img/users_xsmall.png', 'system_application', '1', 'The Joomunity Project', '2008-06-18 20:57:27', NULL, NULL, NULL),

(4, 'Search', 'Search', 'applications/Search/views/img/search_xsmall.png', 'system_application', '1', 'The Joomunity Project', '2008-06-19 10:51:48', NULL, NULL, NULL),

(5, 'Profile', 'Profile', 'applications/Profile/views/img/profile_xsmall.png', 'system_application', '1', 'The Joomunity Project', '2008-06-19 11:11:54', NULL, NULL, NULL),

(6, 'Minifeeds', 'Minifeeds', 'applications/Minifeeds/views/img/minifeeds_xsmall.png', 'application', '1', 'The Joomunity Project', '2008-06-19 11:46:17', '_minifeeds_widget', 'VIEW_MY_RECENT_ACTIVITY', NULL),

(7, 'Messages', 'Messages', 'applications/Messages/views/img/messages_xsmall.png', 'system_application', '1', 'The Joomunity Project', '2008-06-19 12:02:21', NULL, NULL, NULL),

(8, 'Photos', 'Photos', 'applications/Photos/views/img/photos_xsmall.png', 'application', '1', 'The Joomunity Project', '2008-07-13 16:53:51', '_photos_widget', 'SEE_SOME_OF_MY_PICTURES', NULL),

(9, 'Contacts', 'Contacts', 'applications/Contacts/views/img/contacts_xsmall.png', 'application', '1', 'The Joomunity Project', '2008-07-13 16:53:51', '_contacts_widget', 'MY_CONTACT_INFO_WIDGET', NULL),

(14, 'Chat', 'Chat', 'applications/Chat/views/img/chat_xsmall.png', 'system_application', '1', 'The Joomunity Project', '0000-00-00 00:00:00', NULL, NULL, NULL),

(20, 'Wathchthis', 'Watchthis', 'interface/templates/wonderland/watchthis_xsmall.png', 'template', '1', 'The Joomunity Project', '2008-11-23 14:58:33', NULL, NULL, NULL);



-- --------------------------------------------------------



--

-- Structure de la table `joom_rel`

--



DROP TABLE IF EXISTS `#__joom_rel`;

CREATE TABLE IF NOT EXISTS `#__joom_rel` (

  `rel_id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `rel_type` varchar(100) NOT NULL,

  `rel_thisuser` int(20) NOT NULL,

  `rel_thatuser` int(20) NOT NULL,

  `rel_consent` enum('0','1') NOT NULL DEFAULT '0',

  `rel_datereq` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `rel_dateaccept` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `rel_thatdescr` mediumtext CHARACTER SET latin1,

  `rel_thisdescr` mediumint(9) DEFAULT NULL,

  `rel_params` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`rel_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_social`

--

DROP TABLE IF EXISTS `#__joom_social` ;

CREATE TABLE IF NOT EXISTS `#__joom_social` (

  `social_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `social_perms` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0=visible to all, 1=visible to friends',

  `uc_main_occupation` varchar(150) DEFAULT '',

  `uc_favorite_color` varchar(40) DEFAULT '',

  PRIMARY KEY (`social_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;



-- --------------------------------------------------------



--

-- Structure de la table `joom_social_fields`

--

DROP TABLE IF EXISTS `#__joom_social_fields`;

CREATE TABLE IF NOT EXISTS `#__joom_social_fields` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(100) NOT NULL,

  `title` varchar(100) NOT NULL,

  `descr` text CHARACTER SET latin1,

  `type` varchar(100) NOT NULL,

  `maxlength` int(11) DEFAULT NULL,

  `size` varchar(20) DEFAULT NULL,

  `required` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0 = not required, 1 = required',

  `ordering` int(11) NOT NULL,

  `defaultvalue` varchar(255) DEFAULT NULL,

  `visible` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 = no , 1 = yes',

  `validation` text CHARACTER SET latin1,

  `attributes` text CHARACTER SET latin1,

  `indexed` enum('0','1') DEFAULT '1' COMMENT 'allow search 0 = no 1 = yes',

  `linkfieldvalue` varchar(255) DEFAULT NULL COMMENT 'link the value of this field to some url?',

  `tablename` varchar(90) DEFAULT NULL,

  `options` text CHARACTER SET latin1,

  `editable` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Wether the filed is editable from the profile social settings tab',

  PRIMARY KEY (`id`,`name`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;



--

-- Contenu de la table `joom_social_fields`

--



INSERT INTO `#__joom_social_fields` (`id`, `name`, `title`, `descr`, `type`, `maxlength`, `size`, `required`, `ordering`, `defaultvalue`, `visible`, `validation`, `attributes`, `indexed`, `linkfieldvalue`, `tablename`, `options`, `editable`) VALUES

(1, 'user_nickname', 'Nick name', NULL, 'text', NULL, NULL, '0', 6, NULL, '1', NULL, 'style=width::100%;', '1', NULL, '#__joom_users', NULL, '0'),

(2, 'user_sex', 'Sex', NULL, 'text', NULL, NULL, '0', 7, NULL, '1', NULL, 'style=width::100%;', '1', NULL, '#__joom_users', NULL, '0'),

(3, 'user_dob', 'Date of Birth', NULL, 'date', NULL, NULL, '0', 8, NULL, '1', NULL, 'style=width::100%;', '1', NULL, '#__joom_users', NULL, '0'),

(4, 'user_descr', 'About Me', NULL, 'textarea', NULL, NULL, '0', 9, NULL, '1', NULL, 'style=width::100%;', '1', NULL, '#__joom_users', NULL, '0'),

(7, 'uc_main_occupation', 'Occupation', 'Users main occupation', 'text', 150, '', '0', 0, '', '1', NULL, NULL, '1', '', '#__joom_social', '', '1'),

(8, 'uc_favorite_color', 'Favorite Color', 'user favorite color field', 'text', 40, '', '0', 0, '', '1', NULL, NULL, '1', '', '#__joom_social', '', '1');



-- --------------------------------------------------------



--

-- Structure de la table `joom_users`

--

DROP TABLE IF EXISTS `#__joom_users`;

CREATE TABLE IF NOT EXISTS `#__joom_users` (

  `user_id` int(10) NOT NULL,

  `user_name` varchar(30) DEFAULT NULL,

  `user_nickname` varchar(60) NOT NULL,

  `user_firstname` text CHARACTER SET latin1 NOT NULL,

  `user_lastname` text CHARACTER SET latin1 NOT NULL,

  `user_initials` text CHARACTER SET latin1,

  `user_email` varchar(200) DEFAULT NULL,

  `user_reg_date` datetime NOT NULL,

  `user_last_login` datetime NOT NULL,

  `user_sex` int(11) NOT NULL DEFAULT '0',

  `user_dob` date DEFAULT NULL,

  `user_picture` varchar(40) NOT NULL DEFAULT 'nopicture.jpg',

  `user_rating` float(9,3) NOT NULL DEFAULT '0.000',

  `user_votes` int(11) NOT NULL DEFAULT '0',

  `user_occupation` text CHARACTER SET latin1,

  `user_descr` text CHARACTER SET latin1,

  `user_last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `user_tag` text CHARACTER SET latin1,

  `user_views` int(11) NOT NULL DEFAULT '0',

  `user_groups` varchar(145) DEFAULT NULL,

  `user_params` text,

  `user_jid` int(11) NOT NULL,

  `user_fbcid` int(10) unsigned NOT NULL,

  PRIMARY KEY (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;



-- --------------------------------------------------------



--

-- Structure de la table `joom_users_apps`

--

DROP TABLE IF EXISTS `#__joom_users_apps`;

CREATE TABLE IF NOT EXISTS `#__joom_users_apps` (

  `record_id` int(10) NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `app_id` int(11) NOT NULL,

  `app_title` text CHARACTER SET latin1 NOT NULL,

  `app_status` enum('0','1','2') NOT NULL DEFAULT '1',

  `app_proposed_by` int(11) DEFAULT NULL,

  `app_date_proposed` datetime DEFAULT '0000-00-00 00:00:00',

  `app_date_added` datetime NOT NULL,

  `app_user_settings` text,

  `app_order` int(11) DEFAULT NULL,

  PRIMARY KEY (`record_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;

