Login   Register  
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: 2004-03-08 02:02
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 ;