二. 数据库的设计与表创建

CREATE DATABASE `online`CHARACTER SET utf8 COLLATE utf8_general_ci; 

/*==============================================================*/
/* DBMS name:      MySQL 5.0                                    */
/* Created on:     2022/9/29 23:38:39                           */
/*==============================================================*/


drop table if exists create_room;

drop table if exists upload_video;

drop table if exists user;

drop table if exists video;

drop table if exists videoroom;

/*==============================================================*/
/* Table: create_room                                           */
/*==============================================================*/
create table create_room
(
   cr_id                bigint not null,
   vr_id                bigint not null,
   openid               varchar(35) not null,
   vid                  bigint,
   primary key (cr_id)
);

/*==============================================================*/
/* Table: upload_video                                          */
/*==============================================================*/
create table upload_video
(
   vid                  bigint not null,
   openid               varchar(35) not null,
   uv_id                bigint not null,
   primary key (uv_id)
);

/*==============================================================*/
/* Table: user                                                  */
/*==============================================================*/
create table user
(
   openid               varchar(35) not null,
   u_name               varchar(20),
   u_img                varchar(300),
   upload_num           int,
   create_room          int,
   primary key (openid)
);

/*==============================================================*/
/* Table: video                                                 */
/*==============================================================*/
create table video
(
   vid                  bigint not null,
   v_title              varchar(20) not null,
   v_url                varchar(300) not null,
   v_describe           varchar(100),
   primary key (vid)
);

/*==============================================================*/
/* Table: videoroom                                             */
/*==============================================================*/
create table videoroom
(
   vr_id                bigint not null,
   vr_title             varchar(20),
   vr_describe          varchar(100),
   primary key (vr_id)
);

alter table create_room add constraint FK_Relationship_5 foreign key (vid)
      references video (vid) on delete restrict on update restrict;

alter table create_room add constraint FK_create_room foreign key (vr_id)
      references videoroom (vr_id) on delete restrict on update restrict;

alter table create_room add constraint FK_create_room2 foreign key (openid)
      references user (openid) on delete restrict on update restrict;

alter table upload_video add constraint FK_upload_video foreign key (vid)
      references video (vid) on delete restrict on update restrict;

alter table upload_video add constraint FK_upload_video2 foreign key (openid)
      references user (openid) on delete restrict on update restrict;

insert into user (openid, u_name, u_img, upload_num, create_room) values ('NU5YM T64H1ACW0X5C534PIOCKGSWADOWU8', 'OH KGE9O5XAWMW0N51W2', 'BQTH35UYI2PYTBWEEV8J3 BXBAA9XGGDVG6XQEINRJQVVEG1HCKCNFJQAJAI7 B6AH32TLO2IOAIU9YUA Y D76YQ4WUJJHM4AFQ6DP9PVMCMJUOH8FUF51J5V0SJHCW099V9PQ1DA90L8C1OF5GHGO00GU1FGYVMO J03QRJ329QQI6JUPHQSFNXGUGVMA2LS82WBGHAC50IV4WSKVRW6FCGDR05H0NPM0SVOEYO UCXVQR4PQAA2KM7NMV1 KHN8HCJRUIVWWHJDRVB7N8OCIOUJRCUF908I7GWPU81S7U', 19, 4);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('37 9F 679K2B33H1X2A3STRXI4RM6GT095L', 'ICSS7 AVJRME43TUPJ8Q', 'EDB26XAWD8QE0BQXDK3GAAXYLWARCE0 5DBUJMKP9FIAG2G70JWJLAQYQATG19UKV5IB80OCR THWU10OW9R25 L 2UBDVII90B95O5JQDIU3LY9SLK8LEA9I J0LM1SHL2583Q8OI5VV4W1A0YQ5ILF14WT2TUKB S2ENHIJP4N28WMOWEOMT2TUYOP4OJ8 MBRNOQMWLK0IJ8E0GL53K77OEGB4927AF9N0D4 QCEE4LFXT91WJXQLVRIYIML6KN SHVI4OFDXUXC 6A1B0 P39QYIQOMXM PX663RTSYC', 4, 2);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('PYXQG I05VSV0END78CKB 6HA9TDWL7SKYQ', 'GTEN4TJWYTOAMT15C6WS', 'LU3DQXOHNPG18HOK89WFWKDF77CSSQG2EO45M R1JYKUPIDFI2IR9VQCPU 7S W79L3JJOXFUKY43QGY5SR76S9DSS17IP4G8OYUNMLMQ7QMDI6QOY96NOAUQPU55FR8EY LRTYAGGDA1MIYP0VA58XRQ4YHJ47KVBPF3P T8VL555BIUBT9QLYT2K8VY3N6TLX6I4E5CUEH8P3XT5JYYB3B CT5752EDGQTAASY4O3MF89E8OQHYAR7VQ69NF68SLIGBUFJWM85B3WRVYF BW451Y0B7JJEAHWD0WGV0TNR', 16, 10);

