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.
|
