السلام عليكم
ازرع ها الجدولين
الاول
CREATE TABLE `imagecategory` (
`imagecategoryid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`imagetype` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`imagecategoryid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
الثاني
CREATE TABLE `imagecategorypermission` (
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`)
) TYPE=MyISAM;
|