insert into user (openid, u_name, u_img, upload_num, create_room) values (' GOU3TKJSA0LUDR 1R966AC2J0Y7GFOR8P6', 'GII24T8O71Q9DU2UQTJK', '34YHH0YV9W6FX1AMAFF64LV0AUPIXAJAEF5RTPUNFGPYW1AKUIYLM9L0MJUS0Y8RIMWDQU Y339EFTKSDJY94QM20BBMSPIC5QJT24IN0U6Y 6  VR4GY6O3YTDKQA9BK517P6TQF1JJ4UM2WQV5JMV6I3 WCDT8NOABJHNC8HARBFV4JIFYA3IKAOYH8JNNPIULIH RPD1S7GGCDIS5OF9KEGTWY8NFLA33MI1FSABKDCB3LJPL6E RHQYC5UUHQ18LUTF0U9ALGGOWUTQYCPWUP6HOHOOW277I8HX8VO11', 7, 0);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('9IWM51WXRKD9BN21CJV SS9SXBAMV4F FEA', ' 9HBC4M5NMVE DTXA HM', '402FB 9DOYGMTYBFLXSY2LQVVMN0BDBT25AKS4DTTNE41K4R9O33QHBFU50G7JPE1YG9HMYRB6SI6WEJ6YVULJAJ9XOT2UMXSDWP7EPGVVW3HCE85OLYPRN8BRLF B594AA5BO4Q5WCBTM50YN2BPOB669 VJD8UUFJ3N4E5UG0VKVGMHLCYN4WQ21DVVVLTTJV6LTKTPJ0HMMXLK6S39EUX9LJ9O2P Y5R439HLI3T3EVX 5W01P6AC1AL34MUR4R0XKBPY1X5UUYNM47YCOIADQFWHXM29BTNL1AK14U0X', 10, 7);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('P POWY7AQG9WNV5JW6YE894AEFQNB3S4L C', 'L5BTGOH8MM4KVNRAONH8', 'IN0VHHTOG JWN71TDI68JK0G0VAMNHNSD5PV7 1UTEMM7R0K86S4Q9PUJ6R7IEM00 ABCUET25VSS3XCUWCX 0OD6PPVM2U9I70NX5XQ2WCBU4D 2EYGDT1P2EMDYUCGH6YV2VYV6SYTVO0F9QM1 MBQTJS4H1LM2PYRWW3QBBDJDH SCF2Q 97HNW989T9XY0NMJ16VXG1EU7JCSES7JHQ57MVEAABRDNGH7YF2YJ6XWDBIJY5TTY81R781OG0L1QJ23988XBTD3F8U4T5M269O3MS6K7V38MWNGHDFVWQL', 12, 13);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('7F3GGF36N22H3XUAV23EYSDJ6Y1MU7KYUN1', '3G0F4TK4AT3C4JBM9X4L', '3RF4K4P7JNOOH8NJ1DP2R599L0TWCWI3KMC8HEGXKQOVQSVGCNLH K6JS6V0F9I466R6XKTRGQM99G4YMOXHRJYSD64BSCUGNIN8J1 CJRAVWUYP50DBG3PYQ7DJJXGMRMBPIHYY8YM24VO171VH1PANA9SID80S9DC4I4IIXAW8U EW35LJY7D6GAR7KS1Q0KL6SI6N4NP LYY 4K287WEGQ50USNRYUX7P3MAM9VU1C 1KNG3HBGL1KLIQD67JM2KNPT CVNFANN1K3WPDCXX7IAIC569BAGG7GW5CHMWU', 3, 1);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('TIPF1J 5XM2 GYRBN2Q6FME2P7MOVT9PRD0', 'JB7EC53E0BBFSOHUAMKJ', 'M07NVT93VU8T4TJBEWGORKSMP1FWO9VVUFH1G4D1022G NFF2Y8R0PUECVBV22DQHSPNCLYQFXRBQ59MIDQ92464RD0RABL06AE20W7U93F91NG1OKWMXXMKWYLT093B5KXK1NKAAQ0TJANX2DHVP6ANAFSVX2NK4OE 1CT PB66 8RON2 RHUJGV18FRTCOD2OVKEY5ASE54F3W AONDS388E9NBELUQLIFA3B2DHY8PT2933OKKRUDFK0CCQYCGHBJWOG8S5VLK8JQMYT68F2E2XG OLGOHGDP49B9VWX0', 11, 8);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('4 JOITHJDIPDWANASPBR0U55TV0R4M82GHF', 'UHUOI7UKB3P OGG84XH5', 'JEIANQPVLD91AE8P7N8G5KO3NW XKBRXIXE5VQTLW385Q6WBSGTFEA1I9HY69CQIDCTNGLA1H 1RM N9BKYJOI2HSWW4YC0I15NC5F5IMB21OTMLTCQW0I442WU 43ICIN4U5Q4YNAXA57K473GPU1D8X326SR 3R4P0AFS0 2K0T 48I0RFA5P8933BHXYITQ4TUSGY1L6V1HP S9JJVDWA1DT1CLN RJHEPJ7P7U8NNCH44TYTRND469CA 55KOJ117UXW0MIB0PE1KNH4K9H5P132IDC OLE695CRXO2Y', 0, 16);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('5GAAN7XXPTM2PR3FWQN 505579NJN8FP DI', 'FAOHUBNOJ0EOO1VN0MS8', '226QCKVGFY7HMYPLNITLXIHFCGT6JN7V9CDXJB404WGTY176L5 ELYFKE3NQC2JGKT9YFJK4ULTKUCSC2C13WKPHWRTM EYAH8XU6URAC ORCQ1QDGY04T 8XO5Q30N42P883ML5YH94N1Q6BDI5H5B40D5LB52UVSUGF97JHSI W YM7B74CV0G9S8EC WI1F5HK20EB45DB748YXDA07KTBCI WM8C5 DYT6QVB0QY56VAX93KWBWVBRWUR0BNE5I4LPD7XGK2OE372RAKC73IYA44P2P G5B AM7U2VPO', 1, 5);

