my sql.sql

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

-- phpMyAdmin SQL Dump
-- version for WAPM 2.6.1-rc1
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2007 年 12 月 27 日 14:46
-- 服务器版本: 4.0.22
-- PHP 版本: 4.3.10
-- 
-- 数据库: `3`
-- 
CREATE DATABASE `3`;
USE 3;

-- --------------------------------------------------------

-- 
-- 表的结构 `sfilm`
-- 

CREATE TABLE `sfilm` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `md` tinyint(1) unsigned NOT NULL default '0',
  `isshow` tinyint(1) unsigned NOT NULL default '1',
  `sort1` tinyint(3) unsigned NOT NULL default '1',
  `type` varchar(10) NOT NULL default '',
  `star` tinyint(1) unsigned NOT NULL default '1',
  `size` smallint(5) unsigned NOT NULL default '0',
  `kb` enum('kb','mb') NOT NULL default 'kb',
  `viewnum` smallint(5) unsigned zerofill NOT NULL default '00000',
  `text` text,
  `pic` varchar(100) default NULL,
  `url1` varchar(150) NOT NULL default '',
  `url2` varchar(150) default NULL,
  `url3` varchar(120) default NULL,
  `url4` varchar(120) default NULL,
  `url5` varchar(120) default NULL,
  `dotime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- 导出表中的数据 `sfilm`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `sfilm_sort1`
-- 

CREATE TABLE `sfilm_sort1` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `sort1` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- 导出表中的数据 `sfilm_sort1`
-- 

INSERT INTO `sfilm_sort1` VALUES (1, '小电影');
-- 
-- 数据库: `a`
-- 
CREATE DATABASE `a`;
USE a;

-- --------------------------------------------------------

-- 
-- 表的结构 `c_messages`
-- 

CREATE TABLE `c_messages` (
  `type` tinyint(4) NOT NULL default '0',
  `room` varchar(30) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(4) NOT NULL default '0',
  `m_time` int(11) NOT NULL default '0',
  `address` varchar(30) NOT NULL default '',
  `message` text NOT NULL
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `c_messages`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `c_reg_users`
-- 

CREATE TABLE `c_reg_users` (
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(4) NOT NULL default '0',
  `password` varchar(32) NOT NULL default '',
  `firstname` varchar(64) NOT NULL default '',
  `lastname` varchar(64) NOT NULL default '',
  `country` varchar(64) NOT NULL default '',
  `website` varchar(64) NOT NULL default '',
  `email` varchar(64) NOT NULL default '',
  `showemail` int(11) NOT NULL default '0',
  `perms` varchar(32) NOT NULL default '',
  `rooms` varchar(128) NOT NULL default ''
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `c_reg_users`
-- 

INSERT INTO `c_reg_users` VALUES ('admin', 0, '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '');

-- --------------------------------------------------------

-- 
-- 表的结构 `c_users`
-- 

CREATE TABLE `c_users` (
  `room` varchar(30) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(4) NOT NULL default '0',
  `u_time` int(11) NOT NULL default '0',
  UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `c_users`
-- 

-- 
-- 数据库: `mysql`
-- 
CREATE DATABASE `mysql`;
USE mysql;

-- --------------------------------------------------------

-- 
-- 表的结构 `columns_priv`
-- 

CREATE TABLE `columns_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 '',
  `Column_name` char(64) binary NOT NULL default '',
  `Timestamp` timestamp(14) NOT NULL,
  `Column_priv` set('Select','Insert','Update','References') NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) TYPE=MyISAM COMMENT='Column privileges';

-- 
-- 导出表中的数据 `columns_priv`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `db`
-- 

CREATE TABLE `db` (
  `Host` char(60) binary NOT NULL default '',
  `Db` char(64) binary NOT NULL default '',
  `User` char(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',
  `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',
  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`Db`,`User`),
  KEY `User` (`User`)
) TYPE=MyISAM COMMENT='Database privileges';

-- 
-- 导出表中的数据 `db`
-- 

INSERT INTO `db` VALUES (0x6c6f63616c686f7374, 0x74657374, 0x74657374, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'N', 'N');

-- --------------------------------------------------------

-- 
-- 表的结构 `func`
-- 

CREATE TABLE `func` (
  `name` char(64) binary NOT NULL default '',
  `ret` tinyint(1) NOT NULL default '0',
  `dl` char(128) NOT NULL default '',
  `type` enum('function','aggregate') NOT NULL default 'function',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM COMMENT='User defined functions';

-- 
-- 导出表中的数据 `func`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `host`
-- 

CREATE TABLE `host` (
  `Host` char(60) binary NOT NULL default '',
  `Db` char(64) 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',
  `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',
  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`Db`)
) TYPE=MyISAM COMMENT='Host privileges;  Merged with database privileges';

-- 
-- 导出表中的数据 `host`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `movie`
-- 

CREATE TABLE `movie` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `viewnum` int(10) NOT NULL default '168',
  `downnum` int(10) NOT NULL default '0',
  `brief` mediumtext,
  `sort2id` smallint(6) NOT NULL default '0',
  `pic` varchar(200) NOT NULL default '',
  `rmzx` varchar(200) default NULL,
  `asf` varchar(200) default NULL,
  `rm` varchar(200) default NULL,
  `flash` varchar(200) default NULL,
  `asfzx` varchar(200) default NULL,
  `flashzx` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=934 ;

-- 
-- 导出表中的数据 `movie`
-- 

INSERT INTO `movie` VALUES (1, 'love', 1904, 5, 'love', 1, 'http://cartoonfile.163.com/source/5365/ai.gif', '', '', '', 'http://cartoonfile.163.com/source/5365/ai.swf', '', 'Online audio-visual');
INSERT INTO `movie` VALUES (2, 'Soccer', 3215, 0, '<Soccer> A ', 11, 'http://2733.8u8.com/pic/slzq.gif', '', '', 'rtsp://61.138.3.123/asf_vcd/saolinzuqu_1.rm', '', '', '');
INSERT INTO `movie` VALUES (3, 'Soccer', 2231, 0, '<Soccer> B ', 11, 'http://2733.8u8.com/pic/slzq.gif', '', '', 'rtsp://61.138.3.123/asf_vcd/saolinzuqu_2.rm', '', '', '');
INSERT INTO `movie` VALUES (4, 'Chicken', 2548, 0, '<Chicken> ASF format', 14, 'http://y888.net/k666/tt78/8/pic/my.gif', '', 'mms://61.138.3.123/asf_dvd/cr.asf', '', '', '', '');
INSERT INTO `movie` VALUES (5, 'I love you inadequate', 1930, 0, 'liu de hua <I love you inadequate> MTV', 2, 'http://cartoonfile.163.com/desktop/source/4009/andy2.jpg', '', 'mms://61.134.9.121/new/andy/01.wmv', '', '', 'View Online', '');
INSERT INTO `movie` VALUES (6, 'heart', 772, 0, '<heart> FLASH', 1, 'http://cartoonfile.163.com/source/8849/copyofin2.jpg', '', '', '', 'http://cartoonfile.163.com/source/8849/inheart.swf', '', 'View Online');
INSERT INTO `movie` VALUES (7, 'Black days', 783, 0, 'sun yan zi <Black days> FLASH', 1, 'http://cartoonfile.163.com/source/6525/tianhh.jpg', '', '', '', 'http://cartoonfile.163.com/source/6525/tianhh.swf', '', 'View Online');
INSERT INTO `movie` VALUES (8, '<Journey to the West>', 725, 0, '<Journey to the West>', 1, 'http://cartoonfile.163.com/source/6331/xxj01.jpg', '', '', '', 'http://cartoonfile.163.com/source/6331/xxj01.swf', '', 'View Online');
INSERT INTO `movie` VALUES (9, 'Single love songs', 991, 0, 'lin zhi xuan <Single love songs>', 1, 'http://cartoonfile.163.com/source/20/one.jpg', '', '', '', 'http://cartoonfile.163.com/source/20/d.swf', '', 'View Online');
INSERT INTO `movie` VALUES (10, 'Thanks for you love1999', 1274, 0, 'xie ting feng <Thanks for you love1999>', 1, 'http://cartoonfile.163.com/source/46/5-20-007.jpg', '', '', '', 'http://cartoonfile.163.com/source/46/love1999.swf', '', 'View Online');
INSERT INTO `movie` VALUES (11, 'rain', 1018, 0, 'zhang yu <rain>', 1, 'http://cartoonfile.163.com/source/77/snap.jpg', '', '', '', 'http://cartoonfile.163.com/source/77/load.swf', '', 'View Online');
INSERT INTO `movie` VALUES (12, 'come back', 684, 0, 'sun nan <come back>', 1, 'http://cartoonfile.163.com/source/92/comebakce1.jpg', '', '', '', 'http://cartoonfile.163.com/source/92/ybmm3.swf', '', 'View Online');
INSERT INTO `movie` VALUES (13, 'qing zang Plateau', 479, 0, 'qing zang Plateau', 1, 'http://cartoonfile.163.com/source/108/budala.jpg', '', '', '', 'http://cartoonfile.163.com/source/108/qzgy.swf', '', 'View Online');