All pastes #477402 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-05-08 17:05 UTC
rendered paste body
SQL query:

phpMyAdmin SQL Dump-- version 2.10.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 08, 2007 at 10:04 AM
-- Server version: 5.0.38
-- PHP Version: 5.2.1-pl3-gentoo
-- 
-- Database: `egroupware`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `phpgw_kb_articles`
-- 
CREATE TABLE IF NOT EXISTS `phpgw_kb_articles` (
`art_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`q_id` bigint( 20 ) NOT NULL default '0',
`title` varchar( 255 ) NOT NULL ,
`topic` varchar( 255 ) NOT NULL ,
`text` text NOT NULL ,
`cat_id` int( 11 ) NOT NULL default '0',
`published` smallint( 6 ) NOT NULL default '0',
`user_id` int( 11 ) NOT NULL default '0',
`views` int( 11 ) NOT NULL default '0',
`created` int( 11 ) default NULL ,
`modified` int( 11 ) default NULL ,
`modified_user_id` int( 11 ) NOT NULL default '0',
`votes_1` int( 11 ) NOT NULL default '0',
`votes_2` int( 11 ) NOT NULL default '0',
`votes_3` int( 11 ) NOT NULL default '0',
`votes_4` int( 11 ) NOT NULL default '0',
`votes_5` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `art_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =148;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump

CREATE TABLE IF NOT EXISTS `phpgw_kb_articles` (
' at line 1