insert into user (openid, u_name, u_img, upload_num, create_room) values (' WCMA43UXF3MW74PA8T8RB414SR5QHNHRW1', 'HJ2I1HPYE4B9CYCABXHG', '573KTBJLUTMPFGMOILB1LID3DURC902F TA576DJU14OJAPW3A9LJ8YPC6VII2AMGFIVQ1Y1TLLPI6C AQYOLO7SOBP7DOS712TSGYA9B6A97YGN0H4ELN1UXWLHXVSS3PI4 G75XCQ0YTJD8YQ3UA35OG9KS0AM4898ED796JRQME29WF17A9UKJDMU2Y2NLFYOD2PSQ7ICMP6007LCAJJM50 TGXOF2 R438SM9LA0W6T2ME89UJ6I6MT55JG71H7F9YC8EWTYWOPGS12WD2J3BDYQXWIU3GYL4S4UW90L', 14, 14);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('T5QS25YFVGU4HV2B63JTUXLUCLLR34H69P9', 'SXNRE1ESPPBL2XM3DKJQ', 'OFCXM3GBYC9VA9GI ESXW94SGMK9HM3HP22U8F4S21O0VAPN6WWM28YBKTX0YYLE2PX8SS OS4XBVBCHTPETAL3N938732A6DRRSIVAJR2X934BFRFG 8HDEYMBNSN9WQ48TL8J33RE0DCS5E64COW DJYQTVEUQT2RDAEJ6GDUCNNBEOF7OETBIE0XT9SO2TAI2WPCT1NINTGM302BH615WK60FVBNDFUH8QHD6KLG3U7RCEESXUCFSH7Y3PA BXAFT5X7MAPHEO63ED3SSAEHK6BFUQ06R3GXHJ4RL1V80', 2, 19);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('XCU1TRKINDVK4B9VE0CDW57V68TK50V1NLJ', 'AHXDIV7Y1QD3OEDRT85J', 'CM8N 99HDQTU820H MXN7P8G95AS4D4YVL2NSFW52UBBQFXCJ6B45QJPTV8YDWAYE6S4WI8KA23V9S9JGONHBNNTM4D25JPFY9UX UI51QKI 0VQW0J6J0919OR9FS3EQPY375SXC0EHM8CC XVSCPUA75QRNL KV87S8KWP8 K2B35BX6R3N4M312V0Q8N8LITDCMHTUNBTVNGEWBP0Y KPCW2L9G8H33GCB9YB8Y7DJ97W7VFMBGI T1I87DKXOFXBEVGXLN0J4T6S29W5930G1PNU6J9VMVF5G7  2IUA', 13, 3);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('JYKIORMPQFH22 HXJU37MELWBVLF63NYG 1', 'YLTQEYLDLBJPJYK61CMF', 'YIWRUTFYXUFAQ27HAVSC8RCRTE9IV42RW0P2UQLLX3WDN96B5QBXW7EAF2U791C8EDOPG58RFMC5I7XPXVVY AL0N60CHPM5C1O924HB3LGT4UY7BH6BX27CH4VXUF336VE15LRA5MP69X6HK2UN6ERWEO9LPH9UY69X4FRTCPDPU6PDEN57734FE2VOE1X95KHJICG7 8HHP8 T5L8VIUES2V42B55GU724T13 V0UCRKO0MPY9OB 2G38EXR9NLITJN28RB94OYMS7541K8 KG577YNRV6KEADJXOB9LNL', 17, 6);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('DDFF1SUW6HR MP231O TOYRWVAF940LCXEP', 'WLMCQ97S7DJRC8CVBDX ', 'AKAJVYDWWX51EAUQC577EMEPJEHDFMVSTN7KD57WH3LU1BW9H01TYIQF8ID53IJ4KM0K1RYEO8KFWWOPFJG1R2CBL2FHVW0P8JL48XI6C37U5UTEGBXL07WJGTWY6XDQKH32V9EOBAT9EGQERT9BC4WTQA9DV0D1DC BDN02JD12VFNBNGK9XIMNB09MG2M3E0XYOHJ2XSSR9UIGGI5LJF446E UXEH0H7 8CJW4GVA0U74TI7ONFC7 BPS9RP4NJMELB SB4WYMEE 07N1VC5INO68912HEFRQK7DREX0LL', 18, 9);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 'X98HLFUAF3IB9QQ  QLS', '7RFAYTIYN3E6DW8EB09E25VV3R3SYB715YLN6OIO7X3BGX FPGXEG4VFKHTHAR5AL6BMD1T CPIG17Y6VQTUJ 67TDT7280QGVAG1MH01XEK8JVPYKXSCWHGHMOCFJN151Y3P3U0OJAF8NQ5P35YY QITUUXKC9XO K3Y HEAUHC99VWBU2RE96UI3ILOAABIH3NDSBRDJ1BHUVEKS48VKD4WQMQ1UFAPNDNKSIVYST07WMBR9F2FS46RNX9XGP2S2XM9BIKL3IRQT7HP10NBLHYF10WLEF1WP5Q2I1XFFHJ', 15, 15);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('J9NOKX3AV2YRF 3TKFEOKL5I4XKHIP7GTO6', '0BBMNM6IOXOS5E0AYPJF', 'DT4UTALYPNWMRK4WGY4RNX6VSG5424 YH50IXLQOVGYF6BF9U8OW6HWH453KPYYBGTXRHXO51GMTMOQK697B6L1QWHHR 18KOV41FOKCJ 4EIKR3W041WU2GW85D6 AAN75XAM8WOBXXV8XSFA572883 4871QJRULT61 D4VLUA8DF7BW76Y5MT1R7AUO0WRRAO8CDXGVYKM1BM2ILEEE C MPRFMN9XCXHYQG W5JYOQCW9NUJR804Q6QV4Q51XVFTTKNHN99VGC2MGTRDV70AARK5UMW6EQQ1YNPE701U', 8, 18);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('G3F2PYXUUJPSC1HFKVDGK3J7CAR31A7BHP8', 'OEHWHAGVWKPBRTEG56CQ', 'M6V AEGT5E7JNKR5 975YA3P287B231IEXUTEOB0J8IBTR4OH4179S2GB GES3QSGRWPIU07JKNNXDRMTY751CE4HVLLYIUM14RSB1GT4L6A0D2211BI027RSEIG7RG7Y WXK7WFT0CL8MQANYPGWVUG2FW555UUGOJK0BVQOV9KRVONQSITKN KM67JHVM GXPWI53OCNRXST6PVXP0S6JICCP5W3NA8V8PVGO8W6G0I0P589X8G4PXL0F46U2JR3QG U N0RST6Y2UH1Q8F2 LBM5C10CNFIK9QWN9W3  ', 6, 12);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('H2FN6HGYBER 9T2PFJSKRY7X4S93LEQMKUD', 'B8BQI4X25ISIBU05 DU4', '41DURWCGMI5GY3G8BH6Q8IWW21JK88 UNJXAVXT00U9LIQR U0K2MVORYLW9APJC2OFI0K OKEN8H76CH8T NQM EV64VE84TKQ 0QHTBCYRWNNS3QG4VQ79E 469MCG873D5POJAU1SEJWFNYC6DSQ101TJA31AUJ HC6RKKV201TE039M0RCACD IIEY562D69X8O88EJ9HSG E NO77PVLQVIFOCEEGOTTD6NG97MW74DMA5DDJL0S2R6U93VFFUFHIRGD617 77 S93FH0ER7NC9M0M4PTBHW R08SEF', 5, 11);

insert into user (openid, u_name, u_img, upload_num, create_room) values ('7BSUVE2WV9EGWHEK6YDGSPTN CIIUXIFYDO', 'LSLNYJ3PNOOC6RJ0V6WC', '0BD5 WPC9L9T 51N8OYES4WLKH7C7OTPPI XB4JS Q7IF0LGREUJCNUII503MB7RD490YQEKHAYTSN0VQRW41PK2CJSKP0OCUW4S1GDN3F2FEFLB8PGAJGTE4K SU3OGI1C8TWT5NVULLKWAXMOVLYLMILSCDQX774G2IMFELMCAQ5RJYAGFX676NE6JN0EUE4RKE24ST5I57ACW0VH2D28I93YB5WDU1EBQRJ3YTC FHV1DA 9MPEICK9N99BDRLR18YBWMKF620RJ4KM0JSU6IBVLNI3AD3FKBCJ9PL4BM', 9, 17);

insert into video (vid, v_title, v_url, v_describe) values (1, 'OGODMPYGKSAJ3XSYLYKQ', 'C99RPEM1GNR 2KAV2 0M7YJREH2ITYCT EKT9TD P0LBPONK09UB9U H 3N9B3P6SE9XW6J47F98BDI 323MRA37DKP73MBOM BGU67F759E9 6HFE3RDGL1OVODGSLASCHDAHR0NSY4UP6ONL0KVFJ5JBSCST8581BDGKT6WFEDGQE7VHQK 66W3O0FGR8ID12TNWDCVIHQH1YYT6 VIM3T243KVMVT4RVM5TL42VWHDM8WOB8A9J6KN7LDJAPN 0KHAK 9GU1LKA 89VRB2MJ0NWV3VLJR0XTNFBCNK25L', 'TSJ5FDIWLOLN7H94KFS96XLLIK0SJD54E5BO5Y4S  V5 8SEFS1212CK6MJ530DCR8V3QC O0SN5ERQ53GCGTKTQVGUR2Q7WEQC2');

