PHP Classes
elePHPant
Icontem

File: libVersionControl.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Cornelius Bolten  >  Version Control  >  libVersionControl.sql  >  Download  
File: libVersionControl.sql
Role: Configuration script
Content type: text/plain
Description: needed Table-sql-script
Class: Version Control
Managing revisions of content articles
Author: By
Last change: new column "vc_content_changes" added
Date: 10 years ago
Size: 1,061 bytes
 

Contents

Class file image Download
#
# $RCSfile: libVersionControl.sql,v $
# @author $Author: Cornelius Bolten $
# @version $Revision: 1.3 $
#
# @description:
# sql-setup-script for libVersionControl
#

CREATE TABLE `libVersionControl` (
        `vc_id` int(10) NOT NULL auto_increment,
        `vc_content_id` int(5) NOT NULL default '0',
        `vc_content_table` varchar(50) NOT NULL default '',
        `vc_content_version` int(5) NOT NULL default '0',
        `vc_content_editor` int(5) NOT NULL default '0',
        `vc_content_date` varchar(15) NOT NULL default '',
        `vc_content_data` longtext NOT NULL,
        `vc_content_hash` varchar(32) NOT NULL default '',
        `vc_content_changes` longtext,

        PRIMARY KEY (`vc_id`),
        UNIQUE KEY `vc_content_id` (
                `vc_content_id`,
                `vc_content_table`,
                `vc_content_version`,
                `vc_content_hash`
        )
) TYPE=MyISAM COMMENT='VersionControl-Table' AUTO_INCREMENT=1 ;