Login   Register  
PHP Classes

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


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` (