insert into video (vid, v_title, v_url, v_describe) values (13, 'EFQ09WJGI8SBM1A32FF4', 'LT5AS9K3UHM2CL0MF8J1P624 5RDHM8Q W0I3AHCGO3YJ2XKPT2K5QJHD IOQ 3YA12KJ65JWK XKI94CVTJ 16 1P9VH38R3S68 JXR3JIGDJI5WTQBCWTJH5XKD72D0HEGUE R3S95B4W8102GVK R8XNEK1PNPF5C17AYXG1SDOFKFOCLTN0VTOY8SQ15VT352SJDML 902XYQ DMV72RUWJ29SR07Q5BXD9SB6FO9GYXQ 7HBP XX0G2T4C3H7LD4NRI5239MHVO5M9C YHNPA1IP22VG5V2QN3L8 WE', 'C99E9EBQFI0RJMK6FV1CBBGAO610U88GQTUHH I5HCD9UBR6CRU66C5MNE KQ9AA5JF5DN6UMIBF5GCJLGSR7M1Q8UX3O7JPBCI5');

insert into video (vid, v_title, v_url, v_describe) values (17, 'SKGJ53TTU2Y3XWXJM0KA', '68TYTR5J591QUYUXSDXHXESADV4QSN3OK3RAI7THPAWO26RXF6SRSNF255G92L7RVXCT5LHU131P4YY9I275UJ5MPSK69C1JS 3AKKLD25BMR7UWIXJR1MKB9FL4PAM0IYA5PK 09DAWST5XC60DBBLLI8KGPPCCRVYJJ0NUL0DO1IVMIKJEM0F7QM73MSUWT8X607Y3KTORD BC1ATXYYKWOJ3OTO14FVTH5DI68V5MPQ0OIWCQCAQPOAIHOD5PY51J L8O7PHBX9TD EG5U4 RKLLGPSME8OQ2LXA9K77M', 'NGKCBM4KJY0IPM8A52IS9CJT9EA0KKA2586FOSVR7KPGR9CJTL5217BK804ORXV MVTYAGFOBXMYCU000YY1G2IW88YC8L0PY1IY');

insert into video (vid, v_title, v_url, v_describe) values (10, 'RCWYMT144MG27H01S0LB', '1 V9376AJEMBRK86CR96NMWF4A4U PL003JE 3EUL09U3P2W31263F8OOJHFKXOHVVJ C9O54QSX20JIH8FM21AIFDE631BUNCTDCCH9BADDMRXM4XW ISB9KH6GRK4FGJN0SC UEAF2AQ7DKJESYDGYCEEQCGIADCJMXP58M6P2225PGG3TEWJ80LXP52N5LMB J9QF9G7MIBE5GXFYGY7FUFX4 5HD8132 8A2LD83RG8T95587GVJ86S08WTXK870593G06C2FVUML59UBQS5G19FRV4JSQB3EFAKV0D7', '9HEN4NBOM6YTLT2BU03Y21WSW4CQ FMNA59OU8JI8KORHS1P7IXKGDEX7F75MJTEI55FS0FGEMGAKCM3XGL8846W2XTQTU OOK37');

insert into video (vid, v_title, v_url, v_describe) values (4, 'XU5F725LNIEXU9SN8DH7', 'NC417Y17WKWKY2BO01PH60DSO5P JXGD30R8WG3SO30Q4A87YSPS2DLMHC1 IU1K2I9 HFAAWXN9FKLK1YY2Q2GEQ8QI7MR 8TUSSLQIA 4DCP6JAO4MLAS01I 551OXWBMRPJVG6OL1DG40AMME02LJD8T5UPYVWUCP5TEACSXR2EU02RO0ED96EX0DV97GKMN03TAA5HST03 SAI9P92EB6H4ET47GS9YSGWTWIEN2SXKP1P7G2 WHD7HFAP2UYRDS98JQSIR12ARA0L1RCR E6R9CYB6Q LVEK19L 84X', 'ACBPSFAHTWUM15F2709Y0D2XJOA61WT ODULQH246Q2I1AMV9OWG2XPSRA9QD1WDB9WK MDLP3X5Y 33APN0S673JUNA BMNN0QB');

insert into video (vid, v_title, v_url, v_describe) values (14, 'TGSA5V9AHQ923LKSA1BP', 'HD48FR2WM12VBACNI37CEL6QEB4DJEJMRBHB0BHRI9YW0CFIN63460TGW1H5H8LKN8VM1O4WLVMO0S S4L1NUG2Y7206CCM V2P7AOOHK6GHO 9YP8LLG109F5OU7RTN8NLG4MND1EYTTOA68WIXM7H2SYPOOY31KRISC594SN2AT0V8JCVMGT5QI3MEUQ4BQ4LUEDIUHYXPJJNLH71WN5F7U07WFEE8LAEE7P9FYAYYG6 DY M5CWH635K5LL894ROD632A GW7HC0DX6JTA6BXJQ0D2DNH7XIUCSBME8QN', 'V6L F393FPJV8KDC94V6WFG0QF4S3ITL8SX FPB2IFHX0N6A25S5 115 I9B4NWEHLB1SXIYUG6PM6HWE2RPUIY7O3PJA31TI3H5');

insert into video (vid, v_title, v_url, v_describe) values (5, 'WVSIOHB3LOVQ81HWGEBA', '6SOYC30LQFOHK18U57GOV4637J4729QPIPQ960HBGL4EJ442K A74IBHTEHHW3HY2MN0I4PYS   V1VPP0J7 9ULQW2KS8T4WKQLDFRNJAC70O0KDXECJCX43 C8P1V2OY03U XO3N3LFW9KYWS1WQ1YIXNVOS0UIJE62LUIDLWGMEOTEDHA78W37I1LON M3KG874CQT18N4ULM49 UMMJRUUA3RRPQNMM9E7N3DBARISME4XK0DI99NH3S13FQWQ4 XH5JK83 EONPV2CSNHN3FDTQMKQ84CUP FL3FVG8', 'NJLRNIP94E EX2G7PN4Q63YB2JK5S7  7BKNKQVCIEM2VR9OP5PJJU691I2R973XNWS0WNCDX5NHY7DT3N5I74EJUGGAGUW 7UTA');

