summaryrefslogtreecommitdiff
path: root/admin
diff options
context:
space:
mode:
authorspiderr <spider@viovio.com>2011-02-27 20:53:08 -0500
committerspiderr <spider@viovio.com>2011-02-27 20:53:08 -0500
commite201fe972450cd316a075bed7f5b9a9ea2115edc (patch)
tree5cebf8761e9aa731a30d18b46bf56ebf9eb963ae /admin
parentbc89bd6a60c2509b6eea0ae8ed0460e8c18899b3 (diff)
downloadwiki-e201fe972450cd316a075bed7f5b9a9ea2115edc.tar.gz
wiki-e201fe972450cd316a075bed7f5b9a9ea2115edc.tar.bz2
wiki-e201fe972450cd316a075bed7f5b9a9ea2115edc.zip
add CONSTRAINTS
Diffstat (limited to 'admin')
-rw-r--r--admin/schema_inc.php2
1 files changed, 2 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php
index 2ff7a00..752efc7 100644
--- a/admin/schema_inc.php
+++ b/admin/schema_inc.php
@@ -8,12 +8,14 @@ $tables = array(
wiki_page_size I4 DEFAULT 0,
edit_comment C(200),
flag C(1)
+ CONSTRAINT ', CONSTRAINT `wiki_pages_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` )'
",
'wiki_footnotes' => "
user_id I4 PRIMARY,
page_id I4 NOTNULL,
data X
+ CONSTRAINT ', CONSTRAINT `wiki_footnotes_page_ref` FOREIGN KEY (`page_id`) REFERENCES `".BIT_DB_PREFIX."wiki_pages`( `page_id` )'
",
);