qamresources.sql

Sun公司Dream项目

// Oracle 9i DDL code for the TM

create table qamresources (
cpeid		varchar(32),
qamip		varchar(32),
qamport		integer,
tsid		integer,
rfchannel	integer,
timest		timestamp,
free		integer
);



insert into qamresources values (NULL, '10.0.1.2', 49152,0,16, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49154,1,32, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49156,2,48, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49158,3,64, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49160,4,80, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49162,5,96, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49164,6,112, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49166,7,128, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49168,8,144, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49170,9,160, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49172,10,176, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49174,11,192, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49176,12,208, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49178,13,224, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49180,14,240, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49182,15,256, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49184,16,272, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49186,17,288, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49188,18,304, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49190,19,320, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49192,20,336, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49194,21,352, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49196,22,368, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49198,23,384, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49200,24,400, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49202,25,416, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49204,26,432, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49206,27,448, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49208,28,464, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49210,29,480, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49212,30,496, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49214,31,512, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49216,32,528, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49218,33,544, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49220,34,560, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49222,35,576, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49224,36,592, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49226,37,608, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49228,38,624, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49230,39,640, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49232,40,656, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49234,41,672, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49236,42,688, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49238,43,704, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49240,44,720, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49242,45,736, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49244,46,752, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49246,47,768, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49248,48,784, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49250,49,800, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49252,50,816, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49254,51,832, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49256,52,848, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49258,53,864, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49260,54,880, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49262,55,896, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49264,56,912, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49266,57,928, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49268,58,944, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49270,59,960, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49272,60,976, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49274,61,992, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49276,62,1008, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49278,63,1024, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49280,64,1040, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49282,65,1056, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49284,66,1072, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49286,67,1088, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49288,68,1104, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49290,69,1120, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49292,70,1136, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49294,71,1152, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49296,72,1168, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49298,73,1184, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49300,74,1200, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49302,75,1216, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49304,76,1232, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49306,77,1248, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49308,78,1264, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49310,79,1280, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49312,80,1296, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49314,81,1312, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49316,82,1328, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49318,83,1344, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49320,84,1360, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49322,85,1376, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49324,86,1392, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49326,87,1408, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49328,88,1424, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49330,89,1440, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49332,90,1456, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49334,91,1472, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49336,92,1488, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49338,93,1504, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49340,94,1520, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49342,95,1536, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49344,96,1552, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49346,97,1568, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49348,98,1584, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49350,99,1600, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49352,100,1616, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49354,101,1632, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49356,102,1648, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49358,103,1664, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49360,104,1680, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49362,105,1696, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49364,106,1712, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49366,107,1728, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49368,108,1744, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49370,109,1760, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49372,110,1776, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49374,111,1792, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49376,112,1808, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49378,113,1824, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49380,114,1840, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49382,115,1856, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49384,116,1872, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49386,117,1888, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49388,118,1904, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49390,119,1920, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49392,120,1936, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49394,121,1952, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49396,122,1968, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49398,123,1984, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49400,124,2000, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49402,125,2016, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49404,126,2032, NULL, 1);
insert into qamresources values (NULL, '10.0.1.2', 49406,127,2048, NULL, 1);


commit;