Skip to content
Snippets Groups Projects
archappl_mysql.sql 845 B
Newer Older
  • Learn to ignore specific revisions
  • Mijail Todorovich's avatar
    Mijail Todorovich committed
    
    CREATE TABLE PVTypeInfo ( 
    	pvName VARCHAR(255) NOT NULL PRIMARY KEY,
    	typeInfoJSON MEDIUMTEXT NOT NULL,
    	last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=InnoDB;
    
    CREATE TABLE PVAliases ( 
    	pvName VARCHAR(255) NOT NULL PRIMARY KEY,
    	realName VARCHAR(256) NOT NULL,
    	last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=InnoDB;
    
    CREATE TABLE ArchivePVRequests ( 
    	pvName VARCHAR(255) NOT NULL PRIMARY KEY,
    	userParams MEDIUMTEXT NOT NULL,
    	last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=InnoDB;
    
    CREATE TABLE ExternalDataServers ( 
    	serverid VARCHAR(255) NOT NULL PRIMARY KEY,
    	serverinfo MEDIUMTEXT NOT NULL,
    	last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=InnoDB;