?? my sql.sql
字號:
INSERT INTO `movie` VALUES (14, 'the song of earth', 378, 0, '<the song of earth> Micheal Jackson', 1, 'http://cartoonfile.163.com/source/108/earthsong.gif', '', '', '', 'http://cartoonfile.163.com/source/108/earthsong.swf', '', 'View Online');INSERT INTO `movie` VALUES (15, 'Moon', 673, 0, 'liu huang <Moon>', 1, 'http://cartoonfile.163.com/source/99/ctzl.jpg', '', '', '', 'http://cartoonfile.163.com/source/99/ctzl.swf', '', 'View Online');INSERT INTO `movie` VALUES (16, 'small bell', 755, 0, '<small bell>', 1, 'http://cartoonfile.163.com/source/115/sdxl.jpg', '', '', '', 'http://cartoonfile.163.com/source/115/sdxn.swf', '', 'View Online');INSERT INTO `movie` VALUES (17, 'Not old legends', 491, 0, 'zhang xue you <Not old legends> MTV', 1, 'http://cartoonfile.163.com/source/153/zhang.gif', '', '', '', 'http://flash.163.com/show_one.php?idno=192', '', 'View Online');INSERT INTO `movie` VALUES (18, 'Dream of a lifetime for love', 514, 0, 'wang jie <Dream of a lifetime for love>', 1, 'http://cartoonfile.163.com/source/113/ff.gif', '', '', '', 'http://cartoonfile.163.com/source/113/q1.swf', '', 'View Online');INSERT INTO `movie` VALUES (19, 'Most beautiful', 876, 0, 'yu quan <Most beautiful>', 1, 'http://cartoonfile.163.com/source/236/zmgr.jpg', '', '', '', 'http://cartoonfile.163.com/source/236/zmgr.swf', '', 'View Online');INSERT INTO `movie` VALUES (20, 'scalewing', 755, 0, '<scalewing> MTV', 1, 'http://cartoonfile.163.com/source/194/butterfly.gif', '', '', '', 'http://cartoonfile.163.com/source/194/butterfly.swf', '', 'View Online');INSERT INTO `movie` VALUES (21, 'Love songs', 774, 0, 'wu bai <Love songs>', 1, 'http://cartoonfile.163.com/source/233/lrqg.jpg', '', '', '', 'http://cartoonfile.163.com/source/233/lrqg.swf', '', 'View Online');INSERT INTO `movie` VALUES (22, 'Relentlessly', 567, 0, 'cheng xiao cun <Relentlessly>', 1, 'http://cartoonfile.163.com/source/259/zz.gif', '', '', '', 'http://cartoonfile.163.com/source/259/ssss.swf', '', 'View Online');INSERT INTO `movie` VALUES (23, 'skyline', 590, 0, 'ren xing qi <skyline>', 1, 'http://cartoonfile.163.com/source/261/flower0588-85.jpg', '', '', '', 'http://cartoonfile.163.com/source/261/spring.swf', '', 'View Online');INSERT INTO `movie` VALUES (24, 'happy', 361, 0, '<happy>', 1, 'http://cartoonfile.163.com/source/274/gigi.gif', '', '', '', 'http://cartoonfile.163.com/source/274/gigi.swf', '', 'View Online');INSERT INTO `movie` VALUES (25, 'do not talk', 597, 0, 'zhang xin zhe <do not talk>', 1, 'http://cartoonfile.163.com/source/20/bu.jpg', '', '', '', 'http://cartoonfile.163.com/source/20/bu.swf', '', 'View Online');INSERT INTO `movie` VALUES (26, 'last', 497, 0, 'liu luo ying <last>', 1, 'http://cartoonfile.163.com/source/355/lovedove.jpg', '', '', '', 'http://cartoonfile.163.com/source/355/lovedove.swf', '', 'View Online');INSERT INTO `movie` VALUES (27, 'sky', 483, 0, 'su hui lun <sky>', 1, 'http://cartoonfile.163.com/source/238/suhuilun2.jpg', '', '', '', 'http://cartoonfile.163.com/source/238/suhuilun2.swf', '', 'View Online');INSERT INTO `movie` VALUES (28, 'you', 843, 0, 'lin yi lian <you>', 1, 'http://cartoonfile.163.com/source/413/mtv3.jpg', '', '', '', 'http://cartoonfile.163.com/source/413/mtv.swf', '', 'View Online');INSERT INTO `movie` VALUES (29, 'Happy acquitted', 393, 0, 'xu mei jing <Happy acquitted>', 1, 'http://cartoonfile.163.com/source/409/p1120.jpg', '', '', '', 'http://cartoonfile.163.com/source/409/xmj.swf', '', 'View Online');INSERT INTO `movie` VALUES (30, 'wish', 1627, 0, 'zhang bo zhi <wish>', 1, 'http://y888.net/k666/tt78/8/pic/my.gif', '', '', '', 'http://cartoonfile.163.com/source/8840/xyxy.swf', '', '');-- ---------------------------------------------------------- -- 表的結構 `movie_sort1`-- CREATE TABLE `movie_sort1` ( `id` int(10) unsigned NOT NULL auto_increment, `sort1` char(50) NOT NULL default '', `description` char(100) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=3 ;-- -- 導出表中的數據 `movie_sort1`-- INSERT INTO `movie_sort1` VALUES (1, 'Video channel', '');INSERT INTO `movie_sort1` VALUES (2, 'a', 'a');-- ---------------------------------------------------------- -- 表的結構 `movie_sort2`-- CREATE TABLE `movie_sort2` ( `id` int(10) unsigned NOT NULL auto_increment, `sort1id` int(11) NOT NULL default '0', `sort2` char(50) NOT NULL default '', `description` char(100) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=17 ;-- -- 導出表中的數據 `movie_sort2`-- INSERT INTO `movie_sort2` VALUES (1, 1, 'Flash online', '1');INSERT INTO `movie_sort2` VALUES (2, 1, 'Mtv online', '');INSERT INTO `movie_sort2` VALUES (5, 1, 'TV ad', '');INSERT INTO `movie_sort2` VALUES (8, 1, 'Action films', '');INSERT INTO `movie_sort2` VALUES (7, 1, 'TV online', '');INSERT INTO `movie_sort2` VALUES (9, 1, 'science fiction films', '');INSERT INTO `movie_sort2` VALUES (10, 1, 'affectional film', '');INSERT INTO `movie_sort2` VALUES (11, 1, 'comedy', '');INSERT INTO `movie_sort2` VALUES (12, 1, 'War films', '');INSERT INTO `movie_sort2` VALUES (13, 1, 'dracula movie', '');INSERT INTO `movie_sort2` VALUES (14, 1, 'cartoon', '');INSERT INTO `movie_sort2` VALUES (15, 1, 'other', '');INSERT INTO `movie_sort2` VALUES (16, 1, '1', '1');-- ---------------------------------------------------------- -- 表的結構 `movie_user`-- CREATE TABLE `movie_user` ( `id` int(10) unsigned NOT NULL auto_increment, `username` char(50) NOT NULL default '', `password` char(50) NOT NULL default '', `groupid` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=2 ;-- -- 導出表中的數據 `movie_user`-- INSERT INTO `movie_user` VALUES (1, 'admin', 'admin', 1);-- ---------------------------------------------------------- -- 表的結構 `tables_priv`-- CREATE TABLE `tables_priv` ( `Host` char(60) binary NOT NULL default '', `Db` char(64) binary NOT NULL default '', `User` char(16) binary NOT NULL default '', `Table_name` char(64) binary NOT NULL default '', `Grantor` char(77) NOT NULL default '', `Timestamp` timestamp(14) NOT NULL, `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') NOT NULL default '', `Column_priv` set('Select','Insert','Update','References') NOT NULL default '', PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`), KEY `Grantor` (`Grantor`)) TYPE=MyISAM COMMENT='Table privileges';-- -- 導出表中的數據 `tables_priv`-- -- ---------------------------------------------------------- -- 表的結構 `user`-- CREATE TABLE `user` ( `Host` varchar(60) binary NOT NULL default '', `User` varchar(16) binary NOT NULL default '', `Password` varchar(16) binary NOT NULL default '', `Select_priv` enum('N','Y') NOT NULL default 'N', `Insert_priv` enum('N','Y') NOT NULL default 'N', `Update_priv` enum('N','Y') NOT NULL default 'N', `Delete_priv` enum('N','Y') NOT NULL default 'N', `Create_priv` enum('N','Y') NOT NULL default 'N', `Drop_priv` enum('N','Y') NOT NULL default 'N', `Reload_priv` enum('N','Y') NOT NULL default 'N', `Shutdown_priv` enum('N','Y') NOT NULL default 'N', `Process_priv` enum('N','Y') NOT NULL default 'N', `File_priv` enum('N','Y') NOT NULL default 'N', `Grant_priv` enum('N','Y') NOT NULL default 'N', `References_priv` enum('N','Y') NOT NULL default 'N', `Index_priv` enum('N','Y') NOT NULL default 'N', `Alter_priv` enum('N','Y') NOT NULL default 'N', `Show_db_priv` enum('N','Y') NOT NULL default 'N', `Super_priv` enum('N','Y') NOT NULL default 'N', `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N', `Lock_tables_priv` enum('N','Y') NOT NULL default 'N', `Execute_priv` enum('N','Y') NOT NULL default 'N', `Repl_slave_priv` enum('N','Y') NOT NULL default 'N', `Repl_client_priv` enum('N','Y') NOT NULL default 'N', `ssl_type` enum('','ANY','X509','SPECIFIED') NOT NULL default '', `ssl_cipher` blob NOT NULL, `x509_issuer` blob NOT NULL, `x509_subject` blob NOT NULL, `max_questions` int(11) unsigned NOT NULL default '0', `max_updates` int(11) unsigned NOT NULL default '0', `max_connections` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`Host`,`User`)) TYPE=MyISAM COMMENT='Users and global privileges';-- -- 導出表中的數據 `user`-- INSERT INTO `user` VALUES (0x6c6f63616c686f7374, 0x726f6f74, 0x35363534393164373034303133323435, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0);INSERT INTO `user` VALUES (0x6c6f63616c686f7374, 0x74657374, 0x33373862323433653232306361343933, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0);-- -- 數據庫: `test`-- CREATE DATABASE `test`;USE test;-- -- 數據庫: `tlchat`-- CREATE DATABASE `tlchat`;USE tlchat;-- ---------------------------------------------------------- -- 表的結構 `config`-- CREATE TABLE `config` ( `value` varchar(255) default NULL, `name` varchar(50) NOT NULL default '') TYPE=MyISAM;-- -- 導出表中的數據 `config`-- INSERT INTO `config` VALUES ('1', 'chatroom_name');INSERT INTO `config` VALUES ('{%%}來了。', 'chatroom_login');INSERT INTO `config` VALUES ('{%%}走了。', 'chatroom_logout');INSERT INTO `config` VALUES ('{%%}關閉瀏覽器跑掉了。', 'chatroom_leave');INSERT INTO `config` VALUES ('160', 'say_maxlength');INSERT INTO `config` VALUES ('{%%}您好,歡迎您的光臨', 'chatroom_welcome');INSERT INTO `config` VALUES ('歡迎使用 <a href=http://aotianlong.yeah.net>天龍聊天室</a> 1.0.0版。', 'chatroom_affiche');INSERT INTO `config` VALUES ('2', 'say_interval');INSERT INTO `config` VALUES ('我日,草你,操你,法輪,日你,我靠,我草,奶子,陰道,陰莖,陽具,淫水,洪志,干你,媽的,強奸,雞奸,插你,搞你,老子,fuck,shit', 'say_filter');INSERT INTO `config` VALUES ('5000', 'refresh_interval');INSERT INTO `config` VALUES ('1', 'chatroom_admin');INSERT INTO `config` VALUES ('500', 'chatroom_maxonline');INSERT INTO `config` VALUES ('margingz@sina.com', 'chatroom_adminemail');INSERT INTO `config` VALUES ('{##}恭恭敬敬的把{%%}請出聊天室……', 'message_kick');INSERT INTO `config` VALUES ('{##}把{%%}炸上天堂……', 'message_bomb');INSERT INTO `config` VALUES ('{%%}偷偷的關閉瀏覽器走了……', 'message_leave');INSERT INTO `config` VALUES ('{##}封鎖{%%}的IP……', 'message_lock');INSERT INTO `config` VALUES ('天上烏云密布,剎那間一條白龍化作了{%%}……', 'message_login');INSERT INTO `config` VALUES ('{%%}幻化做一條青龍,飛走了……', 'message_logout');INSERT INTO `config` VALUES ('{##}警告{%%}一次……', 'message_warn');INSERT INTO `config` VALUES ('{%%}由于潛水時間過長,系統自清除。', 'message_clear');INSERT INTO `config` VALUES ('{%%}去了{##}了。', 'message_changeroom');INSERT INTO `config` VALUES ('#EEEEFF', 'style_inputsayframe_background_color');INSERT INTO `config` VALUES ('images/bg.gif', 'style_inputsayframe_background_image');INSERT INTO `config` VALUES ('#EEEEFF', 'style_onlinelistframe_background_color');INSERT INTO `config` VALUES ('images/bg.gif', 'style_onlinelistframe_background_image');INSERT INTO `config` VALUES ('#DDDDFF', 'style_titleframe_background_color');INSERT INTO `config` VALUES ('', 'style_titleframe_background_image');INSERT INTO `config` VALUES ('#EEEEFF', 'style_showmessageframe_background_color');INSERT INTO `config` VALUES ('', 'style_showmessageframe_background_image');INSERT INTO `config` VALUES ('c4ca4238a0b923820dcc509a6f75849b', 'chatroom_adminpassword');INSERT INTO `config` VALUES ('0', 'notice_show_time');INSERT INTO `config` VALUES ('1', 'chatroom_default_split');INSERT INTO `config` VALUES ('0', 'say_enable_filter');INSERT INTO `config` VALUES ('0', 'savecents_interval');INSERT INTO `config` VALUES ('2', 'enable_picture');INSERT INTO `config` VALUES ('3', 'enable_title');INSERT INTO `config` VALUES ('9', 'enable_warn');INSERT INTO `config` VALUES ('6', 'enable_kick');INSERT INTO `config` VALUES ('7', 'enable_lock');INSERT INTO `config` VALUES ('8', 'enable_unlock');INSERT INTO `config` VALUES ('8', 'enable_bomb');INSERT INTO `config` VALUES ('9', 'enable_grade');INSERT INTO `config` VALUES ('12', 'enable_unauto_grade');INSERT INTO `config` VALUES ('12', 'enable_nolimit_grade');INSERT INTO `config` VALUES ('11', 'enable_auto_grade');INSERT INTO `config` VALUES ('500', 'grade2_cents');INSERT INTO `config` VALUES ('1000', 'grade3_cents');INSERT INTO `config` VALUES ('2000', 'grade4_cents');INSERT INTO `config` VALUES ('4000', 'grade5_cents');INSERT INTO `config` VALUES ('-1', 'grade6_cents');INSERT INTO `config` VALUES ('-1', 'grade7_cents');INSERT INTO `config` VALUES ('-1', 'grade8_cents');INSERT INTO `config` VALUES ('-1', 'grade9_cents');INSERT INTO `config` VALUES ('-1', 'grade10_cents');INSERT INTO `config` VALUES ('1', 'enable_grade_auto_increment');INSERT INTO `config` VALUES ('5', 'kick_cantlogin_time');INSERT INTO `config` VALUES ('20', 'lock_cantlogin_time');INSERT INTO `config` VALUES ('0', 'img_verify');INSERT INTO `config` VALUES ('1082880882.2993', 'check_online');INSERT INTO `config` VALUES ('0', 'max_nosay_time');INSERT INTO `config` VALUES ('5', 'enable_view_loginip');INSERT INTO `config` VALUES ('3', 'enable_view_sysinfo');INSERT INTO `config` VALUES ('4', 'enable_view_grade');INSERT INTO `config` VALUES ('2', 'enable_view_nameattrib');INSERT INTO `config` VALUES ('1', 'enable_view_userinfo');INSERT INTO `config` VALUES ('這里可以顯示您在首頁的信息', 'loginpage_affiche');INSERT INTO `config` VALUES ('20', 'log_pagesize');INSERT INTO `config` VALUES ('72', 'log_clear_interval');INSERT INTO `config` VALUES ('10', 'title_interval');INSERT INTO `config` VALUES ('600', 'optimize_time');INSERT INTO `config` VALUES ('1082853663', 'last_optimize_time');INSERT INTO `config` VALUES ('2000', 'max_message_number');INSERT INTO `config` VALUES ('系統調整中,請稍后再來,謝謝您的支持~', 'why_close');INSERT INTO `config` VALUES ('1', 'chatroom_is_closed');INSERT INTO `config` VALUES ('1', 'name_min_length');INSERT INTO `config` VALUES ('12', 'name_max_length');INSERT INTO `config` VALUES ('6', 'password_min_length');INSERT INTO `config` VALUES ('1', 'chatroom_admin_pic_verify');INSERT INTO `config` VALUES ('1082637112', 'log_last_clear_time');INSERT INTO `config` VALUES ('1', 'enable_auto_clear_logs');INSERT INTO `config` VALUES ('{%%}經過多次警告無效,系統將其清除出聊天室……', 'message_warning_out');INSERT INTO `config` VALUES ('3', 'warning_out_number');INSERT INTO `config` VALUES ('{%%}解除IP封鎖{##}.....', 'message_unlock');INSERT INTO `config` VALUES ('1', 'enable_viewlog_manage');INSERT INTO `config` VALUES ('10', 'enable_viewlog_error');INSERT INTO `config` VALUES ('3', 'enable_viewlog_grade');INSERT INTO `config` VALUES ('0', 'visit_number');INSERT INTO `config` VALUES ('8', 'enable_outside_picture');INSERT INTO `config` VALUES ('9', 'enable_viewlog_name');INSERT INTO `config` VALUES ('2', 'enable_viewlog_login');INSERT INTO `config` VALUES ('1', 'enable_write_guestbook');INSERT INTO `config` VALUES ('10', 'enable_delete_guestbook');INSERT INTO `config` VALUES ('1', 'enable_deleteself_guestbook');INSERT INTO `config` VALUES ('如果您有什么意見或者建議,請在這里留言。', 'guestbook_affiche');INSERT INTO `config` VALUES ('-1', 'grade12_cents');INSERT INTO `config` VALUES ('-1', 'grade11_cents');INSERT INTO `config` VALUES ('2', 'write_guestbook_interval');INSERT INTO `config` VALUES ('0', 'top_online_record');
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -