diff options
| author | Brion Vibber <brion@users.mediawiki.org> | 2004-10-02 02:10:51 +0000 |
|---|---|---|
| committer | Brion Vibber <brion@users.mediawiki.org> | 2004-10-02 02:10:51 +0000 |
| commit | 0959cfb46cf9825a608a01189a3d1a386b670da7 (patch) | |
| tree | b12f37afe72ba0933b4887db371f8dd8371690f4 | |
| parent | bbc1ac7f049d78c477629a9751623ab9e1f89674 (diff) | |
| download | mediawikicore-0959cfb46cf9825a608a01189a3d1a386b670da7.tar.gz mediawikicore-0959cfb46cf9825a608a01189a3d1a386b670da7.zip | |
Fix SQL syntax errors
Notes
Notes:
http://mediawiki.org/wiki/Special:Code/MediaWiki/5627
| -rw-r--r-- | maintenance/archives/patch-userlevels.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/maintenance/archives/patch-userlevels.sql b/maintenance/archives/patch-userlevels.sql index 98133e984bae..c21f78c61ed0 100644 --- a/maintenance/archives/patch-userlevels.sql +++ b/maintenance/archives/patch-userlevels.sql @@ -5,15 +5,15 @@ -- Hold group name and description CREATE TABLE `group` ( - `group_id` int(5) unsigned NOT NULL auto_increment, - `group_name` varchar(50) NOT NULL default '', - `group_description` varchar(255) NOT NULL default '', - PRIMARY KEY (`group_id`) -) + group_id int(5) unsigned NOT NULL auto_increment, + group_name varchar(50) NOT NULL default '', + group_description varchar(255) NOT NULL default '', + PRIMARY KEY (group_id) +); -- Relation table between user and groups -CREATE TABLE `user_groups` ( - user_id` int(5) unsigned NOT NULL default '0', - group_id` int(5) unsigned NOT NULL default '0', - PRIMARY KEY (`user_id`,`group_id`) -) +CREATE TABLE user_groups ( + user_id int(5) unsigned NOT NULL default '0', + group_id int(5) unsigned NOT NULL default '0', + PRIMARY KEY (user_id,group_id) +); |