diff options
| author | Christian Fowler <spider@viovio.com> | 2006-02-15 23:10:10 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2006-02-15 23:10:10 +0000 |
| commit | 76f05c69088c83e704f0190215a3ec41c2b48440 (patch) | |
| tree | 8deb271b2a9193b8d0a2f40ee03b6e5d395d4365 | |
| parent | 3a37cfb8e10aea679b6a67cd3fdcb0bba17da28d (diff) | |
| download | liberty-76f05c69088c83e704f0190215a3ec41c2b48440.tar.gz liberty-76f05c69088c83e704f0190215a3ec41c2b48440.tar.bz2 liberty-76f05c69088c83e704f0190215a3ec41c2b48440.zip | |
add backticks for reserved column names in schema_inc's
| -rw-r--r-- | admin/schema_inc.php | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 6f1aa85..21cf137 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -11,16 +11,6 @@ $tables = array( maintainer_url C(250) ", -'liberty_copyrights' => " - copyright_id I4 AUTO PRIMARY, - page_id I4 NOTNULL, - title C(200), - year I8, - authors C(200), - copyright_order I8, - user_id I4 -", - 'liberty_content_types' => " content_type_guid C(16) PRIMARY, content_description C(250) NOTNULL, @@ -59,11 +49,21 @@ $tables = array( description C(200), user_id C(40), ip C(15), - comment C(200), + `comment` C(200), data X CONSTRAINT ', CONSTRAINT `liberty_history_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` )' ", +'liberty_copyrights' => " + copyright_id I4 AUTO PRIMARY, + page_id I4 NOTNULL, + title C(200), + year I8, + authors C(200), + copyright_order I8, + user_id I4 +", + 'liberty_content_links' => " from_content_id I4 PRIMARY, to_content_id I4 PRIMARY @@ -118,7 +118,7 @@ $tables = array( file_id I4 PRIMARY, user_id I4 NOTNULL, storage_path C(250), - size I4, + `size` I4, mime_type C(64) ", @@ -126,7 +126,7 @@ $tables = array( structure_id I4 AUTO PRIMARY, root_structure_id I4 NOTNULL, content_id I4 NOTNULL, - level I1 NOTNULL DEFAULT 1, + `level` I1 NOTNULL DEFAULT 1, pos I4, page_alias C(240), parent_id I4 |