Создать клиент - серверное приложение "Учет компьютерной техники на складе"

/*
Navicat MySQL Data Transfer
 
Source Server         : sullen
Source Server Version : 50524
Source Host           : localhost:3306
Source Database       : sklad
 
Target Server Type    : MYSQL
Target Server Version : 50524
File Encoding         : 65001
 
Date: 2012-11-14 11:42:23
*/
 
SET FOREIGN_KEY_CHECKS=0;
 
-- ----------------------------
-- Table structure for `buyer`
-- ----------------------------
DROP TABLE IF EXISTS `buyer`;
CREATE TABLE `buyer` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `fio` CHAR(100) DEFAULT NULL,
  `pasport` CHAR(100) DEFAULT NULL,
  `discount` INT(100) DEFAULT NULL,
  `product` INT(100) DEFAULT NULL,
  `served` INT(100) DEFAULT NULL,
  `date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of buyer
-- ----------------------------
INSERT INTO `buyer` VALUES ('1', 'Вася петечкин', '354512 Дания', '1', '10', '100', '0000-00-00 00:00:00');
 
-- ----------------------------
-- Table structure for `discount`
-- ----------------------------
DROP TABLE IF EXISTS `discount`;
CREATE TABLE `discount` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `percent` SET('10%','5%') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of discount
-- ----------------------------
INSERT INTO `discount` VALUES ('1', '5%');
INSERT INTO `discount` VALUES ('2', '10%');
 
-- ----------------------------
-- Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `type` CHAR(100) DEFAULT NULL,
  `maker` CHAR(100) DEFAULT NULL,
  `model` CHAR(100) DEFAULT NULL,
  `features` CHAR(255) DEFAULT NULL,
  `availability` SET('Нет','Да') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES ('10', 'Мышка', 'Logitech', 'L-30', 'Лазерная', 'Нет,Да');
 
-- ----------------------------
-- Table structure for `seller`
-- ----------------------------
DROP TABLE IF EXISTS `seller`;
CREATE TABLE `seller` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `fio` CHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of seller
-- ----------------------------
INSERT INTO `seller` VALUES ('100', 'Петр Первый');