-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]collection`
CREATE TABLE `[[dbprefix]]collection` (
`id` int(11) NOT NULL auto_increment,
`artist` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`year` int(11) NOT NULL default '0',
`format` varchar(100) NOT NULL default '',
`label` varchar(100) NOT NULL default '',
`comment` varchar(100) NOT NULL default '',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Dumping data for table `[[dbprefix]]collection`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]login`
CREATE TABLE `[[dbprefix]]login` (
`brugernavn` varchar(25) NOT NULL default '',
`password` varchar(35) NOT NULL default '',
PRIMARY KEY (`brugernavn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Dumping data for table `[[dbprefix]]login`
INSERT INTO `[[dbprefix]]login` VALUES ('[[admin_username]]', '[[admin_pass]]');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]settings`
CREATE TABLE `[[dbprefix]]settings` (
`id` int(1) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`persite` char(3) NOT NULL default '',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Dumping data for table `[[dbprefix]]settings`
INSERT INTO `[[dbprefix]]settings` VALUES (1, '[[site_name]]', 'all');