insert into video (vid, v_title, v_url, v_describe) values (18, 'N6DV80DX8VKLI16R8BL7', 'DVTAGS6VQ LWGUMLMYD259MFUI 2ITW 5MN2FNPKXD7IKPIR91G7ARYRV LRX1UHD3T1WLDUJYXW3377PEEREF52D41RAXEISFCFHYBCXVH5 K9N8LS1XDB9P15RQ7GM6JJMCILCI8UJM5YE31MGR0C AS1L 4QYAB 47E SO1BI 7EFK33NE8VHKB4B97QAXMJLA7Y9V5EOJJFD1 OBSACQ0G41AIO3 4BVCVX2LF QACQJUW7EIV 93Y 4DDNJBERYNTY2DJ5MT7QWDWPXK2TBCI 0AOFDU0K 1TYVP4AE', 'D8HCGKM8GRRW2L5P92F22QWFF98T5MH6AUHY8HC67C7YYGQE78TBDNU4QYTPRL GH8BMGLVAI46N2I6X6KYJHB1CGW OC0Q2BLPA');

insert into video (vid, v_title, v_url, v_describe) values (6, 'A59SFAU8H82KQ6MPP5J8', '75N02XI6KCLTDONDFLN1IDQ8V1LO7O480MG6DVAIMLWBPXT NQOM9SI613BDGOKJFEYASIWFE421 OKSD5PV5IGFX EH4EWT4QOYUJJN3O9SV6AXI9N76ODRH4U7U5MR9A E1JP DBC51MNLKX9NFCE38CFFC1J8N2 I114HHK0A84K9ID2  GWH4URMC3Q6HJLTEETA8ER06PBGVABI VK7Q96XMCLRLKGIS 3PX3UTN9DYQO4AMCBM5MV8YMQBAD3HV L7DFAVHMJMO0C00KFAXDPX5P4AGOP8CJ5FYJW ', 'BJNN9R18P13VSHYJ4UGD8G0CB2F6PG7O2T9LUBWQ94AW7QQT07GJACU 0U310T43 XOJ69LP5SWV3H KYBKC8Q9JVDY382JIC643');

insert into video (vid, v_title, v_url, v_describe) values (0, '5HD64CV3G31YHKJ1J5HQ', 'HJVHV7K1G4EX7EF739XAHICY NX4KYAKJLPRWJ8B6H1DPWIUOWN3AETFJ9C9NNTSJCQS0MKJG1DOKJ79T23NB6O5T95Y6 NEG9S2XMI0M2T JFLLF8A1K7CANCCEMPQS8N4BU0VP0T0NV0IKJNKIK4XMW762 1S4UT7ALO581DT4D6JL4JKGC1ELGE7HVJC2DWR0GXOU2RI3C73R905FGIGB9DBDC7M2T VMBIKJKVIBNRCS04J52ELJ9JMM0ER5B0TDIIOV KMSO 81HR5HS22PF4I92YJ1 X8QYGQ3VKWL', 'RFTGS1CTPD7JRYNHD7TNCILWU ALIT3 K40VNPBWRCM7ATVSEPVIX2U8VT3LT D54 DL8JTELUBQFIM9NNH23RU V4CJOS MG4WT');

insert into video (vid, v_title, v_url, v_describe) values (9, '5U6FBG4NGKRP6OIEWHXL', 'CDIKSSRGS9 WUDOH42N2YG B4B43QIM 2TP25YD9R24THD2MGDGBFC8VYE4H5YGFVM4WQVA8 15VH2 7SU5EL5EBYHPFPC9H7KS1R54V76G4YFWUDXQPQE9P5OPT126V6QM5I7PSPS7808NE0HX64JSB3LN6TCQJBO9LAE6UCNDLV8CT3QAI2UAHX4XPQDLGQB4BE10YFXQ7P0C9GB4YVJBR8PN9H7TV10EX7AWAX6RQR4AYH9IIYTQV63RAVVO6GJ3R49T27FSIC 4E42DSPNONGGY N8QTN1YQIW2R80XI', '272UYN4W2LM0XSKWE7X8WX9YJ6BN70EHP9MV80L36FVCLBT7GXU5KNT5T0YLFJF3Q6B89I5GPDMPJUOVUDI404T002V U0CWTE7V');

insert into video (vid, v_title, v_url, v_describe) values (15, 'F CMU5BUPCAYX83QUO50', 'P 35ULC1K0J3AFO5M3WJT2KGV45YHR0E7BOYM2V7 Q1EFY89O694RL85OR D0VQF76MR 75VHM4V5GMEO1ALR13REHLXBXHL4N1L0279JA2Y9RPEI8N1M50VNXGPJXHHCM9O96UBSCFD413O67BTQ5OOYM6U7CQCC2WFUDLJR8 TMY4BL8LCYLJ2Y0SSJ 14MOVCG0T53CVB5J02SK 9OIUK8EH161XDO7D49RN1G0GWM6NCSCCBVBLEI1S9B6QD38TMXR PIDDWJRU6ONSF1UMDH2JBPGLYF71TRIIC0JMO', 'I6XONOEQ5EDF6U6OYKU6O26JL59QK5QYUHX83G17DCX46MDIJM6TCLD2D245NNIOS8T51SO0QJ5QITWFJBYUK47LG9KAU HHCO64');

insert into video (vid, v_title, v_url, v_describe) values (2, 'W5L3H9YIKL6152GGLI A', 'WI1BJEPP59G1VKS6LAEOAM WHYPROJEU83K5JGQCR8JJFIW TJURCP05FFUH9A84LKHNSLUSYSXPYPK3OID2AQQ2GNXMMLVDLDNKHHAJBEL A NY1T93STYAVRT0K7FNCEP6WPKB U9IA F59KI0L WJMB220P85IX1J8QG MGD3TCCHC8YNH6 T5A1YTOW89MW9TY2KFU86SH7VOO5H98W7D1YFWKDEDL7OXPR852UU7V0F98HOQWOXTCPXAOTB0CSRY55B0N3U0R6CMK3 TULFHC1IYCRT1Q448E5BTFKM', 'NKO866MTXIUG644T03PAMP30U7XY0I8K0PP5BWPH5NKQBWBXAS7F5NXTG6ATVQ3HB Q35QJM03QK8V 03G9IWX5THQEXITMKQ0 N');

