اوامر sql لزراعه الجداول المحذوفة من المنتديات

[محمود الغرايبه]

الجزء الثاني
adminutil

CREATE TABLE `adminutil` ( 
`title` varchar(50) NOT NULL default '', 
`text` mediumtext, 
PRIMARY KEY  (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

album

CREATE TABLE `album` ( 
`albumid` int(10) unsigned NOT NULL auto_increment, 
`userid` int(10) unsigned NOT NULL default '0', 
`createdate` int(10) unsigned NOT NULL default '0', 
`lastpicturedate` int(10) unsigned NOT NULL default '0', 
`visible` int(10) unsigned NOT NULL default '0', 
`moderation` int(10) unsigned NOT NULL default '0', 
`title` varchar(100) NOT NULL default '', 
`description` mediumtext, 
`state` enum('public','private','profile') NOT NULL default 'public', 
`coverpictureid` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`albumid`), 
KEY `userid` (`userid`,`lastpicturedate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

albumpicture

CREATE TABLE `albumpicture` ( 
`albumid` int(10) unsigned NOT NULL default '0', 
`pictureid` int(10) unsigned NOT NULL default '0', 
`dateline` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`albumid`,`pictureid`), 
KEY `albumid` (`albumid`,`dateline`), 
KEY `pictureid` (`pictureid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

albumupdate

CREATE TABLE `albumupdate` ( 
`albumid` int(10) unsigned NOT NULL default '0', 
`dateline` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`albumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

announcement

CREATE TABLE `announcement` ( 
`announcementid` smallint(5) unsigned NOT NULL auto_increment, 
`title` varchar(250) NOT NULL default '', 
`userid` int(10) unsigned NOT NULL default '0', 
`startdate` int(10) unsigned NOT NULL default '0', 
`enddate` int(10) unsigned NOT NULL default '0', 
`pagetext` mediumtext, 
`forumid` smallint(6) NOT NULL default '0', 
`views` int(10) unsigned NOT NULL default '0', 
`announcementoptions` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`announcementid`), 
KEY `forumid` (`forumid`), 
KEY `startdate` (`enddate`,`forumid`,`startdate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;