| Code: |
|
DROP TABLE IF EXISTS `pn_pngroups`; CREATE TABLE `pn_pngroups` ( `pn_gid` int(11) default NULL, `pn_type` varchar(25) default '', `pn_description` varchar(200) default '', `pn_prefix` varchar(25) default '', `pn_state` int(1) default '0', `pn_nbuser` int(11) default '0', `pn_nbumax` int(11) default '0', `pn_link` int(11) default '0', `pn_uidmaster` int(11) default '0', KEY `pncGIndex` (`pn_gid`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Structure de la table `pn_pngroups_applications` # DROP TABLE IF EXISTS `pn_pngroups_applications`; CREATE TABLE `pn_pngroups_applications` ( `pn_app_id` int(11) NOT NULL auto_increment, `pn_uid` int(11) default '0', `pn_gid` int(11) default '0', `pn_application` longblob, `pn_status` int(1) default '0', PRIMARY KEY (`pn_app_id`), KEY `pncGAppIndex` (`pn_app_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; |