create.sql
上传用户:qdrechuli
上传日期:2022-08-01
资源大小:917k
文件大小:2k
- -- MySQL dump 8.21
- --
- -- Host: localhost Database: netcam
- ---------------------------------------------------------
- -- Server version 3.23.49
- --
- -- Current Database: netcam
- --
- CREATE DATABASE /*!32312 IF NOT EXISTS*/ netcam;
- USE netcam;
- --
- -- Table structure for table 'cam'
- --
- CREATE TABLE cam (
- C_ID bigint(20) NOT NULL auto_increment,
- C_Name varchar(30) NOT NULL default '',
- C_Url varchar(80) NOT NULL default '',
- C_User varchar(10) NOT NULL default '',
- C_Pwd varchar(10) NOT NULL default '',
- C_Active tinyint(4) NOT NULL default '0',
- C_Freq tinyint(4) NOT NULL default '0',
- C_Pid bigint(20) NOT NULL default '0',
- C_Age tinyint(4) NOT NULL default '0',
- PRIMARY KEY (C_ID,C_Name)
- ) TYPE=MyISAM;
- --
- -- Table structure for table 'record'
- --
- CREATE TABLE record (
- R_ID bigint(20) unsigned NOT NULL auto_increment,
- R_Cam bigint(20) NOT NULL default '0',
- R_Date varchar(14) NOT NULL default '',
- R_Img blob,
- R_Size bigint(20) NOT NULL default '0',
- R_Index bigint(20) NOT NULL default '0',
- R_Opt tinyint(4) NOT NULL default '0',
- R_Day varchar(8) NOT NULL default '',
- R_Hour tinyint(4) NOT NULL default '0',
- KEY ID (R_ID),
- KEY Cam (R_Cam),
- KEY rindex (R_Index),
- KEY opt (R_Opt),
- KEY day (R_Day),
- KEY hour (R_Hour),
- KEY Date (R_Date)
- ) TYPE=MyISAM MAX_ROWS=15000000 AVG_ROW_LENGTH=10000;
- --
- -- Table structure for table 'tranche'
- --
- CREATE TABLE tranche (
- T_ID bigint(20) unsigned NOT NULL auto_increment,
- T_Cam bigint(20) NOT NULL default '0',
- T_Index bigint(20) NOT NULL default '0',
- T_Day varchar(8) NOT NULL default '',
- T_Hour tinyint(4) NOT NULL default '0',
- KEY ID (T_ID),
- KEY Cam (T_Cam),
- KEY day (T_Day),
- KEY hour (T_Hour)
- ) TYPE=MyISAM;
- --
- -- Table structure for table 'vars'
- --
- CREATE TABLE vars (
- V_Var varchar(30) NOT NULL default '',
- V_Value varchar(80) default NULL,
- PRIMARY KEY (V_Var)
- ) TYPE=MyISAM;
- --
- -- Dumping data for table 'vars'
- --
- INSERT INTO vars VALUES ('GetCamState','START');
- INSERT INTO vars VALUES ('OptCamState','START');