diff options
| author | Lester Caine <lester@lsces.co.uk> | 2006-02-08 20:18:31 +0000 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2006-02-08 20:18:31 +0000 |
| commit | 976c26d1e099a732b8501801be50d9f714479995 (patch) | |
| tree | b700006c1fb1cffa942811f47a1c905a5bd31e3b /admin/schema_inc.php | |
| parent | 9ece3e307ad41a8fe3904b832275041ff9b1c04a (diff) | |
| download | liberty-976c26d1e099a732b8501801be50d9f714479995.tar.gz liberty-976c26d1e099a732b8501801be50d9f714479995.tar.bz2 liberty-976c26d1e099a732b8501801be50d9f714479995.zip | |
Add source_id and group_id
source_id will flag the original version of a multiple translation set of a content item
group_id will provide a simple group filter function.
Content can only be displayed if user is a member of the group
Diffstat (limited to 'admin/schema_inc.php')
| -rw-r--r-- | admin/schema_inc.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 4ea8335..5e204d3 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -43,12 +43,15 @@ $tables = array( event_time I8 NOTNULL DEFAULT 0, version I4, lang_code C(32), + source_id I4 NOTNULL, + group_id I4 NOTNULL DEFAULT -1, title C(160), ip C(39), data X CONSTRAINT ' , CONSTRAINT `liberty_content_type_ref` FOREIGN KEY (`content_type_guid`) REFERENCES `".BIT_DB_PREFIX."liberty_content_types`( `content_type_guid` ) , CONSTRAINT `liberty_content_guid_ref` FOREIGN KEY (`format_guid`) REFERENCES `".BIT_DB_PREFIX."liberty_plugins`( `plugin_guid` )' + , CONSTRAINT `liberty_content_group_id` FOREIGN KEY (`group_id`) REFERENCES `".BIT_DB_PREFIX."users_groups`( `group_id` )' ", 'liberty_content_history' => " |