Code : Tout sélectionner
Categories generales:
CREATE TABLE `sawtiyat` (
`id` int(11) NOT NULL auto_increment,
`sawtiyat` varchar(50) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`icon` varchar(255) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`information` text NOT NULL,
PRIMARY KEY (`id`)
)TYPE=MyISAM;
Sous categories:
CREATE TABLE `moughani` (
`id` int(11) NOT NULL auto_increment,
`moughani` varchar(50) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`icon` varchar(255) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`information` text NOT NULL,
`sawtiyat_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ;
Les Albums:
CREATE TABLE `shareet` (
`id` int(11) NOT NULL auto_increment,
`shareet` varchar(50) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`icon` varchar(255) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`information` text NOT NULL,
`moughani_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ;
Les chansons:
CREATE TABLE `onshouda` (
`id` int(11) NOT NULL auto_increment,
`onshouda` varchar(50) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`icon` varchar(255) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`information` text NOT NULL,
`shareet_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ;