use zdl_data
CREATE TABLE [dbo].[InfiniteClass](
[cid] [int] IDENTITY(1,1) NOT NULL,
[PID] [int] NULL,
[ClassName] [nvarchar](50) NULL,
[Orderby] [int] NULL,
)
insert into InfiniteClass(PID,ClassName,OrderBy) values(0,'a1',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(0,'b2',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(0,'c3',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(1,'a11',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(1,'a12',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(1,'a13',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(1,'a14',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(2,'b21',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(2,'b22',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(3,'c31',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(3,'c32',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(4,'a1111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(4,'a1112',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(12,'a11111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(14,'a111111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(15,'a1111111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(16,'a11111111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(17,'a111111111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(18,'a1111111111',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(8,'b211',1)
insert into InfiniteClass(PID,ClassName,OrderBy) values(20,'b2111',1)