root/buddyloo/install.sql @ 536

ALTER TABLE wcf1_user ADD socialID int(10) UNSIGNED NOT NULL DEFAULT '0';

DROP TABLE IF EXISTS wcf1_buddyloo;
CREATE TABLE wcf1_buddyloo (
  userID int(10) unsigned NOT NULL,
  whiteUserID int(10) unsigned NOT NULL,
  PRIMARY KEY (userID,whiteUserID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_buddyloo_invitation;
CREATE TABLE wcf1_buddyloo_invitation (
  userID int(10) unsigned NOT NULL,
  email varchar(255) NOT NULL,
  PRIMARY KEY (userID,email)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_buddyloo_social;
CREATE TABLE wcf1_buddyloo_social (
  socialID int(10) unsigned NOT NULL auto_increment,
  socialTitle varchar(80) NOT NULL,
  socialAccess tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (socialID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_buddyloo_gadget;
CREATE TABLE wcf1_buddyloo_gadget (
  gadgetID int(10) unsigned NOT NULL auto_increment,
  gadgetTitle varchar(80) NOT NULL,
  gadgetCode MEDIUMTEXT NOT NULL,
  gadgetImage BLOB NULL DEFAULT NULL,
  gadgetDescription TEXT NOT NULL,
  PRIMARY KEY (gadgetID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--CREATE TABLE `ModulePrefs` (
--`title` VARCHAR( 255 ) NOT NULL ,
--`directory_title` VARCHAR( 80 ) NOT NULL ,
--`title_url` VARCHAR( 255 ) NOT NULL ,
--`description` TEXT NOT NULL ,
--`author` VARCHAR( 80 ) NOT NULL ,
--`author_email` VARCHAR( 80 ) NOT NULL ,
--`author_affiliation` VARCHAR( 80 ) NOT NULL ,
--`author_location` VARCHAR( 80 ) NOT NULL ,
--`screenshot` VARCHAR( 255 ) NOT NULL ,
--`thumbnail` VARCHAR( 255 ) NOT NULL ,
--`height` INT UNSIGNED NOT NULL ,
--`width` INT UNSIGNED NOT NULL ,
--`scaling` BOOL NOT NULL ,
--`scrolling` BOOL NOT NULL ,
--`singleton` BOOL NOT NULL ,
--`author_photo` VARCHAR( 255 ) NOT NULL ,
--`author_aboutme` VARCHAR( 255 ) NOT NULL ,
--`author_link` VARCHAR( 255 ) NOT NULL ,
--`author_quote` VARCHAR( 255 ) NOT NULL
--) ENGINE = MYISAM 


DROP TABLE IF EXISTS wcf1_buddyloo_gadget_to_social;
CREATE TABLE wcf1_buddyloo_gadget_to_social (
  boxID int(10) unsigned NOT NULL auto_increment,
  socialID int(10) unsigned NOT NULL,
  gadgetID int(10) unsigned NOT NULL,
  icolumn tinyint(1) unsigned NOT NULL,
  irow tinyint(1) unsigned NOT NULL,
  visible tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (boxID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_buddyloo_user_to_social;
CREATE TABLE wcf1_buddyloo_user_to_social (
  userID int(10) unsigned NOT NULL,
  socialID int(10) unsigned NOT NULL,
  icolumn tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (userID,socialID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;