From 0959cfb46cf9825a608a01189a3d1a386b670da7 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Sat, 2 Oct 2004 02:10:51 +0000 Subject: [PATCH] Fix SQL syntax errors --- maintenance/archives/patch-userlevels.sql | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/maintenance/archives/patch-userlevels.sql b/maintenance/archives/patch-userlevels.sql index 98133e984b..c21f78c61e 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) +); -- 2.20.1