Edit - impleo.sql

Edit: impleo.sql

-- 
-- Database: `impleo`
--

-- --------------------------------------------------------

-- 
-- 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 '',
  PRIMARY KEY  (`id`)
) 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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]settings`
--

INSERT INTO `[[dbprefix]]settings` VALUES (1, '[[site_name]]', 'all');

Cancel