Initial commit
[moodle.git] / search / db / mysql.sql
CommitLineData
682d4032 1CREATE TABLE IF NOT EXISTS `search_documents` (
2 `id` int(11) NOT NULL auto_increment,
3 `type` varchar(12) NOT NULL default 'none',
4 `title` varchar(100) NOT NULL default '',
5 `url` varchar(100) NOT NULL default '',
6 `updated` timestamp NOT NULL default CURRENT_TIMESTAMP,
7 `courseid` int(11) NOT NULL default '0',
8 `userid` int(11) NOT NULL default '0',
9 `groupid` int(11) NOT NULL default '0',
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM AUTO_INCREMENT=1;
12
13DELETE FROM `search_documents` WHERE 1;
14ALTER TABLE `search_documents` AUTO_INCREMENT =1;
15