mybatis-plus/src/test/resources/plugins/paginationInterceptor/CreateDB.sql

DROP TABLE
IF EXISTS page_user;

CREATE TABLE page_user (
	id bigint (11) NOT NULL AUTO_INCREMENT,
	NAME VARCHAR (20),
	age INT (11),
	PRIMARY KEY (`id`)
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;
insert into page_user(name,age) values("编号0",0);
insert into page_user(name,age) values("编号1",1);
insert into page_user(name,age) values("编号2",2);
insert into page_user(name,age) values("编号3",3);
insert into page_user(name,age) values("编号4",4);
insert into page_user(name,age) values("编号5",5);
insert into page_user(name,age) values("编号6",6);
insert into page_user(name,age) values("编号7",7);
insert into page_user(name,age) values("编号8",8);
insert into page_user(name,age) values("编号9",9);
insert into page_user(name,age) values("编号10",10);
insert into page_user(name,age) values("编号11",11);
insert into page_user(name,age) values("编号12",12);
insert into page_user(name,age) values("编号13",13);
insert into page_user(name,age) values("编号14",14);
insert into page_user(name,age) values("编号15",15);
insert into page_user(name,age) values("编号16",16);
insert into page_user(name,age) values("编号17",17);
insert into page_user(name,age) values("编号18",18);
insert into page_user(name,age) values("编号19",19);
insert into page_user(name,age) values("编号20",20);
insert into page_user(name,age) values("编号21",21);
insert into page_user(name,age) values("编号22",22);
insert into page_user(name,age) values("编号23",23);
insert into page_user(name,age) values("编号24",24);
insert into page_user(name,age) values("编号25",25);
insert into page_user(name,age) values("编号26",26);
insert into page_user(name,age) values("编号27",27);
insert into page_user(name,age) values("编号28",28);
insert into page_user(name,age) values("编号29",29);
insert into page_user(name,age) values("编号30",30);
insert into page_user(name,age) values("编号31",31);
insert into page_user(name,age) values("编号32",32);
insert into page_user(name,age) values("编号33",33);
insert into page_user(name,age) values("编号34",34);
insert into page_user(name,age) values("编号35",35);
insert into page_user(name,age) values("编号36",36);
insert into page_user(name,age) values("编号37",37);
insert into page_user(name,age) values("编号38",38);
insert into page_user(name,age) values("编号39",39);
insert into page_user(name,age) values("编号40",40);
insert into page_user(name,age) values("编号41",41);
insert into page_user(name,age) values("编号42",42);
insert into page_user(name,age) values("编号43",43);
insert into page_user(name,age) values("编号44",44);
insert into page_user(name,age) values("编号45",45);
insert into page_user(name,age) values("编号46",46);
insert into page_user(name,age) values("编号47",47);
insert into page_user(name,age) values("编号48",48);
insert into page_user(name,age) values("编号49",49);
insert into page_user(name,age) values("编号50",50);
insert into page_user(name,age) values("编号51",51);
insert into page_user(name,age) values("编号52",52);
insert into page_user(name,age) values("编号53",53);
insert into page_user(name,age) values("编号54",54);
insert into page_user(name,age) values("编号55",55);
insert into page_user(name,age) values("编号56",56);
insert into page_user(name,age) values("编号57",57);
insert into page_user(name,age) values("编号58",58);
insert into page_user(name,age) values("编号59",59);
insert into page_user(name,age) values("编号60",60);
insert into page_user(name,age) values("编号61",61);
insert into page_user(name,age) values("编号62",62);
insert into page_user(name,age) values("编号63",63);
insert into page_user(name,age) values("编号64",64);
insert into page_user(name,age) values("编号65",65);
insert into page_user(name,age) values("编号66",66);
insert into page_user(name,age) values("编号67",67);
insert into page_user(name,age) values("编号68",68);
insert into page_user(name,age) values("编号69",69);
insert into page_user(name,age) values("编号70",70);
insert into page_user(name,age) values("编号71",71);
insert into page_user(name,age) values("编号72",72);
insert into page_user(name,age) values("编号73",73);
insert into page_user(name,age) values("编号74",74);
insert into page_user(name,age) values("编号75",75);
insert into page_user(name,age) values("编号76",76);
insert into page_user(name,age) values("编号77",77);
insert into page_user(name,age) values("编号78",78);
insert into page_user(name,age) values("编号79",79);
insert into page_user(name,age) values("编号80",80);
insert into page_user(name,age) values("编号81",81);
insert into page_user(name,age) values("编号82",82);
insert into page_user(name,age) values("编号83",83);
insert into page_user(name,age) values("编号84",84);
insert into page_user(name,age) values("编号85",85);
insert into page_user(name,age) values("编号86",86);
insert into page_user(name,age) values("编号87",87);
insert into page_user(name,age) values("编号88",88);
insert into page_user(name,age) values("编号89",89);
insert into page_user(name,age) values("编号90",90);
insert into page_user(name,age) values("编号91",91);
insert into page_user(name,age) values("编号92",92);
insert into page_user(name,age) values("编号93",93);
insert into page_user(name,age) values("编号94",94);
insert into page_user(name,age) values("编号95",95);
insert into page_user(name,age) values("编号96",96);
insert into page_user(name,age) values("编号97",97);
insert into page_user(name,age) values("编号98",98);
insert into page_user(name,age) values("编号99",99);
insert into page_user(name,age) values("编号100",100);
insert into page_user(name,age) values("编号101",101);
insert into page_user(name,age) values("编号102",102);
insert into page_user(name,age) values("编号103",103);
insert into page_user(name,age) values("编号104",104);
insert into page_user(name,age) values("编号105",105);
insert into page_user(name,age) values("编号106",106);
insert into page_user(name,age) values("编号107",107);
insert into page_user(name,age) values("编号108",108);
insert into page_user(name,age) values("编号109",109);
insert into page_user(name,age) values("编号110",110);
insert into page_user(name,age) values("编号111",111);
insert into page_user(name,age) values("编号112",112);
insert into page_user(name,age) values("编号113",113);
insert into page_user(name,age) values("编号114",114);
insert into page_user(name,age) values("编号115",115);
insert into page_user(name,age) values("编号116",116);
insert into page_user(name,age) values("编号117",117);
insert into page_user(name,age) values("编号118",118);
insert into page_user(name,age) values("编号119",119);
insert into page_user(name,age) values("编号120",120);
insert into page_user(name,age) values("编号121",121);
insert into page_user(name,age) values("编号122",122);
insert into page_user(name,age) values("编号123",123);
insert into page_user(name,age) values("编号124",124);
insert into page_user(name,age) values("编号125",125);
insert into page_user(name,age) values("编号126",126);
insert into page_user(name,age) values("编号127",127);
insert into page_user(name,age) values("编号128",128);
insert into page_user(name,age) values("编号129",129);
insert into page_user(name,age) values("编号130",130);
insert into page_user(name,age) values("编号131",131);
insert into page_user(name,age) values("编号132",132);
insert into page_user(name,age) values("编号133",133);
insert into page_user(name,age) values("编号134",134);
insert into page_user(name,age) values("编号135",135);
insert into page_user(name,age) values("编号136",136);
insert into page_user(name,age) values("编号137",137);
insert into page_user(name,age) values("编号138",138);
insert into page_user(name,age) values("编号139",139);
insert into page_user(name,age) values("编号140",140);
insert into page_user(name,age) values("编号141",141);
insert into page_user(name,age) values("编号142",142);
insert into page_user(name,age) values("编号143",143);
insert into page_user(name,age) values("编号144",144);
insert into page_user(name,age) values("编号145",145);
insert into page_user(name,age) values("编号146",146);
insert into page_user(name,age) values("编号147",147);
insert into page_user(name,age) values("编号148",148);
insert into page_user(name,age) values("编号149",149);
insert into page_user(name,age) values("编号150",150);
insert into page_user(name,age) values("编号151",151);
insert into page_user(name,age) values("编号152",152);
insert into page_user(name,age) values("编号153",153);
insert into page_user(name,age) values("编号154",154);
insert into page_user(name,age) values("编号155",155);
insert into page_user(name,age) values("编号156",156);
insert into page_user(name,age) values("编号157",157);
insert into page_user(name,age) values("编号158",158);
insert into page_user(name,age) values("编号159",159);
insert into page_user(name,age) values("编号160",160);
insert into page_user(name,age) values("编号161",161);
insert into page_user(name,age) values("编号162",162);
insert into page_user(name,age) values("编号163",163);
insert into page_user(name,age) values("编号164",164);
insert into page_user(name,age) values("编号165",165);
insert into page_user(name,age) values("编号166",166);
insert into page_user(name,age) values("编号167",167);
insert into page_user(name,age) values("编号168",168);
insert into page_user(name,age) values("编号169",169);
insert into page_user(name,age) values("编号170",170);
insert into page_user(name,age) values("编号171",171);
insert into page_user(name,age) values("编号172",172);
insert into page_user(name,age) values("编号173",173);
insert into page_user(name,age) values("编号174",174);
insert into page_user(name,age) values("编号175",175);
insert into page_user(name,age) values("编号176",176);
insert into page_user(name,age) values("编号177",177);
insert into page_user(name,age) values("编号178",178);
insert into page_user(name,age) values("编号179",179);
insert into page_user(name,age) values("编号180",180);
insert into page_user(name,age) values("编号181",181);
insert into page_user(name,age) values("编号182",182);
insert into page_user(name,age) values("编号183",183);
insert into page_user(name,age) values("编号184",184);
insert into page_user(name,age) values("编号185",185);
insert into page_user(name,age) values("编号186",186);
insert into page_user(name,age) values("编号187",187);
insert into page_user(name,age) values("编号188",188);
insert into page_user(name,age) values("编号189",189);
insert into page_user(name,age) values("编号190",190);
insert into page_user(name,age) values("编号191",191);
insert into page_user(name,age) values("编号192",192);
insert into page_user(name,age) values("编号193",193);
insert into page_user(name,age) values("编号194",194);
insert into page_user(name,age) values("编号195",195);
insert into page_user(name,age) values("编号196",196);
insert into page_user(name,age) values("编号197",197);
insert into page_user(name,age) values("编号198",198);
insert into page_user(name,age) values("编号199",199);