 -- phpMyAdmin SQL Dump
 -- version 3.2.5
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: Feb 26, 2011 at 12:39 PM
--- Server version: 5.1.44
--- PHP Version: 5.3.2
 
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 

-- Database: `sjamayee_demo`
--
-- --------------------------------------------------------

--
-- Table structure for table `sja_sequences`
--

--DROP TABLE IF EXISTS `sja_sequences`;
CREATE TABLE `sja_sequences` (
  `value` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence',
  PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sja_texts`
--

--DROP TABLE IF EXISTS `sja_texts`;
CREATE TABLE `sja_texts` (
  `id` varchar(255) NOT NULL COMMENT 'Primary ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `version` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Version',
  `nid` varchar(255) DEFAULT NULL COMMENT 'Next ID',
  `pid` varchar(255) DEFAULT NULL COMMENT 'Previous ID',
  `par` char(8) NOT NULL DEFAULT '' COMMENT 'Paragraph',
  `seq` float NOT NULL DEFAULT '0' COMMENT 'Sequence',
  `text` longtext NOT NULL COMMENT 'Text',
  `cbi` varchar(255) NOT NULL COMMENT 'Created by ID',
  `cat` datetime NOT NULL COMMENT 'Created at',
  `mbi` varchar(255) NOT NULL COMMENT 'Modified by ID',
  `mat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Modified at',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sjamayee texts';

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

--
-- Table structure for table `sja_types`
--

--DROP TABLE IF EXISTS `sja_types`;
CREATE TABLE `sja_types` (
  `id` varchar(255) NOT NULL COMMENT 'Primary ID',
  `type` varchar(32) NOT NULL COMMENT 'Type',
  `code` char(4) NOT NULL COMMENT 'Code',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `version` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Version',
  `description` mediumtext COMMENT 'Description',
  `in_use` char(1) NOT NULL DEFAULT 'Y' COMMENT 'In use',
  `object` varchar(255) DEFAULT NULL COMMENT 'Object',
  `txi` varchar(255) DEFAULT NULL COMMENT 'Text ID',
  `cbi` varchar(255) NOT NULL COMMENT 'Created by ID',
  `cat` datetime NOT NULL COMMENT 'Created at',
  `mbi` varchar(255) NOT NULL COMMENT 'Modified by ID',
  `mat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Modified at',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sjamayee types';


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

--
-- Table structure for table `sja_model_attributes`
--

--DROP TABLE IF EXISTS `sja_model_attributes`;
CREATE TABLE `sja_model_attributes` (
  `id` varchar(255) NOT NULL COMMENT 'Primary ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `version` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Version',
  `eid` varchar(255) NOT NULL COMMENT 'Entity ID',
  `default_value` varchar(255) DEFAULT NULL COMMENT 'Default value',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',

  `type` varchar(32) NOT NULL DEFAULT 'Text' COMMENT 'Type',
  `unique` char(1) NOT NULL DEFAULT 'N' COMMENT 'Unique',
  `cbi` varchar(255) NOT NULL COMMENT 'Created by ID',
  `cat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at',
  `mbi` varchar(255) NOT NULL COMMENT 'Modified by ID',
  `mat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Modified at',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sjamayee attributes';
