3
-- Host: localhost Database: kugardb
4
---------------------------------------------------------
5
-- Server version 4.1.0-alpha-max-nt
8
-- Table structure for table 'salers'
11
DROP TABLE IF EXISTS salers;
13
name varchar(100) NOT NULL default '',
14
NumSaler int(10) unsigned NOT NULL auto_increment,
15
PRIMARY KEY (NumSaler)
19
-- Dumping data for table 'salers'
22
/*!40000 ALTER TABLE salers DISABLE KEYS */;
23
LOCK TABLES salers WRITE;
24
INSERT INTO salers VALUES ('Red Hat',1),('Sun',2),('Microsoft',3),('Mandrake',4),('Suse',5);
26
/*!40000 ALTER TABLE salers ENABLE KEYS */;
29
-- Table structure for table 'software'
32
DROP TABLE IF EXISTS software;
33
CREATE TABLE software (
34
NumSoftware int(10) unsigned NOT NULL auto_increment,
35
NumSaler int(11) NOT NULL default '0',
36
title varchar(100) NOT NULL default '',
37
version varchar(10) NOT NULL default '',
38
platform varchar(100) NOT NULL default '',
39
copies int(11) NOT NULL default '0',
40
PRIMARY KEY (NumSoftware)
44
-- Dumping data for table 'software'
47
/*!40000 ALTER TABLE software DISABLE KEYS */;
48
LOCK TABLES software WRITE;
49
INSERT INTO software VALUES (1,1,'Red hat linux','5.0','x86',1),(2,4,'Mandrake linux','9.1','x86',2),(3,4,'Mandrake linux','9.0','x86',3);
51
/*!40000 ALTER TABLE software ENABLE KEYS */;