# MySQL sNews Dump
#
# Host: localhost   Database: snews14
# --------------------------------------------------------
# Server version 4.1.19


#
# Table structure for table 'articles'
#
CREATE TABLE articles (
  id INT PRIMARY KEY AUTO_INCREMENT,
  title VARCHAR(100) DEFAULT NULL,
  seftitle VARCHAR(100) DEFAULT NULL,
  text LONGTEXT,
  textlimit INT(5) NOT NULL DEFAULT '0',
  date DATETIME DEFAULT NULL,
  category INT(8) NOT NULL DEFAULT '0',
  position CHAR(3),
  displaytitle CHAR(3) NOT NULL DEFAULT 'YES',
  displayinfo CHAR(3) NOT NULL DEFAULT 'YES',
  commentable VARCHAR(5) NOT NULL,
  image varchar(30) DEFAULT NULL,
  published INT(3) NOT NULL DEFAULT '1'
);

#
# Dumping data for table 'articles'
#

# --------------------------------------------------------

#
# Table structure for table 'categories'
#

CREATE TABLE categories (
  id int(8) PRIMARY KEY AUTO_INCREMENT,
  name varchar(40) NOT NULL,
  seftitle VARCHAR(100) DEFAULT NULL,
  description varchar(100) NOT NULL,
  published varchar(4) NOT NULL DEFAULT 'YES'
);

#
# Dumping data for table 'categories'
#

# --------------------------------------------------------

#
# Table structure for table 'comments'
#

CREATE TABLE comments (
  id INT(11) PRIMARY KEY AUTO_INCREMENT,
  articleid INT(11) DEFAULT '0',
  name varchar(50) DEFAULT '',
  comment TEXT,
  time DATETIME DEFAULT NULL
);

#
# Dumping data for table 'comments'
#