/*
SQLyog - Free MySQL GUI v5.02
Host - 5.0.45-community-nt : Database - ojass
*********************************************************************
Server version : 5.0.45-community-nt
*/



USE `oscotech_cms`;

/*Table structure for table `issues` */

DROP TABLE IF EXISTS `issues`;

CREATE TABLE `issues` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `year` varchar(50) default NULL,
  `volume` varchar(50) NOT NULL,
  `path` varchar(50) NOT NULL,
  `createdby` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

/*Table structure for table `ojass_admin` */

DROP TABLE IF EXISTS `ojass_admin`;

CREATE TABLE `ojass_admin` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `kokoro` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

/*Table structure for table `pub` */

DROP TABLE IF EXISTS `pub`;

CREATE TABLE `pub` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(400) NOT NULL,
  `author` varchar(50) NOT NULL,
  `pdf_pat` varchar(400) NOT NULL,
  `issues_id` int(11) NOT NULL,
  `uploaded_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