insert into video (vid, v_title, v_url, v_describe) values (11, '5MEPQO12YCB628COAT1T', '7E83TTXWDL79YNGWWOWVQ4K18I UWPO7UV57EHPIBOC4A97K7RAMX78GCC5P36KC182CHGXKNF4X4JEH KAC04  1RDWSW7FUEGGQ3UIB50OMBVEB GIWCITVIQGXGCHG72IB4IFD0MLFR8PDSOP0V9WC7JQWOH7YEWQXNS0U4Y SJWDCP4PC0FS0EF3RXXXNM9ES9AOTG9EFM33GB8EEI2PIK84XWROOFR2OVFHEY2GMHQ7Y4RV6IXHG16LIRV3C98DXUD3SF7 6WMP2JOD9LMPH3PD20UJYJU3BY3W3KQY', 'B41NCN9FTRFL46S68LKUQMBC2OF5HE JYXXQ YCWGLNV41W619RC5GEA7KY8UNILQEOMTNHT2VGNUY1GRV3FKS8226DI34NTT6LS');

insert into video (vid, v_title, v_url, v_describe) values (19, 'Y27Y1LMALSPP1 3DI1M ', 'F5986XA9QQHJBXIIOL5XTI178DBWK01H9V 4KG6389NTOKN70W0XACIVKOLRFASV14VANA5JX 21A1FU7MCUR48APT8UYUWKQBTCTGDIH3DD 7DWY  LNUIYO7B2G0L4SDHLHX9Y553MKVE3HHGRFFVFWMP482EC7JAY5II2N5I8URL8L53NJO5GF91AP523HHG0A0259JLDRHFBIC04I9IXSRSI7ANHPA0 F18QT38R6IKH4T3RWUAX245E8IJOGGQT48IEN00W2B00QT1T9X6NVQ486OA3UV60 0QYOYAU', 'R6G13IFE4RY5CSRW 2S8GKO8J4RF COCRYCQJQYAR7MGASO5AM9FJ9MEJVHQFES0UAF3WB53NYBTN0KAJP2H55RMHGR8 6J7 DCI');

insert into video (vid, v_title, v_url, v_describe) values (16, '846AT2LK7EKUW9HM2N6 ', 'D71E9X957X6HCFGWJJV9JUPSNR D8XAC5E57241BE8HX6GR0WSFVO2F1QTOPBDWTD2786UDHH0NOKGBSQ2GQ0O9AXCF9D4VA68BE W2I6HGK8GA3OTPWS6WNYF9FEFQILVVSKIPW6N0LGXKIBH6IQHT1K4BSXXSVSUJMFANTAIOW0OT8AD6V7X9WJA521P2CXV9BOA12AW2T90I3BOCG1A9DPSJ6B7FO7O9DUYS6 M5S1LWN2JJWKONAVCK3WBJ6TT3K55M79B4FRH11A0WYPN 3WKJ3FBTT1RJP6210 MHJ', 'M603L6TCDOUYQJYBPHVR0HERNXF S2V99MSPMT0P77QF0HMORSD0E6 ISV R99BRQ60J2SBL0TB9VKYN88D3I19JURN99D9XKR5I');

insert into video (vid, v_title, v_url, v_describe) values (7, 'AX4PDOJADOWJULYTIJW7', 'C6O2S VMW5PXQ 5H3VFB5YNU6F9 30 08KG9AD6Y3KXIA39RM2DXHMT4VAD8IUO EWPRPUS7SNLBJ73MAFEOD0NVI38J9HYNEXLBV41S0LFEGL4WTU24784MWREAB4DF8Q2FNQF9A YJ3F2JKLPLDADYBJAKRUUWJUT505UDRRF2IR1ODGE C4WQO423MPJRD5CBWREY0DY3SKANLH1XLIIUANP81MYUE XABUH37MCB2RGU59AML97G5LX14GS9S3N59KTY0O83H3FWHOL1XYCTNUA83X339MBNS1CVM61G', 'IQ0A9D45IK FT OSC588 8TK04VJNQG6G6Q9Y7FG340AQJWF1I310BPAP1MHJTWRKMC1K1B5WRLSRWG3N1FN6E9TLP7V87A4GD1D');

insert into video (vid, v_title, v_url, v_describe) values (8, 'NL3W3FO8EHGASNL LO81', '7ACLL47O45IDSR143O5R13J7 ABCU4Y1HXNSXA4TSBLN22APEAKPVFRS 692VYX8KJ2LJC49LTSFIUVO877M3156WI TLIQ0PJM8 VSK4WJKQOGCXS7AIONOX2MK91X078M3DUIY5RK6SGHPSB NHH0BAFHHT5RJFUKPCKD8CGVEDL4C6 AVW1SS759SMWEKRIDR0WBVGYTMLSEKGU277C9DXMW MROOK9554Y13B7WC581C3XM2BRJ3T8MM9M96B2BUUD0NPY0ABHM8I3I2R4HK58VHKPM GRJ1X4H2IWB8', '50OX6 MK7EIGEJ1V9B93 INWBF7SRR95AN43649EWR2WEQ0OMC7T6R8 VG Y7WQG2W3MAHW967TGV9O753G9HPJMINSGHVHG44S5');

insert into video (vid, v_title, v_url, v_describe) values (3, 'WQY1W2Y3TVJWT7LAR8YF', 'SIHJ77JYJKP3ARHG0PXOI4U0PMJEKP76XPP4NWUL6RPMOVIMPP8IYSGAYO HTUDAIT8KFVT3SNOSPKA666BCECWI0IEP7QUUV3O44K4N QLTUPFIM2PRE90ESP67OQUAY3JNAHRLVS8NL1V6MMR LXW NCIP81X94T1PMWYH516UGBRUDKNUNMYBKTCMYTYICP7GR47004RN 2LCM18V8JTO0 E W4  3JTRE8C0743 SU4QKI792TFHY35J4WFQEKH4ACFG F2BF0C30X3UWF1AYSYOS0Y0RFJQ7DVI5YDX', 'U79BYABQ2NRP8N2DAFFKGTJTDOTIM18Y7FDSM0W4AB6NRFXT01 MB3W5N8A69T5 U3G46QMKRM4M9APT3GOTC4DA4AR2923V543W');

insert into video (vid, v_title, v_url, v_describe) values (12, 'BHJ8BNDYMGYLJ0DY6CW6', 'LXMT9N23IA4U24UE27J7946CW79H1XIMYRHB5D86P7I1WKOD55DUJ49I8LKTI0NX8OV80ADVBY8VJ04 8G0OO9JB1905YBW04OWDSW3N84OLOQJ7KL8JESGK7S19AA0PFQ0NW7RNCAGJID6PHY4GUDCOOMG3 TLIYNX6BJJMLUG7Q20S9U0LR27SE7AP 70JJ8N7IOD Y7W9MARE9FKAFDVMBTXCV6FM02G4JS UEKAJXX07VUP1M5 MHOXGMSR5ARWIWHVX 5B0 B1GI4MGNOXTXW7JVLRABSU3QQCMR 3T', '38CPWT4DOKUAYI5BBV7PNLE2EPETNB3VCRQV01XSJVKV5YFFHQGJ4PL5 47RUEMYJV8 IDM YBVS6IQONJXIG62GR5DA9 17QL1M');

