From c952071e9beb0124360b65b127ab571dd8d9f970 Mon Sep 17 00:00:00 2001 From: Christopher Vogt Date: Mon, 23 Dec 2013 08:11:12 +0100 Subject: Initial code example --- .gitignore | 11 + README.md | 3 + project/Build.scala | 37 +++ project/build.properties | 1 + project/plugins.sbt | 1 + src/main/scala/Example.scala | 22 ++ src/main/sql/create.sql | 622 +++++++++++++++++++++++++++++++++++++++++++ 7 files changed, 697 insertions(+) create mode 100644 .gitignore create mode 100755 README.md create mode 100644 project/Build.scala create mode 100644 project/build.properties create mode 100644 project/plugins.sbt create mode 100644 src/main/scala/Example.scala create mode 100644 src/main/sql/create.sql diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..110ccb5 --- /dev/null +++ b/.gitignore @@ -0,0 +1,11 @@ +/.idea/ +*~ +target/ +*.log +*.iml +/\.target/ +/\.cache +/\.project +/\.classpath +/.settings/org.scala-ide.sdt.core.prefs + diff --git a/README.md b/README.md new file mode 100755 index 0000000..1e542c2 --- /dev/null +++ b/README.md @@ -0,0 +1,3 @@ +This code example shows how to setup sbt to use Slick's preconfigued code-generator for working with an existing database schema. `project/Build.scala` enables automatically as well as manually triggered code-generation. `src/main/scala/Example.scala` uses the generated code. The code is generated into file `target/scala-2.10/src_managed/slick/demo/Tables.scala`. The location can be changed in the sbt script. It is usally wise to keep the generated Slick code under version control. + +Use `sbt run` to run the demo. \ No newline at end of file diff --git a/project/Build.scala b/project/Build.scala new file mode 100644 index 0000000..ec7f527 --- /dev/null +++ b/project/Build.scala @@ -0,0 +1,37 @@ +import sbt._ +import Keys._ +import Tests._ + +/** + * This is a simple sbt setup generating Slick code from the given + * database before compiling the projects code. + */ +object myBuild extends Build { + lazy val mainProject = Project( + id="main", + base=file("."), + settings = Project.defaultSettings ++ Seq( + scalaVersion := "2.10.3", + libraryDependencies ++= List( + "com.typesafe.slick" %% "slick" % "2.0.0-RC1", + "org.slf4j" % "slf4j-nop" % "1.6.4", + "com.h2database" % "h2" % "1.3.166" + ), + slick <<= slickCodeGenTask, // register manual sbt command + sourceGenerators in Compile <+= slickCodeGenTask // register automatic code generation on every compile, remove for only manual use + ) + ) + + // code generation task + lazy val slick = TaskKey[Seq[File]]("gen-tables") + lazy val slickCodeGenTask = (sourceManaged, dependencyClasspath in Compile, runner in Compile, streams) map { (dir, cp, r, s) => + val outputDir = (dir / "slick").getPath // place generated files in sbt's managed sources folder + val url = "jdbc:h2:mem:test;INIT=runscript from 'src/main/sql/create.sql'" // connection info for a pre-populated throw-away, in-memory db for this demo, which is freshly initialized on every run + val jdbcDriver = "org.h2.Driver" + val slickDriver = "scala.slick.driver.H2Driver" + val pkg = "demo" + toError(r.run("scala.slick.model.codegen.SourceCodeGenerator", cp.files, Array(slickDriver, jdbcDriver, url, outputDir, pkg), s.log)) + val fname = outputDir + "/demo/Tables.scala" + Seq(file(fname)) + } +} \ No newline at end of file diff --git a/project/build.properties b/project/build.properties new file mode 100644 index 0000000..0974fce --- /dev/null +++ b/project/build.properties @@ -0,0 +1 @@ +sbt.version=0.13.0 diff --git a/project/plugins.sbt b/project/plugins.sbt new file mode 100644 index 0000000..0b28604 --- /dev/null +++ b/project/plugins.sbt @@ -0,0 +1 @@ +addSbtPlugin("com.typesafe.sbteclipse" % "sbteclipse-plugin" % "2.2.0") diff --git a/src/main/scala/Example.scala b/src/main/scala/Example.scala new file mode 100644 index 0000000..85a6ed3 --- /dev/null +++ b/src/main/scala/Example.scala @@ -0,0 +1,22 @@ +object Tables extends demo.Tables{ // or just use object demo.Tables, which is hard-wired to the driver stated during generation + val profile = scala.slick.driver.H2Driver +} +import Tables._ +import Tables.profile.simple._ + +object Example extends App { + // connection info for a pre-populated throw-away, in-memory db for this demo, which is freshly initialized on every run + val url = "jdbc:h2:mem:test;INIT=runscript from 'src/main/sql/create.sql'" + val db = Database.forURL(url, driver = "org.h2.Driver") + + // Using generated code. Our Build.sbt makes sure they are generated before compilation. + val q = Companies.join(Computers).on(_.id === _.manufacturerId) + .map{ case (co,cp) => (co.name, cp.name) } + + db.withTransaction { implicit session => + println( q.run.groupBy{ case (co,cp) => co } + .mapValues(_.map{ case (co,cp) => cp }) + .mkString("\n") + ) + } +} diff --git a/src/main/sql/create.sql b/src/main/sql/create.sql new file mode 100644 index 0000000..27d5034 --- /dev/null +++ b/src/main/sql/create.sql @@ -0,0 +1,622 @@ +create table "COMPUTERS" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL,"MANUFACTURER_ID" INTEGER NOT NULL); +create table "COMPANIES" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL); + + +insert into "COMPANIES" values (1,'Apple Inc.'); +insert into "COMPANIES" values (2,'Thinking Machines'); +insert into "COMPANIES" values (3,'RCA'); +insert into "COMPANIES" values (4,'Netronics'); +insert into "COMPANIES" values (5,'Tandy Corporation'); +insert into "COMPANIES" values (6,'Commodore International'); +insert into "COMPANIES" values (7,'MOS Technology'); +insert into "COMPANIES" values (8,'Micro Instrumentation and Telemetry Systems'); +insert into "COMPANIES" values (9,'IMS Associates, Inc.'); +insert into "COMPANIES" values (10,'Digital Equipment Corporation'); +insert into "COMPANIES" values (11,'Lincoln Laboratory'); +insert into "COMPANIES" values (12,'Moore School of Electrical Engineering'); +insert into "COMPANIES" values (13,'IBM'); +insert into "COMPANIES" values (14,'Amiga Corporation'); +insert into "COMPANIES" values (15,'Canon'); +insert into "COMPANIES" values (16,'Nokia'); +insert into "COMPANIES" values (17,'Sony'); +insert into "COMPANIES" values (18,'OQO'); +insert into "COMPANIES" values (19,'NeXT'); +insert into "COMPANIES" values (20,'Atari'); +insert into "COMPANIES" values (22,'Acorn ComputersRow'); +insert into "COMPANIES" values (23,'Timex Sinclair'); +insert into "COMPANIES" values (24,'Nintendo'); +insert into "COMPANIES" values (25,'Sinclair Research Ltd'); +insert into "COMPANIES" values (26,'Xerox'); +insert into "COMPANIES" values (27,'Hewlett-Packard'); +insert into "COMPANIES" values (28,'Zemmix'); +insert into "COMPANIES" values (29,'ACVS'); +insert into "COMPANIES" values (30,'Sanyo'); +insert into "COMPANIES" values (31,'Cray'); +insert into "COMPANIES" values (32,'Evans & Sutherland'); +insert into "COMPANIES" values (33,'E.S.R. Inc.'); +insert into "COMPANIES" values (34,'OMRON'); +insert into "COMPANIES" values (35,'BBN Technologies'); +insert into "COMPANIES" values (36,'Lenovo Group'); +insert into "COMPANIES" values (37,'ASUS'); +insert into "COMPANIES" values (38,'Amstrad'); +insert into "COMPANIES" values (39,'Sun Microsystems'); +insert into "COMPANIES" values (40,'Texas Instruments'); +insert into "COMPANIES" values (41,'HTC Corporation'); +insert into "COMPANIES" values (42,'Research In Motion'); +insert into "COMPANIES" values (43,'Samsung Electronics'); + + +insert into "COMPUTERS" values (1,'MacBook Pro 15.4 inch', 1); +insert into "COMPUTERS" values (2,'CM-2a', 2); +insert into "COMPUTERS" values (3,'CM-200', 2); +insert into "COMPUTERS" values (4,'CM-5e', 2); +insert into "COMPUTERS" values (5,'CM-5', 2); +insert into "COMPUTERS" values (6,'MacBook Pro', 1); +insert into "COMPUTERS" values (7,'Apple IIe', 1); +insert into "COMPUTERS" values (8,'Apple IIc', 1); +insert into "COMPUTERS" values (9,'Apple IIGS', 1); +insert into "COMPUTERS" values (10,'Apple IIc Plus', 1); +insert into "COMPUTERS" values (11,'Apple II Plus', 1); +insert into "COMPUTERS" values (12,'Apple III', 1); +insert into "COMPUTERS" values (13,'Apple Lisa', 1); +insert into "COMPUTERS" values (14,'CM-2', 2); +insert into "COMPUTERS" values (15,'Connection Machine', 2); +insert into "COMPUTERS" values (16,'Apple II', 1); +insert into "COMPUTERS" values (17,'Apple III Plus', 1); +insert into "COMPUTERS" values (18,'COSMAC ELF', 3); +insert into "COMPUTERS" values (19,'COSMAC VIP', 3); +insert into "COMPUTERS" values (20,'ELF II', 4); +insert into "COMPUTERS" values (21,'Macintosh', 1); +insert into "COMPUTERS" values (22,'Macintosh II', 0); +insert into "COMPUTERS" values (23,'Macintosh Plus', 1); +insert into "COMPUTERS" values (24,'Macintosh IIfx', 0); +insert into "COMPUTERS" values (25,'iMac', 1); +insert into "COMPUTERS" values (26,'Mac Mini', 1); +insert into "COMPUTERS" values (27,'Mac Pro', 1); +insert into "COMPUTERS" values (28,'Power Macintosh', 1); +insert into "COMPUTERS" values (29,'PowerBook', 1); +insert into "COMPUTERS" values (30,'Xserve', 0); +insert into "COMPUTERS" values (31,'Powerbook 100', 0); +insert into "COMPUTERS" values (32,'Powerbook 140', 0); +insert into "COMPUTERS" values (33,'Powerbook 170', 0); +insert into "COMPUTERS" values (34,'PowerBook Duo', 0); +insert into "COMPUTERS" values (35,'PowerBook 190', 0); +insert into "COMPUTERS" values (36,'Macintosh Quadra', 1); +insert into "COMPUTERS" values (37,'Macintosh Quadra 900', 0); +insert into "COMPUTERS" values (38,'Macintosh Quadra 700', 0); +insert into "COMPUTERS" values (39,'Macintosh LC', 1); +insert into "COMPUTERS" values (40,'Macintosh LC II', 1); +insert into "COMPUTERS" values (41,'Macintosh LC III', 1); +insert into "COMPUTERS" values (42,'Macintosh LC III+', 0); +insert into "COMPUTERS" values (43,'Macintosh Quadra 605', 1); +insert into "COMPUTERS" values (44,'Macintosh LC 500 series', 0); +insert into "COMPUTERS" values (45,'TRS-80 Color ComputersRow', 5); +insert into "COMPUTERS" values (46,'Acorn System 2', 0); +insert into "COMPUTERS" values (47,'Dragon 32/64', 0); +insert into "COMPUTERS" values (48,'MEK6800D2', 0); +insert into "COMPUTERS" values (49,'Newbear 77/68', 0); +insert into "COMPUTERS" values (50,'Commodore PET', 6); +insert into "COMPUTERS" values (51,'Commodore 64', 6); +insert into "COMPUTERS" values (52,'Commodore 64C', 0); +insert into "COMPUTERS" values (53,'Commodore SX-64', 6); +insert into "COMPUTERS" values (54,'Commodore 128', 6); +insert into "COMPUTERS" values (55,'Apple I', 1); +insert into "COMPUTERS" values (56,'KIM-1', 7); +insert into "COMPUTERS" values (57,'Altair 8800', 8); +insert into "COMPUTERS" values (58,'IMSAI 8080', 9); +insert into "COMPUTERS" values (59,'IMSAI Series Two', 0); +insert into "COMPUTERS" values (60,'VAX', 10); +insert into "COMPUTERS" values (61,'VAX 11/780', 10); +insert into "COMPUTERS" values (62,'VAX 11/750', 10); +insert into "COMPUTERS" values (63,'TX-2', 11); +insert into "COMPUTERS" values (64,'TX-0', 11); +insert into "COMPUTERS" values (65,'Whirlwind', 11); +insert into "COMPUTERS" values (66,'ENIAC', 12); +insert into "COMPUTERS" values (67,'IBM PC', 13); +insert into "COMPUTERS" values (68,'Macintosh Classic', 0); +insert into "COMPUTERS" values (69,'Macintosh Classic II', 1); +insert into "COMPUTERS" values (70,'Amiga', 14); +insert into "COMPUTERS" values (71,'Amiga 1000', 6); +insert into "COMPUTERS" values (72,'Amiga 500', 6); +insert into "COMPUTERS" values (73,'Amiga 500+', 0); +insert into "COMPUTERS" values (74,'Amiga 2000', 6); +insert into "COMPUTERS" values (75,'Amiga 3000', 6); +insert into "COMPUTERS" values (76,'Amiga 600', 6); +insert into "COMPUTERS" values (77,'Macintosh 128K', 1); +insert into "COMPUTERS" values (78,'Macintosh 512K', 1); +insert into "COMPUTERS" values (79,'Macintosh SE', 1); +insert into "COMPUTERS" values (80,'Macintosh SE/30', 1); +insert into "COMPUTERS" values (81,'Canon Cat', 15); +insert into "COMPUTERS" values (82,'Nokia 770', 16); +insert into "COMPUTERS" values (83,'Nokia N800', 16); +insert into "COMPUTERS" values (84,'Mylo', 17); +insert into "COMPUTERS" values (85,'OQO 02', 18); +insert into "COMPUTERS" values (86,'OQO 01+', 0); +insert into "COMPUTERS" values (87,'Pinwheel calculator', 0); +insert into "COMPUTERS" values (88,'iBook', 1); +insert into "COMPUTERS" values (89,'MacBook', 1); +insert into "COMPUTERS" values (90,'NeXTstation', 19); +insert into "COMPUTERS" values (91,'NeXTcube', 19); +insert into "COMPUTERS" values (92,'NeXTstation Color Turbo', 0); +insert into "COMPUTERS" values (93,'NeXTstation Color', 0); +insert into "COMPUTERS" values (94,'NeXTstation Turbo', 0); +insert into "COMPUTERS" values (95,'NeXTcube Turbo', 19); +insert into "COMPUTERS" values (96,'NeXTcube 040', 19); +insert into "COMPUTERS" values (97,'NeXTcube 030', 19); +insert into "COMPUTERS" values (98,'Tinkertoy Tic-Tac-Toe ComputersRow', 0); +insert into "COMPUTERS" values (99,'Z3', 0); +insert into "COMPUTERS" values (100,'Z4', 0); +insert into "COMPUTERS" values (101,'Z1', 0); +insert into "COMPUTERS" values (102,'Z2', 0); +insert into "COMPUTERS" values (103,'Wang 2200', 0); +insert into "COMPUTERS" values (104,'Wang VS', 0); +insert into "COMPUTERS" values (105,'Wang OIS', 0); +insert into "COMPUTERS" values (106,'BBC Micro', 22); +insert into "COMPUTERS" values (107,'IBM 650', 13); +insert into "COMPUTERS" values (108,'Cray-1', 0); +insert into "COMPUTERS" values (109,'Cray-3', 0); +insert into "COMPUTERS" values (110,'Cray-2', 0); +insert into "COMPUTERS" values (111,'Cray-4', 0); +insert into "COMPUTERS" values (112,'Cray X1', 0); +insert into "COMPUTERS" values (113,'Cray XD1', 0); +insert into "COMPUTERS" values (114,'Cray T3D', 0); +insert into "COMPUTERS" values (115,'Cray T3E', 0); +insert into "COMPUTERS" values (116,'Cray C90', 0); +insert into "COMPUTERS" values (117,'Cray T90', 0); +insert into "COMPUTERS" values (118,'Cray SV1', 0); +insert into "COMPUTERS" values (119,'Cray J90', 0); +insert into "COMPUTERS" values (120,'Cray XT3', 0); +insert into "COMPUTERS" values (121,'Cray CS6400', 0); +insert into "COMPUTERS" values (122,'Atari ST', 20); +insert into "COMPUTERS" values (123,'Amiga 2500', 0); +insert into "COMPUTERS" values (124,'Amiga 2500', 6); +insert into "COMPUTERS" values (125,'Amiga 4000', 6); +insert into "COMPUTERS" values (126,'Amiga 3000UX', 6); +insert into "COMPUTERS" values (127,'Amiga 3000T', 6); +insert into "COMPUTERS" values (128,'Amiga 4000T', 6); +insert into "COMPUTERS" values (129,'Amiga 1200', 6); +insert into "COMPUTERS" values (130,'Atari 1040 STf', 0); +insert into "COMPUTERS" values (131,'Atari 520 ST', 0); +insert into "COMPUTERS" values (132,'Atari 520 STfm', 0); +insert into "COMPUTERS" values (133,'Atari 1040 STe', 0); +insert into "COMPUTERS" values (134,'Atari MEGA STe', 0); +insert into "COMPUTERS" values (135,'Atari 520 ST+', 0); +insert into "COMPUTERS" values (136,'Atari 520 STm', 0); +insert into "COMPUTERS" values (137,'Atari 130 ST', 0); +insert into "COMPUTERS" values (138,'Atari 260 ST', 0); +insert into "COMPUTERS" values (139,'Atari MEGA ST', 0); +insert into "COMPUTERS" values (140,'Atari 520 STf', 0); +insert into "COMPUTERS" values (141,'Atari 1040 STfm', 0); +insert into "COMPUTERS" values (142,'Atari 2080 ST', 0); +insert into "COMPUTERS" values (143,'Atari 260 ST+', 0); +insert into "COMPUTERS" values (144,'Atari 4160 STe', 0); +insert into "COMPUTERS" values (145,'TRS-80 Color ComputersRow 2', 0); +insert into "COMPUTERS" values (146,'TRS-80 Color ComputersRow 3', 0); +insert into "COMPUTERS" values (147,'TRS-80 Model 1', 5); +insert into "COMPUTERS" values (148,'Timex Sinclair 2068', 23); +insert into "COMPUTERS" values (149,'ZX Spectrum', 25); +insert into "COMPUTERS" values (150,'Xerox Star', 26); +insert into "COMPUTERS" values (151,'Xerox Alto', 0); +insert into "COMPUTERS" values (152,'Acorn Archimedes', 22); +insert into "COMPUTERS" values (153,'Nintendo Entertainment System', 24); +insert into "COMPUTERS" values (154,'Super Nintendo Entertainment System', 24); +insert into "COMPUTERS" values (155,'Super Famicom', 0); +insert into "COMPUTERS" values (156,'Nintendo GameCube', 24); +insert into "COMPUTERS" values (157,'Game Boy line', 0); +insert into "COMPUTERS" values (158,'PlayStation', 17); +insert into "COMPUTERS" values (159,'PlayStation 2', 17); +insert into "COMPUTERS" values (160,'Game & Watch', 24); +insert into "COMPUTERS" values (161,'EDSAC', 0); +insert into "COMPUTERS" values (162,'IBM System/4 Pi', 0); +insert into "COMPUTERS" values (163,'IBM AP-101', 0); +insert into "COMPUTERS" values (164,'IBM TC-1', 0); +insert into "COMPUTERS" values (165,'IBM AP-101B', 0); +insert into "COMPUTERS" values (166,'IBM AP-101S', 13); +insert into "COMPUTERS" values (167,'ProLiant', 27); +insert into "COMPUTERS" values (168,'Http://nepomuk.semanticdesktop.org/xwiki/', 0); +insert into "COMPUTERS" values (169,'Sinclair QL', 25); +insert into "COMPUTERS" values (170,'Sinclair ZX81', 25); +insert into "COMPUTERS" values (171,'Sinclair ZX80', 25); +insert into "COMPUTERS" values (172,'Atari 65XE', 20); +insert into "COMPUTERS" values (173,'Deep Blue', 0); +insert into "COMPUTERS" values (174,'Macintosh Quadra 650', 0); +insert into "COMPUTERS" values (175,'Macintosh Quadra 610', 0); +insert into "COMPUTERS" values (176,'Macintosh Quadra 800', 0); +insert into "COMPUTERS" values (177,'Macintosh Quadra 950', 0); +insert into "COMPUTERS" values (178,'PowerBook 160', 0); +insert into "COMPUTERS" values (179,'PowerBook 145B', 0); +insert into "COMPUTERS" values (180,'PowerBook 170', 0); +insert into "COMPUTERS" values (181,'PowerBook 145', 0); +insert into "COMPUTERS" values (182,'PowerBook G3', 0); +insert into "COMPUTERS" values (183,'PowerBook 140', 0); +insert into "COMPUTERS" values (184,'Macintosh IIcx', 0); +insert into "COMPUTERS" values (185,'Powerbook 180', 0); +insert into "COMPUTERS" values (186,'PowerBook G4', 0); +insert into "COMPUTERS" values (187,'Macintosh XL', 0); +insert into "COMPUTERS" values (188,'PowerBook 100', 0); +insert into "COMPUTERS" values (189,'PowerBook 2400c', 0); +insert into "COMPUTERS" values (190,'PowerBook 1400', 0); +insert into "COMPUTERS" values (191,'Macintosh Quadra 630', 0); +insert into "COMPUTERS" values (192,'Macintosh Quadra 660AV', 0); +insert into "COMPUTERS" values (193,'Macintosh Quadra 840AV', 0); +insert into "COMPUTERS" values (194,'PowerBook 5300', 0); +insert into "COMPUTERS" values (195,'PowerBook 3400c', 0); +insert into "COMPUTERS" values (196,'Macintosh Color Classic', 0); +insert into "COMPUTERS" values (197,'Macintosh 512Ke', 0); +insert into "COMPUTERS" values (198,'Macintosh IIsi', 0); +insert into "COMPUTERS" values (199,'Macintosh IIx', 0); +insert into "COMPUTERS" values (200,'PowerBook 500 series', 0); +insert into "COMPUTERS" values (201,'Power Macintosh G3', 0); +insert into "COMPUTERS" values (202,'Macintosh IIci', 0); +insert into "COMPUTERS" values (203,'iMac G5', 1); +insert into "COMPUTERS" values (204,'Power Mac G4', 0); +insert into "COMPUTERS" values (205,'Power Macintosh 7100', 0); +insert into "COMPUTERS" values (206,'Power Macintosh 9600', 0); +insert into "COMPUTERS" values (207,'Power Macintosh 7200', 0); +insert into "COMPUTERS" values (208,'Power Macintosh 7300', 0); +insert into "COMPUTERS" values (209,'Power Macintosh 8600', 0); +insert into "COMPUTERS" values (210,'Power Macintosh 6200', 0); +insert into "COMPUTERS" values (211,'Power Macintosh 8100', 0); +insert into "COMPUTERS" values (212,'Compact Macintosh', 0); +insert into "COMPUTERS" values (213,'Power Macintosh 4400', 0); +insert into "COMPUTERS" values (214,'Power Macintosh 9500', 0); +insert into "COMPUTERS" values (215,'Macintosh Portable', 0); +insert into "COMPUTERS" values (216,'EMac', 0); +insert into "COMPUTERS" values (217,'Power Macintosh 7600', 0); +insert into "COMPUTERS" values (218,'Power Mac G5', 0); +insert into "COMPUTERS" values (219,'Power Macintosh 7500', 0); +insert into "COMPUTERS" values (220,'Power Macintosh 6100', 0); +insert into "COMPUTERS" values (221,'Power Macintosh 8500', 0); +insert into "COMPUTERS" values (222,'Macintosh IIvi', 0); +insert into "COMPUTERS" values (223,'Macintosh IIvx', 0); +insert into "COMPUTERS" values (224,'IMac G3', 0); +insert into "COMPUTERS" values (225,'IMac G4', 0); +insert into "COMPUTERS" values (226,'Power Mac G4 Cube', 1); +insert into "COMPUTERS" values (227,'Intel iMac', 0); +insert into "COMPUTERS" values (228,'Deep Thought', 13); +insert into "COMPUTERS" values (229,'Wii', 24); +insert into "COMPUTERS" values (230,'IBM System x', 0); +insert into "COMPUTERS" values (231,'IBM System i', 13); +insert into "COMPUTERS" values (232,'IBM System z', 13); +insert into "COMPUTERS" values (233,'IBM System p', 13); +insert into "COMPUTERS" values (234,'LC 575', 0); +insert into "COMPUTERS" values (235,'Macintosh TV', 0); +insert into "COMPUTERS" values (236,'Macintosh Performa', 0); +insert into "COMPUTERS" values (237,'Macintosh II series', 0); +insert into "COMPUTERS" values (238,'Power Macintosh 6400', 0); +insert into "COMPUTERS" values (239,'Power Macintosh 6500', 0); +insert into "COMPUTERS" values (240,'Apple PenLite', 0); +insert into "COMPUTERS" values (241,'Wallstreet', 0); +insert into "COMPUTERS" values (242,'Twentieth Anniversary Macintosh', 0); +insert into "COMPUTERS" values (243,'Power Macintosh 5500', 0); +insert into "COMPUTERS" values (244,'iBook G3', 1); +insert into "COMPUTERS" values (245,'Power Macintosh 5200 LC', 0); +insert into "COMPUTERS" values (246,'Power Macintosh 5400', 0); +insert into "COMPUTERS" values (247,'CM-1', 0); +insert into "COMPUTERS" values (248,'MSX', 28); +insert into "COMPUTERS" values (249,'PlayStation 3', 17); +insert into "COMPUTERS" values (250,'MSX2', 29); +insert into "COMPUTERS" values (251,'MSX2+', 30); +insert into "COMPUTERS" values (252,'MSX turbo R', 0); +insert into "COMPUTERS" values (253,'Panasonic FS A1GT', 0); +insert into "COMPUTERS" values (254,'Panasonic FS A1ST', 0); +insert into "COMPUTERS" values (255,'PDP-11', 10); +insert into "COMPUTERS" values (256,'PDP-1', 10); +insert into "COMPUTERS" values (257,'PDP-10', 10); +insert into "COMPUTERS" values (258,'PDP-8', 10); +insert into "COMPUTERS" values (259,'PDP-6', 10); +insert into "COMPUTERS" values (260,'DECSYSTEM-20', 10); +insert into "COMPUTERS" values (261,'PDP-7', 10); +insert into "COMPUTERS" values (262,'PDP-5', 10); +insert into "COMPUTERS" values (263,'PDP-12', 10); +insert into "COMPUTERS" values (264,'LINC', 10); +insert into "COMPUTERS" values (265,'PDP-14', 10); +insert into "COMPUTERS" values (266,'PDP-15', 10); +insert into "COMPUTERS" values (267,'PDP-16', 10); +insert into "COMPUTERS" values (268,'Cray X2', 31); +insert into "COMPUTERS" values (269,'Cray X-MP', 31); +insert into "COMPUTERS" values (270,'Evans & Sutherland ES-1', 32); +insert into "COMPUTERS" values (271,'Commodore VIC-20', 6); +insert into "COMPUTERS" values (272,'PowerBook 150', 0); +insert into "COMPUTERS" values (273,'MacBook Air', 1); +insert into "COMPUTERS" values (274,'Digi-Comp I', 33); +insert into "COMPUTERS" values (275,'Digi-Comp', 0); +insert into "COMPUTERS" values (276,'Digi-Comp II', 33); +insert into "COMPUTERS" values (277,'Manchester Mark I', 0); +insert into "COMPUTERS" values (278,'Small-Scale Experimental Machine', 0); +insert into "COMPUTERS" values (279,'Nintendo 64', 24); +insert into "COMPUTERS" values (280,'Game Boy Advance', 24); +insert into "COMPUTERS" values (281,'Game Boy', 24); +insert into "COMPUTERS" values (282,'Nintendo DS Lite', 24); +insert into "COMPUTERS" values (283,'Nintendo DS', 24); +insert into "COMPUTERS" values (284,'Game Boy Color', 24); +insert into "COMPUTERS" values (285,'Game Boy Advance SP', 24); +insert into "COMPUTERS" values (286,'Virtual Boy', 24); +insert into "COMPUTERS" values (287,'Game Boy Micro', 24); +insert into "COMPUTERS" values (288,'Roadrunner', 13); +insert into "COMPUTERS" values (289,'HP 9000', 0); +insert into "COMPUTERS" values (290,'OMRON Luna-88K2', 0); +insert into "COMPUTERS" values (291,'OMRON Luna-88K', 34); +insert into "COMPUTERS" values (292,'Motorola series 900', 0); +insert into "COMPUTERS" values (293,'Motorola M8120', 0); +insert into "COMPUTERS" values (294,'Triton Dolphin System 100', 0); +insert into "COMPUTERS" values (295,'BBN TC2000', 35); +insert into "COMPUTERS" values (296,'WRT54G', 0); +insert into "COMPUTERS" values (297,'ThinkPad', 36); +insert into "COMPUTERS" values (298,'Apple Newton', 1); +insert into "COMPUTERS" values (299,'Atanasoff-Berry ComputersRow', 0); +insert into "COMPUTERS" values (300,'Atlas ComputersRow', 0); +insert into "COMPUTERS" values (301,'ASUS Eee PC 901', 37); +insert into "COMPUTERS" values (302,'ASUS Eee PC 701', 0); +insert into "COMPUTERS" values (303,'IBM 7030', 13); +insert into "COMPUTERS" values (304,'System/38', 13); +insert into "COMPUTERS" values (305,'System/36', 13); +insert into "COMPUTERS" values (306,'IBM 7090', 13); +insert into "COMPUTERS" values (307,'IBM RT', 13); +insert into "COMPUTERS" values (308,'System/360', 13); +insert into "COMPUTERS" values (309,'IBM 801', 13); +insert into "COMPUTERS" values (310,'IBM 1401', 13); +insert into "COMPUTERS" values (311,'ASCI White', 13); +insert into "COMPUTERS" values (312,'Blue Gene', 13); +insert into "COMPUTERS" values (313,'ASCI Blue Pacific', 13); +insert into "COMPUTERS" values (314,'iPhone', 1); +insert into "COMPUTERS" values (315,'Nokia N810', 16); +insert into "COMPUTERS" values (316,'EDSAC 2', 0); +insert into "COMPUTERS" values (317,'Titan', 0); +insert into "COMPUTERS" values (318,'Pilot ACE', 0); +insert into "COMPUTERS" values (319,'HP Mini 1000', 27); +insert into "COMPUTERS" values (320,'HP 2133 Mini-Note PC', 27); +insert into "COMPUTERS" values (321,'Kogan Agora Pro', 0); +insert into "COMPUTERS" values (322,'D-Series Machines', 0); +insert into "COMPUTERS" values (323,'ZX Spectrum 48K', 25); +insert into "COMPUTERS" values (324,'ZX Spectrum 16K', 25); +insert into "COMPUTERS" values (325,'ZX Spectrum 128', 25); +insert into "COMPUTERS" values (326,'ZX Spectrum +3', 38); +insert into "COMPUTERS" values (327,'ZX Spectrum +2', 38); +insert into "COMPUTERS" values (328,'ZX Spectrum +2A', 38); +insert into "COMPUTERS" values (329,'ZX Spectrum +', 25); +insert into "COMPUTERS" values (330,'Acer Extensa', 0); +insert into "COMPUTERS" values (331,'Acer Extensa 5220', 0); +insert into "COMPUTERS" values (332,'Dell Latitude', 0); +insert into "COMPUTERS" values (333,'Toshiba Satellite', 0); +insert into "COMPUTERS" values (334,'Timex Sinclair 2048', 23); +insert into "COMPUTERS" values (335,'Sprinter', 0); +insert into "COMPUTERS" values (336,'Timex ComputersRow 2048', 0); +insert into "COMPUTERS" values (337,'Pentagon', 0); +insert into "COMPUTERS" values (338,'Belle', 0); +insert into "COMPUTERS" values (339,'Loki', 25); +insert into "COMPUTERS" values (340,'Hobbit', 0); +insert into "COMPUTERS" values (341,'NeXT ComputersRow', 19); +insert into "COMPUTERS" values (342,'TRS-80', 0); +insert into "COMPUTERS" values (343,'TRS-80 Model 2', 5); +insert into "COMPUTERS" values (344,'TRS-80 Model 3', 5); +insert into "COMPUTERS" values (345,'STacy', 0); +insert into "COMPUTERS" values (346,'ST BOOK', 0); +insert into "COMPUTERS" values (347,'Atari 520 STE', 0); +insert into "COMPUTERS" values (348,'Amiga 2000 Model A', 0); +insert into "COMPUTERS" values (349,'Amiga 2000 Model B', 0); +insert into "COMPUTERS" values (350,'Amiga 2000 Model C', 0); +insert into "COMPUTERS" values (351,'IBM 3270', 0); +insert into "COMPUTERS" values (352,'CALDIC', 0); +insert into "COMPUTERS" values (353,'Modbook', 0); +insert into "COMPUTERS" values (354,'Compaq SystemPro', 0); +insert into "COMPUTERS" values (355,'ARRA', 0); +insert into "COMPUTERS" values (356,'IBM System Cluster 1350', 0); +insert into "COMPUTERS" values (357,'Finite element machine', 0); +insert into "COMPUTERS" values (358,'ES7000', 0); +insert into "COMPUTERS" values (359,'HP MediaSmart Server', 0); +insert into "COMPUTERS" values (360,'HP Superdome', 0); +insert into "COMPUTERS" values (361,'IBM Power Systems', 13); +insert into "COMPUTERS" values (362,'Oslo Analyzer', 0); +insert into "COMPUTERS" values (363,'Microsoft Softcard', 0); +insert into "COMPUTERS" values (364,'WITCH', 0); +insert into "COMPUTERS" values (365,'Analytical engine', 0); +insert into "COMPUTERS" values (366,'EDVAC', 0); +insert into "COMPUTERS" values (367,'BINAC', 0); +insert into "COMPUTERS" values (368,'Earth Simulator', 0); +insert into "COMPUTERS" values (369,'BARK', 0); +insert into "COMPUTERS" values (370,'Harvard Mark I', 13); +insert into "COMPUTERS" values (371,'ILLIAC IV', 0); +insert into "COMPUTERS" values (372,'ILLIAC II', 0); +insert into "COMPUTERS" values (373,'ILLIAC III', 0); +insert into "COMPUTERS" values (374,'Water integrator', 0); +insert into "COMPUTERS" values (375,'CSIRAC', 0); +insert into "COMPUTERS" values (376,'System X', 0); +insert into "COMPUTERS" values (377,'Harvest', 0); +insert into "COMPUTERS" values (378,'ChipTest', 0); +insert into "COMPUTERS" values (379,'HiTech', 0); +insert into "COMPUTERS" values (380,'Bomba', 0); +insert into "COMPUTERS" values (381,'ACE', 0); +insert into "COMPUTERS" values (382,'ASCI Red', 0); +insert into "COMPUTERS" values (383,'ASCI Thors Hammer', 0); +insert into "COMPUTERS" values (384,'ASCI Purple', 13); +insert into "COMPUTERS" values (385,'ASCI Blue Mountain', 0); +insert into "COMPUTERS" values (386,'Columbia', 0); +insert into "COMPUTERS" values (387,'HP Integrity', 0); +insert into "COMPUTERS" values (388,'APEXC', 0); +insert into "COMPUTERS" values (389,'Datasaab D2', 0); +insert into "COMPUTERS" values (390,'BRLESC', 0); +insert into "COMPUTERS" values (391,'DYSEAC', 0); +insert into "COMPUTERS" values (392,'SSEC', 13); +insert into "COMPUTERS" values (393,'Hydra', 0); +insert into "COMPUTERS" values (394,'FUJIC', 0); +insert into "COMPUTERS" values (395,'RAYDAC', 0); +insert into "COMPUTERS" values (396,'Harvard Mark III', 0); +insert into "COMPUTERS" values (397,'DATAR', 0); +insert into "COMPUTERS" values (398,'ReserVec', 0); +insert into "COMPUTERS" values (399,'DASK', 0); +insert into "COMPUTERS" values (400,'UTEC', 0); +insert into "COMPUTERS" values (401,'DRTE ComputersRow', 0); +insert into "COMPUTERS" values (402,'PowerEdge', 0); +insert into "COMPUTERS" values (403,'Apple Network Server', 0); +insert into "COMPUTERS" values (404,'Goodyear MPP', 0); +insert into "COMPUTERS" values (405,'Macintosh 128K technical details', 0); +insert into "COMPUTERS" values (406,'Power Macintosh G3', 0); +insert into "COMPUTERS" values (407,'CER-10', 0); +insert into "COMPUTERS" values (408,'CER-20', 0); +insert into "COMPUTERS" values (409,'IBM BladeCenter', 13); +insert into "COMPUTERS" values (410,'Wisconsin Integrally Synchronized ComputersRow', 0); +insert into "COMPUTERS" values (411,'Amstrad CPC', 38); +insert into "COMPUTERS" values (412,'Amstrad CPC 6128', 38); +insert into "COMPUTERS" values (413,'Amstrad CPC 664', 38); +insert into "COMPUTERS" values (414,'Amstrad CPC 464', 38); +insert into "COMPUTERS" values (415,'Intergraph', 0); +insert into "COMPUTERS" values (416,'Enterprise', 0); +insert into "COMPUTERS" values (417,'MTX500', 0); +insert into "COMPUTERS" values (418,'Acorn Electron', 0); +insert into "COMPUTERS" values (419,'Sony Vaio P', 17); +insert into "COMPUTERS" values (420,'VAIO', 17); +insert into "COMPUTERS" values (421,'Sony Vaio P VGN-P588E/Q', 0); +insert into "COMPUTERS" values (422,'Sony Vaio P VGN-P530H/G', 0); +insert into "COMPUTERS" values (423,'Sony Vaio P VGN-P530H/W', 0); +insert into "COMPUTERS" values (424,'Sony Vaio P VGN-P530H/Q', 0); +insert into "COMPUTERS" values (425,'Sony Vaio P VGN-P530H/R', 0); +insert into "COMPUTERS" values (426,'Sony Vaio P VGN-P588E/R', 0); +insert into "COMPUTERS" values (427,'Sony Vaio P VGN-P598E/Q', 0); +insert into "COMPUTERS" values (428,'Timex Sinclair 1000', 23); +insert into "COMPUTERS" values (429,'Komputer 2086', 0); +insert into "COMPUTERS" values (430,'Galaksija', 0); +insert into "COMPUTERS" values (431,'Vector-06C', 0); +insert into "COMPUTERS" values (432,'Elektronika BK', 0); +insert into "COMPUTERS" values (433,'Sun386i', 39); +insert into "COMPUTERS" values (434,'Xerox Daybreak', 0); +insert into "COMPUTERS" values (435,'Xerox NoteTaker', 26); +insert into "COMPUTERS" values (436,'D4a', 0); +insert into "COMPUTERS" values (437,'LGP-30', 0); +insert into "COMPUTERS" values (438,'LGP-21', 0); +insert into "COMPUTERS" values (439,'ASUS Eee PC 900', 37); +insert into "COMPUTERS" values (440,'Atari TT030', 0); +insert into "COMPUTERS" values (441,'Bi Am ZX-Spectrum 48/64', 0); +insert into "COMPUTERS" values (442,'Bi Am ZX-Spectrum 128', 0); +insert into "COMPUTERS" values (443,'PlayStation Portable', 0); +insert into "COMPUTERS" values (444,'MSI Wind Netbook', 0); +insert into "COMPUTERS" values (445,'Sharp Mebius NJ70A', 0); +insert into "COMPUTERS" values (446,'HTC Snap', 41); +insert into "COMPUTERS" values (447,'Commodore Educator 64', 6); +insert into "COMPUTERS" values (448,'Amiga 1500', 6); +insert into "COMPUTERS" values (449,'Commodore 65', 6); +insert into "COMPUTERS" values (450,'Commodore 16', 6); +insert into "COMPUTERS" values (451,'Commodore CBM-II', 6); +insert into "COMPUTERS" values (452,'Commodore Plus/4', 6); +insert into "COMPUTERS" values (453,'Commodore LCD', 6); +insert into "COMPUTERS" values (454,'Commodore MAX Machine', 6); +insert into "COMPUTERS" values (455,'Aster CT-80', 0); +insert into "COMPUTERS" values (456,'Test', 0); +insert into "COMPUTERS" values (457,'MSI GX723', 0); +insert into "COMPUTERS" values (458,'Eee PC 1000HV', 0); +insert into "COMPUTERS" values (459,'VTech Laser 200', 0); +insert into "COMPUTERS" values (460,'CrunchPad', 0); +insert into "COMPUTERS" values (461,'Neo Geo', 0); +insert into "COMPUTERS" values (462,'Sega Mega Drive', 0); +insert into "COMPUTERS" values (463,'Sega Master System', 0); +insert into "COMPUTERS" values (464,'TurboGrafx-16', 0); +insert into "COMPUTERS" values (465,'Sun-3', 39); +insert into "COMPUTERS" values (466,'Pleiades', 0); +insert into "COMPUTERS" values (467,'IBM Sequoia', 0); +insert into "COMPUTERS" values (468,'Inves Spectrum 48k plus', 0); +insert into "COMPUTERS" values (469,'iPhone 3G', 0); +insert into "COMPUTERS" values (470,'iPhone 3GS', 0); +insert into "COMPUTERS" values (471,'Beagle Board', 40); +insert into "COMPUTERS" values (472,'HP nPar', 0); +insert into "COMPUTERS" values (473,'MacBook Family', 0); +insert into "COMPUTERS" values (474,'Reservisor', 0); +insert into "COMPUTERS" values (475,'BladeSystem', 0); +insert into "COMPUTERS" values (476,'lenovo thinkpad t60p', 0); +insert into "COMPUTERS" values (477,'lenovo thinkpad x200', 36); +insert into "COMPUTERS" values (478,'lenovo thinkpad t60', 0); +insert into "COMPUTERS" values (479,'lenovo thinkpad w700', 0); +insert into "COMPUTERS" values (480,'lenovo thinkpad t41', 0); +insert into "COMPUTERS" values (481,'lenovo thinkpad z61p', 0); +insert into "COMPUTERS" values (482,'lenovo thinkpad x61s', 0); +insert into "COMPUTERS" values (483,'lenovo thinkpad t43', 0); +insert into "COMPUTERS" values (484,'lenovo thinkpad r400', 0); +insert into "COMPUTERS" values (485,'lenovo thinkpad x60s', 0); +insert into "COMPUTERS" values (486,'lenovo thinkpad x301', 0); +insert into "COMPUTERS" values (487,'lenovo thinkpad t42', 0); +insert into "COMPUTERS" values (488,'lenovo thinkpad r61', 0); +insert into "COMPUTERS" values (489,'lenovo thinkpad w500', 0); +insert into "COMPUTERS" values (490,'lenovo thinkpad sl400', 0); +insert into "COMPUTERS" values (491,'lenovo thinkpad x40', 0); +insert into "COMPUTERS" values (492,'lenovo thinkpad x200 tablet', 36); +insert into "COMPUTERS" values (493,'lenovo thinkpad t400s', 0); +insert into "COMPUTERS" values (494,'Nokia N900', 16); +insert into "COMPUTERS" values (495,'Internet Tablet', 0); +insert into "COMPUTERS" values (496,'Meiko Computing Surface', 0); +insert into "COMPUTERS" values (497,'CS-2', 0); +insert into "COMPUTERS" values (498,'IBM 701', 13); +insert into "COMPUTERS" values (499,'IBM 5100', 13); +insert into "COMPUTERS" values (500,'AN/FSQ-7', 13); +insert into "COMPUTERS" values (501,'AN/FSQ-32', 13); +insert into "COMPUTERS" values (502,'IBM CPC', 13); +insert into "COMPUTERS" values (503,'System/34', 13); +insert into "COMPUTERS" values (504,'System/32', 13); +insert into "COMPUTERS" values (505,'System/3', 13); +insert into "COMPUTERS" values (506,'IBM 305', 13); +insert into "COMPUTERS" values (507,'English Electric DEUCE', 0); +insert into "COMPUTERS" values (508,'CER-203', 0); +insert into "COMPUTERS" values (509,'CER-22', 0); +insert into "COMPUTERS" values (510,'Kentucky Linux Athlon Testbed', 0); +insert into "COMPUTERS" values (511,'QNAP TS-101', 0); +insert into "COMPUTERS" values (512,'iPad', 1); +insert into "COMPUTERS" values (513,'iPhone 2G', 0); +insert into "COMPUTERS" values (514,'Inslaw', 0); +insert into "COMPUTERS" values (515,'WePad', 0); +insert into "COMPUTERS" values (516,'MacBook Parts', 1); +insert into "COMPUTERS" values (517,'MacBook 13-inch Core 2 Duo 2.13GHz (MC240LL/A) DDR2 Model', 1); +insert into "COMPUTERS" values (518,'MacBook 13-inch Core 2 Duo 2.13GHz (MC240T/A) DDR2 Model', 0); +insert into "COMPUTERS" values (519,'MacBook 13-inch Core 2 Duo 2.13GHz (MC240X/A) DDR2 Model', 0); +insert into "COMPUTERS" values (520,'MacBook 13-inch Core 2 Duo 2.26GHz (Unibody MC207LL/A) DDR3 Model', 0); +insert into "COMPUTERS" values (521,'MC240LL/A', 0); +insert into "COMPUTERS" values (522,'D.K.COMMUNICATION', 0); +insert into "COMPUTERS" values (523,'iPhone 4', 1); +insert into "COMPUTERS" values (524,'Nintendo 3DS', 24); +insert into "COMPUTERS" values (525,'ASUS Eee PC 1005PE', 37); +insert into "COMPUTERS" values (526,'National Law Enforcement System', 0); +insert into "COMPUTERS" values (527,'BlackBerry PlayBook', 42); +insert into "COMPUTERS" values (528,'Barnes & Noble nook', 0); +insert into "COMPUTERS" values (529,'SAM Coupé', 0); +insert into "COMPUTERS" values (530,'HTC Dream', 41); +insert into "COMPUTERS" values (531,'Samsung Galaxy Tab', 43); +insert into "COMPUTERS" values (532,'BlackBerry PlayBook', 42); +insert into "COMPUTERS" values (533,'Tianhe-I', 0); +insert into "COMPUTERS" values (534,'Kno', 0); +insert into "COMPUTERS" values (535,'ThinkPad 701 C', 0); +insert into "COMPUTERS" values (536,'ThinkPad 340 CSE', 0); +insert into "COMPUTERS" values (537,'ThinkPad 755 CX', 0); +insert into "COMPUTERS" values (538,'ThinkPad 755 CE', 0); +insert into "COMPUTERS" values (539,'ThinkPad 370 C', 0); +insert into "COMPUTERS" values (540,'Coleco Adam', 0); +insert into "COMPUTERS" values (541,'Nebulae', 0); +insert into "COMPUTERS" values (542,'Alex eReader', 0); +insert into "COMPUTERS" values (543,'Acer Iconia', 0); +insert into "COMPUTERS" values (544,'Archos 101', 0); +insert into "COMPUTERS" values (545,'Fujitsu Lifebook T900', 0); +insert into "COMPUTERS" values (546,'Motorola Xoom', 0); +insert into "COMPUTERS" values (547,'ViewSonic G Tablet', 0); +insert into "COMPUTERS" values (548,'DEC Professional', 10); +insert into "COMPUTERS" values (549,'DEC Multia', 10); +insert into "COMPUTERS" values (550,'DEC Firefly', 10); +insert into "COMPUTERS" values (551,'DEC 3000 AXP', 10); +insert into "COMPUTERS" values (552,'DEC 2000 AXP', 10); +insert into "COMPUTERS" values (553,'DEC 4000 AXP', 10); +insert into "COMPUTERS" values (554,'DEC 7000/10000 AXP', 10); +insert into "COMPUTERS" values (555,'DEC Professional 350', 0); +insert into "COMPUTERS" values (556,'DEC Rainbow 100', 0); +insert into "COMPUTERS" values (557,'DEC Professional 325', 0); +insert into "COMPUTERS" values (558,'DECmate II', 10); +insert into "COMPUTERS" values (559,'DECmate', 10); +insert into "COMPUTERS" values (560,'DECsystem', 10); +insert into "COMPUTERS" values (561,'NetApp Filer', 0); +insert into "COMPUTERS" values (562,'DEC GT40', 10); +insert into "COMPUTERS" values (563,'ecoATM', 0); +insert into "COMPUTERS" values (564,'MindWave BrainCubed Education Bundle', 0); +insert into "COMPUTERS" values (565,'PalmPilot', 0); +insert into "COMPUTERS" values (566,'Upcoming iPhone 5', 1); +insert into "COMPUTERS" values (567,'Dell Inspiron 560 Desktop ComputersRow ', 0); +insert into "COMPUTERS" values (568,'IPad 2', 1); +insert into "COMPUTERS" values (569,'HP TouchPad', 27); +insert into "COMPUTERS" values (570,'HP Veer', 27); +insert into "COMPUTERS" values (571,'Lenovo Thinkpad Edge 11', 36); +insert into "COMPUTERS" values (572,'Dell Vostro', 0); +insert into "COMPUTERS" values (573,'Gateway LT3103U', 0); +insert into "COMPUTERS" values (574,'iPhone 4S', 1); \ No newline at end of file -- cgit v1.2.3