Twk1Uaig

1CREATE TABLE IF NOT EXISTS `document` 
2(
3  `intId` int(11) NOT NULL auto_increment,
4  `chDocumentTitle` varchar(32) default NULL,
5  `dtLastUpdate` datetime default NULL,
6  `chUser` varchar(32) default NULL,
7  `chLink` varchar(256) default NULL,
8  `Keyword` varchar(256) default NULL,
9  `intParentid` int(11) NOT NULL,
10
11  PRIMARY KEY  (`intId`),
12  KEY `dtLastUpdate` (`dtLastUpdate`,`chUser`)
13) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
14
15CREATE TABLE IF NOT EXISTS `category` 
16(
17  `intId` int(11) NOT NULL auto_increment,
18  `chName` varchar(32) NOT NULL,
19  `Isactive` tinyint(1) NOT NULL default '0',
20  `chnestUnder` int(5) NOT NULL default '0',
21  PRIMARY KEY  (`intId`),
22  KEY `chName` (`chName`)
23) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
24	
25Category One
26
27Documents of Category One
28
29Sub Category - [ If any ]
30
31Documents of Sub Category