/
create.sql
6 lines (6 loc) · 1.68 KB
/
create.sql
1
2
3
4
5
6
create table account (tenant varchar(255) not null, credits_remaining integer not null, credits_used integer not null, primary key (tenant)) engine=MyISAM
create table assessment (key bigint not null, assessmentid bigint, family_name varchar(255), given_name varchar(255), phone_number varchar(255), q1a integer not null, q1b integer not null, q2a integer not null, q2b integer not null, q3a integer not null, q3b integer not null, q4a integer not null, q4b integer not null, score integer not null, status varchar(255), tenant varchar(255), primary key (key)) engine=MyISAM
create table account (tenant varchar(255) not null, credits_remaining integer not null, credits_used integer not null, primary key (tenant)) engine=MyISAM
create table assessment (key bigint not null, assessmentid bigint, family_name varchar(255), given_name varchar(255), phone_number varchar(255), q1a integer not null, q1b integer not null, q2a integer not null, q2b integer not null, q3a integer not null, q3b integer not null, q4a integer not null, q4b integer not null, score integer not null, status varchar(255), tenant varchar(255), primary key (key)) engine=MyISAM
create table account (tenant varchar(255) not null, credits_remaining integer not null, credits_used integer not null, primary key (tenant)) engine=MyISAM
create table assessment (key bigint not null, assessmentid bigint, family_name varchar(255), given_name varchar(255), phone_number varchar(255), q1a integer not null, q1b integer not null, q2a integer not null, q2b integer not null, q3a integer not null, q3b integer not null, q4a integer not null, q4b integer not null, score integer not null, status varchar(255), tenant varchar(255), primary key (key)) engine=MyISAM