matrix-create.sql 312 B

1234567891011
  1. CREATE TABLE `matrix` (
  2. `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
  3. `first` INT(10) NOT NULL,
  4. `second` SMALLINT(10) NOT NULL,
  5. `res` INT(10) NOT NULL
  6. );
  7. CREATE INDEX matrix_idx ON matrix (`first`, `second`);
  8. INSERT INTO version (table_name, table_version) values ('matrix','1');