insert into videoroom (vr_id, vr_title, vr_describe) values (13, 'V59 CQX91GGPVAODXJVY', 'E9WUE2TDILQTWIMDU81U WWSCROJC10SXYM1WEAQQ4S6 75NDBGHRFIGB1BGNB0VIKD XMNQ0VXUL6D3TCX92LU SW8SA2EMNV21');

insert into videoroom (vr_id, vr_title, vr_describe) values (4, 'G5AA8FPW4YF07R5 ISAX', 'S30F8IKTYVDMP0L4D1C95DGLAB69VIYNAO4N9IE6Y02SL T3TQ7YSFC29L4PP2MGQJNU3AFBWU3U0PBDY4FB8 IMCSTJS1V92BY1');

insert into videoroom (vr_id, vr_title, vr_describe) values (18, 'JWN2S0L4EVCWV4ICMVNJ', 'O7WLOXXOKO0D 0S9WRVR57KXPSS0N2810HCPQ9USY76LKMVCCHL7VJJQ5LRTG6D759ND BSDTIBQVMYT4R5R7WMIRNGWWI5N5LVI');

insert into videoroom (vr_id, vr_title, vr_describe) values (6, 'MWUK38233ED6 8UC8D2Q', 'XTMBTS8LO28LT2BGFUJFA3TQ1B124EE8K2W3Q2177CJ51T3FA8PAHW2UD9ES6LYRFO VBB2PADMRFBT14GFM3 P  D8XIWFHLN1H');

insert into videoroom (vr_id, vr_title, vr_describe) values (19, 'HE2SBLSJEKPESJUL ES1', 'CEYE9DV9NS1PQ8PKX6K1G4F3903YOFYEN3OQY1L5GDP3IPEXV8N1WEMNPIFVTWGQ42FDSFSLJ2WYCF14RQD60G7M2UA3NB1ALXP2');

insert into videoroom (vr_id, vr_title, vr_describe) values (17, '4RTBRMSGO1BUQU1X0Y61', 'N0AFPU39ND2BI8BUY FNNFOODA I148Q1PN5PI 2FULA16EHG381RL0QQXAHC44HWS9VFVLO5PLFCYUTRADRRHXN0PU K6PJS 9F');

insert into videoroom (vr_id, vr_title, vr_describe) values (14, 'G4AH 7J0DYHP5I1A84LH', 'QJ7GT1RTES4NOFEF08BWXG7ENHJBQCL7H2D 1HN88U YHUNBXVD3VJTUO8LDAF DM X V1H1W6GW088DYBM2OKU QD0FL4WO4L C');

insert into videoroom (vr_id, vr_title, vr_describe) values (3, 'OGFNHDNJ WMM3PXHBKOY', 'X1CBJTUPPR07LDTQPP78WV9CBRMJX8 3CC3R7LTWEWN1BT 9WEONBK24K38041LEU4DQ3B61KNMSN8HVPMSV56H 39KVP6SMM0J8');

insert into videoroom (vr_id, vr_title, vr_describe) values (0, 'TW3DEOYHLE C7CVP86UU', 'DO4V7A5078V02MSAMES84R8GSKT9E1U 9A4DRL8XJ739I6TWXQKEELMUH66 HL8B0NUJAPNEBK9C4EODDNP492XQXRQLNJF7X6DO');

insert into videoroom (vr_id, vr_title, vr_describe) values (9, 'JUXEBTIF9QDUCFVL9HCX', 'D61 6JW6ET208JB6I 4HB3K2930996X420OUSBORHDDSUOVKJIY3TS0J6XAUDX3E1JQTX OD0FTCJ82E66X8PDR9S2CWOHQ9FK5E');

insert into videoroom (vr_id, vr_title, vr_describe) values (1, 'V4JWQR1KR1IWIEV0O7YN', 'CI4B5PD P9WXW0D999RQ1 21JY JX8KRSSM4KEUMSTMLNDC4QT6HEI3IE897Q6JQ3M1GI2RV7RS1W3RGIAKBU WAP78HMD9Q4QI6');

insert into videoroom (vr_id, vr_title, vr_describe) values (7, 'OSYLNP8T 6M6LUYERH 8', '84CNMVHUT1ILO02W QSEUJJ69MBQVPKMH2X3Q1 420EO0P306ABYYNLO1KKV3AD8ITOOOVBLMJ6BFJK8EHJKBQNJN4NNELVV NVN');

insert into videoroom (vr_id, vr_title, vr_describe) values (15, 'BJ78OHUJCRTTS3FIY8W3', '1QL6WM3BYO254APSJ3YASJ1NCB9839PUIV7 UP12MCEL86USC00NLF53F305JR1TRJT9XMRLHJPG9WQGEMLFVV1V9EWNKPLPHSDG');

insert into videoroom (vr_id, vr_title, vr_describe) values (2, 'LXJ3EWEMCKLC64SHBG1O', '5MRON8CS6P 8F UMUANIGMWVY TEGO341DBM890WJ8YC723DCKN8O3D40Y BF3H0MXKJFFN3FJRLJP00NXIWK1WVKC4O8UBYKQA1');

insert into videoroom (vr_id, vr_title, vr_describe) values (5, 'FBWQFJJLLDVOOAO7 KBF', 'DDG F0CG8PI O2H0UKDR B08QOP1YN5HCO09OIF05PSXR2KR9QWK6DBHQ8YGG0LWLU2SVBH46CDLVDKXLFX8KIDH70QJ8GSWD9QK');

insert into videoroom (vr_id, vr_title, vr_describe) values (8, '2LI8M4EFA4ER4LADXBTH', '52R7830XGX41MK7V43C21IYT12PU17BSAVCCACR0HYK86UQOCW6N81R 4E4NWWIRI41AAFY3I7194XR482LARVOS8AL DG70NSHH');

insert into videoroom (vr_id, vr_title, vr_describe) values (11, 'VIGXB7EQ10GV H5WYVI2', 'AI8LIRIMEDVRC73QN6G9Q2F3UVM4 31 AQG044NEVOWATAYE 14JFGPXR38YEQXIE4U4G9 DJ7YL7P9BUE0WPLD2MXTF8U1GQMTS');

insert into videoroom (vr_id, vr_title, vr_describe) values (16, 'XLPUM7CV44KI3U7E42TG', '4GTYE7HPOAT7B5PRHY1SW4DOGW6TD14 AF48FX5TY8BGM43S7J6Y5AAXITTCJ4TYPDTWPEW96541WXCPTM06W15NBXADEJ6 LRID');

