root/buddyloo/install.sql @ 737

Revision 737, 13.2 kB (checked in by d0nut, 4 years ago)

change size of members gadget
Line 
1ALTER TABLE wcf1_user ADD socialID int(10) UNSIGNED NOT NULL DEFAULT '0';
2
3DROP TABLE IF EXISTS wcf1_buddyloo;
4CREATE TABLE wcf1_buddyloo (
5  userID int(10) unsigned NOT NULL,
6  whiteUserID int(10) unsigned NOT NULL,
7  PRIMARY KEY (userID,whiteUserID)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8;
9
10DROP TABLE IF EXISTS wcf1_buddyloo_invitation;
11CREATE TABLE wcf1_buddyloo_invitation (
12  userID int(10) unsigned NOT NULL,
13  email varchar(255) NOT NULL,
14  PRIMARY KEY (userID,email)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
17DROP TABLE IF EXISTS wcf1_buddyloo_social;
18CREATE TABLE wcf1_buddyloo_social (
19  socialID int(10) unsigned NOT NULL auto_increment,
20  socialTitle varchar(80) NOT NULL,
21  socialAccess tinyint(1) unsigned NOT NULL DEFAULT 0,
22  PRIMARY KEY (socialID)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8;
24
25DROP TABLE IF EXISTS wcf1_buddyloo_gadget;
26CREATE TABLE wcf1_buddyloo_gadget (
27  gadgetID int(10) unsigned NOT NULL auto_increment,
28  gadgetTitle varchar(80) NOT NULL,
29  gadgetCode MEDIUMTEXT NOT NULL,
30  gadgetImage BLOB NULL DEFAULT NULL,
31  gadgetDescription TEXT NOT NULL,
32  PRIMARY KEY (gadgetID)
33) ENGINE=MyISAM DEFAULT CHARSET=utf8;
34
35DROP TABLE IF EXISTS wcf1_buddyloo_gadget_to_social;
36CREATE TABLE wcf1_buddyloo_gadget_to_social (
37  boxID int(10) unsigned NOT NULL auto_increment,
38  socialID int(10) unsigned NOT NULL,
39  gadgetID int(10) unsigned NOT NULL,
40  icolumn tinyint(1) unsigned NOT NULL,
41  irow tinyint(1) unsigned NOT NULL,
42  visible tinyint(1) unsigned NOT NULL DEFAULT 1,
43  PRIMARY KEY (boxID)
44) ENGINE=MyISAM DEFAULT CHARSET=utf8;
45
46DROP TABLE IF EXISTS wcf1_buddyloo_user_to_social;
47CREATE TABLE wcf1_buddyloo_user_to_social (
48  userID int(10) unsigned NOT NULL,
49  socialID int(10) unsigned NOT NULL,
50  icolumn tinyint(1) unsigned NOT NULL,
51  PRIMARY KEY (userID,socialID)
52) ENGINE=MyISAM DEFAULT CHARSET=utf8;   
53
54DROP TABLE IF EXISTS wcf1_buddyloo_gadget_variables;
55CREATE TABLE wcf1_buddyloo_gadget_variables (
56  variableID int(10) unsigned NOT NULL auto_increment,
57  gadgetID int(10) unsigned NOT NULL,
58  variableName varchar(64) NOT NULL,
59  variableType ENUM('text','textarea','radio','checkbox','select','multiselect') NOT NULL,
60  variableDefault varchar(255) NOT NULL,
61  PRIMARY KEY (variableID),
62  UNIQUE(gadgetID, variableName)
63) ENGINE=MyISAM DEFAULT CHARSET=utf8;
64
65DROP TABLE IF EXISTS wcf1_buddyloo_gadget_variables_value;
66CREATE TABLE wcf1_buddyloo_gadget_variables_value (
67  variableID int(10) unsigned NOT NULL,
68  boxID int(10) unsigned NOT NULL,
69  userID int(10) unsigned NOT NULL,
70  variableValue varchar(255) NOT NULL,
71  PRIMARY KEY (variableID, boxID, userID)
72) ENGINE=MyISAM DEFAULT CHARSET=utf8;
73
74INSERT INTO `wcf1_buddyloo_gadget` (`gadgetID`, `gadgetTitle`, `gadgetCode`, `gadgetImage`, `gadgetDescription`) VALUES
75(1, 'Members gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678532311" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''HEIGHT''] = ''348'';\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderMembersGadget(\r\n { id: ''div-1228678532311'',\r\n   site: ''08725200924522186419''},\r\n  skin);\r\n</script>\r\n', NULL, 'The Members gadget allows visitors to join your site, sign in and out, see pictures of other site members, see pictures of their friends, explore other members'' profiles, invite other people to join your site.'),
76(2, 'Sign In gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678744328" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''ALIGNMENT''] = ''right'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderSignInGadget(\r\n { id: ''div-1228678744328'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'The Sign In gadget allows visitors to join your site, sign in and out, and invite people to become members. It doesn''t have all the features of the Members gadget, but it can fit neatly in to a small space.'),
77(3, '''User'' Wall gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228680667275" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''DEFAULT_COMMENT_TEXT''] = ''{$DEFAULT_COMMENT_TEXT}'';\r\nskin[''HEADER_TEXT''] = ''{$HEADER_TEXT}'';\r\nskin[''POSTS_PER_PAGE''] = ''5'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderWallGadget(\r\n { id: ''div-1228680667275'',\r\n   site: ''{$siteID}'',\r\n   ''view-params'':{"scope":"ID","features":"video,comment","docId":"{$userID}"}\r\n},\r\n  skin);\r\n</script>\r\n', NULL, 'Allows viewers to post comments, or links to videos on your site.'),
78(4, 'Review/Rate gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678871007" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''DEFAULT_COMMENT_TEXT''] = ''- add your review here -'';\r\nskin[''HEADER_TEXT''] = ''Ratings'';\r\nskin[''POSTS_PER_PAGE''] = ''5'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderReviewGadget(\r\n { id: ''div-1228678871007'',\r\n   site: ''{$siteID}'',\r\n   ''view-params'':{"disableMinMax":"false","scope":"ID","docId":"{$userID}","startMaximized":"true"}\r\n},\r\n  skin);\r\n</script>\r\n', NULL, 'Allows viewers to rate a page, or a section of a page. Viewers can use this to rate videos, articles, books, photos, songs, or anything else you can imagine. You can put multiple Review/Rate gadgets on one page, one for each item you want viewers to review.'),
79(5, 'OpenSocial Demo', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678942573" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228678942573'',\r\n   url:''http://www.google.com/friendconnect/gadgets/sample.xml'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'This is a sample OpenSocial application that demonstrates the basic concepts that an OpenSocial developer can use in their application.'),
80(6, 'LameGame demo', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678995231" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228678995231'',\r\n   url:''http://www.google.com/friendconnect/gadgets/lamegame.xml'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'Here is a silly game (lame) where visitors simply click as often as they can to increase their score vs. their friends and other members.'),
81(7, 'Custom Gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228679272840" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228679272840'',\r\n   url:''{$GADGET_URL}'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'Use this to generate the code snippet that you need to add a custom OpenSocial gadget to your site.');
82
83
84INSERT INTO `wcf1_buddyloo_gadget_variables` (`variableID`, `gadgetID`, `variableName`, `variableType`, `variableDefault`) VALUES
85(1, 3, 'DEFAULT_COMMENT_TEXT', 'text', '- add your comment here -'),
86(2, 3, 'HEADER_TEXT', 'text', 'Comments'),
87(3, 7, 'GADGET_URL', 'text', '');
Note: See TracBrowser for help on using the browser.