 -- Table structure for table `pictures`
 --
 
-DROP TABLE IF EXISTS `pictures`;
-CREATE TABLE IF NOT EXISTS `pictures` (
-  `pic_id` int(11) NOT NULL AUTO_INCREMENT,
+CREATE TABLE `pictures` (
+  `pic_id` int(11) NOT NULL,
   `pic_path` text NOT NULL,
-  `client_id` int(11) NOT NULL,
-  PRIMARY KEY (`pic_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+  `client_id` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --
 -- Dumping data for table `pictures`

-- Table structure for table `privmsgs`
--

DROP TABLE IF EXISTS `privmsgs`;
CREATE TABLE IF NOT EXISTS `privmsgs` (
  `privmsg_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `privmsg_author` bigint(20) NOT NULL,
  `from_name` varchar(50) NOT NULL,
  `privmsg_date` varchar(20) NOT NULL,

-- Table structure for table `client_type`
--

CREATE TABLE `client_type` (
  `cl_type_id` int(11) NOT NULL,
  `cl_type_desc` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_type`
