personalweb

archived
git clone git://git.wimdupont.com/personalweb.git
Log | Files | Refs | LICENSE

V1_2__guide-to-adoccontent.sql (258B)

      1 DELETE FROM guide;
      2 
      3 RENAME TABLE guide TO adoc_content;
      4 
      5 ALTER TABLE adoc_content ADD COLUMN committed_date DATETIME;
      6 ALTER TABLE adoc_content ADD COLUMN content_type VARCHAR(20) NOT NULL;
      7 
      8 ALTER TABLE adoc_content ADD INDEX content_type_idx (content_type);