hicheck_db_notes.sql 418 B

1234567891011121314151617181920212223
  1. DROP TABLE IF EXISTS hicheck.notes;
  2. DROP TABLE IF EXISTS notes;
  3. CREATE TABLE notes (
  4. id SERIAL,
  5. tstamp TIMESTAMP default CURRENT_TIMESTAMP,
  6. hi_user_id text NOT NULL,
  7. password text,
  8. note text,
  9. image text,
  10. type int,
  11. date varchar(10)
  12. );
  13. SELECT AddGeometryColumn('notes','geom',4326,'POINT',2);
  14. ALTER TABLE ONLY notes ADD CONSTRAINT pk_notes PRIMARY KEY (id);
  15. ALTER TABLE notes SET SCHEMA hicheck;