35 lines
3.9 KiB
SQL
Executable File
35 lines
3.9 KiB
SQL
Executable File
CREATE TABLE dbtest.Basicp1(id BIGINT NOT NULL AUTO_INCREMENT, textarea_field VARCHAR(400), paragraph_field VARCHAR(400), textarea VARCHAR(400), paragraph_field2 VARCHAR(400), phone_number2 VARCHAR(400), name VARCHAR(400), number1 int, phone_number VARCHAR(400), number2 int, name2 VARCHAR(400), password_field VARCHAR(400), textarea_field2 VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Basicp2(id BIGINT NOT NULL AUTO_INCREMENT, datetime_field2 VARCHAR(400), about VARCHAR(400), datetime_field VARCHAR(400), userid_field VARCHAR(400), email_field2 VARCHAR(400), date_field Date, email_field VARCHAR(400), textarea2 VARCHAR(400), date_field2 Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Basicp3(id BIGINT NOT NULL AUTO_INCREMENT, toggle_switch2 VARCHAR(400), decimal_field2 double, documentsequenc VARCHAR(400), toggle_switch VARCHAR(400), recaptcha VARCHAR(400), percentage_field int, percentage_field2 int, url_field VARCHAR(400), url_field2 VARCHAR(400), decimal_field double, recaptcha2 VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Adv1(id BIGINT NOT NULL AUTO_INCREMENT, t4 bit(1), video_field2 VARCHAR(400), video_field VARCHAR(400), ismale VARCHAR(400), fileupload_field VARCHAR(400), test1 bit(1), test2 bit(1), audio_field2 VARCHAR(400), fileupload_field2 VARCHAR(400), imageupload_field VARCHAR(400), audio_field VARCHAR(400), idfemale VARCHAR(400), t1 bit(1), imageupload_field2 VARCHAR(400), t2 bit(1), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Dv2(id BIGINT NOT NULL AUTO_INCREMENT, qrcode_field2 VARCHAR(400), test3 VARCHAR(400), test VARCHAR(400), currency2 VARCHAR(400), currency VARCHAR(400), qrcode_field VARCHAR(400), name VARCHAR(400), last_name VARCHAR(400), barcode_field2 VARCHAR(400), static VARCHAR(400), barcode_field VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Adv3(id BIGINT NOT NULL AUTO_INCREMENT, datagrid_field2 VARCHAR(400), country VARCHAR(400), dynamic VARCHAR(400), dymlt2 VARCHAR(400), dymlti1 VARCHAR(400), stmlit VARCHAR(400), stmmlt2 VARCHAR(400), state VARCHAR(400), datagrid_field VARCHAR(400), dy2 int, dy1 int, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Support(id BIGINT NOT NULL AUTO_INCREMENT, description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Adv4(id BIGINT NOT NULL AUTO_INCREMENT, onetoone VARCHAR(400), atdy1 VARCHAR(400), atdy2 VARCHAR(400), atoc int, atc2 int, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Adv5(id BIGINT NOT NULL AUTO_INCREMENT, onetomanyextension VARCHAR(400), multiplication VARCHAR(400), value_list_field VARCHAR(400), value_list_field2 VARCHAR(400), age int, age2 int, name VARCHAR(400), addition VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Ad6(id BIGINT NOT NULL AUTO_INCREMENT, checkout_field VARCHAR(400), country int, district VARCHAR(400), description VARCHAR(400), state VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Ad7(id BIGINT NOT NULL AUTO_INCREMENT, button_field2 VARCHAR(400), button_field VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Ad8(id BIGINT NOT NULL AUTO_INCREMENT, onetoone VARCHAR(400), buttonupdate2 VARCHAR(400), onetomanyextension VARCHAR(400), buttonupdate VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Ad9(id BIGINT NOT NULL AUTO_INCREMENT, approved_field VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.Country(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE dbtest.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 dbtest.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 dbtest.Childform(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), description VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|