[littlericky]

My first attempt at a module is for embedding widgets. Fields I need are, widget_id which is dynamically assigned),band_id(dynamically populated), widget_name(text), embed_code(textarea),widget_location(select), and widget_active(select)

Does the following look correct, specifically the widget_id? Thanks

Code

// jrWidgets $tbl = "CREATE TABLE {$jamroom_db['jrWidgets']} (   jrWidgets_widget_id INT(7) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY),   jrWidgets_band_id INT(7) UNSIGNED NOT NULL,   jrWidgets_widget_name VARCHAR(40) NOT NULL DEFAULT '',    jrWidgets_embed_code text NOT NULL DEFAULT '',   jrWidgets_location INT(4) UNSIGNED NOT NULL DEFAULT '0',      jrWidget_active TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',    )";

[Michael]

I would normally do it like this:

Code

$tbl = "CREATE TABLE {$jamroom_db['jrWidgets']} (   jrWidgets_widget_id INT(7) NOT NULL auto_increment,   jrWidgets_band_id INT(7) NOT NULL,   jrWidgets_widget_name VARCHAR(40) NOT NULL DEFAULT '',   jrWidgets_embed_code text NOT NULL DEFAULT '',   jrWidgets_location INT(4) NOT NULL DEFAULT '0',      jrWidget_active TINYINT(1) NOT NULL DEFAULT '1', PRIMARY KEY  (jrWidgets_widget_id)    )";

Try it and see if it triggers any errors.


_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center

[littlericky]

Great thanks. I'll give it a try.