README.md 1.22 KB

Raw Blame History Permalink



run project
php artisan serve
http://127.0.0.1:8000/ocr
create database
CREATE TABLE mst_template (
id INT(11) NOT NULL AUTO_INCREMENT,
tpl_name VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
tpl_text VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
tpl_xy VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
in_date DATETIME NOT NULL DEFAULT current_timestamp(),
up_date DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX tpl_name (tpl_name) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=11
;


CREATE TABLE dt_template (
  tpl_detail_id INT(11) NOT NULL AUTO_INCREMENT,
  tpl_id INT(11) NOT NULL,
  field_name VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
  field_xy VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
  in_date DATETIME NOT NULL DEFAULT current_timestamp(),
  up_date DATETIME NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (tpl_detail_id) USING BTREE,
  INDEX tpl_id (tpl_id) USING BTREE
  )
  COLLATE='utf8mb4_general_ci'
  ENGINE=MyISAM
  AUTO_INCREMENT=7
  ;