my sql.sql

Audio-visual system an online simulation of the film, when operations can be used by the

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 ('[e-mail]', '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');