Pacific-Design.com

    
Home Index

1. SQL Language

2. 01 CREATE TABLE

SQL Language / 01 CREATE TABLE /

SQL CREATE TABLE

CREATE TABLE part_5af (

  sha256url     char(64)        CHARACTER SET ascii NOT NULL,
  md5root       char(32)        CHARACTER SET ascii NOT NULL,
  url           varchar(255)    NOT NULL,
  root          varchar(64)     NOT NULL,
  tags          varchar(128)    DEFAULT NULL,
  title         varchar(128)    DEFAULT NULL,
  body          varchar(4096)   DEFAULT NULL,
  alexa         mediumint(6)    DEFAULT NULL,
  rank          mediumint(6)    DEFAULT NULL,
  hit1          mediumint(6)    DEFAULT NULL,
  hit2          mediumint(6)    DEFAULT NULL,
  hit3          mediumint(6)    DEFAULT NULL,
  category      char(3)         DEFAULT NULL,
  period        date            DEFAULT NULL,
  gunning       float(5,2)      NOT NULL DEFAULT '0.00',
  flesch        float(5,2)      NOT NULL DEFAULT '0.00',
  kincaid       float(5,2)      NOT NULL DEFAULT '0.00',
  sentence      smallint(5)     unsigned NOT NULL DEFAULT '0',
  words         float(5,2)      unsigned NOT NULL DEFAULT '0.00',
  syllables     float(7,6)      unsigned NOT NULL DEFAULT '0.000000',
  complex       float(4,2)      unsigned NOT NULL DEFAULT '0.00',
  
  PRIMARY KEY (sha256url)

) ENGINE=MyISAM DEFAULT CHARSET=utf8