diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-10-16 11:19:23 -0400 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-10-16 11:19:23 -0400 |
| commit | 1fd518d1c2b1d4e88ad88218b606a284b7128107 (patch) | |
| tree | 220bbea3845cdd8058c3a4c44b8acb6687803cc3 /generator/schema.sql | |
| parent | 59eab842de02b2b2ba8bf53e2214b558457e6356 (diff) | |
| download | verbly-1fd518d1c2b1d4e88ad88218b606a284b7128107.tar.gz verbly-1fd518d1c2b1d4e88ad88218b606a284b7128107.tar.bz2 verbly-1fd518d1c2b1d4e88ad88218b606a284b7128107.zip | |
Added length field to form table
This commit contains a database update.
Diffstat (limited to 'generator/schema.sql')
| -rw-r--r-- | generator/schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
| diff --git a/generator/schema.sql b/generator/schema.sql index a49a853..c0f2bcb 100644 --- a/generator/schema.sql +++ b/generator/schema.sql | |||
| @@ -155,7 +155,8 @@ CREATE TABLE `forms` ( | |||
| 155 | `form_id` INTEGER PRIMARY KEY, | 155 | `form_id` INTEGER PRIMARY KEY, |
| 156 | `form` VARCHAR(32) NOT NULL, | 156 | `form` VARCHAR(32) NOT NULL, |
| 157 | `complexity` SMALLINT NOT NULL, | 157 | `complexity` SMALLINT NOT NULL, |
| 158 | `proper` SMALLINT NOT NULL | 158 | `proper` SMALLINT NOT NULL, |
| 159 | `length` SMALLINT NOT NULL | ||
| 159 | ); | 160 | ); |
| 160 | 161 | ||
| 161 | CREATE UNIQUE INDEX `form_by_string` ON `forms`(`form`); | 162 | CREATE UNIQUE INDEX `form_by_string` ON `forms`(`form`); |