CREATE TABLE jos_installed_apps
(
id int(11) NOT NULL auto_increment,
app_name varchar(255) NOT NULL,
app_mainclass varchar(255) NOT NULL,
app_type int(2) unsigned NOT NULL default '0',
restricted tinyint(1) unsigned NOT NULL default '0',
install_date datetime NOT NULL,
PRIMARY KEY (id)
(
id int(11) NOT NULL auto_increment,
app_name varchar(255) NOT NULL,
app_mainclass varchar(255) NOT NULL,
app_type int(2) unsigned NOT NULL default '0',
restricted tinyint(1) unsigned NOT NULL default '0',
install_date datetime NOT NULL,
PRIMARY KEY (id)
);