Comments (3)
This is the table schema:
`
-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
-- Host: localhost:3306
-- Generato il: Giu 05, 2016 alle 13:41
-- Versione del server: 5.5.34-32.0-log
-- Versione PHP: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
-- Database: sviluppo
-- Struttura della tabella docenti
CREATE TABLE IF NOT EXISTS docenti
(
DOC_COD
varchar(6) NOT NULL,
cognome
varchar(40) NOT NULL,
nome
varchar(40) NOT NULL,
nominativo
varchar(50) NOT NULL,
CF_DOC
varchar(16) NOT NULL,
SSD_DOC
varchar(13) NOT NULL,
web_page
varchar(255) NOT NULL,
mail
varchar(255) NOT NULL,
telefono
varchar(15) NOT NULL,
dipartimento
varchar(30) NOT NULL,
PRIMARY KEY (DOC_COD
),
UNIQUE KEY CF_DOC
(CF_DOC
),
KEY SSD_DOC
(SSD_DOC
),
KEY dipartimento
(dipartimento
),
KEY dipartimento_2
(dipartimento
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dump dei dati per la tabella docenti
INSERT INTO docenti
(DOC_COD
, cognome
, nome
, nominativo
, CF_DOC
, SSD_DOC
, web_page
, mail
, telefono
, dipartimento
) VALUES
('000100', 'ROSSI', 'MARIO', 'ROSSI Mario', 'XXXXX1', 'INF/01', 'http://www.test.it/a', '[email protected]', '02 1234 5678', 'A'),
('000102', 'VERDI', 'PAOLO', 'VERDI Paolo', 'XXXXX2', 'IUS/17', 'http://www.test.it/b', '[email protected]', '02 1234 5679', 'B'),
('000106', 'BIANCHI', 'LUCA', 'BIANCHI Luca', 'XXXXX3', 'SECS-P/01', '', '', '', 'C');
-- Limiti per le tabelle scaricate
-- Limiti per la tabella docenti
ALTER TABLE docenti
ADD CONSTRAINT docenti_ibfk_1
FOREIGN KEY (SSD_DOC
) REFERENCES SSD
(SSD
),
ADD CONSTRAINT docenti_ibfk_2
FOREIGN KEY (dipartimento
) REFERENCES dipartimenti
(DIP_COD
);
`
from electrocrud.
- Its working for me (i create the same table)
- Check if you are using version 0.8.3, its looks like bug i fix in latest version
from electrocrud.
Yes on the v 0.8.4 it is fixed!
from electrocrud.
Related Issues (20)
- Layouts
- Filters
- Login / Locked
- Use react-async
- Full masking now working
- Markdown links
- Sidebar menu views section
- Move pane to package
- Loading view lagging
- Sidebar menu
- fix make & package
- normalize release assets after publish HOT 2
- semantic release commits HOT 2
- Replace icons to new icon HOT 2
- SQLite every file return successful connection
- Prevent password lock if no password
- New README HOT 2
- Add new record HOT 1
- MacOS Build "PROTOCOL_INCORRECT_PACKET_SEQUENCE" HOT 4
- "Unsupported driver used: pg"
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from electrocrud.