[Gemstracker-svn] SF.net SVN: gemstracker:[1184] trunk/new_project/application/configs/db/ tables/gems__respondents.30.sql

[<gem...@li...>]

Revision: 1184
          http://sourceforge.net/p/gemstracker/code/1184
Author:   matijsdejong
Date:     2013-03-14 11:52:00 +0000 (Thu, 14 Mar 2013)
Log Message:
-----------
last table would not upload before

Added Paths:
-----------
    trunk/new_project/application/configs/db/tables/gems__respondents.30.sql

Added: trunk/new_project/application/configs/db/tables/gems__respondents.30.sql
===================================================================
--- trunk/new_project/application/configs/db/tables/gems__respondents.30.sql	                        (rev 0)
+++ trunk/new_project/application/configs/db/tables/gems__respondents.30.sql	2013-03-14 11:52:00 UTC (rev 1184)
@@ -0,0 +1,40 @@
+
+CREATE TABLE if not exists gems__respondents (
+      grs_id_user bigint unsigned not null auto_increment references gems__user_ids (gui_id_user),
+
+      grs_ssn varchar(32) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
+            null unique key,
+
+      grs_iso_lang char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' not null default 'en',
+
+      grs_email varchar(100) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null,
+
+      grs_first_name varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_surname_prefix varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_last_name varchar(50) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_gender char(1) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
+            not null default 'U',
+      grs_birthday date,
+
+      grs_address_1 varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      -- grs_address_2 varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_zipcode varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_city varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      -- grs_region varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      grs_iso_country char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' not null default 'NL',
+      grs_phone_1 varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      -- grs_phone_2 varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+      -- grs_phone_3 varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
+
+      grs_changed timestamp not null default current_timestamp on update current_timestamp,
+      grs_changed_by bigint unsigned not null,
+      grs_created timestamp not null,
+      grs_created_by bigint unsigned not null,
+
+      PRIMARY KEY(grs_id_user),
+      INDEX (grs_email)
+   )
+   ENGINE=InnoDB
+   AUTO_INCREMENT = 30001
+   CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
+

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.