615 lines
21 KiB
Plaintext
615 lines
21 KiB
Plaintext
|
|
|
|
#dbacl
|
|
|
|
CREATE TABLE dbacl (
|
|
id text,
|
|
dbaclname VARCHAR,
|
|
dbuserid INT,
|
|
dbaclid INT,
|
|
status VARCHAR
|
|
PRIMARY KEY (dbaclid, status));
|
|
|
|
|
|
CREATE TABLE dbacl (
|
|
id text,
|
|
dbaclname VARCHAR,
|
|
dbuserid INT,
|
|
dbaclid INT PRIMARY KEY,
|
|
status VARCHAR,
|
|
);
|
|
|
|
INSERT INTO dbacl (dbaclid, dbaclname, dbuserid, id, status) VALUES (1, 'abcACL', 1, 'xyz', '1');
|
|
INSERT INTO dbacl (dbaclid, dbaclname, dbuserid, id, status) VALUES (2, 'xyzAcl', 2, 'abc', '1');
|
|
|
|
|
|
#dbauth
|
|
|
|
CREATE TABLE dbauth (
|
|
id text,
|
|
dbauthdesc TEXT,
|
|
dbauthid INT PRIMARY KEY,
|
|
status VARCHAR
|
|
);
|
|
|
|
INSERT INTO dbauth (dbauthid, dbauthdesc, id, status) VALUES (1,'abcAuth','xyz','1');
|
|
INSERT INTO dbauth (dbauthid, dbauthdesc, id, status) VALUES (2,'xyzAuth','nnn','1');
|
|
|
|
|
|
#dbbilling
|
|
|
|
CREATE TABLE dbbilling (
|
|
id text,
|
|
dbbillingname VARCHAR,
|
|
dbbillingid INT PRIMARY KEY,
|
|
dbcustomerid INT,
|
|
amount VARCHAR,
|
|
dbbillingdate VARCHAR,
|
|
dbbillinglastupdate VARCHAR,
|
|
dbinvoiceid INT,
|
|
status VARCHAR);
|
|
|
|
INSERT INTO dbbilling (id, dbbillingname, dbbillingid, dbcustomerid, amount, dbbillingdate, dbbillinglastupdate, dbinvoiceid, status) VALUES ('1', 'abcBILLING', 1, 1, '1200', '12jan', '10jan', 1, '1');
|
|
INSERT INTO dbbilling (id, dbbillingname, dbbillingid, dbcustomerid, amount, dbbillingdate, dbbillinglastupdate, dbinvoiceid, status) VALUES ('2', 'xyzBILLING', 2, 2, '1500', '8jan', '10dec', 2, '1');
|
|
|
|
|
|
#dbcategory
|
|
CREATE TABLE dbcategory (
|
|
id text,
|
|
dbcategoryname varchar,
|
|
dbcategoryid int PRIMARY KEY,
|
|
dbschemaid int,
|
|
dbcategorydesc varchar,
|
|
status varchar);
|
|
|
|
INSERT INTO dbcategory (id, dbcategoryname, dbcategoryid, dbschemaid, dbcategorydesc, status) VALUES ('1', 'abcCAT', 1, 1, 'category1', '1');
|
|
INSERT INTO dbcategory (id, dbcategoryname, dbcategoryid, dbschemaid, dbcategorydesc, status) VALUES ('2', 'xyzCAT', 2, 2, 'category2', '1');
|
|
|
|
|
|
#dbcharges
|
|
CREATE TABLE dbcharges (
|
|
id text,
|
|
dbchargename varchar,
|
|
dbchargeid int PRIMARY KEY,
|
|
dbschemaid int,
|
|
status varchar);
|
|
|
|
INSERT INTO dbcharges (id, dbchargename, dbchargeid, dbschemaid, status) VALUES ('1', 'abcCHARGE', 1, 1, '1');
|
|
INSERT INTO dbcharges (id, dbchargename, dbchargeid, dbschemaid, status) VALUES ('2', 'xyzCHARGE', 2, 2, '1');
|
|
|
|
|
|
#dbcity
|
|
CREATE TABLE IF NOT EXISTS dbcity (
|
|
id text,
|
|
dbcityname varchar,
|
|
dbcityid int PRIMARY KEY,
|
|
dbstateid int,
|
|
status varchar);
|
|
|
|
INSERT INTO dbcity (id, dbcityname, dbcityid, dbstateid, status) VALUES ('1', 'guntur', 1, 1, '1');
|
|
INSERT INTO dbcity (id, dbcityname, dbcityid, dbstateid, status) VALUES ('2', 'bandarwela', 2, 2, '1');
|
|
|
|
#dbcollection
|
|
CREATE TABLE dbcollection (
|
|
id text,
|
|
dbcollectionname varchar,
|
|
dbcollectionid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbcollection (id, dbcollectionname, dbcollectionid, status) VALUES ('1', 'abcdCOLL', 1, '1');
|
|
INSERT INTO dbcollection (id, dbcollectionname, dbcollectionid, status) VALUES ('2', 'xyzCOLL', 2, '1');
|
|
|
|
|
|
CREATE TABLE dbconnectionstring (
|
|
id text ,
|
|
dbconnectionstringname varchar ,
|
|
dbconnectionstringid int PRIMARY KEY ,
|
|
dbusernameid int ,
|
|
dbpasswordid int ,
|
|
dbipaddressid int ,
|
|
dbtypeid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbconnectionstring (id, dbconnectionstringname, dbconnectionstringid, dbusernameid, dbpasswordid, dbipaddressid, dbtypeid, status) VALUES ('1', 'abcCONNECTION', 1, 1, 1, 1, 1, '1');
|
|
INSERT INTO dbconnectionstring (id, dbconnectionstringname, dbconnectionstringid, dbusernameid, dbpasswordid, dbipaddressid, dbtypeid, status)VALUES ('2', 'xyzCONNECTION', 2, 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbcountry
|
|
CREATE TABLE dbcountry (
|
|
id text ,
|
|
dbcountryname varchar ,
|
|
dbcountryid int PRIMARY KEY ,
|
|
dbcountrydesc varchar ,
|
|
status varchar );
|
|
|
|
INSERT INTO dbcountry (id, dbcountryname, dbcountryid, dbcountrydesc, status) VALUES ('1', 'india', 1, 'best country', '1');
|
|
INSERT INTO dbcountry (id, dbcountryname, dbcountryid, dbcountrydesc, status) VALUES ('2', 'bangladesh', 2, 'brinjal', '1');
|
|
|
|
#dbcustomer
|
|
CREATE TABLE dbcustomer (
|
|
id text ,
|
|
dbfirstname varchar ,
|
|
dbcustomerid int PRIMARY KEY ,
|
|
dblastname varchar ,
|
|
dbemailid int ,
|
|
dbuserid int ,
|
|
dbaddress varchar ,
|
|
dbcreatedate varchar ,
|
|
dblastupdated varchar ,
|
|
dbplanid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbcustomer (id, dbfirstname, dbcustomerid, dblastname, dbemailid, dbuserid, dbaddress, dbcreatedate, dblastupdated, dbplanid, status) VALUES ('1', 'ab', 1, 'c', 1, 1, 'madhapur', '20march2023', 'yesterday', 1, '1');
|
|
INSERT INTO dbcustomer (id, dbfirstname, dbcustomerid, dblastname, dbemailid, dbuserid, dbaddress, dbcreatedate, dblastupdated, dbplanid, status) VALUES ('2', 'xy', 2, 'z', 2, 2, 'sainikpuri', '19march2023', 'today', 2, '1');
|
|
|
|
|
|
#dbdeletenote
|
|
CREATE TABLE dbdeletenote (
|
|
id text ,
|
|
dbdeletenotename varchar ,
|
|
dbdeletenoteid int PRIMARY KEY,
|
|
dbdeletenotedesc varchar ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbdeletenote (id, dbdeletenotename, dbdeletenoteid, dbdeletenotedesc, status) VALUES ('1', 'abcdDELETENOTE', 1, 'deletenote12', '1');
|
|
INSERT INTO dbdeletenote (id, dbdeletenotename, dbdeletenoteid, dbdeletenotedesc, status) VALUES ('2', 'xyzDELETENOTE', 2, 'deletenote2', '1');
|
|
|
|
|
|
#dbdeploy
|
|
CREATE TABLE dbdeploy (
|
|
id text ,
|
|
dbdeployname varchar ,
|
|
dbdeployid int PRIMARY KEY ,
|
|
dbbillingid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbdeploy (id, dbdeployname, dbdeployid, dbbillingid, status) VALUES ('1', 'abcDEPLOY', 1, 1, '1');
|
|
INSERT INTO dbdeploy (id, dbdeployname, dbdeployid, dbbillingid, status) VALUES ('2', 'xyzDEPLOY', 2, 2, '1');
|
|
|
|
#dbemail
|
|
CREATE TABLE dbemail (
|
|
id text ,
|
|
dbemail varchar ,
|
|
dbemailid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbemail (id, dbemail, dbemailid, status) VALUES ('1', 'abcd@gmail.com', 1, '1');
|
|
INSERT INTO dbemail (id, dbemail, dbemailid, status) VALUES ('2', 'xyz@gmail.com', 2, '1');
|
|
|
|
#dbencoding
|
|
CREATE TABLE dbencoding (
|
|
id text ,
|
|
dbencodingdesc varchar ,
|
|
dbencodingid int PRIMARY KEY ,
|
|
dbencodingname varchar ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbencoding (id, dbencodingdesc, dbencodingid, dbencodingname, status) VALUES ('1', 'xyzENC', 1, 'encoding1', '1');
|
|
INSERT INTO dbencoding (id, dbencodingdesc, dbencodingid, dbencodingname, status) VALUES ('2', 'abcENC', 2, 'encoding2', '1');
|
|
|
|
|
|
CREATE TABLE dbgeninvoice (
|
|
id text ,
|
|
dbgeninvoiceid int PRIMARY KEY,
|
|
dbgeninvoicetype varchar ,
|
|
dbinvoiceid int ,
|
|
status varchar)
|
|
|
|
|
|
INSERT INTO dbgeninvoice (id, dbgeninvoiceid, dbgeninvoicetype, dbinvoiceid, status) VALUES ('1', 1, 'abcGENINVOCE', 1, '1');
|
|
INSERT INTO dbgeninvoice (id, dbgeninvoiceid, dbgeninvoicetype, dbinvoiceid, status) VALUES ('2', 2, 'xyzGENINVOCE', 2, '1');
|
|
|
|
#dbgst
|
|
CREATE TABLE dbgst (
|
|
id text ,
|
|
dbgstnumber varchar ,
|
|
dbgstid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbgst (id, dbgstnumber, dbgstid, status) VALUES ('1', '12345', 1, '1');
|
|
INSERT INTO dbgst (id, dbgstnumber, dbgstid, status) VALUES ('2', '54321', 2, '1');
|
|
|
|
|
|
#dbhash
|
|
CREATE TABLE dbhash (
|
|
id text ,
|
|
dbhashname varchar ,
|
|
dbhashid int PRIMARY KEY,
|
|
dbhashtype varchar ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbhash (id, dbhashname, dbhashid, dbhashtype, status) VALUES ('1', 'abcHASH', 1, 'hash1', '1');
|
|
INSERT INTO dbhash (id, dbhashname, dbhashid, dbhashtype, status) VALUES ('2', 'xyzHASH', 2, 'hash2', '1');
|
|
|
|
|
|
#dbinstance
|
|
CREATE TABLE dbinstance (
|
|
id text ,
|
|
dbinstancename varchar ,
|
|
dbinstanceid int PRIMARY KEY,
|
|
dbportid int ,
|
|
dbipaddressid int ,
|
|
dbusernameid int ,
|
|
dbpasswordid int ,
|
|
dbschemaid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbinstance (id, dbinstancename, dbinstanceid, dbportid, dbipaddressid, dbusernameid, dbpasswordid, dbschemaid, status) VALUES ('1', 'abcINSTANCE', 1, 1, 1, 1, 1, 1, '1');
|
|
INSERT INTO dbinstance (id, dbinstancename, dbinstanceid, dbportid, dbipaddressid, dbusernameid, dbpasswordid, dbschemaid, status) VALUES ('2', 'xyzINSTANCE', 2, 2, 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbinvoice
|
|
CREATE TABLE dbinvoice (
|
|
id text ,
|
|
dbinvoicenumber varchar ,
|
|
dbinvoiceid int PRIMARY KEY ,
|
|
dbinvoiceperiodstartdate varchar ,
|
|
dbinvoicelineitemid int ,
|
|
dbcustomerid int ,
|
|
dbinvoicedate varchar ,
|
|
dbinvoiceperiodenddate varchar ,
|
|
dbchargeid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbinvoice (id, dbinvoicenumber, dbinvoiceid, dbinvoiceperiodstartdate, dbinvoicelineitemid, dbcustomerid, dbinvoicedate, dbinvoiceperiodenddate, dbchargeid, status) VALUES ('1', '12345', 1, '12feb', 1, 1, '20march', '15feb', 1, '1');
|
|
INSERT INTO dbinvoice (id, dbinvoicenumber, dbinvoiceid, dbinvoiceperiodstartdate, dbinvoicelineitemid, dbcustomerid, dbinvoicedate, dbinvoiceperiodenddate, dbchargeid, status) VALUES ('2', '54321', 2, '13feb', 2, 2, '19march', '21feb', 2, '1');
|
|
|
|
|
|
#dbinvoicelineitem
|
|
CREATE TABLE dbinvoicelineitem (
|
|
id text ,
|
|
dbinvoicelineitemname varchar ,
|
|
dbinvoicelineitemid int PRIMARY KEY ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbinvoicelineitem (id, dbinvoicelineitemname, dbinvoicelineitemid, status) VALUES ('1', 'abcLINEITEM', 1, '1');
|
|
INSERT INTO dbinvoicelineitem (id, dbinvoicelineitemname, dbinvoicelineitemid, status) VALUES ('2', 'xyzLINEITEM', 2, '1');
|
|
|
|
|
|
#dbipaddress
|
|
CREATE TABLE dbipaddress (
|
|
id text ,
|
|
dbipaddressvalue varchar ,
|
|
dbipaddressid int PRIMARY KEY,
|
|
dbipaddressdesc varchar ,
|
|
dbusernameid int ,
|
|
dbpasswordid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbipaddress (id, dbipaddressvalue, dbipaddressid, dbipaddressdesc, dbusernameid, dbpasswordid, status) VALUES ('1', '12.34.56.78', 1, 'ipaddress1', 1, 1, '1');
|
|
INSERT INTO dbipaddress (id, dbipaddressvalue, dbipaddressid, dbipaddressdesc, dbusernameid, dbpasswordid, status) VALUES ('2', '87.65.43.21', 2, 'ipaddress2', 2, 2, '1');
|
|
|
|
|
|
#dbkyc
|
|
CREATE TABLE dbkyc (
|
|
id text ,
|
|
dbkycdesc varchar ,
|
|
dbkycid int PRIMARY KEY ,
|
|
dbtypeid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbkyc (id, dbkycdesc, dbkycid, dbtypeid, status) VALUES ('1', 'abcKYC', 1, 1, '1');
|
|
INSERT INTO dbkyc (id, dbkycdesc, dbkycid, dbtypeid, status) VALUES ('2', 'xyzKYC', 2, 2, '1');
|
|
|
|
|
|
CREATE TABLE dbname (
|
|
id text ,
|
|
dbname varchar ,
|
|
dbnameid int PRIMARY KEY,
|
|
dbschemaid int ,
|
|
dbcategoryid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbname (id, dbname, dbnameid, dbschemaid, dbcategoryid, status) VALUES ('1', 'mySQL', 1, 1, 1, '1');
|
|
INSERT INTO dbname (id, dbname, dbnameid, dbschemaid, dbcategoryid, status) VALUES ('2', 'msSQL', 2, 2, 2, '1');
|
|
|
|
#dborders
|
|
CREATE TABLE dborders (
|
|
id text ,
|
|
dborderid int PRIMARY KEY,
|
|
dbordername varchar ,
|
|
dbbillingid int ,
|
|
dbpackageid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dborders (id, dborderid, dbordername, dbbillingid, dbpackageid, status) VALUES ('1', 1, 'abcORDERS', 1, 1, '1');
|
|
INSERT INTO dborders (id, dborderid, dbordername, dbbillingid, dbpackageid, status) VALUES ('2', 2, 'xyzORDERS', 2, 2, '1');
|
|
|
|
|
|
#dborganization
|
|
CREATE TABLE dborganization (
|
|
id text ,
|
|
dborganizationname varchar ,
|
|
dborganizationid int PRIMARY KEY ,
|
|
dborganizationdesc varchar ,
|
|
dbpanid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dborganization (id, dborganizationname, dborganizationid, dborganizationdesc, dbpanid, status) VALUES ('1', 'abcORG', 1, 'organisation1', 1, '1');
|
|
INSERT INTO dborganization (id, dborganizationname, dborganizationid, dborganizationdesc, dbpanid, status) VALUES ('2', 'xyzORG', 2, 'organisation2', 2, '1');
|
|
|
|
|
|
#dbpackage
|
|
CREATE TABLE dbpackage (
|
|
id text ,
|
|
dbpackagename varchar ,
|
|
dbpackageid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpackage (id, dbpackagename, dbpackageid, status) VALUES ('1', 'abcPACKAGE', 1, '1');
|
|
INSERT INTO dbpackage (id, dbpackagename, dbpackageid, status) VALUES ('2', 'xyzPACKAGE', 2, '1');
|
|
|
|
#dbpan
|
|
CREATE TABLE dbpan (
|
|
id text ,
|
|
dbpannumber varchar ,
|
|
dbpanid int PRIMARY KEY ,
|
|
dbemailid int ,
|
|
dbphoneid int ,
|
|
dbkycid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpan (id, dbpannumber, dbpanid, dbemailid, dbphoneid, dbkycid, status) VALUES ('1', 'ABC2345678', 1, 1, 1, 1, '1');
|
|
INSERT INTO dbpan (id, dbpannumber, dbpanid, dbemailid, dbphoneid, dbkycid, status) VALUES ('2', 'XYZ9876543', 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbpassword
|
|
CREATE TABLE dbpassword (
|
|
id text ,
|
|
dbpassword varchar ,
|
|
dbpasswordid int PRIMARY KEY,
|
|
dbpassworddesc varchar ,
|
|
dbusernameid int ,
|
|
dbcategoryid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpassword (id, dbpassword, dbpasswordid, dbpassworddesc, dbusernameid, dbcategoryid, status) VALUES ('1', 'abc@123', 1, 'password1', 1, 1, '1');
|
|
INSERT INTO dbpassword (id, dbpassword, dbpasswordid, dbpassworddesc, dbusernameid, dbcategoryid, status) VALUES ('2', 'xyz@123', 2, 'password2', 2, 2, '1');
|
|
|
|
|
|
#dbpermission
|
|
CREATE TABLE dbpermission (
|
|
id text ,
|
|
dbpermissionname varchar ,
|
|
dbpermissionid int PRIMARY KEY,
|
|
dbtypeid int ,
|
|
dbaclid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpermission (id, dbpermissionname, dbpermissionid, dbtypeid, dbaclid, status) VALUES ('1', 'abcPERMISSION', 1, 1, 1, '1');
|
|
INSERT INTO dbpermission (id, dbpermissionname, dbpermissionid, dbtypeid, dbaclid, status) VALUES ('2', 'xyzPERMISSION', 2, 2, 2, '1');
|
|
|
|
|
|
#dbphone
|
|
CREATE TABLE dbphone (
|
|
id text ,
|
|
dbphonenumber varchar ,
|
|
dbphoneid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbphone (id, dbphonenumber, dbphoneid, status) VALUES ('1', '1234567891', 1, '1');
|
|
INSERT INTO dbphone (id, dbphonenumber, dbphoneid, status) VALUES ('2', '2134567876', 2, '1');
|
|
|
|
#dbpincode
|
|
CREATE TABLE dbpincode (
|
|
id text ,
|
|
dbpincode varchar ,
|
|
dbpincodeid int PRIMARY KEY ,
|
|
dbcityid int ,
|
|
dbstateid int ,
|
|
dbcountryid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpincode (id, dbpincode, dbpincodeid, dbcityid, dbstateid, dbcountryid, status) VALUES ('1', '522003', 1, 1, 1, 1, '1');
|
|
INSERT INTO dbpincode (id, dbpincode, dbpincodeid, dbcityid, dbstateid, dbcountryid, status) VALUES ('2', '431200', 2, 2, 2, 2, '1');
|
|
|
|
#dbplan
|
|
CREATE TABLE dbplan (
|
|
id text ,
|
|
dbplanname varchar ,
|
|
dbplanid int PRIMARY KEY,
|
|
status varchar);
|
|
|
|
INSERT INTO dbplan (id, dbplanname, dbplanid, status) VALUES ('1', 'abcPLAN', 1, '1');
|
|
INSERT INTO dbplan (id, dbplanname, dbplanid, status) VALUES ('2', 'xyzPLAN', 2, '1');
|
|
|
|
|
|
#dbplanbilling
|
|
CREATE TABLE dbplanbilling (
|
|
id text ,
|
|
dbplanbillingname varchar ,
|
|
dbplanbillingid int PRIMARY KEY,
|
|
dbpackageid int ,
|
|
dbplanid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbplanbilling (id, dbplanbillingname, dbplanbillingid, dbpackageid, dbplanid, status) VALUES ('1', 'abcBILLING', 1, 1, 1, '1');
|
|
INSERT INTO dbplanbilling (id, dbplanbillingname, dbplanbillingid, dbpackageid, dbplanid, status) VALUES ('2', 'xyzBILLING', 2, 2, 2, '1');
|
|
|
|
#dbplans
|
|
CREATE TABLE dbplans (
|
|
id text ,
|
|
dbplansid int PRIMARY KEY,
|
|
dbplansname varchar ,
|
|
dbtypeid int ,
|
|
dbbillingid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbplans (id, dbplansid, dbplansname, dbtypeid, dbbillingid, status) VALUES ('1', 1, 'abcPLAN', 1, 1, '1');
|
|
INSERT INTO dbplans (id, dbplansid, dbplansname, dbtypeid, dbbillingid, status) VALUES ('2', 2, 'xyzPLAN', 2, 2, '1');
|
|
|
|
|
|
#dbpo
|
|
CREATE TABLE dbpo (
|
|
id text ,
|
|
dbponumber varchar ,
|
|
dbpoid int PRIMARY KEY,
|
|
dbinvoiceid int ,
|
|
dbbillingid int ,
|
|
dbcustomerid int ,
|
|
dborganizationid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbpo (id, dbponumber, dbpoid, dbinvoiceid, dbbillingid, dbcustomerid, dborganizationid, status) VALUES ('1', '12345678', 1, 1, 1, 1, 1, '1');
|
|
INSERT INTO dbpo (id, dbponumber, dbpoid, dbinvoiceid, dbbillingid, dbcustomerid, dborganizationid, status) VALUES ('2', '76543211', 2, 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbportnumber
|
|
CREATE TABLE dbportnumber (
|
|
id text ,
|
|
dbportnumbername varchar ,
|
|
dbportid int PRIMARY KEY,
|
|
dbportnumbercategory varchar ,
|
|
dbportnumberdesc varchar ,
|
|
dbcountryid int ,
|
|
dbpincodeid int ,
|
|
dbusernameid int ,
|
|
dbpasswordid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbportnumber (id, dbportnumbername, dbportid, dbportnumbercategory, dbportnumberdesc, dbcountryid, dbpincodeid, dbusernameid, dbpasswordid, status) VALUES ('1', 'abcPORT', 1, 'local1', 'portnumber1', 1, 1, 1, 1, '1');
|
|
INSERT INTO dbportnumber (id, dbportnumbername, dbportid, dbportnumbercategory, dbportnumberdesc, dbcountryid, dbpincodeid, dbusernameid, dbpasswordid, status) VALUES ('2', 'xyzPORT', 2, 'local2', 'portnumber2', 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbprod
|
|
CREATE TABLE dbprod (
|
|
id text ,
|
|
dbprodname varchar ,
|
|
dbprodid int PRIMARY KEY ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbprod (id, dbprodname, dbprodid, status) VALUES ('1', 'abcPROD', 1, '1');
|
|
INSERT INTO dbprod (id, dbprodname, dbprodid, status) VALUES ('2', 'xyzPROD', 2, '1');
|
|
|
|
|
|
#dbrole
|
|
CREATE TABLE dbrole (
|
|
id text ,
|
|
dbrolename varchar ,
|
|
dbroleid int PRIMARY KEY,
|
|
dbuserid int ,
|
|
dbroledesc varchar ,
|
|
dbpermissionid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbrole (id, dbrolename, dbroleid, dbuserid, dbroledesc, dbpermissionid, status) VALUES ('1', 'VP', 1, 1, 'vice president', 1, '1');
|
|
INSERT INTO dbrole (id, dbrolename, dbroleid, dbuserid, dbroledesc, dbpermissionid, status) VALUES ('2', 'HOD', 2, 2, 'head of department', 2, '1');
|
|
|
|
|
|
#dbschema
|
|
CREATE TABLE dbschema (
|
|
id text ,
|
|
dbschemaname varchar ,
|
|
dbschemaid int PRIMARY KEY ,
|
|
dbschemadesc varchar ,
|
|
dbcollectionid int ,
|
|
dbauthid int ,
|
|
dbencodingid int ,
|
|
dbvariabletypeid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbschema (id, dbschemaname, dbschemaid, dbschemadesc, dbcollectionid, dbauthid, dbencodingid, dbvariabletypeid, status) VALUES ('1', 'schema1', 1, 'ABCschema', 1, 1, 2, 1, '1');
|
|
INSERT INTO dbschema (id, dbschemaname, dbschemaid, dbschemadesc, dbcollectionid, dbauthid, dbencodingid, dbvariabletypeid, status) VALUES ('2', 'schema2', 2, 'XYZschema', 2, 2, 1, 2, '1');
|
|
|
|
|
|
#dbstate
|
|
CREATE TABLE dbstate (
|
|
id text ,
|
|
dbstatename varchar ,
|
|
dbstateid int PRIMARY KEY,
|
|
dbcountryid int ,
|
|
dbstatedesc varchar ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbstate (id, dbstatename, dbstateid, dbcountryid, dbstatedesc, status) VALUES ('1', 'andhra', 1, 1, 'spices', '1');
|
|
INSERT INTO dbstate (id, dbstatename, dbstateid, dbcountryid, dbstatedesc, status) VALUES ('2', 'badulla', 2, 2, 'uva', '1');
|
|
|
|
|
|
#dbtype
|
|
CREATE TABLE dbtype (
|
|
id text ,
|
|
dbtypename varchar ,
|
|
dbtypeid int PRIMARY KEY,
|
|
dbtypedesc varchar ,
|
|
dbschemaid int ,
|
|
dbcategoryid int ,
|
|
dbinstanceid int ,
|
|
dbnameid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbtype (id, dbtypename, dbtypeid, dbtypedesc, dbschemaid, dbcategoryid, dbinstanceid, dbnameid, status) VALUES ('1', 'abcTYPE', 1, 'type1', 1, 1, 1, 1, '1');
|
|
INSERT INTO dbtype (id, dbtypename, dbtypeid, dbtypedesc, dbschemaid, dbcategoryid, dbinstanceid, dbnameid, status) VALUES ('2', 'xyzTYPE', 2, 'type2', 2, 2, 2, 2, '1');
|
|
|
|
|
|
#dbauc
|
|
CREATE TABLE dbuac (
|
|
id text ,
|
|
dbuactype varchar ,
|
|
dbuacid int PRIMARY KEY,
|
|
dbroleid int ,
|
|
dbuacname varchar ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbuac (id, dbuactype, dbuacid, dbroleid, dbuacname, status) VALUES ('1', 'abcdUAC', 1, 1, 'uac12', '1');
|
|
INSERT INTO dbuac (id, dbuactype, dbuacid, dbroleid, dbuacname, status) VALUES ('2', 'xyzUAC', 2, 2, 'uac2', '1');
|
|
|
|
|
|
|
|
#dbusagelimit
|
|
CREATE TABLE dbusagelimit (
|
|
id text ,
|
|
dbusagelimitmin int ,
|
|
dbusagelimitid int PRIMARY KEY,
|
|
dbschemaid int ,
|
|
dborganizationid int ,
|
|
dbroleid int ,
|
|
dbplanid int ,
|
|
dbusagelimitmax int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbusagelimit (id, dbusagelimitmin, dbusagelimitid, dbschemaid, dborganizationid, dbroleid, dbplanid, dbusagelimitmax, status) VALUES ('1', 100, 1, 1, 1, 1, 1, 1000, '1');
|
|
INSERT INTO dbusagelimit (id, dbusagelimitmin, dbusagelimitid, dbschemaid, dborganizationid, dbroleid, dbplanid, dbusagelimitmax, status) VALUES ('2', 200, 2, 2, 2, 2, 2, 2000, '1');
|
|
|
|
|
|
#dbusername
|
|
CREATE TABLE dbusername (
|
|
id text ,
|
|
dbusername varchar ,
|
|
dbusernameid int PRIMARY KEY,
|
|
dbusernamedesc varchar ,
|
|
dbnameid int ,
|
|
dbcategoryid int ,
|
|
status varchar);
|
|
|
|
|
|
INSERT INTO dbusername (id, dbusername, dbusernameid, dbusernamedesc, dbnameid, dbcategoryid, status) VALUES ('1', 'suhaniY', 1, 'green_liked', 1, 1, '1');
|
|
INSERT INTO dbusername (id, dbusername, dbusernameid, dbusernamedesc, dbnameid, dbcategoryid, status) VALUES ('2', 'shivani', 2, 'yellow', 2, 2, '1');
|
|
|
|
|
|
|
|
#dbusers
|
|
CREATE TABLE dbusers (
|
|
id text ,
|
|
dbuserstype varchar ,
|
|
dbuserid int PRIMARY KEY ,
|
|
dbusersname varchar ,
|
|
dbusersemail varchar ,
|
|
dbusersdp varchar ,
|
|
dbusersrole varchar ,
|
|
dbusernameid int ,
|
|
dbpasswordid int ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbusers (id, dbuserstype, dbuserid, dbusersname, dbusersemail, dbusersdp, dbusersrole, dbusernameid, dbpasswordid, status) VALUES ('1', 'fulltime', 1, 'suhaniUser', 'suhani@gmail.com', 'abc.url', 'engineer', 1, 1, '1');
|
|
INSERT INTO dbusers (id, dbuserstype, dbuserid, dbusersname, dbusersemail, dbusersdp, dbusersrole, dbusernameid, dbpasswordid, status) VALUES ('2', 'parttime', 2, 'shivaniUser', 'shivani@gmail.com', 'xyz.url', 'doctor', 2, 2, '1');
|
|
|
|
|
|
#dbvariabletype
|
|
CREATE TABLE dbvariabletype (
|
|
id text ,
|
|
dbvariabletypename varchar ,
|
|
dbvariabletypeid int PRIMARY KEY ,
|
|
status varchar);
|
|
|
|
INSERT INTO dbvariabletype (id, dbvariabletypename, dbvariabletypeid, status) VALUES ('1', 'abcdVAR', 1, '1');
|
|
INSERT INTO dbvariabletype (id, dbvariabletypename, dbvariabletypeid, status) VALUES ('2', 'xyzVAR', 2, '1'); |