| Index: trunk/extensions/Storyboard/storyboard.sql |
| — | — | @@ -0,0 +1,14 @@ |
| | 2 | +-- MySQL version of the database schema for the Storyboard extension. |
| | 3 | + |
| | 4 | +CREATE TABLE /*$wgDBprefix*/storyboard ( |
| | 5 | + story_id INT(8) unsigned NOT NULL auto_increment PRIMARY KEY, |
| | 6 | + story_author_id INT unsigned NULL, |
| | 7 | + story_author_name VARCHAR(255) NULL, |
| | 8 | + story_hit_count INT(8) unsigned NOT NULL, |
| | 9 | + story_title VARCHAR(255) NOT NULL, |
| | 10 | + story_text MEDIUMBLOB NULL, |
| | 11 | + story_modified CHAR(14) binary NOT NULL default '', |
| | 12 | + story_created CHAR(14) binary NOT NULL default '', |
| | 13 | + story_is_published TINYINT NOT NULL default '0', |
| | 14 | + story_is_hidden TINYINT NOT NULL default '0' |
| | 15 | +) /*$wgDBTableOptions*/; |
| \ No newline at end of file |
| Property changes on: trunk/extensions/Storyboard/storyboard.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 16 | + native |
| Index: trunk/extensions/Storyboard/storyboard.pg.sql |
| — | — | @@ -0,0 +1,18 @@ |
| | 2 | +-- Postgres version of the database schema for the Storyboard extension. |
| | 3 | + |
| | 4 | +BEGIN; |
| | 5 | + |
| | 6 | +CREATE SEQUENCE story_id_seq; |
| | 7 | + |
| | 8 | +CREATE TABLE `storyboard` ( |
| | 9 | + story_id INTEGER PRIMARY KEY DEFAULT nextval('story_id_seq'), |
| | 10 | + story_author_id INTEGER NULL, |
| | 11 | + story_author_name TEXT NULL, |
| | 12 | + story_hit_count INTEGER NOT NULL, |
| | 13 | + story_title TEXT NOT NULL, |
| | 14 | + story_text TEXT NULL, |
| | 15 | + story_modified TIMESTAMPTZ NULL DEFAULT now(), |
| | 16 | + story_created TIMESTAMPTZ NULL DEFAULT now(), |
| | 17 | +); |
| | 18 | + |
| | 19 | +COMMIT; |
| \ No newline at end of file |
| Property changes on: trunk/extensions/Storyboard/storyboard.pg.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 20 | + native |