MOON
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 PHP/5.4.10
System: Linux vps.presagepowered.net 2.6.18-398.el5 #1 SMP Tue Sep 16 20:51:48 EDT 2014 i686
User: mckernan (512)
PHP: 5.4.10
Disabled: NONE
$ pwd: /home/mckernan/public_html/iJournal/includes/file/
Upload Files
File: /home/mckernan/public_html/iJournal/includes/file/ijnlschema.sql
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2012 at 07:32 PM
-- Server version: 5.1.37
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `ijnl_testmeup`
--

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

--
-- Table structure for table `accounting_year`
--

CREATE TABLE IF NOT EXISTS `accounting_year` (
  `yr_id` int(11) NOT NULL AUTO_INCREMENT,
  `yr_year` char(4) NOT NULL,
  `yr_mos` int(2) unsigned NOT NULL,
  `yr_depr` decimal(12,2) NOT NULL,
  `yr_fed` decimal(6,4) NOT NULL,
  `yr_state` decimal(6,4) NOT NULL,
  `yr_local` decimal(6,4) NOT NULL,
  PRIMARY KEY (`yr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `in_gross` varchar(30) DEFAULT NULL,
  `in_hascogs` int(1) DEFAULT NULL,
  `in_cogs` varchar(30) DEFAULT NULL,
  `in_0` varchar(30) DEFAULT NULL,
  `in_1` varchar(30) DEFAULT NULL,
  `in_2` varchar(30) DEFAULT NULL,
  `in_3` varchar(30) DEFAULT NULL,
  `oh_0` varchar(30) DEFAULT NULL,
  `oh_1` varchar(30) DEFAULT NULL,
  `oh_2` varchar(30) DEFAULT NULL,
  `oh_3` varchar(30) DEFAULT NULL,
  `oh_4` varchar(30) DEFAULT NULL,
  `oh_5` varchar(30) DEFAULT NULL,
  `oh_6` varchar(30) DEFAULT NULL,
  `oh_7` varchar(30) DEFAULT NULL,
  `oh_8` varchar(30) DEFAULT NULL,
  `la_0` varchar(30) DEFAULT NULL,
  `la_1` varchar(30) DEFAULT NULL,
  `la_2` varchar(30) DEFAULT NULL,
  `la_3` varchar(30) DEFAULT NULL,
  `la_4` varchar(30) DEFAULT NULL,
  `la_5` varchar(30) DEFAULT NULL,
  `la_6` varchar(30) DEFAULT NULL,
  `la_7` varchar(30) DEFAULT NULL,
  `op_0` varchar(30) DEFAULT NULL,
  `op_1` varchar(30) DEFAULT NULL,
  `op_2` varchar(30) DEFAULT NULL,
  `op_3` varchar(30) DEFAULT NULL,
  `op_4` varchar(30) DEFAULT NULL,
  `op_5` varchar(30) DEFAULT NULL,
  `op_6` varchar(30) DEFAULT NULL,
  `op_7` varchar(30) DEFAULT NULL,
  `op_8` varchar(30) DEFAULT NULL,
  `op_9` varchar(30) DEFAULT NULL,
  `op_10` varchar(30) DEFAULT NULL,
  `op_11` varchar(30) DEFAULT NULL,
  `op_12` varchar(30) DEFAULT NULL,
  `op_13` varchar(30) DEFAULT NULL,
  `op_14` varchar(30) DEFAULT NULL,
  `op_15` varchar(30) DEFAULT NULL,
  `op_16` varchar(30) DEFAULT NULL,
  `op_17` varchar(30) DEFAULT NULL,
  `op_18` varchar(30) DEFAULT NULL,
  `op_19` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `client`
--

CREATE TABLE IF NOT EXISTS `client` (
  `cli_type` int(1) DEFAULT NULL,
  `cli_sortname` varchar(40) NOT NULL DEFAULT '',
  `cli_filename` varchar(24) DEFAULT NULL,
  `cli_mailname1` varchar(40) DEFAULT NULL,
  `cli_mailname2` varchar(40) DEFAULT NULL,
  `cli_str1` varchar(30) DEFAULT NULL,
  `cli_str2` varchar(30) DEFAULT NULL,
  `cli_city` varchar(30) DEFAULT NULL,
  `cli_state` char(2) DEFAULT NULL,
  `cli_zipc` varchar(10) DEFAULT NULL,
  `cli_salute` varchar(50) DEFAULT NULL,
  `cli_fye` int(2) DEFAULT '12',
  `cli_freq` int(2) DEFAULT NULL,
  `cli_active` int(1) DEFAULT NULL,
  PRIMARY KEY (`cli_sortname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `c_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `c_type` tinyint(1) NOT NULL DEFAULT '0',
  `c_descrip` varchar(50) NOT NULL,
  `c_details` varchar(255) NOT NULL,
  `c_comments` varchar(200) NOT NULL,
  `c_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`c_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `depreciation`
--

CREATE TABLE IF NOT EXISTS `depreciation` (
  `depr_id` int(11) NOT NULL AUTO_INCREMENT,
  `depr_yr` char(4) DEFAULT NULL,
  `depr_mos` int(2) DEFAULT '12',
  `depr_irs_depr` decimal(12,2) DEFAULT '0.00',
  PRIMARY KEY (`depr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `fixed_assets`
--

CREATE TABLE IF NOT EXISTS `fixed_assets` (
  `fa_id` int(11) NOT NULL AUTO_INCREMENT,
  `fa_per` int(11) DEFAULT NULL,
  `fa_date` date DEFAULT NULL,
  `fa_caption` varchar(35) NOT NULL,
  `fa_mos` int(2) DEFAULT '0',
  `fa_cost` decimal(12,2) DEFAULT '0.00',
  `fa_financed` decimal(12,2) DEFAULT '0.00',
  `fa_monthly` decimal(12,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`fa_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `journal`
--

CREATE TABLE IF NOT EXISTS `journal` (
  `jrnl_id` int(11) NOT NULL AUTO_INCREMENT,
  `jrnl_per` int(11) DEFAULT NULL,
  `jrnl_in_gross` decimal(12,2) DEFAULT '0.00',
  `jrnl_in_cogs` decimal(12,2) DEFAULT '0.00',
  `jrnl_in_0` decimal(12,2) DEFAULT '0.00',
  `jrnl_in_1` decimal(12,2) DEFAULT '0.00',
  `jrnl_in_2` decimal(12,2) DEFAULT '0.00',
  `jrnl_in_3` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_0` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_1` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_2` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_3` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_4` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_5` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_6` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_7` decimal(12,2) DEFAULT '0.00',
  `jrnl_oh_8` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_0` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_1` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_2` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_3` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_4` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_5` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_6` decimal(12,2) DEFAULT '0.00',
  `jrnl_la_7` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_0` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_1` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_2` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_3` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_4` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_5` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_6` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_7` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_8` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_9` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_10` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_11` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_12` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_13` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_14` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_15` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_16` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_17` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_18` decimal(12,2) DEFAULT '0.00',
  `jrnl_op_19` decimal(12,2) DEFAULT '0.00',
  PRIMARY KEY (`jrnl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `notes_client`
--

CREATE TABLE IF NOT EXISTS `notes_client` (
  `cnot_id` int(11) NOT NULL AUTO_INCREMENT,
  `cnot_per` int(11) DEFAULT NULL,
  `cnot_note` text,
  PRIMARY KEY (`cnot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `notes_internal`
--

CREATE TABLE IF NOT EXISTS `notes_internal` (
  `inot_id` int(11) NOT NULL AUTO_INCREMENT,
  `inot_note` text,
  `inot_active` int(1) DEFAULT '1',
  PRIMARY KEY (`inot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `periods`
--

CREATE TABLE IF NOT EXISTS `periods` (
  `per_id` int(11) NOT NULL AUTO_INCREMENT,
  `per_per` varchar(25) NOT NULL,
  `per_yr` char(4) NOT NULL,
  `per_mos` int(2) NOT NULL DEFAULT '1',
  `per_created` datetime DEFAULT NULL,
  `per_statements` datetime DEFAULT NULL,
  `per_locked` int(1) NOT NULL DEFAULT '0',
  `per_current` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`per_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tracker`
--

CREATE TABLE IF NOT EXISTS `tracker` (
  `trkr_id` int(11) NOT NULL AUTO_INCREMENT,
  `trkr_caption` varchar(50) DEFAULT NULL,
  `trkr_target` decimal(12,2) DEFAULT '0.00',
  `trkr_active` int(1) DEFAULT NULL,
  PRIMARY KEY (`trkr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tracking`
--

CREATE TABLE IF NOT EXISTS `tracking` (
  `trkg_id` int(11) NOT NULL AUTO_INCREMENT,
  `trkg_tracker` int(11) DEFAULT NULL,
  `trkg_per` int(11) DEFAULT NULL,
  `trkg_amt` decimal(12,2) DEFAULT '0.00',
  PRIMARY KEY (`trkg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
@ Telegram