Changeset 11380

Show
Ignore:
Timestamp:
07/28/07 13:02:29 (1 year ago)
Author:
piotras
Message:

Added locked ( as int ) and author ( legacy stuff :/ ) to repligard table.
Removed metadata columns.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/midgard/data/midgard/empty.sql

    r11378 r11380  
    324324  action enum('create','update','delete') NOT NULL default 'create', 
    325325  sitegroup int(11) NOT NULL default '0', 
    326   creator varchar(80) NOT NULL default '', 
    327   created datetime NOT NULL default '0000-00-00 00:00:00', 
    328   revisor varchar(80) NOT NULL default '', 
    329   revised datetime NOT NULL default '0000-00-00 00:00:00', 
    330326  revision int(11) NOT NULL default '0', 
    331327  locker varchar(80) NOT NULL default '', 
    332   locked datetime NOT NULL default '0000-00-00 00:00:00', 
    333   approver varchar(80) NOT NULL default '', 
    334   approved datetime NOT NULL default '0000-00-00 00:00:00', 
     328  locked int(11) NOT NULL default '0', 
     329  author int(11) NOT NULL default '0'), 
    335330  typename varchar(80) NOT NULL default '', 
    336   metadata_creator varchar(80) NOT NULL default '', 
    337   metadata_created datetime NOT NULL default '0000-00-00 00:00:00', 
    338   metadata_revisor varchar(80) NOT NULL default '', 
    339   metadata_revised datetime NOT NULL default '0000-00-00 00:00:00', 
    340   metadata_revision int(11) NOT NULL default '0', 
    341   metadata_approver varchar(80) NOT NULL default '', 
    342   metadata_approved datetime NOT NULL default '0000-00-00 00:00:00', 
    343   metadata_locker varchar(80) NOT NULL default '', 
    344   metadata_locked datetime NOT NULL default '0000-00-00 00:00:00', 
    345331  PRIMARY KEY (guid), 
    346332  KEY realm(realm,id)