PageRenderTime 28ms CodeModel.GetById 17ms app.highlight 7ms RepoModel.GetById 2ms app.codeStats 0ms

/upgrade.102.103.sql

http://freshdns.googlecode.com/
SQL | 20 lines | 18 code | 2 blank | 0 comment | 0 complexity | 6660cdb186e73bc5e1f3d836957ccf25 MD5 | raw file
 1ALTER TABLE `users` ADD `maxdomains` SMALLINT( 5 ) NOT NULL;
 2
 3CREATE TABLE IF NOT EXISTS `template` (
 4  `templateId` int(11) NOT NULL AUTO_INCREMENT,
 5  `userId` int(11) NOT NULL,
 6  `name` varchar(255) NOT NULL,
 7  PRIMARY KEY (`templateId`)
 8) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 9
10CREATE TABLE IF NOT EXISTS `template_records` (
11  `recordId` int(11) NOT NULL AUTO_INCREMENT,
12  `templateId` int(11) NOT NULL,
13  `name` varchar(255) NOT NULL,
14  `type` varchar(50) NOT NULL,
15  `content` varchar(255) NOT NULL,
16  `prio` smallint(5) NOT NULL,
17  `ttl` int(11) NOT NULL,
18  PRIMARY KEY (`recordId`),
19  KEY `templateId` (`templateId`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;