nieuwssysteem

CREATE TABLE IF NOT EXISTS `leden_accounts` (
  `uId` int(11) NOT NULL AUTO_INCREMENT,
  `uNaam` varchar(50) NOT NULL,
  `uPass` varchar(50) NOT NULL,
  PRIMARY KEY (`uId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `leden_accounts` (`uId`, `uNaam`, `uPass`) VALUES
(1, adminn, 0d22961a647db7511be58ebc9b97d1cc);


CREATE TABLE IF NOT EXISTS `system_bekeken` (
  `bId` int(11) NOT NULL AUTO_INCREMENT,
  `bIp` varchar(50) NOT NULL,
  `bNieuws` int(11) NOT NULL,
  `bDatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`bId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `system_ipban` (
  `bId` int(11) NOT NULL AUTO_INCREMENT,
  `bIp` varchar(50) NOT NULL,
  PRIMARY KEY (`bId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `system_news` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nDoor` varchar(50) NOT NULL,
  `nOnderwerp` varchar(50) NOT NULL,
  `nBericht` varchar(1000) NOT NULL,
  `nViews` int(11) NOT NULL DEFAULT 0,
  `nDatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `nStick` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`nId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `system_reacties` (
  `rId` int(11) NOT NULL AUTO_INCREMENT,
  `rBericht` varchar(1000) NOT NULL,
  `rNieuws` int(11) NOT NULL,
  `rDatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `rIp` varchar(50) NOT NULL,
  PRIMARY KEY (`rId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `system_votes` (
  `vId` int(11) NOT NULL AUTO_INCREMENT,
  `vNieuws` int(11) NOT NULL,
  `vStem` int(2) NOT NULL,
  `vIp` varchar(50) NOT NULL,
  PRIMARY KEY (`vId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;