| 1 | ALTER TABLE wcf1_user ADD socialID int(10) UNSIGNED NOT NULL DEFAULT '0'; |
|---|
| 2 | |
|---|
| 3 | CREATE TABLE IF NOT EXISTS wcf1_buddyloo_social ( |
|---|
| 4 | socialID int(10) unsigned NOT NULL auto_increment, |
|---|
| 5 | socialTitle varchar(80) NOT NULL, |
|---|
| 6 | PRIMARY KEY (socialID) |
|---|
| 7 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 8 | |
|---|
| 9 | CREATE TABLE IF NOT EXISTS wcf1_buddyloo_gadget ( |
|---|
| 10 | gadgetID int(10) unsigned NOT NULL auto_increment, |
|---|
| 11 | gadgetTitle varchar(80) NOT NULL, |
|---|
| 12 | gadgetCode MEDIUMTEXT NOT NULL, |
|---|
| 13 | gadgetImage BLOB NOT NULL, |
|---|
| 14 | gadgetDescription TEXT NOT NULL, |
|---|
| 15 | PRIMARY KEY (gadgetID) |
|---|
| 16 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 17 | |
|---|
| 18 | CREATE TABLE IF NOT EXISTS wcf1_buddyloo_social_to_gadget ( |
|---|
| 19 | socialID int(10) unsigned NOT NULL, |
|---|
| 20 | gadgetID int(10) unsigned NOT NULL, |
|---|
| 21 | icolumn tinyint(1) unsigned NOT NULL, |
|---|
| 22 | irow tinyint(1) unsigned NOT NULL, |
|---|
| 23 | visible tinyint(1) unsigned NOT NULL DEFAULT 1, |
|---|
| 24 | PRIMARY KEY (socialID,gadgetID) |
|---|
| 25 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 26 | |
|---|
| 27 | CREATE TABLE IF NOT EXISTS wcf1_buddyloo_user_to_social ( |
|---|
| 28 | userID int(10) unsigned NOT NULL, |
|---|
| 29 | socialID int(10) unsigned NOT NULL, |
|---|
| 30 | icolumn tinyint(1) unsigned NOT NULL, |
|---|
| 31 | PRIMARY KEY (userID,socialID) |
|---|
| 32 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
