matrix-create.sql 402 B

12345678910111213141516171819
  1. CREATE TABLE matrix (
  2. id NUMBER(10) PRIMARY KEY,
  3. first NUMBER(10),
  4. second NUMBER(5),
  5. res NUMBER(10)
  6. );
  7. CREATE OR REPLACE TRIGGER matrix_tr
  8. before insert on matrix FOR EACH ROW
  9. BEGIN
  10. auto_id(:NEW.id);
  11. END matrix_tr;
  12. /
  13. BEGIN map2users('matrix'); END;
  14. /
  15. CREATE INDEX matrix_matrix_idx ON matrix (first, second);
  16. INSERT INTO version (table_name, table_version) values ('matrix','1');