虎克的博客

Enthusiasm Biogeography-Biodiversity Informatics-Data Sciences

物种2000数据库结构SQL脚本

| Comments 

   1:  # SQL Manager 2007 for MySQL 4.3.2.3

   2:  # ——————————————————–—

   3:  # Host     : localhost

   4:  # Port     : 3306

   5:  # Database : sp2000cn

   6:   

   7:   

   8:  /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;

   9:  /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;

  10:  /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;

  11:  /!40101 SET NAMES utf8 /;

  12:   

  13:  SET FOREIGN_KEY_CHECKS=0;

  14:   

  15:  DROP DATABASE IF EXISTS sp2000cn;

  16:   

  17:  CREATE DATABASE sp2000cn

  18:      CHARACTER SET ‘utf8’

  19:      COLLATE ‘utf8_unicode_ci’;

  20:   

  21:  USE sp2000cn;

  22:   

  23:  #

  24:  # Structure for the common_names table : 

  25:  #

  26:   

  27:  CREATE TABLE common_names (

  28:    record_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  29:    name_code VARCHAR(50) COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘’,

  30:    common_name VARCHAR(500) COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘’,

  31:    <span class="kwrd">language</span> VARCHAR(21) COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘’,

  32:    country VARCHAR(44) COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘’,

  33:    reference_id INTEGER(10) DEFAULT ‘0’,

  34:    database_id INTEGER(10) NOT NULL DEFAULT ‘0’,

  35:    is_infraspecies INTEGER(1) NOT NULL DEFAULT ‘0’,

  36:    PRIMARY KEY (record_id),

  37:    KEY common_name (common_name),

  38:    KEY <span class="kwrd">language</span> (<span class="kwrd">language</span>, common_name, name_code),

  39:    KEY common_name_2 (common_name, name_code, database_id),

  40:    KEY name_code (name_code),

  41:    KEY common_name_3 (common_name, database_id)

  42:   

  43:  )ENGINE=MyISAM

  44:  AUTO_INCREMENT=1661048 CHARACTER SET ‘latin1’ COLLATE ‘latin1_swedish_ci’;

  45:   

  46:  #

  47:  # Structure for the databases table : 

  48:  #

  49:   

  50:  CREATE TABLE databases (

  51:    database_name_displayed VARCHAR(100) COLLATE latin1_swedish_ci DEFAULT NULL,

  52:    record_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  53:    database_name VARCHAR(150) COLLATE latin1_swedish_ci DEFAULT NULL,

  54:    database_full_name VARCHAR(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘’,

  55:    web_site LONGTEXT,

  56:    organization VARCHAR(255) COLLATE latin1_swedish_ci DEFAULT NULL,

  57:    



   original link:
   <a href='http://Apiaceae.github.io/blog/2009/04/26/%E7%89%A9%E7%A7%8D2000%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%93%E6%9E%84SQL%E8%84%9A%E6%9C%AC/'>http://Apiaceae.github.io/blog/2009/04/26/%E7%89%A9%E7%A7%8D2000%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%93%E6%9E%84SQL%E8%84%9A%E6%9C%AC/</a><br/>
   &nbsp;written by <a href='http://Apiaceae.github.io'>Hooker</a>
   &nbsp;posted at <a href='http://Apiaceae.github.io'>http://Apiaceae.github.io</a>
   </p>

Comments