35 lines
3.1 KiB
SQL
Executable File
35 lines
3.1 KiB
SQL
Executable File
CREATE TABLE testtensep.Basicp1(id BIGINT NOT NULL AUTO_INCREMENT, paragraph_field VARCHAR(400), textarea VARCHAR(400), name VARCHAR(400), number1 int, phone_number VARCHAR(400), password_field VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Basicp2(id BIGINT NOT NULL AUTO_INCREMENT, about VARCHAR(400), datetime_field VARCHAR(400), userid_field VARCHAR(400), date_field Date, email_field VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Basicp3(id BIGINT NOT NULL AUTO_INCREMENT, documentsequenc VARCHAR(400), toggle_switch VARCHAR(400), recaptcha VARCHAR(400), percentage_field int, url_field VARCHAR(400), decimal_field double, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Adv1(id BIGINT NOT NULL AUTO_INCREMENT, video_field VARCHAR(400), test2 bit(1), ismale VARCHAR(400), fileupload_field VARCHAR(400), imageupload_field VARCHAR(400), audio_field VARCHAR(400), test1 bit(1), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Dv2(id BIGINT NOT NULL AUTO_INCREMENT, test3 VARCHAR(400), currency VARCHAR(400), qrcode_field VARCHAR(400), name VARCHAR(400), last_name VARCHAR(400), static VARCHAR(400), barcode_field VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Adv3(id BIGINT NOT NULL AUTO_INCREMENT, country VARCHAR(400), dynamic VARCHAR(400), dymlti1 VARCHAR(400), stmlit VARCHAR(400), datagrid_field VARCHAR(400), dy1 int, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Support(id BIGINT NOT NULL AUTO_INCREMENT, description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Adv4(id BIGINT NOT NULL AUTO_INCREMENT, onetoone VARCHAR(400), atdy1 VARCHAR(400), atoc int, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Adv5(id BIGINT NOT NULL AUTO_INCREMENT, onetomanyextension VARCHAR(400), multiplication VARCHAR(400), value_list_field VARCHAR(400), age int, age2 int, name VARCHAR(400), addition VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Ad6(id BIGINT NOT NULL AUTO_INCREMENT, country int, district VARCHAR(400), description VARCHAR(400), state VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Ad7(id BIGINT NOT NULL AUTO_INCREMENT, button_field VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Ad8(id BIGINT NOT NULL AUTO_INCREMENT, onetoone VARCHAR(400), onetomanyextension VARCHAR(400), buttonupdate VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Ad9(id BIGINT NOT NULL AUTO_INCREMENT, approved_field VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Country(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.State(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), description VARCHAR(400), state_name VARCHAR(400), country_name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.District(id BIGINT NOT NULL AUTO_INCREMENT, district_name VARCHAR(400), active VARCHAR(400), description VARCHAR(400), state_name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE testtensep.Childform(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|