insert into videoroom (vr_id, vr_title, vr_describe) values (10, '8CT6SMQYLISH5HFK6ORI', 'BO0L52GND9WFU0KMTRUEGXMV8USLOLKPDM0E4D8NAKH1ATM7HTIXWYRJ9GIGB76L03OJWXA0XA3RQMQFLJO4AJ9OSSJCBCCEER6 ');

insert into videoroom (vr_id, vr_title, vr_describe) values (12, 'HYWLNIYSANWXDIPOLQ8O', 'U 3DLQ1 ACAHS100ONM9438708R4SATTS6 1N5U9JFF7UEKUPM0YNKC8BD0FE69E4J1 GMF9OL14HMLXJ6F0RAUMNTCNGWH3UJ6T');

insert into upload_video (vid, openid, uv_id) values (10, '7BSUVE2WV9EGWHEK6YDGSPTN CIIUXIFYDO', 2);

insert into upload_video (vid, openid, uv_id) values (18, '7F3GGF36N22H3XUAV23EYSDJ6Y1MU7KYUN1', 0);

insert into upload_video (vid, openid, uv_id) values (0, '9IWM51WXRKD9BN21CJV SS9SXBAMV4F FEA', 11);

insert into upload_video (vid, openid, uv_id) values (6, 'DDFF1SUW6HR MP231O TOYRWVAF940LCXEP', 14);

insert into upload_video (vid, openid, uv_id) values (0, 'J9NOKX3AV2YRF 3TKFEOKL5I4XKHIP7GTO6', 15);

insert into upload_video (vid, openid, uv_id) values (13, 'JYKIORMPQFH22 HXJU37MELWBVLF63NYG 1', 8);

insert into upload_video (vid, openid, uv_id) values (14, 'T5QS25YFVGU4HV2B63JTUXLUCLLR34H69P9', 4);

insert into upload_video (vid, openid, uv_id) values (0, 'T5QS25YFVGU4HV2B63JTUXLUCLLR34H69P9', 16);

insert into upload_video (vid, openid, uv_id) values (6, 'T5QS25YFVGU4HV2B63JTUXLUCLLR34H69P9', 12);

insert into upload_video (vid, openid, uv_id) values (18, '9IWM51WXRKD9BN21CJV SS9SXBAMV4F FEA', 5);

insert into upload_video (vid, openid, uv_id) values (10, 'XCU1TRKINDVK4B9VE0CDW57V68TK50V1NLJ', 6);

insert into upload_video (vid, openid, uv_id) values (9, 'XCU1TRKINDVK4B9VE0CDW57V68TK50V1NLJ', 9);

insert into upload_video (vid, openid, uv_id) values (16, '7F3GGF36N22H3XUAV23EYSDJ6Y1MU7KYUN1', 10);

insert into upload_video (vid, openid, uv_id) values (9, 'XCU1TRKINDVK4B9VE0CDW57V68TK50V1NLJ', 7);

insert into upload_video (vid, openid, uv_id) values (2, '7F3GGF36N22H3XUAV23EYSDJ6Y1MU7KYUN1', 3);

insert into upload_video (vid, openid, uv_id) values (6, 'DDFF1SUW6HR MP231O TOYRWVAF940LCXEP', 1);

insert into upload_video (vid, openid, uv_id) values (15, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 17);

insert into upload_video (vid, openid, uv_id) values (19, ' WCMA43UXF3MW74PA8T8RB414SR5QHNHRW1', 19);

insert into upload_video (vid, openid, uv_id) values (7, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 13);

insert into upload_video (vid, openid, uv_id) values (14, 'TIPF1J 5XM2 GYRBN2Q6FME2P7MOVT9PRD0', 18);

insert into create_room (cr_id, vr_id, openid, vid) values (9, 17, 'JYKIORMPQFH22 HXJU37MELWBVLF63NYG 1', 13);

insert into create_room (cr_id, vr_id, openid, vid) values (5, 15, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 7);

insert into create_room (cr_id, vr_id, openid, vid) values (7, 9, 'G3F2PYXUUJPSC1HFKVDGK3J7CAR31A7BHP8', 14);

insert into create_room (cr_id, vr_id, openid, vid) values (17, 13, '4 JOITHJDIPDWANASPBR0U55TV0R4M82GHF', 2);

insert into create_room (cr_id, vr_id, openid, vid) values (3, 10, 'NU5YM T64H1ACW0X5C534PIOCKGSWADOWU8', 5);

insert into create_room (cr_id, vr_id, openid, vid) values (18, 10, ' GOU3TKJSA0LUDR 1R966AC2J0Y7GFOR8P6', 4);

insert into create_room (cr_id, vr_id, openid, vid) values (6, 14, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 5);

insert into create_room (cr_id, vr_id, openid, vid) values (14, 14, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 3);

insert into create_room (cr_id, vr_id, openid, vid) values (13, 16, ' WCMA43UXF3MW74PA8T8RB414SR5QHNHRW1', 1);

insert into create_room (cr_id, vr_id, openid, vid) values (11, 6, '5GAAN7XXPTM2PR3FWQN 505579NJN8FP DI', 1);

insert into create_room (cr_id, vr_id, openid, vid) values (15, 2, 'TIPF1J 5XM2 GYRBN2Q6FME2P7MOVT9PRD0', 6);

insert into create_room (cr_id, vr_id, openid, vid) values (2, 11, 'J9NOKX3AV2YRF 3TKFEOKL5I4XKHIP7GTO6', 5);

insert into create_room (cr_id, vr_id, openid, vid) values (4, 8, 'PYXQG I05VSV0END78CKB 6HA9TDWL7SKYQ', 14);

insert into create_room (cr_id, vr_id, openid, vid) values (10, 6, 'J9NOKX3AV2YRF 3TKFEOKL5I4XKHIP7GTO6', 9);

insert into create_room (cr_id, vr_id, openid, vid) values (19, 17, 'TIPF1J 5XM2 GYRBN2Q6FME2P7MOVT9PRD0', 5);

insert into create_room (cr_id, vr_id, openid, vid) values (16, 8, '4 JOITHJDIPDWANASPBR0U55TV0R4M82GHF', 4);

insert into create_room (cr_id, vr_id, openid, vid) values (12, 14, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 16);

insert into create_room (cr_id, vr_id, openid, vid) values (0, 2, '7F3GGF36N22H3XUAV23EYSDJ6Y1MU7KYUN1', 1);

insert into create_room (cr_id, vr_id, openid, vid) values (1, 0, 'WV2N5Y4VAINKIYOGGSXUAHSU2BJ2 V3P0E2', 19);

insert into create_room (cr_id, vr_id, openid, vid) values (8, 11, 'J9NOKX3AV2YRF 3TKFEOKL5I4XKHIP7GTO6', 10);