Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Invite,expert klausimas.

Parašė cmdee· 2008 Vas. 10 13:02:00
#7

$inf_newtable_[1] = "invite_invitations (
inv_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
inv_key VARCHAR(50) NULL default '',
inv_email VARCHAR(100) NULL default '',
inv_date DATE NULL ,
user_id SMALLINT(5) UNSIGNED NOT NULL,
PRIMARY KEY(inv_id)
) TYPE=MyISAM;";
$inf_newtable_[2] = "invite_settings (
inv_group SMALLINT(3) UNSIGNED NOT NULL DEFAULT 101,
inv_lasts SMALLINT(3) UNSIGNED NOT NULL DEFAULT 10,
inv_adminapproval BOOL NOT NULL DEFAULT 0,
inv_emailverification BOOL NULL DEFAULT 0,
inv_enabled BOOL NULL default 1,
PRIMARY KEY(inv_group),
INDEX fusion_invite_settings_FKIndex1(inv_group)
) TYPE=MyISAM;";

$inf_droptable_[1] = "invite_invitations";
$inf_droptable_[2] = "invite_settings";

$inf_insertdbrow_[1] = "invite_settings (inv_group, inv_lasts, inv_adminapproval) VALUES(101, 10, 0)";