SQL database schema

[neosin]

hi it seems the SQL schema is missing

this project looks really cool

[erikperttu]

Here is a dump: Obviously there is alot that could be much more effective in this project since im still learning. Would need to add a link_rel_comments table aswell among other things.

---

-- phpMyAdmin SQL Dump -- version 3.4.5deb1

-- http://www.phpmyadmin.net

-- Host: localhost -- Generation Time: Oct 18, 2011 at 04:26 PM -- Server version: 5.1.58 -- PHP Version: 5.3.6-13ubuntu3.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

-- Database: ci_reddit_clone

---

-- Table structure for table comments

DROP TABLE IF EXISTS comments; CREATE TABLE IF NOT EXISTS comments ( comment_id int(11) NOT NULL AUTO_INCREMENT, comment_user varchar(255) NOT NULL, comment_text text NOT NULL, comment_rating int(11) NOT NULL, date_added timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, post_id int(11) NOT NULL, parent_id int(11) NOT NULL DEFAULT '0', UNIQUE KEY comment_id (comment_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

---

-- Table structure for table links

DROP TABLE IF EXISTS links; CREATE TABLE IF NOT EXISTS links ( link_id int(11) NOT NULL AUTO_INCREMENT, link varchar(255) NOT NULL, link_description text NOT NULL, link_rating int(11) NOT NULL, date_added timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (link_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

---

-- Table structure for table link_user_rel

DROP TABLE IF EXISTS link_user_rel; CREATE TABLE IF NOT EXISTS link_user_rel ( rel_id int(11) NOT NULL AUTO_INCREMENT, link_id int(11) NOT NULL, user_id int(11) NOT NULL, PRIMARY KEY (rel_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

---

-- Table structure for table users

DROP TABLE IF EXISTS users; CREATE TABLE IF NOT EXISTS users ( user_id int(11) NOT NULL AUTO_INCREMENT COMMENT 'user_id', username varchar(32) NOT NULL COMMENT 'username', user_password varchar(255) NOT NULL COMMENT 'user_password', admin tinyint(1) NOT NULL COMMENT 'user_admin boolean', user_email varchar(32) NOT NULL COMMENT 'valid_email ', date_added timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (user_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

---

[neosin]

thanks