sql文件

Question

sql文件

Opened this issue 6 years ago · 1 comments

Deleted user commented 6 years ago

你好，请问你可以上传你的sql数据库文件吗？

Answer 1 · 2019-04-25T02:53:13.000Z

`/*

Date: 2019-04-25 10:52:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- Table structure for account

DROP TABLE IF EXISTS account;
CREATE TABLE account (
account_id varchar(32) NOT NULL COMMENT '管理员ID',
account_name varchar(75) NOT NULL COMMENT '管理员姓名',
account_login_name varchar(32) NOT NULL COMMENT '管理员登录账号',
account_password varchar(32) NOT NULL DEFAULT '123456' COMMENT '管理员登录密码',
account_role varchar(2) NOT NULL COMMENT '管理员角色',
account_phone varchar(11) NOT NULL COMMENT '电话号码',
account_email varchar(32) DEFAULT NULL COMMENT '邮箱',
account_address varchar(300) DEFAULT NULL COMMENT '地址',
account_sex varchar(1) DEFAULT NULL COMMENT '性别',
account_age int(11) DEFAULT NULL COMMENT '年龄',
account_identify varchar(18) NOT NULL COMMENT '身份证号码',
account_photo blob COMMENT '证件照',
account_gradu varchar(1) DEFAULT NULL COMMENT '学历',
PRIMARY KEY (account_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- Records of account

-- Table structure for data_dictionary

DROP TABLE IF EXISTS data_dictionary;
CREATE TABLE data_dictionary (
id int(11) NOT NULL AUTO_INCREMENT COMMENT '字典ID',
bm varchar(10) DEFAULT NULL COMMENT '字典编码',
bmmc varchar(100) DEFAULT NULL COMMENT '编码名称',
dm varchar(10) DEFAULT NULL COMMENT '代码',
dmmc varchar(100) DEFAULT NULL COMMENT '代码名称',
is_valid varchar(1) DEFAULT NULL COMMENT '是否启用',
create_time varchar(16) DEFAULT NULL COMMENT '创建时间',
update_time varchar(16) DEFAULT NULL COMMENT '创建时间',
up_dm varchar(10) DEFAULT NULL COMMENT '父亲节点代码',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典表';

-- Records of data_dictionary

-- Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
user_id varchar(32) NOT NULL COMMENT '用户ID',
user_login_name varchar(50) DEFAULT NULL COMMENT '用户登录名',
user_password varchar(64) DEFAULT NULL COMMENT '用户登录密码',
user_phone varchar(11) DEFAULT NULL COMMENT '绑定手机号',
user_email varchar(100) DEFAULT NULL COMMENT '绑定邮箱',
user_photo blob COMMENT '头像',
user_status varchar(1) DEFAULT NULL COMMENT '激活状态',
user_level varchar(1) DEFAULT NULL COMMENT '登记',
user_integral int(11) DEFAULT NULL COMMENT '积分',
last_login_time varchar(16) DEFAULT NULL COMMENT '上次登录时间',
last_login_ip varchar(15) DEFAULT NULL COMMENT '上次登录IP',
user_register_time varchar(16) DEFAULT NULL COMMENT '注册时间',
user_register_ip varchar(15) DEFAULT NULL COMMENT '注册IP',
is_vip varchar(1) DEFAULT NULL COMMENT '是否是会员',
vip_effective_time varchar(50) DEFAULT NULL COMMENT '会员激活时间',
delete_flag varchar(1) DEFAULT NULL COMMENT '删除状态',
user_real_name varchar(75) DEFAULT NULL COMMENT '真实姓名',
user_nick_name varchar(75) DEFAULT NULL COMMENT '昵称',
user_education_status varchar(1) DEFAULT NULL COMMENT '学历',
user_address_divisions varchar(6) DEFAULT NULL COMMENT '地址区划',
user_address_detail varchar(200) DEFAULT NULL COMMENT '详细地址',
user_sex varchar(1) DEFAULT NULL COMMENT '性别：1男，2女，0：未知',
user_age int(11) DEFAULT NULL COMMENT '年龄',
update_time varchar(16) DEFAULT NULL,
user_signature varchar(255) DEFAULT NULL,
PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

-- Records of user

INSERT INTO user VALUES ('BCF8C1CAE0CE4E5DB53C120DEAE822FB', null, '123456', null, '1032089468@qq.com', null, '0', '0', '0', '2018-08-02 16:41', '10.180.20.209', '2018-08-02 16:41', '10.180.20.209', '0', null, '0', null, '青奎', null, null, null, null, null, '2018-08-02 16:41', null);
INSERT INTO user VALUES ('default', 'default', 'default', 'default', 'default@sina.com', 0xFFD8FFE000104A46494600010101004800480000FFDB004300080606070605080707070909080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C2837292C30313434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232FFC000110800C800C803012200021101031101FFC4001C0000000701010000000000000000000000000203040506070108FFC4003E10000201030302040306050205040300000102030004110512213141061322511461710723328191A11542B1C1D1245216337282F0254353E162A2E2FFC4001A010003010101010000000000000000000000010203040506FFC4002D1100020202010303030109000000000000000102110321310412410551612271B1A1233234427281C1E1F1FFDA000C03010002110311003F00D5232548EE0D3A57500E38A2BC3B081D4510A2B0FA569A6661C380D902B8EBEADC0F349AABAC80F1B69E2EC299EF4B80082467F4FB570FA0E4D29100339C0AEB14079C1A563112FCE79A01B7F141B04D47EA9ACD8E8D179B77285E32107E234EC0910FB0ED35DFC5CD665A9FDA892C56C2D1703A348724D37D37ED0F5695C3CA917947BEDC67E9FE6972146AB86CF2697121518AA8DBF8E6CA48D5A58981C73B4F7F90AB05A6AF67A9408F6D303BFA06E0FD2901291CD9E284ACA720D36890A9C973CF6A5B6EF3C67EA6800A1B68E00A02422834780493C0148F25720D02163283C30A1BD40C28C522AC49C6334189C81DCF6A003B39C1C520C7B03C9A3224D24C13200EF4F6D624F506505D4F5A0637B6B32C77CC323B034FC0006074A528A46280395C3D2BB42800B428933F951337B50A0089F34B3726B848009349A83BFAE68F31091926AC428A4B2605031C91AE41E69B09F0BE8EB4B23CC579A180752ECB93C5032ABB63BD289C8233499444DC4E06075F6A9B404578835C8742D31AE5F0F2B1DB0A13F89BE7F215856B7AEDD6AF7AF2CB31619CE4F4FAE3FA0A98F1C7884EB3AB49E4B9302E63880ECBEFF9FF004AA63C8074E42F4F99A5C97C6874BB4A7AC90B9E57BB1F9D2C2ED83924F4000FF1516673BB939C5704C776735A2744B44F457D2070DBC8CF19CF41DEA6ACBC42C2654624443B7CF3C9AA609CEDC679A5229C893393D0F4F6A69A6268D9F4CF1E3DB6C8EE079D6A30A6466CB83D78F71D2AFD677D15E5AA5C5BB8789C643035E73B4BD31C0739FF00999C83CF4ABAF82FC50DA6DF0B39E4FF004F3118E78CF63F2ACDA19B009976FAA9162D21C28C2572360EB9001068DB89A4028A0C472318C7349C69BE7321FA0A3382405278EF47DCAAA00ED4082C65967638E00EB4ADBC99DEDEE69B3CA49C76A20B8D99E080393C5032551F35D269947729B32AC1874E0E68DE716E9400EA8537121240A519BD340063B5860F4A14DF7119E68500476CC1C8A24CBBA26CD2FC2F4A23E0A915621A5A2E464FE94E6498C5196C700572242A293BE72B6A6861C20D6F2348BBC77AADF8FF005A3A5F878C11B11717998C11D42FF31FEDF9D592D0116EB58F7DA56A6D79E2596D95BEEAD9445F43D5BF73FB54C8A87C9469E4666383CB753EC2994D200C1476A7134854363BD309321F9EF480E337EFD682B739ED9A4C9E335DE98140C543F39A5EDF2CA4D3304D48DB46459B3FBB6286C287F1EE3144A3BF34B5C3BDAF9673820061F43CD291C3E55B47211DC1FD9BFC51FC45188442A786589411F962A54B65B852B36DF03EB0757F0DC4E5F74B09F29FDF8E9FB55917AD649F64B7EF16A77B62C70AF10700FB83FF00DD6B80E45519301639A231C9CD1F02B9C7B5002249068C3AE68CC01AE8031408692EF8DCC91FE1C65A355E58FB8F9FF5A716D36EC32B078A5398D87620720FE87F7A502E4533BCC5A5BCD7196F2F1BA40A37107B381EE3B8EF40124870B935C6958D34B596536CA939DD2AF0CC0601381CD75E6E70BCB7B0A00599C9EF42A3D65B91723CCDBE591FBD0A00704E693B990AC3E81EAAEBF149CD32C6A33CD580A5B990C40B0C1A17481A0E7AD3A88868871D69A5EA37014FCE95EC3C1D7B88ED2C1A69080B1A176FA019AF38EA776D777B35C48C5A495DA4727DC9CD6D3E30BB92CFC2F76CDC348A225FAB1C7F4AC22F64C1D83F3A87C971E06A499660A072C700536B93F7CD91D0E29581CFC5EFFF0069FDE9B4C73231F7A3C8FC05FC58AE67BF6A1D87CEBA07200ED4C475572EA2A74C2F059C237AE09DD822A3F4DB56B8B8031D3FF3FBD5BE6F0E5F7C6AC76E9E798D439CF3B41E8083F4A86F6690836AC6D6915E4B25B492D8C8D029CA2E30AE400324FB527E29B7B885219EF1BEFAE24E1070028FFC02B53B271A5786CDC6A2B18F222DF260719F9564FE20D5FF00E21F13C66250F022ED50BFCDC649E7F4A98BB65E48A8A2CFF66619FC648E3A186463F4C715B728E2B24FB28B090EB17F76E0AF95104FCD8F4FDAB5A4520E0D6A7330C3E75C6207029465C7348E32D4080324734CD9668EFD53CF220742554807D5C71EFD327F5A7B2482342C41200C9C5309AE6D25963DF701707700CDB76B0FDBBF4340D0BCF772DBC5BCC3BC0396287A2E3AE0FF004A46790DCD8948E4F29E55C16DBBB66467241EB4A34E25D3DE40986236943CE1BA60FEB4258219E2B8B6B850D13039CF036918EBF950000ED1E96AD146ECDB4955E0173F9FBFF7A6F05CC8D786030EC1B43060771CE390D8E0104FBF38A76B133C51C79548D102FA79278C75EC2905D2AD60B28EDA332436D1316DA8E40F7C1F9679A4EC6ABC8F2581645C50A6B6F2345712A195E5842A057603D23692496CF39FA50A62A0EC85B914D65819A552DF847614FB7639ED5DC2C94D3D88EC6C30074E284A01E6BBE58ED4470CBD7A51E40A07DA95E2C7A759DA29DA647695C7C94607EE6B14B9932CD21E093C7CAB43FB4CBE69F5F923C10B122C4BF9727F73FB566B76790054AF7347C502D013E611D02E6919170C6A42C60C59CD211D401FBD339C7ACF6A49EC1AD210C64814645C91C5740E4D2B12FA49FCAA85458FC336FE65CC2A572188240EFEACE3FF00D6B65D3AC7E1AD8B4B833CA7CC94FCCF6FA01C5679F67B63E7DE999FF040A08F9B1E95A64FEA40BCE0F5C573CDECEDC6BE9434D62C46A7A16A162846E9ADDD57FEAC647EE0563FF677A68D435E90CAA0AC36CEC4374DC7D23F73FB56AF3F89B46D227952FEF2081A150C63F3373B03DB68E73551FB2EB15B98756BA51B639660992395419623EBCFED578B831CF568D0BC1766B6FA75E4E102FC45DBB29F751802ACC58019A6FA6DBFC369B1464007962076C9CE3F7A73B015E6B53999D0FBBBD73386C5051DEBB9E6811DED4D2E36C4DE732C9229010C6064633C9C53CDC338A8FBDB2925B9B7B98046668895FBC276EC6C6EE9DF038A0A411AD634C3D92B458903BC6A842C9F518E3EA3DAB8F317BE89151E543BA3930014F7C9E7FCF714E269058AC6146632C2355E7209E833EDF5FD69A5EBC076BB2CB1E641B9915B0C47B95FEB47208716575F10B29098412954E0F2B8073CFD4D3970194AB0054F507BD42D9DC5E7C65D4E33710BBAEC465D8C833838E7040C67A02735213DC6F77B7864C4C072DB7213FB67D8502634C876BB8ADE48416B8DB2679DA02A8DA00EFF00B62853A4B42A43798EEE3ABB9C9F6FA0FCA853A0BF6177CE36D08D083C518900FBD1A23BF9A108385C734576C9DBF9D719896C03465DA8189E4E3BD203CFFE3973FF00115E28CB1572A33EE7AFF5AA6CB69704EE304B8E80EC3CD6D2FE148352F1A6AB2DE6F30C25665238C96E464FE46A5A6D240110DACDCE49638C7B7F5353E0D198AA6D8B4FF2CAB2B1C64118A879402CFF002AD9BED12CE38B4312F96B9570B9FA9158DBA8F264939CEF029254372B4220719A776B11931819C9E94D01E0FE9565F0A69E9A86AA96ED32C6F82E9BFA310385FA934D8A356685E11B3F81D3C1C61A4C33525E20D7F5AD11A69736CD6A0165263C1C7B673D6A52CEE2DECAD87C54B143B54125DC018233593F8D75A5D735D91EDE567B28808E1E4E18F76C7CCD6118B6F6772CB1C4AEAC88D53529759D5EE75095023CEDB8AAF41C01FDAB75FB2BD30C7E0CB7770556791E43F319C7F6AC0A18CBBAA81CB1C0AF54E8768BA5E876367803C981108F9E39FDF35D28E06EF64B39005265C6DC51598919A22F24024027A73D6820503ED1499739E95D69046503038660B9F6CD375BD8A696148A399D652C0388CED52BD727B50349B1D28C8CE6B86464466542E47F2838269A5DB4E9B16DDD158BA86DCA4E573C81F3A75E6AC7D680A196A0D3EF4DBE851862E54E1979F4633C9FAE31C574DCC724134531DA1909542BB401ED9F7CD2F04D1CE45D28914BA6D01891E9CE41DBD89FD69765568D8CAC3CBC1DC18FA48F9D03BF62A9A8DB4FA4DEE9B756D79EA95D2D2E4CAE58047E4301DB057233C7A8D4D5B25C967795D0C24831007385C75DDDF3D7FBD436B5A749FC1AE05B926F2095258D50604BE590C8083D8E31918E6A5ECF54FE20D18B7858DBB160D20C32E4630B90783C9FD28E03944921CF18A15C50CBD3F434286488B32839EA7E75C567452D9EB4DE61B189C9A11C8F8E4F1561648DBA868B71EA6985DEAD676B39B7927433E33E4A905B1EF8EDF9D2D14E4FD0567BE29D4E569AF597679332A881F0B938C82548E4E49E86B0CB3EDE0EBE93A759A74FC168B2B94BEF105C988379525AA06CAE30C1BA1F9E0D4BDDDB79B6D22AF0E4707E63A5677E10D656F7C59041024DE624652556C9C285EA4FD6B50F2B29EA269C1B71D93D4E38E39D45DA293E31B56D53C2779E5AE6458FCC0BDC329C91FB11581B9CDACC00FC2EADFDABD4179A5B485E4B7976B37E2461E96FF07E758378D7C3177E1ED56591ADCAD95C93B5979519E719AB30454F69DC0019CB7157CF0B683F1C1648DDA3BA80892361DC678C8AA7D82092E6007AF98056B7E17B6F80D6EC47FED5C452400FFF0092FA867FED2293435A293E3D59A3BC586E170C32EB81C73FE338AAACB6E638CA918F297737D58F02B7BF18F85EDF5BD3773A319621C32FE2DB9C91FB66B19F115AC96B7D79BD36F9F73BE23D9A323823E5FDE8E341638F02E90758F15D940537448C2497FE95E4FF00615E9254DEB93C64D663F63DA42C56379A932FAE4610A13FED0327F722B5203E74C4C4E4922B65512B805CE117BB1F603B9A48AAA38B9B968D1941D819801183D79EE4F1934945751DCEB0C3D2D1C510F2640EA54B127763BE40C03FFDD23AB6B51D8093CDB467548F7990EDD8A3206589E8327DBB503EC77472E85F6A16D3471CB6F6C0484798BF7A7CBC70DD82B67EA38A4F4888C82EAE0CAA6724C4258E532295C655B078C9DD9E38A4EC2182D1B6CF6B6CBE7CE0225AC6C42B32E5B71F6CE793818A2C1341A642F744BAC383BA0C83E585CF0A075C0EDD874E9492B29BA5483C739B7BF4F88B8595430B7DEE42FDE15E4803B9C631DB9A24F7F24C7C84B5996495D222C5D405539CB8079F97CF8A35EC97368F8D3E1B795982331989C000312DC7CFBFCE9A582C422BBB912DA49109E32B2A1C380AC095627D81FAF5E94B761AAB27B66CF963F6A4E6BEB71015606656210AAC6581C9FD2983C925C49315924DC73E5828D2089BB311D1877EBC53B12452C76F05E186795886D8571EA5EE14F4E4551084B50BB8D8496E23F2E568832F9B85DC376D000F7DD8EBEE2A3BC29E79568A61345F0924C810E155C33EE56DA0609C1233F2A7BAA5AEE36F772FDE6D99219D4EE50B1B9C371DBAA9CFC8530D3DAE6CFC4F71A64E53E1EE2337114806D2EAB8509D73E919CFD7B5008B46E0C09520FD2854742B72903916F6F14A1C9DA8E595C741CF63803B75A1409A1AAB35D4A1474A94F865540B4DED6D844865239A72252FC81556C42176F1D9584F338DC238D988F7E2B27D5A18ACE2D36CE28B6191CCC841E884138C7620E39EE2B4FD79646D0AF156367768F6AAAF56248E2A87ABC6FABF8D2CAC1415C8D853706DA070DF4039AE4CC9B9A47B9E94E305DEFDF7F654593ECEF476B5D3A7D4A54026BD9329C72225E17F5393FA55D4A862067A512DE2486DD6241B5140555F600714A01FA574254A8F273E579B2CB23F2C4DE2F634DAEEC2DEFAD9EDAEE049A17E19245041FCA9D36ECF1401F7A664641E27FB2892D5DAFBC38CCC01DC6CDCF231FEC63D7E87F5A5ECAF4CBA7D95E2232496B7092C88460C6EBE97523B654E7F235AC30E39E45406BDE1D8EF926BBB20B1DF14C127F0CC074571DFE47A8FA7140D3249765CC21908C1E45543C5BE0AB6D674A9628F6413C64C90331C2ABF704F653FB1E695F08F896DAE613A7DCC9E4DDC27618E63B5B238C73D4F6A7FE24769AC6EEDA69203693426111F495A6278033C72071498E29DD107E123776BE1096D74D8124BA59C4656493CBF2E4C0C96FA1006075AB4C139D527B6D9E608C2319DE39F66C7E9B193AF5CF3C631557D1E2F2A6596E5629AC679A3F8D3347EA4B8541B5F8E00C9C67A0FCEAC179341A2DE5C5D244A06A442798AB9FBFC6D50C47623F420FBD35B1BD7034F224FE2C93C5616CFE4A06568DF32C61C1CFA7206738393EF51B7D717305D59B4D7DE54B302B2C9200E98255595460150382720726AD1A8DACB69A4C8F632F9571146BBA51107791507E1E7AE7F6A80BE5D9A15FEAF1C91C7A8BC08F327A774792A50E4F43C0F91F6E95348A4DBA25F4B974FD22C24493518E67836452CC5B2490A00CF249EB51B756EF0EB73089638ED49334AF2CAA23C3104B6DC67771B41CE2BAFAAAF88341BF1642EA3B88E351E6AC403B1C64E41E064E41C73D7150935F79567B7C816A610D16F672CF20DB9C3161C824FED49FC0E2AADB26628DF509B6C7751B5B3C6EB25A6E003A1CF96B9EABC9EB9A60F717B61A8359DECF079690B48D1CB6D848F6A12A448387C7738A42C9AE357D66326F2284794A54DBA34726D5E76E0F0410319CD4BEA372DFC5AD278042CD18936CD73E98C650A907BF51CF18E45555EC56D6993B05DC8DA74533AABC861591D90911F4C9209EA28B6B35ADEBB1B9859F31ABACB346363039F4A93DC639029A5A5E413DACD67653C4EA4B0819395C1382BF5539E3DB1523E421892391118201818E011ED4FEC66BE46F3E89A75F59C88F13AC520C0D92B8E3A83D7DF07F215097ACDA83DBDC5D486CEE749BAF2E4B90540DAC982C327F0B657E60F156AC92A00E9552F1C40D068FAACDF0ECF04DA73472957E4B861B3D38ED9EBF951F0243986E6E21B88E6B876B8C0096C648DA377562033150060838072381CE79A15136BA925EF87ECADAD5E796F20F2E324BAF9A55800E00FA123DFD3F2A14D5329D97C97123796BD28E11215FA53685C97DC7BD2B2A6F230DC5364111E20B9BA368A96903C8ECDD533E9F9F1D7AD40786EDE3BBF1F5EDC2210963682352EDB98BBB1C927DF00FEB5784B740B55FF0008C0A1B55B958E35F32E15415EA428EFFAD60E3FB4B3BB1E4AE9A492DAFF003FF0B5E3118F7EF41880302813E8149331E95A9C2067345E49E2BAA7F7AE671D6800C0E460D158EDE3DE866BA4065C1A00A2F8B3C1B05EDCFF0016B697E1AF036EDDD14B7CC8E99F7F7A4AC249EE259E3BF2D3DC2A622920004C1D5495C1E85B05B079071C55F1BF0906A36E74982E184B07FA6BA565659635009C1C80DFEE1F234A8BEED14E3E7F87F523B0CCD6D2FDCF957710C4CE5785DDC0CE5BD47A1C0F6351D2B5C586A30CD2BE6D81923489653BD5002C8580E0609EB8CF156EBD8AC2FA796DB558D60BC9231186663B5D41C8284F0793C8EBCE3A73558B6B5FE1BE2AD3AD6E2F911A6495630CB9D8595BAE7F1A92782791D0F3534D1A7746B81C58789AE75191DEFA59BE18C0C446ADB41456C9C9EEFC0181D4135CBBBBB1D6443792ECB692E0C905CAC649FC0B940CBD76920E7E9D6A1AFAD8E85A86D291EA115BFA904ABBA37DC3D5C0385C139E7E54EF46934ABFD463B79B4B5F364047C4A03903963841C743B7F4E29277A347AFA92118AEE2875432F9CB72046D0B4513B61B00AAEDC7E325777AB1C7A73DE9E6A7FC3EE748BFB985268226B8581A17424B1390ECE7A8EA78CE062A1EF7E322BE8D34C4F3209E5536B9618233E951900A13C8FF0018AEDBDFB995E68D161373234777BA525A22CE57CB63D7185E49FCCD01CBA44CA4173AA786AD2E64BAB89238444912C48CACAEA781807381DD87B669BF896592EEFA69EF2167B795162B69A161E5B0C024B3638620F4C75A4DB55BDD099B4868E18E0551106190B1923779808EF82483D383ED4EB42BF7B8B5B9B0B5675D3C1DD124C03BBAB1D8B863D42B2E430E79038A13BD09AAD933A7D85D5AE8B64D1DB5B7C4A4A665790FDF31E4649C000F3824FF002D4D5B4D72F7371E6A5C02B88D226652A464E5C773C7EA3B75AAB5A349622E8AFF00ADB353232A5D48CC521FF7AE39DB9C8230704023AD349757BF8F4481FF0082C905B471992439F30CD86DB180C7D432C460F3D4704569F065B7B65AE1D69A7B596F239123B74959132BCBAE42AB7C8EE0FC639E296D7ED6E2F2D2E60B9588DA18D9A2642C245655C9CF63D38C5406877F63FC2EFADACAD9A328F224E2452A632132D9279E0E7E85BDB9A92D62FF00C8F88C19894215A3770E8CA508F481C8C824FF00DB9F6A09D15DF0DF9EDE1B4DF69323C61E7371105612364928CDDBAE7A8E4D0A7BA569D3685E07BC5D42D56D659A66F3097DDF705B20FD429231D685251654A76CBA3C984010522AF3138C9069C85017A511BA71D6B43202BB85C16E6A2FC1F0C96B0EA76F380255BC2C4641386452338F953E0B216C9381558F06EAA65F157886DE59559A799668C8C7202818FD0AFE9512AEE474E28CE58A4A3C69FE4BFE7D19A4FAB5773E915C5EB41CC748AEE372E7DA81EB40100D00279DA68D9E283AF1914456EC6800C47069BA9C363D8D39A4255C1DC3F3A0061AB5826A3692C1295F29D48605013F504F423DEAA3AC6817B26970CF633A6A135BB2DCC26601A5665EAA24FE653CF06AF04EE520F39E0D55A3D4DACEF1615B64F83798C31B5B38748F1D33EC49EDEFF95265C7822AE2DDBC656725D692B3C3105DB2095CA6580C3451A741F363C6703DC8574EB54D3F489D6311B89D3CBF869943986551B7D4081B5BF0FA9B00E7923A93DCE9B25AEA2D3E81A83DADC6A05C3C0632D03381EA624731BFCFDFB547EA77FAC6990AA5FE972DB4FE498A6BD89C1F8867CF1B870C31D98123DE9696CAB94B446DC443CDD30DCDD85BD6B9580ED266907A4EFF0047B00703E9C1A8F8ECE5D2D26BC49D52149248CA6F21A45CE01518C1E3A8CF635DB1D6CE9FE2886FEE962B6DA150C4B00CAC438F4AF5CE07BF7CD683792C1A8E996DFC3512E2D67731A96971192C0E495E738E4F3820D24BB915DCE12B2A171258EAD7A6ED6E5EDA1D8916E97B20E1471C1DC0E3E946D36D9ADED316D7D0DD6A08658C42CC888AAC776558E3A10480318A3E82BADE976B73A5D9411422EAEDD2DA799392E9805016E071B8A9E7A1039A4E6821D14E2E2194E9923CB099648C0785B70C3364673F84E7DB1D31424EF6536AB4899D6AEECB59D1E256D4E2B1BEB642D149B4A3070A410A39217B1EBC7D2A9F6D7F2DBEA56D6F217590CA5A416EADC9453B769C9DFCED61C0E467DEAD1A7A1D5932F04B31646858B48A67591595588C8C6D1C3100F39CF39E1A5E7872FEEB53952EB5048EFBC958BCF545092444E1C93C10FB70707AE0E09AA33E357A05F5D5CDD6A79B292484DD2F92DE48479030F547B8EEDADBB249C678EBCD4B26971D82DBBDF693162462B2986F1BD4A5483B813F4EFF002A77E23D160B0D16F65B73F729123A69EAAA10C88CA415EEB9008F9E6AA9E23D56E3596B55B6B59956DD9D3CA99879833820B03D1540CE4FE749CA871877E90A0D6ECEFBC473C2D1B45630490C90A15624F382195B9C9EBDFF009450AADDE6AA750D6ED6CAC6E4DD4290C677792146F5249C7765ED96CD0A4E75C970E9DCB68DDFE203B94AE21F298EE19CF4A6120904E187BD48EF0F0E0F5ADCE54237B308ECE57C0FC0DFD2B15B5D4A6D33C433DF5B10248AE4900743C723E87915ADEBB725340BD0721BCBDAA47B9207F7AC56424DEDEE4E4FC4373FA57267752547D17A26352BEEE1DAFD3FD9BEE93A9C1ABE9B05F5BE7CA957383D548E083F43C53D5EB551FB3C97CCF0944BFF00C73C8BFBE7FBD5B01AD93B5678DD56258B3CF1AE1362A7A0AE574FE115CA6738291914AF3DA96E9CD71B0460F4A004D5B22BADD29171E5B70720D743FBD00252FA73F3AA9EADA625B190C4D3086E9B6B431421D63623FE601DB919279AB6CA37023BF6A6459D6096658CC922A9DA80E0B1F6A4D171934CAF59345780C4F34F345B312CEF0EC2F8E419003C83D338078EBCD2BE2ABE68AD556E34D57163347299987A4E7F9909FD0F5C6691D695ACE58B516B69DE5BB4586481504983D71CF0A31DFF00CD46D9A1BD824BAB8BA9A786298E2D449848F0320738C678E9C0E953E28D6BCAE04FC59626786D6E27D26E036A042C823903C51B12C40181CB1241CF03E7D6AB1189F45D47FF004ABA9E3B95DBE6419124465C10EBC7071D88ED9EF57A4B87D73C388746B8BB8B60FBE8571243B8E48505B927207009C1238A6FA368DA35D699F1D7B7E826BA5398BD3F752673C7192C0755EF93F2A6DBF024A3FCC364F1458DEC52787FC4F18B491A4F312EEDDCF95BF3BD4AB7F29191FDF14DB5AD4AE186A1A7DF4EF3DAC32AFF00AD58C1138F2CAF96DCFA491905C71E9A8CF114845E7C2EA568258ADCB490333BC7F1111E362923F0AE490C7A00168B6372DA2DBE95AADDFC3DDE8F3C42192D43F98F6EAE0E46C278C9F51C7D38EF56675B12F016B11681ACADA6A67CBB7BBC88E59463CB907A4649E4640DA7E616AC977ACD85EC3E20DEAC527B88228F2987056318207F2E0E79ACF7588EDEDE489E24925D0EE6E0B42EF20F340E8E87073EC4647240F9D2DA7DD496771716AB2199641E6AB48E32C870013F3C01C67B54B968B8C374CBA24EBAB5A5B4C6D2E6DE4F5C571B9494331FC2E7B1EC7B726AA9FC62FBF86C7A66C08B285339C7AE66EE598F2791D3E552B078AAEEEE65D32011456EC63DEAB8881CE01766079E9CE7350B77106D292E23605E0BA91242A7380CDB8723D89FDEA25B37C75165BFC2DA05AE95AD5CCF71217BE58551955B88B700D8FF00AB07AF6A14878224B0BDB31791E56F4C9B2E24DC72E7DD81EBF234292935A2A718BA6CD26E1493B9451E352B1063FA5270CC19CA9239A77228F2F8E95D479E573C597023D0581E0B4F0A8C7CDC56388FBE7BB7FF0075C3D6A1E3C973A45AC484067BD880FD4D6556A789F9CE667E7F3AE3CCBEA6CFA6F4574A0BDFB9FE11AC7D995D07D22F6D7F9A29C3FE4CBFE56AF5597FD98DC05D4AFEDC9E64815C7FDADFFF0055A7839AD71BB8A3CDF57876F572F9A7FA0B754A00122B80FDDD7532C783567981C0C8E9CD11D091C1C9F6A3B1C702B8781400D65524608229BEE22A47CCFF0070A4DFCB707280FE5400CF3B86688CB871EC6972027007144721871D45031B5D466481D15B63153B5BAED3D8FE55548E0B8D3B46D4211605DA2932D2E0FDE7A73BF03F1738C85E3B55B1E419E29304FBD26ACA8CA8A99D4224D32C6CED84F77A92942F3043132F20ED38C648ED9CE3151DA8C97B16A82C249CA5B4972D71117B60640E548C70304E7DB156C934EDF7B2BDC5C35C5ACA771B69943057041054F50063A7BD455E98B57B4B533182EA686E8ACED01281406E719E4E38E9DEB3766D16BFB94FD560D666D7D21B99B7CD711ADB8666CA90CBB88EB9200C13DB351D62750B9B4B9B5852CE4B65E55362F984B36D5DACCB9209EC082722AE1A303AAF886EAF0A16B589640DE64650066C007E64AE73F202AB8F7D6B6BACC31B462E74C32AB2A244632CA09C03EE17D27E78A1CB76351D76D10FAC591D1EEE13145EA4B5CDCDA6A1080771241DB9EA3E60E462A2B47B68F51BA9115BC8D8A645239653D029E327248ADAB56B166924BD8BCA9498C2CB6F7217CA9101279247A4F279E9542B9D23F876BB16ADA069FF000BE629012F906C8D8FF32AE738EBC7E9C53D22236D94EB799F46D593CF5D82190C52AF50A0F51F307A8FCEAC3A64903DD5FE9254470CF26226EDBF68207F4FD29F5AF812DA50D3DFDEDCDCBB8E76811A904E71DCF535270F8574E86D9EDD2DDDD19D6462F212DB97A1CF6FCAA1CE26D0C13641782E7D3ED34DB96BAB9963BC5B96F2A28D0905811824FD722855DAC748B18E2C45636C083CE231D7FCD0A976F68E88CA305DB265C12105C321C5293CEF1C6500C9A142BB4F27C141F1F16874CB2772771BA561F2C026B36D3DC9B6627AF98D9A142B933793E93D2752C7F697E4B5783B524D37C4F632487092C9E431FF00AF81FBE2B6C142855E1FDC39BD77F895FD2BF2C557F0E28C0ED18142856878A701EF5DCE6850A000690B8CAC0E5464FB0A142801A2C8597FF38A29906EFA8A14280119300EEEC6B88ACDF8471EF4285265AE08ABCD62D3E285B5BCC935CB31558D4F008EBB8F6C527736B6E2DA14BCBA9412DC4AB218F2C79E36F03A7E9428567C9AD534124B68A309A6DFDE3CEF301E6215C1624B6DDC570304120FD055675786EA7D42086D2D845636C82184CABE5889F3D46796C151D3DE850A2EDB29AED49FB93B7172F3DBA4F3BC85063109000DE3A87C7E2C1C63B77EF51533BDC4C6490EE24E79A142B1C8F7474608A51B178CB4BE8C1C1E38A61796B05B9DB36A570C09E2233373F41428542377A24BC316F17F1011C31B42240465C6DDFF00950A142BAB13D1C1D5AFAD1FFFD9, '0', '0', '0', 'default', 'default', 'default', 'default', '0', '0', '0', 'default', 'default', '0', '000000', 'default', '0', '0', null, null);
INSERT INTO user VALUES ('E9AE2235B8784B4D9DEE713CC8719536', null, '123456', null, 'zhangyule1993@sina.com', null, '0', '0', '0', '2018-06-29 16:40', '127.0.0.1', '2018-06-29 16:40', '127.0.0.1', '0', null, '0', null, '人鬼殊途', null, null, null, null, null, '2018-06-29 16:40', null);

-- Table structure for user_download_video_record

DROP TABLE IF EXISTS user_download_video_record;
CREATE TABLE user_download_video_record (
id varchar(32) NOT NULL COMMENT '下载记录ID',
video_id varchar(32) DEFAULT NULL COMMENT '视频ID',
download_time varchar(16) DEFAULT NULL COMMENT '下载时间',
user_id varchar(32) DEFAULT NULL COMMENT '下载者ID',
user_nick_name varchar(75) DEFAULT NULL COMMENT '下载者昵称',
download_ip varchar(15) DEFAULT NULL COMMENT '下载地IP',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户下载视频资源记录表';

-- Records of user_download_video_record

INSERT INTO user_download_video_record VALUES ('54E77AF7D1564B8494B96B12179CF02C', 'DCF7036F0A5D494587568921A742FFA0', '2018-12-26 10:11', 'E9AE2235B8784B4D9DEE713CC8719536', '人鬼殊途', '127.0.0.1');
INSERT INTO user_download_video_record VALUES ('C6284D49B1A8447B90A20EFA04499094', '9348F1A1882F4B8F83132FDEEC052891', '2018-08-02 17:25', 'E9AE2235B8784B4D9DEE713CC8719536', '人鬼殊途', '127.0.0.1');
INSERT INTO user_download_video_record VALUES ('DCC1C49D7B1A4D7AB8124A18F527DD42', '64FED028DC8C4854B56893B936F155B0', '2018-12-24 18:11', 'E9AE2235B8784B4D9DEE713CC8719536', '人鬼殊途', '10.180.12.109');

-- Table structure for user_infomation

DROP TABLE IF EXISTS user_infomation;
CREATE TABLE user_infomation (
user_id varchar(32) NOT NULL COMMENT '用户ID',
user_real_name varchar(75) DEFAULT NULL COMMENT '真实姓名',
user_nick_name varchar(75) DEFAULT NULL COMMENT '昵称',
user_education_status varchar(1) DEFAULT NULL COMMENT '学历',
user_address_divisions varchar(6) DEFAULT NULL COMMENT '地址区划',
user_address_detail varchar(200) DEFAULT NULL COMMENT '详细地址',
user_sex varchar(1) DEFAULT NULL COMMENT '性别：1男，2女，0：未知',
user_age int(11) DEFAULT NULL COMMENT '年龄',
PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户扩展信息表';

-- Records of user_infomation

-- Table structure for user_upload_video_record

DROP TABLE IF EXISTS user_upload_video_record;
CREATE TABLE user_upload_video_record (
id varchar(32) NOT NULL COMMENT '上传记录ID',
video_id varchar(32) DEFAULT NULL COMMENT '视频ID',
create_time varchar(16) DEFAULT NULL COMMENT '上传时间',
account_id varchar(32) DEFAULT NULL COMMENT '上传者ID',
status varchar(1) DEFAULT NULL COMMENT '视频状态 0：合法，1：不合法，2：删除',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员上传的视频资源记录表';

-- Records of user_upload_video_record

-- Table structure for user_wallet

DROP TABLE IF EXISTS user_wallet;
CREATE TABLE user_wallet (
id varchar(32) NOT NULL COMMENT '自增主键',
user_id varchar(100) DEFAULT NULL COMMENT '用户ID',
pay_password varchar(32) DEFAULT NULL COMMENT '支付密码',
user_real_name varchar(75) DEFAULT NULL COMMENT '提现姓名=真实名称',
user_identifiers varchar(18) DEFAULT NULL COMMENT '身份证号',
balance decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户钱包表';

-- Records of user_wallet

-- Table structure for user_wallet_log

DROP TABLE IF EXISTS user_wallet_log;
CREATE TABLE user_wallet_log (
log_id varchar(32) NOT NULL COMMENT '日志ID',
record_sn char(20) NOT NULL COMMENT '交易流水sn，关联wallet_record表',
user_id varchar(32) DEFAULT NULL COMMENT '用户ID',
change_money decimal(10,2) NOT NULL COMMENT '变动金额增+ 减-',
balance decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变动后的金额',
remark char(100) DEFAULT NULL COMMENT '备注',
create_time int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
display tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否显示 0不显示 1显示'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='钱包变动日志';

-- Records of user_wallet_log

-- Table structure for user_wallet_record

DROP TABLE IF EXISTS user_wallet_record;
CREATE TABLE user_wallet_record (
record_id varchar(32) NOT NULL COMMENT '自增ID',
record_sn char(20) NOT NULL COMMENT '交易流水sn，ymdHis+2位随机数',
from_user_id varchar(32) NOT NULL COMMENT '支付方UID，0系统充值',
to_user_id varchar(32) NOT NULL COMMENT '接收方UID，0系统提现',
type tinyint(2) NOT NULL DEFAULT '3' COMMENT '交易类型 1充值 2提现 3交易 ',
money decimal(10,2) NOT NULL COMMENT '交易金额',
pay_type tinyint(2) NOT NULL DEFAULT '0' COMMENT '支付方式 0待定 1支付宝 2微信 3银行卡 4余额',
remark varchar(100) NOT NULL COMMENT '备注信息',
pay_status tinyint(2) NOT NULL DEFAULT '0' COMMENT '支付状态 0待支付 -1失败 1成功',
pay_time varchar(16) DEFAULT NULL COMMENT '交易时间',
fetch_status tinyint(2) NOT NULL DEFAULT '0' COMMENT '收款状态 0待收款 -1失败 1成功',
fetch_time varchar(16) DEFAULT NULL COMMENT '收款时间',
check_status tinyint(2) NOT NULL DEFAULT '0' COMMENT '对账状态 0未对账 1已对账',
check_time varchar(16) DEFAULT NULL COMMENT '对账时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='钱包交易记录表';

-- Records of user_wallet_record

-- Table structure for validate

DROP TABLE IF EXISTS validate;
CREATE TABLE validate (
info_id varchar(32) NOT NULL COMMENT 'id',
info_answer varchar(200) NOT NULL COMMENT '答案',
info_question varchar(200) NOT NULL COMMENT '问题',
info_state varchar(1) NOT NULL COMMENT '是否启用',
PRIMARY KEY (info_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='验证消息表';

-- Records of validate

INSERT INTO validate VALUES ('1', '2', '1+1=？', '0');
INSERT INTO validate VALUES ('2', '6', '1+10-5=？', '0');
INSERT INTO validate VALUES ('3', '奎', '罗', '0');
INSERT INTO validate VALUES ('4', '白', '李', '0');
INSERT INTO validate VALUES ('5', '14', '12+9-7=？', '0');

-- Table structure for video

DROP TABLE IF EXISTS video;
CREATE TABLE video (
video_id varchar(32) NOT NULL COMMENT '视频ID',
video_name varchar(100) DEFAULT NULL COMMENT '视频名称',
video_title varchar(200) DEFAULT NULL,
video_descript varchar(200) DEFAULT NULL COMMENT '视频描述',
video_content varchar(200) DEFAULT NULL COMMENT '视频内容',
channel_type varchar(1) DEFAULT NULL COMMENT '栏目类型',
video_type varchar(1) DEFAULT NULL COMMENT '小类型',
video_source varchar(2) DEFAULT NULL COMMENT '视频来源 0：腾讯，1：优酷，2：土豆，3：爱奇艺，4：火山小视频，5：陌陌，6：其他。',
upload_type varchar(1) DEFAULT NULL COMMENT '上传类型 0：用户上传，1：管理员上传',
video_cover varchar(200) DEFAULT NULL COMMENT '视频封面海报',
video_state varchar(1) DEFAULT NULL COMMENT '审核状态 0,：上传成功（待提交审核），1：提交审核（待审核）,2：审核不通过，3：审核通过，4：发布，5：下架，6：删除',
audit_time varchar(16) DEFAULT NULL COMMENT '审核时间',
audit_person_id varchar(32) DEFAULT NULL COMMENT '审核人ID',
audit_person_name varchar(75) DEFAULT NULL COMMENT '审核人姓名',
publish_time varchar(16) DEFAULT NULL COMMENT '发布时间',
publish_person_type varchar(1) DEFAULT NULL COMMENT '发布人类型 0：用户，1：管理员',
publish_person_id varchar(32) DEFAULT NULL COMMENT '发布人ID',
publish_person_name varchar(75) DEFAULT NULL COMMENT '发布人姓名',
unpublish_time varchar(16) DEFAULT NULL COMMENT '下架时间',
unpublish_person_type varchar(1) DEFAULT NULL COMMENT '下架人类型 0：用户，1：管理员',
unpublish_person_id varchar(32) DEFAULT NULL COMMENT '下架人ID',
unpublish_person_name varchar(75) DEFAULT NULL COMMENT '下架人姓名',
delete_time varchar(16) DEFAULT NULL COMMENT '删除时间',
delete_person_id varchar(32) DEFAULT NULL COMMENT '删除人ID',
delete_person_name varchar(75) DEFAULT NULL COMMENT '删除人姓名',
create_time varchar(16) DEFAULT NULL COMMENT '上传时间',
create_person_id varchar(32) DEFAULT NULL COMMENT '上传人ID',
create_person_name varchar(75) DEFAULT NULL COMMENT '上传人姓名',
download_count int(10) DEFAULT '0' COMMENT '下载次数',
PRIMARY KEY (video_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='视频资源表总表';

-- Records of video

INSERT INTO video VALUES ('0B38D8EBAED0416FBC51B7231F4D5916', '问月', '如果早一点知道我们后来将要面对的世界不过如此，那么年少的时候是否会少一些因为过度期待而产生的怨怼。', '如果早一点知道我们后来将要面对的世界不过如此，那么年少的时候是否会少一些因为过度期待而产生的怨怼。', '/upload/videos/1530260191344.flv', '3', '3', '3', '1', '/upload/images/1530260191535.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:16', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('10D9D0C9923B47018FE27C8CFAD01969', '马步谣', '青春就是用来追忆的，当你怀揣着它时，它一文不值，只有将它耗尽后，再回过头看，一切才有了意义。', '青春就是用来追忆的，当你怀揣着它时，它一文不值，只有将它耗尽后，再回过头看，一切才有了意义。', '/upload/videos/1530258450593.flv', '0', '0', '0', '1', '/upload/images/1530258451067.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:48', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('2CD94064E0F44EA683B8736FD13E2345', '山鬼', '所谓绝唱，就不会有安可。', '所谓绝唱，就不会有安可。', '/upload/videos/1530259718591.flv', '1', '1', '1', '1', '/upload/images/1530259718749.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:08', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('365B64764318495191404DCE667F8FA2', '凤凰劫', '你知道的，生命中有多少事毁于大火，就有多少事以灰烬的形式永存。', '你知道的，生命中有多少事毁于大火，就有多少事以灰烬的形式永存。', '/upload/videos/1530260090932.flv', '3', '3', '3', '1', '/upload/images/1530260091083.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:15', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('39FEFFC29BF1406885752F9D56AA4D04', '星月神话', '你知道满天星的花语是什么吗？就是甘愿做配角。我怀揣着对你的爱，就像怀着赃物的盗贼一样。', '你知道满天星的花语是什么吗？就是甘愿做配角。我怀揣着对你的爱，就像怀着赃物的盗贼一样。', '/upload/videos/1530259784962.flv', '1', '1', '1', '1', '/upload/images/1530259785081.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:10', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('3AF35179D4A54CE9B219FAA294388BFF', '黯然销魂', '斜阳散了余温，凉意入骨几寸。', '斜阳散了余温，凉意入骨几寸。', '/upload/videos/1545629030744.flv', '3', '4', '6', '1', '/upload/images/1545629030795.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-12-24 13:54', 'D52AF7867E294513B4888827776877D2', '张宇乐', null);
INSERT INTO video VALUES ('636015B60DAD48CD924FDA7560282024', '风筝误', '就让我们继续与生命的慷慨与繁华相爱；即使岁月以刻薄与荒芜相欺。', '就让我们继续与生命的慷慨与繁华相爱；即使岁月以刻薄与荒芜相欺。', '/upload/videos/1530259685322.flv', '1', '1', '1', '1', '/upload/images/1530259685444.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:08', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('64FED028DC8C4854B56893B936F155B0', 'はるかな旅', '他有双冰冷眼睛诱我入境当他开心时人间就化为仙境', '他有双冰冷眼睛诱我入境当他开心时人间就化为仙境', '/upload/videos/1545546958691.flv', '3', '1', '3', '1', '/upload/images/1545546958939.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-12-23 14:36', 'D52AF7867E294513B4888827776877D2', '张宇乐', null);
INSERT INTO video VALUES ('6BCB7549359D4846BD8DABF35B6F7B91', '轮回之境', '命运狰狞。爪牙下的众生，劫数重重。 ', '命运狰狞。爪牙下的众生，劫数重重。 ', '/upload/videos/1530260134528.flv', '3', '3', '3', '1', '/upload/images/1530260134882.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:15', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('77795219D3A64BF7BBFD51053E496E73', '牵丝戏', '我想，誓言之美，不在于它能对抗世事无常，而在于今生今世，有那么一瞬间，我们曾经愿意相信它能。', '我想，誓言之美，不在于它能对抗世事无常，而在于今生今世，有那么一瞬间，我们曾经愿意相信它能。', '/upload/videos/1530259026072.flv', '0', '0', '0', '1', '/upload/images/1530259026336.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:57', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('888B79E3EE2C41E8BAEA2FBC1130D988', '惊鸿一面', '好似脚下横尸遍野兀自对镜试妆', '好似脚下横尸遍野兀自对镜试妆', '/upload/videos/1530259152819.flv', '0', '0', '0', '1', '/upload/images/1530259153153.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:59', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('8D9D493545DF4ABFAFA1DB255434105A', '风华', '即使生命如尘，仍愿岁月如歌。', '即使生命如尘，仍愿岁月如歌。', '/upload/videos/1530259586733.flv', '1', '1', '1', '1', '/upload/images/1530259586892.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:07', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('9348F1A1882F4B8F83132FDEEC052891', '玲珑', '时光驯服一切，我与往事之间，像回声，再怎么千回百转，终究消失在山谷。爱如吗啡，能止痛，可使人舒畅，但要上瘾，也能杀人。', '时光驯服一切，我与往事之间，像回声，再怎么千回百转，终究消失在山谷。爱如吗啡，能止痛，可使人舒畅，但要上瘾，也能杀人。', '/upload/videos/1530260284768.flv', '3', '3', '3', '1', '/upload/images/1530260285110.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:18', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('A34252D6252B4A0EB080174AA2B8715B', '千古佳话水墨中', '气质美如兰，才华馥比仙。天生成孤癖人皆罕。你道是啖肉食腥膻，视绮罗俗厌；却不知太高人愈妒，过洁世同嫌。可叹这，青灯古殿人将老；辜负了，红粉朱楼春色阑。到头来，依旧是风尘肮脏违心愿。好一似，无瑕白玉遭泥陷；又何须，王孙公子叹无缘。', '气质美如兰，才华馥比仙。天生成孤癖人皆罕。你道是啖肉食腥膻，视绮罗俗厌；却不知太高人愈妒，过洁世同嫌。可叹这，青灯古殿人将老；辜负了，红粉朱楼春色阑。到头来，依旧是风尘肮脏违心愿。好一似，无瑕白玉遭泥陷；又何须，王孙公子叹无缘。', '/upload/videos/1530259077483.flv', '0', '0', '0', '1', '/upload/images/1530259077659.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:58', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('B1947FB7711E4469959EFCCEA4EDECD2', '半壶纱', '犹如一首歌，停在了最酣畅的时候，未尝不是好事，而他们太过贪婪，固执地以为可以再唱下去，才知道后来的曲调是这样不堪。', '犹如一首歌，停在了最酣畅的时候，未尝不是好事，而他们太过贪婪，固执地以为可以再唱下去，才知道后来的曲调是这样不堪。', '/upload/videos/1530258951349.flv', '0', '0', '0', '1', '/upload/images/1530258951728.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:56', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('BC4E21BB2F904113AF3BF72C5147A231', '泼茶香', '愿逆风如解意，容易莫摧残', '愿逆风如解意，容易莫摧残', '/upload/videos/1530259334436.flv', '1', '1', '1', '1', '/upload/images/1530259335049.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:02', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('BE42CAE02ECA4DD9AFEE6AAED5BE0FA1', '红豆', '少年时的深情，总是这样不留退路，一贯到底，貌似气势如虹，实则不过是雨后幻景。', '少年时的深情，总是这样不留退路，一贯到底，貌似气势如虹，实则不过是雨后幻景。', '/upload/videos/1530258881032.flv', '0', '0', '0', '1', '/upload/images/1530258881163.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:55', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('CE4449A584DB451EA2E61C82E21C6105', '君心我心', '这个世界上，从来不是你怎么对一个人，他就该怎么对你。说爱应该是无私的，其实不是在说什么高尚，而是在说人心迥异。你本来就不该在付出的时候，期待回报。报之我幸，不报我命。', '这个世界上，从来不是你怎么对一个人，他就该怎么对你。说爱应该是无私的，其实不是在说什么高尚，而是在说人心迥异。你本来就不该在付出的时候，期待回报。报之我幸，不报我命。', '/upload/videos/1530259898788.flv', '1', '1', '1', '1', '/upload/images/1530259899101.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:11', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('D2C5B443C9E94FB5B1BFAE6E849736D1', '狐言', '你终有一天会发现的，生命的名字叫做徒劳。', '你终有一天会发现的，生命的名字叫做徒劳。', '/upload/videos/1530260011454.flv', '3', '3', '3', '1', '/upload/images/1530260011781.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:13', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('DCF7036F0A5D494587568921A742FFA0', '唐人', '生于盛夏八月，但求一世长安。', '生于盛夏八月，但求一世长安。', '/upload/videos/1530260234805.flv', '3', '3', '3', '1', '/upload/images/1530260235026.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:17', 'D52AF7867E294513B4888827776877D2', '张宇乐', '1');
INSERT INTO video VALUES ('E9E02BAD554845248163010404FC88EF', '菁华浮梦', '越是良辰美景，越是情深孤独。', '越是良辰美景，越是情深孤独。', '/upload/videos/1530259831605.flv', '1', '1', '1', '1', '/upload/images/1530259831983.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:10', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('F397BBEEF2C64B59AB263E5927214E5F', '黯然销魂', '回过头去看看那些浸透在白纸黑字上的生动的悲喜，切肤地感觉到，在那样一个唯唯诺诺的苟且年纪，伤情似乎是装点生命的勋章，好像只有凭借那些，幻觉般的，被我们脆弱的主观承受力无限夸大的非难，我们才得以拥有热泪盈眶的青春。', '回过头去看看那些浸透在白纸黑字上的生动的悲喜，切肤地感觉到，在那样一个唯唯诺诺的苟且年纪，伤情似乎是装点生命的勋章，好像只有凭借那些，幻觉般的，被我们脆弱的主观承受力无限夸大的非难，我们才得以拥有热泪盈眶的青春。', '/upload/videos/1530258824201.flv', '0', '0', '0', '1', '/upload/images/1530258824298.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 15:54', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
INSERT INTO video VALUES ('FC33F9D695BC4561ADA6B721F167EDB2', '胭脂雪', '如果过去还值得留恋，别太快冰释前嫌。', '如果过去还值得留恋，别太快冰释前嫌。', '/upload/videos/1530259963681.flv', '3', '3', '3', '1', '/upload/images/1530259964204.jpg', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-06-29 16:13', 'D52AF7867E294513B4888827776877D2', '张宇乐', '0');
`